Inventory Distribution shows the amounts affecting posting for each transaction originating from Inventory Module. In this post, I intend to illustrate upon several issues regarding the Inventory Distribution setup, utilities and reports.
Inventory Distribution Setup
Within Item Maintenance, there is an option under “Maintain History” to either keep distribution history or not, which is not quite an easy option to go through without thinking of the negative ramifications.
In case the “Maintain Distribution History” is not checked, distribution breakdown registers and posting journals may not be re-printed. Although, there is good news in here at the “System Level” which are:
Within the Audit Trail Codes Setup window, there is an option for reprinting the posting journals, which will enable the distribution history to be kept regardless of how this option is selected in Item Maintenance Options Window.
Inventory Distribution Utilities
Dynamics GP provides a utility for removing General Ledger distribution history records. This will be found on:
Dynamics GP > Tools > Utilities > Inventory > Remove Distribution
Inventory Distribution Reporting
Depending on the configurations above, you will either be able to print the distribution history report or not. In case your configuration allows inventory distribution, you could print the report at the following path:
Inventory > Reports > History > Distribution History
The following script provides a detailed view for the posting account distribution history originating from Inventory Transactions. This view will not retrieve data in one of the following scenarios:
- Distribution history is not maintained
- Audit Trail Code setup window is not configured to re-print the posting journal
--IV30500 | Inventory Distribution History
--GL00100 | Account Master
--GL00105 | Account Index Master
SELECT C.[DOCNUMBR] 'Document Number' ,
C.[ITEMNMBR] 'Item Number' ,
C.[ACTINDX] 'Account Index' ,
D.[ACTNUMST] 'Account Number' ,
C.[ACTDESCR] 'Account Description' ,
C.[POSTEDDT] 'Posting Date' ,
C.[DEBITAMT] 'Debit Amount' ,
C.[CRDTAMNT] 'Credit Amount'
FROM ( SELECT RTRIM(A.[DOCNUMBR]) AS [DOCNUMBR] ,
RTRIM(A.[ITEMNMBR]) AS [ITEMNMBR] ,
RTRIM(B.[ACTDESCR]) AS [ACTDESCR] ,
FROM [IV30500] AS A
LEFT OUTER JOIN [GL00100] AS B ON A.[ACTINDX] = B.[ACTINDX]
) AS C
LEFT OUTER JOIN [GL00105] AS D ON D.ACTINDX = C.ACTINDX
WHERE C.DOCNUMBR = '#DocumentNumber'
Mahmoud M. AlSaadi