Price Variance Postings (Sage Integration)

Price Variance Postings

Overview

Purchase Orders are input on to the system with different products, and product costs.  Sometimes the cost specified on the order, is actually different to the value invoiced by the Supplier. 

In this instance, in the ‘Purchase Order’ window under the ‘Invoicing’ tab, the ‘Inv Value’ entered by the user would be different to the original expected cost input under the ‘Purchase Order Details’ tab.

Please see section above which explains when a Purchase Order Invoice is posted to Sage which is also when a PO Price Variance posting is sent to Sage.

Purchase Order Price Variance

Please see the table below for the debit/credit details posted to Sage for this posting type.

 EP Sales Order Cost of Sales Accruals & Variance Postings

When an EP Sales Order is created, and an EP Invoice is raised, the same procedure applies as for a normal Stock Sales Order Invoice.  However the next time a Stock Movement Posting is made, an accrual is also made as follows:

When the EP Purchase Order is receipted and the Purchase Invoice raised, stock is allowed to be allocated against the EP Sales Orders.  When these EP Sales Orders are confirmed delivered, if the product cost is more/less than accrued then a price variance is posted to Sage to compensate for this.