Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

AP Checks Posted to Wrong GL Account

(0) ShareShare
ReportReport
Posted on by

OK, so up until August 1, an accounting company was handling all of our accounting functions. As such, no one here had ever actually used Dynamics SL. When I came on board, that was one of my responsibilities in regards to A/P.

In getting changed over, the accounting company sent me a set of guidelines they had used for the multiple employees that had worked in our company's file. As such, it had instructions for which GL account to select when posting A/P check batches. Unfortunately, the instructions given were incorrect, and so all check batches since August 1 have been posted to the wrong account.

Short of a journal entry, how can I move these checks to the proper account? Keep in mind, the checks were printed, many have cleared, and as far as vendors are concerned, they're correct. However, on our end, it's going to obviously affect bank reconciliations and the like. Therein lies the problem with a journal entry: It will cause issues with outstanding checks.

So, is there a way to go into the database and change the account number these checks were posted to? Or are we basically hosed on this one?

Thanks!

*This post is locked for comments

  • John_Joyce Profile Picture
    1,040 on at
    RE: AP Checks Posted to Wrong GL Account

    Note: One flaw with my proposed solution would be that the AP checks in the AP module would all be shown as "cleared".  If you were to do research on any of those checks, you would have to rely on the "OA" Cash Transactions to see what has cleared or not.

  • Suggested answer
    John_Joyce Profile Picture
    1,040 on at
    RE: AP Checks Posted to Wrong GL Account

    I would not recommend updating the database, but it can be done.

    It sounds like you're using Cash Manager for bank recs, so I would do the following:

    1) Temporarily disable posting to the GL from Cash Manager Setup screen;

    2) Enter GL Journal Transactions to reclass the check batches from wrong account to proper account. I would probably do one transaction line per Batch Total, and also enter the AP batch number in the Transaction Description field;

    3) Enter "OD" Cash Account Transactions in Cash Mgr to the **wrong** bank account, using the same check date and same check number for each.  This will get the Cash Mgr Balance for the **wrong** account back to where it should be.  

    4) Enter "OA" Cash Account Transactions in Cash Mgr to the **proper** bank account, using the same check date & check number for each. This will get the Cash Mgr Balance for the **proper** account back to where it should be and then allow you to reconcile the individual checks properly for this account;

    5) After releasing the GL Batches in Note 2 above, go back to Cash Mgr Setup and re-enable the GL Posting option;

    6) For the August Bank Rec in the **wrong** account, you can go ahead and clear everything that was entered related to this.  In theory, the "OD" transactions should offset the AP checks to the penny;

    Good luck!

    John

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,265 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,927 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans