Featured Post

Dynamics GP 2016 R2 is Now Available .. and #MSDynGP will Always be Avilable

The Microsoft Dynamics GP team announced today that Microsoft Dynamics GP 2016 R2 has released . Dynamics GP 2016 R2 continues the grea...

Monday, September 2, 2013

Inventory Distribution History

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.

 

clip_image001

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

 

clip_image002

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

 

clip_image003

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

No comments:

Post a Comment