web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Dynamics GP Essentials / Inventory Distribution History

Inventory Distribution History

Views (6021)
Mahmoud Saadi Profile Picture Mahmoud Saadi 32,738
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.

Item Maintenance Options

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

Remove Distribution History

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

Inventory Distribution History Report


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



--Tables Included:
--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] ,
                    A.[ACTINDX] ,
                    RTRIM(B.[ACTDESCR]) AS [ACTDESCR] ,
                    A.[POSTEDDT] ,
                    A.[DEBITAMT] ,
                    A.[CRDTAMNT]
          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'


Best Regards,
Mahmoud M. AlSaadi






This was originally posted here.

Comments

*This post is locked for comments