When Park City Group receives a sales file from a retailer, we compare any costs included in the file with those currently set up in each supplier’s Park City Group item catalog. If the costs do not match, discrepancies are logged in this report for you to resolve. This version of the “Cost Discrepancy” report includes the supplier’s cost zones, and if applicable, the cross reference to the retailer’s cost zone.
Cost discrepancies are often associated with a hand-held unit that has old cost information, or pricing-maintenance in the supplier’s catalog that was not updated in a timely manner. However, the issue may be that the retailer has not recently updated the costs in their system.
It is important to note that the cost used to generate invoices is the current cost in Park City Group. If that cost is incorrect, the result can be over / under charges on your invoices.
Note: Not all sales files received from a retailer will contain costs. Many retailers choose to provide supplier, store, date, and item quantity (units moved) information only.
|
Col |
Field Name |
Description |
|
A |
Supplier Store ID |
ID used by supplier to internally identify retailer's store. |
|
B |
Retailer Store ID |
ID used by retailer to internally identify store. |
|
C |
Store Name |
Retailer's store name. |
|
D |
Day |
Sales business date. This is the date the sales took place, not the date the file was received by Park City Group |
|
E |
Supplier Name |
Supplier's company name. |
|
F |
Retailer Name |
Retailer’s company name. |
|
G |
Supplier's Cost Zone Name |
Supplier’s cost zone name. |
|
H |
Supplier's Cost Zone ID |
Supplier’s cost zone ID. |
|
I |
Retailer's Cost Zone X-Ref / Alias |
Retailer or other applicable party’s cost zone ID. When used, the supplier’s cost zone is cross-referenced to that ID to accommodate requirements in the retailer’s system. |
|
J |
Item Order Number |
Supplier's item number. |
|
K |
SKU |
Retailer's Stock Keeping Unit (SKU) identifier, if available in Park City Group. |
|
L |
Description |
Supplier's description of the item. |
|
M |
UPC |
Item's reportable product code. |
|
N |
Units |
The number of items reported sold. |
|
O |
PCG Net Cost |
The net cost (base minus allowance) listed in the supplier’s item catalog. |
|
P |
PCG Allowance |
Any allowance associated with the cost in the supplier’s item catalog. |
|
Q |
Submitted Net Cost |
The net cost on file in the retailer’s internal system. |
|
R |
Submitted Allowance |
Any allowance on file in the retailer’s internal system. |
Updated 3/20/2012