17 July 2008

Inventory Account Number Edit Changes in SP2

Microsoft has made some changes to what you can do with the inventory number in Purchase Order Processing. The details of what you can no longer change are below and the reasoning is pretty straightforward. They want the new HITB report to actually work and balance to the GL. These changes make that possible. The change affects GP 9 SP3 and GP 10 SP2.
This was another one of those Hot Topics with no reference number things. More info via this link. Overview below.
Details
In order to facilitate the matching of the inventory value in the Inventory module to the inventory value in the General Ledger module, a change was made beginning in Microsoft Dynamics GP 9.0 Service Pack 3 and Microsoft Dynamics GP 10.0 Service Pack 2. You can no longer edit the inventory account number in the Purchase Order Processing module. This change applies to summary level changes made in the Purchasing Distribution Entry window for the PURCH account type. This change also enables the Historical Inventory Trial Balance (HITB) report to balance.
If this activity were allowed, it could cause a situation where the inventory value in the Inventory module would not match the inventory value in the General Ledger module.
This means that the following actions are no longer enabled:
· You cannot create multiple distributions for the same account type in the Purchasing Distribution Entry window.
· You cannot create split distributions for the same account type in the Purchasing Distribution Entry window.