View Retailer Cost Adjustments

In some trading partnerships, retailers provide the base costs to be used for invoicing directly within the sales files submitted to Park City Group. This scenario is different from the usual setup where the supplier maintains costs through a PCG item catalog.

Cost Adjustment Events provide these retailers with a method for temporarily adjusting costs for sales from specific areas. Similar to a promotion, the event lowers or raises costs for specific items over a set date range. Adjustment Events can apply to sales from single stores or to sales from all stores within a Cost Zone. PCG applies the adjustments to the base costs received in the sales data.

If multiple events are active for the same period, the adjustments "stack" to arrive at the final cost. For example, two $0.50 allowance adjustments in effect at the same time total to $1.00 off the received cost. If one event ends but another remains in effect, the second adjustment continues until reaching the end date.

Retailers create and update Adjustment Events through batch processes such as EDI transactions. This screen provides visibility to scheduled, current and past events.

Note: This option appears only if you are connected with one or more suppliers doing Retailer Cost Adjustments.

Follow these steps:

From the Item & Cost tab:

Click View Retailer Cost Adjustments.

Select the Supplier.
Enter search criteria to locate specific Adjustment Events. (Or click Find to list all Events active today.)

Event ID: Search using the adjustment description or other ID assigned by the retailer.

Supplier Item ID: Search for adjustments that include specific items. Options are UPC, Item Description, or Supplier Item Number. Use asterisks as wild cards.

For example, if UPC is 0-55555-44444-1, enter *44444*.

Cost Zone or Store: Choose to search for all stores within a Cost Zone or for an individual Store.

Retailer Cost Zone ID or Store ID: Enter your Zone or Store ID and click Choices. Select the Zone or Store.

Start on or After: Search for adjustment events that begin on or after a specific date. You can search for past events.

In Effect On: Search for adjustments active on a specific date. Defaults to today's date. You can search for past events.

Choose an Order By sort option.
Click Find.

__________________________________________________________

Column	Description
Event ID	Adjustment description or other ID assigned by the retailer
Supplier Item ID	Supplier item description and UPC.
Adjustment Code	Code assigned to the event in the Retailer’s internal systems. For example, an SAC code.
Effective Period	Date the cost adjustment begins and ends.
Retailer Cost Zone / Retailer Store ID	The cost area for which the adjustment applies. Cost Zone adjustments apply to all stores within a zone. Store areas apply to single stores only. If the Supplier's Cost Zone ID is cross-referenced to a Retailer Zone ID, the cross-reference ID displays.
Adjustment Amount	The amount subtracted from or added to the supplier's base cost. Arrow shows whether the amount was a decrease (allowance) or an increase (charge). Note that the blue link is not a hyperlink, and does not present further information.

(Top)

New 9/25/2012