Dynamics GP Tip: Improve Purchase Price Variance with Dex.ini

Starting on Microsoft Dynamics GP 9.0 the system began automatically generating General Ledger adjustments when an item is sold or consumed from inventory and the cost of the item’s receipt layer is subsequently changed. Each of these General Ledger adjustments will have a reference number assigned; as well as a prefix, which is determined by the type of transaction that consumed or removed the item from inventory.

For example, a prefix of SALES indicates that the cost for an item on a previously posted sales invoice has changed.  It will also include a suffix to indicate the function that changed the cost of the item.  For example, RCT would indicate that a purchasing document caused the cost adjustment.

Additional detail can be posted to the General Ledger by adding the following switch to the Dex.ini:

REVALJEINDETAIL=TRUE

 

General Ledger entries for costs updated after the switch is enabled will include the following additional details:

 ORCTRNUM- Contains the originating document number of the outflow transaction such as the SOP number or the Inventory document number.

ORMSTRID- Contains the item number involved in the cost change.

ORMSTRNM- Contains the reference of ‘IV Ripple Transaction’.

ORDOCNUM- Contains the document number of the receipt record in the IV10200 being updated.

Find more Tips & Tricks for using Microsoft Dynamics GP here.

Contact your Socius Account Manager for help or further questions.


Leave a Reply

Your email address will not be published.

X