Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Problem with AP reconc...
Microsoft Dynamics GP (Archived)

Problem with AP reconcile to GL report in Great Plains.

(0) ShareShare
ReportReport
Posted on by Thomas Shooter 40

 We run the reconcile to GL report for the month and there is a problem with our AP. We entered an AP transaction for $5,000.00 recording the payment at the same time. We needed to void the invoice (and the payment ) which we did no problem. Now when we run the reconcile to GL report the AP side is showing two negatives for that amount (one for the invoice and one for the payment). A negative is a debit in the GL. The GL is however not showing any entry to correspond to these two negatives. The bank is showing the cheque as voided so it is ok.  The Vendor inquiry shows both the Invoice and Payment as voided. Did we do something wrong in our process?

*This post is locked for comments

  • Thomas Shooter Profile Picture
    Thomas Shooter 40 on at
    RE: Problem with AP reconcile to GL report in Great Plains.

    Ok this is an issue reported in 2016. Does anyone have a solution?

    community.dynamics.com/.../189574

  • Thomas Shooter Profile Picture
    Thomas Shooter 40 on at
    RE: Problem with AP reconcile to GL report in Great Plains.

    Ok the plot thickens.

    I can see that the voiding of the cheque and the voiding of the invoice are both in the reconciled section. They are number 1234 and 1430 respectively for the full amount of the transaction. One is a negative and one is a positive (which is correct).

    I can also see that 1430 and 1234 are also in the unreconciled section for the full amount of the transaction. In this section they are both negatives(decrease in AP).

    So they are in the AP side of the report twice but the GL only once. They should be only in the spreadsheet once. Where does the information come from for the AP side of the GL reconciliation spreadsheet come from? It here any reconcile or check links I could run that could fix this?

  • Thomas Shooter Profile Picture
    Thomas Shooter 40 on at
    RE: Problem with AP reconcile to GL report in Great Plains.

    When a transaction with a payment is voided the following happens

    When the invoice is entered with a payment we debit a purchase account and credit the Cash account.

    The payment is voided first. It will debit Cash and credit AP. On the reconcile to GL report this will show on the left side as a positive transaction (as the AP has Increased).

    At this point the sub ledger shows the invoice as outstanding and the report and the sub ledger are in balance.

    The invoice is now voided. We will Debit AP and credit the Purchases account used on the original transaction. On the reconcile to GL report this will show on the left side as a negative transaction (as the AP has Decreased).

    On my reconcile both the voided payment and voided invoice are showing as a negative transaction on the left side of the reconcile to GL report. This is one of the problems. The second problem is that nothing shows in the GL. Even if a use choose to delete the transaction before posting at the GL level the Spreadsheet is still not correct. I have three examples of it functioning this way. Has anyone seen this before and if yes is it some sort of user error that can be correct during the voiding process?

  • Thomas Shooter Profile Picture
    Thomas Shooter 40 on at
    RE: Problem with AP reconcile to GL report in Great Plains.

    I drilled down on the transaction in Purchasing and it was voided the same date as the transaction. Even if we account for someone maybe deleting it that does not explain the two debits entries for $5000.00 in the AP side of the reconcile  excel spreadsheet. One $5,000 is tied to the invoice and the second is tied to the voided cheque.

    To me it looks like a problem with the excel spreadsheet. When I drill down on the transaction the distributions look right.

  • Rick Hollis Profile Picture
    Rick Hollis 495 on at
    RE: Problem with AP reconcile to GL report in Great Plains.

    It could also be the case, the GL transaction was deleted at the GL or posted to a different period.

  • Thomas Shooter Profile Picture
    Thomas Shooter 40 on at
    RE: Problem with AP reconcile to GL report in Great Plains.

    Thank you for the quick response:

    That was the first thing I checked. there is nothing to post in the GL or in batch recovery. Going to run a few tests in my test system. I will let you know what I find.

  • Rick Hollis Profile Picture
    Rick Hollis 495 on at
    RE: Problem with AP reconcile to GL report in Great Plains.

    I have seen in the past where the void transaction is not posted in the GL.  Can you check to see if you have open GP Batches that need to be posted?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans