Apply Payable Document Error

While applying a payment to a posted invoice in the payable module, an error pops up indicating that " You can't choose this document because it is part of a recovered batch or is still in the process of posting" as illustrated in the screen shot below.

Resolution:

Nothing exists in the batch recover, don't waste time looking for any corrupted records there 

This issue occurs due to having the same record ( mostly an invoice ) in both work and open tables (Unposted and Posted table) . As the apply function checks for any open transaction, duplicated records are found across PM10000 and PM20000, which results with this issue. 

In order to resolve the issue, you basically need to delete the record from the PM10000 which already exists in the PM20000. Then, try again and the apply payable document will work perfectly as designed. 

          DELETE FROM PM10000 WHERE VCHNUMWK = 'XXXXXXX'

Run the script as you replace the XXXXXXX with the specific voucher number which already exists in PM20000. 

Best Regards, 

Mahmoud M. AlSaadi

Payables Reconcile to GL is showing a variance while the PM HATB matches the GL TB

The reconcile to GL utility in Dynamics GP provides a very effective tool to match the sub ledger with the general ledger module for the Bank, Inventory, AP and AR.  As known, there are primarily three parts of the reconcile to GL report which details the following:

• Matched Transactions
• UnMatched Transactions
• Potentially Matched Transactions

In a recent support case, one of the client report a mismatch between the accounts payable and general ledger module, due to one transaction which has been posted on the AP module and went through correctly to the GL tables

UnMatched AP Transaction

The very first step was to look for this journal number specifically on the general journal inquiry in order to check its source, which seems correct. 

Diagnosis

•  The GL journal is correct and it results from the original AP document
• The AP document on the sub ledger has been correctly posted and it exists in AP tables without any issues.
• When printing the HATB for the vendors, the total values matches the total value of all AP GL accounts 
• Reconcile to GL for the AP is showing a difference

Findings

In case the GL Distribution table in the Sub ledger module is empty, the transaction will show in the un-matched section of the Reconcile-To-GL despite of the fact that the transaction details are correct in both modules. 

Bottom line is 

Missing AR/ AP distribution will result in unmatched transaction on the Reconcile to GL report

Resolution

The resolution was to manually populate the distribution table for that transaction, and then when printing the Reconcile to GL, the difference was gone and it shows zero variance.

Best Regards, 
Mahmoud M. AlSaadi