PO Promo Costing

Promo discounts can be applied to PO costs from a table provided by a warehouse and loaded via a feed, when available and applicable. When created, an eligible PO goes through a recosting process that alters part cost of any part that has a PO Promo when identified via this feed.

 

A purchase order is recosted, in whole or part (by individual part), during any of the following activities if the supplier that the order is targeted for is one that received pricing details via PW Central Services.   

 

• PO Create

• PO Edit

• PO Write-in

• PO Transmission

Tables

A Vendor Pricing Server Supplier table contains a list of suppliers that are eligible to apply PO Costing Promos. This table controls which of these suppliers' POs are eligible for PO Promos. A Vendor Pricing Service Promo Daily table is created, which contains part numbers and promos, and loaded via a feed. The VPS (Vendor Pricing Service) is used to receive the Pricing Service Promo Daily table on a weekly basis and load it into the PartsWatch database.

 

The Pricing Service Promo Daily table includes, but is not necessarily limited to, the following fields.

 

• 'Start Date'

• 'End Date'

• 'Supplier Code' – This indicates the warehouse. Different warehouses might have different promos. This is matched to the supplier code of the PO.

• 'Line Code'

• 'Part Number'

• 'Quantity' to be used to determine quantity breaks

• '% Discount'

• 'Absolute $ Value' (replacement cost) 

 

All records and discounts are by specific part number. No discounts are applied to an entire supplier order, line, or subset of a line.

PO Create

Promos apply to all regular and write-in POs of any kind except those with a 'Source' of 'Sourced'. 

 

When a record exists in the Vendor Pricing Server Supplier table for the supplier, the PO checks for applicable discounts for that supplier. Discounts only apply when there is a match on 'Supplier', 'Line', and 'Part Number', and the order was created using cost level 'Vendor Cost 1'. Discounts begin at 12:01 AM (EST) on the 'Start Date' and are in effect until midnight (12 AM EST) on the 'End Date'.

 

The order quantity must be equal to or greater than the table quantity in order for the discount to apply.

 

When multiple quantity breaks exist for the same part number, the discount that applies is the one with the highest quantity that does not exceed the order quantity.

 

Calculation Formula:

New Cost = Original Order Cost – (Order Cost * Discount %)

 

When a PO is created, the PO goes through a re-costing process that alters part cost of any part that has a PO Promo.

 

The 'Source' types of POs that support re-costing are: 

 

• 'Core'

• 'Deal'

• 'DNRVDefective'

• 'Force'

• 'LaborClaim'

• 'MergedMan'

• 'NID'

• 'Ovrstk'

• 'PDC'

• 'Recall'

• 'RtnBuyout'

• 'Shelf'

• 'ShrinkMan'

• 'StkAdjPO'

• 'StkAdjRtn'

• 'Warranty'

• 'Xfer'

• 'WHDirect'

'AutoSrc', 'ShelfSrc', 'Sourced', 'WRecon', and 'Callback' are not supported.

PO Quantity Edit

If the order quantity on a PO is changed either up or down, the item goes through the re-costing process in case there is higher or lower pricing based on quantity. Pricing is recalculated against the original PO cost and not an already-discounted cost. Re-costing occurs even if the PO has already been transmitted.  

Write-In Parts

When a write-in part is added to a PO (regular PO or Write-in PO) via the 'Add To PO' button in the 'Write In PO Form' window in the Purchase Order screen, the information goes through the re-costing process. When a match is found and a discount is applied, the PO detail and totals reflects the new cost.

PO Transmit

Just before a PO that is eligible for PO discounts is transmitted, all parts go through the costing process to check if a new Pricing Service Promo Daily table had been sent and replaced the table that was in place at the time the PO was created or edited. Any discounts found are applied to the original PO price ('Vendor Cost 1'), not to an already-discounted cost from a previous table feed.