The Buying Price Table is opened from the drill button adjacent to the Cost Price field on the Purchase Order Detail page. Purchase Order Processing allows a Purchase Order to be raised on a Supplier, for a Stock item, at the Cost (Purchase) Price currently held for that item.

Optionally, when entering the Purchase Order, the user can set a Transaction option to Update Cost Price when the Order is processed. This option will only update the cost Price Line 1 for the stock item.

This is not relevant when using the Batch Order option because when Orders are Batched you can control this updating as and when Deliveries/Invoices are received and processed from the Batch.

When you receive Deliveries of the goods and process the Batched Order (with or without the Invoice), you can update the Stock Record Cost Price with the Price being taken from the Order, or if an Invoice accompanies the Delivery, the Order’s Invoice. It is at the time the goods are received that the Stock record is updated (Due In and Physical Quantities also being updated), and the Stock Movement generated.

Batched Purchase Orders, enable you to process multiple Deliveries, and to process the Invoices, whether they are received at the same time as the goods or not.

When you process an Order directly from the Batched Orders list window, using the OK button, or via the Detail window from the Batch window, the Batch Options window is displayed:

If the Invoice is being processed at the same time as the goods are received (Delivered), this Invoice value can be used in this Stock update in place of the original Order value.

If the Invoice is received at a later date from the goods being Delivered into Stock, there is no possibility of the Invoice value being used, as the Stock Movement transaction has already been completed.

An update to Stock at this time would require a transaction EDIT to replace the transaction Value originally entered. Even if this were designed and possible there would be questions over the matter of Stock valuation and Audit.

The Update Cost Price... will only be displayed if the Update Delivery option is ticked.

Also note that this option will only update the cost Price Line 1 for the selected stock.

If only Update Delivery is ticked, the Cost Price will be updated with the Order value.

If Update Delivery and Update Invoice are ticked, the Cost Price will be updated with the Invoice value.