Dynamics Community Forum Thread Details

HATB Reconcilation to GL

We have a client due to cutover from one system to another has entries in GL that doesn't appear in AP. We wanted some advice that these wouldn't cause an out of balance issue. Below is an example of what we are seeing.

Original Invoice is in Payables (PM30600) and GL (GL20000)

Purchasing Expense Debit

AP Credit

Only GL (GL20000) shows the void:

AP Debit

Purchasing Expense Credit

The invoice is set to History (DCSTATUS = 3 in the PM00400). On the Payables Inquiry screen you see the Invoice as History and voided, when you click on the distribution you only see the Debit to the expense and the credit to AP.

When we run an HATB TB we do not see the Invoice as open.

I wanted to confirm that even though the Void is missing from the PM30300 these type of items would not be a reconciling transaction. GL AP for this invoice is zero and AP for this invoice is not an open item.

Thank you!

Categories:

Microsoft Dynamics GP

Hi Lisa,

Thank you for using Microsoft Communities.

The HATB report looks at the payables transactions and apply tables and does not take into consideration the payables distribution tables.

When a Payables invoice is voided, there is no record for it in the PM30300. The invoice is in the PM30200 with a status of void.

If the payables invoice has been voided, with the same date or in the same month/time, it would not show on the HATB. If the GL entries for the original and void are posted in those same dates, then they would balance out.

As always, the best way to validate is to make sure to test this in a test environment

I hope this information helps.

Thank you,

Janelle

Microsoft Support

Quick Links