Missing Sub-ledger distribution in Microsoft GP

It is noted that when you drill-down the AP transactions sometimes you notice that the distribution is missing or is blank and you may also get issues while inquiring the document through Payable Transaction Inquiry.

Cause: Most of the time this happens when the posting process is interrupted for various reasons and the user has killed the session to reset GP, during which the tables are partially updated.

Resolution: There is no direct approach as GP Checklinks will not fix this issue and alternately SQL script will do by inserting the missing records. You can refer PM80600 table to re-insert the information through SQL script into PM30600 (PM Distribution History File) for historical distribution because it is easier.  And use the GL20000 for PM Open documents going into the PM10100 table (PM Distribution WORK OPEN) - most information is available in the GL table assuming that the posting set up is either Post To or through.

If you compare the content of these tables, most of the information is almost identical.  It is just a matter of rearranging the field to suit the tables. Any missing fields can then be mapped to a constant value just like when performing Integrations.

Start with a simple select statement from the source table and making sure that the result of the query reflects the expected information before going into the destination table.

Using the record from the sample screenshot in the original post, you can find the distribution detail in GL by running the select statement below:

SELECT * FROM GL20000 WHERE ORCTRNUM = 'Trx No' AND ORMSTRID = 'Customer/Vendor ID'