web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Suggested answer
    John_Joyce Profile Picture
    1,042 on at

    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

  • John_Joyce Profile Picture
    1,042 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans