Dynamics GP 10 introduced new, Excel based, functionality to reconcile AP to the GL (Dynamics GP-Tools-Routines-Financial-Reconcile to GL). Unfortunately, this doesn't seem to work correctly if there are outstanding transactions paid by credit card.

When you pay an AP transaction with a credit card, there's no GL affect, the liability within the AP subledger is simply moved from the original…

Dynamics GP Best Practices for Accounts Payable Management –in Microsoft Dynamics GP - One challenge many companies face is their ability to reconcile their A/P sub-ledgers to the G/L. Causes can be as simple as journal entries being posted directly to the A/P account or…

This situation presents us with a unique set of circumstances as you can not restrict the Receivables aged trial balance by account. It can be restricted by payment priority and class so with some forethought and planning you could have debtor classes set up that use a specific control account or something similar along the lines of payment priority. If you have not done this or you think some transactions may have been miss posted then using smartlists would be your next best thing.

In Smartlists you can create a report for the receivables transactions based on the system date range and then create a report for GL (account transactions) for the system date range. This way, you can compare when the information was physically entered in the system (even with a different document date between modules). If one of the modules has the transaction posted and the other is missing, you can determine if the transactions were posted with a different date in GL than in receivables.

Within smartlists, open up the receivables transaction option. Add the column Posted Date. This column stores the date from your computer of when the document was physically entered in receivables. Even if the document date was for the previous year,…

Steve Chapman of Rose Business solutions has a nice write up on the new AP and AR reconcile…