web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Debit Memos in Sales t...
Microsoft Dynamics GP (Archived)

Debit Memos in Sales transactions, not flowing to general ledger

(0) ShareShare
ReportReport
Posted on by Community Member

Hello

I am new to Great Plains. I am "cleaning up" the accounts receivable sub-ledger. A debit memo was booked to one of our vendors and the accounts affected were bad debts (cr) and accounts receivable (dr).

The entry has been posted and all entries that need to be posted to the general ledger (the company is not setup to post through the g/l); however the entry is not showing up on the general ledger.

Any suggestions?

Thank you

Christine

*This post is locked for comments

I have the same question (0)
  • twelvestrikes Profile Picture
    twelvestrikes 3,657 on at

    Hi Christine

    Here are a couple of things for you to check.

    First check to see if the transaction/batch is sitting in batch recovery.  (Microsoft Dynamics GP > Tools > Routines > Batch Recovery). If it is there, try and recover it.

    If it isn't there the only other thing that I can think of is that the posting to the GL has been turned off.  You can verify this by going to

    Microsoft Dynamics GP > Tools > Setup > Posting > Posting

    For series select sales and for Origin select Receivables Sales Entry.  Is the Post to General Ledger box marked?

    I am assuming that it is sales because you gave the entry pertaining to this missing transactions as bad debts and receivables whereas you said vendor rather than customer but I am not sure as you are creating a debit memo whereas if you were writing off a bad debt it would be a credit memo (note) that you would need to create.

    If it is a balance for a vendor then also go to Microsoft Dynamics GP > Tools > Setup > Posting > Posting

    For the series select Purchasing and for Origin select Payables Trx Entry

    Again, is the box next to Post to General Ledger marked?

    Try the above out first and lets see what you have.  Once we know I can give you further steps

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    Unfortunately, the most frequent reason in my world why things 'didn't make it' to the general ledger is because someone deleted the entry before it was posted. Absent that, there is a nice reconciliation  routine in the Financial area called 'Reconcile to GL', that works great. I see you are on GP10 and I do not recall if this feature had been released on GP10. Another way I would approach this is to search the entire database for occurrences of the Payables document number. There are several SQL statements on the internet that you can get that will accomplish this task. Here's one www.mssqltips.com/.../search-all-string-columns-in-all-sql-server-databases

    Just put 'search sql database for string' and that will pop up several. The reason I do this is to find out which tables store that information. It should be relatively simple to figure out where it went with the results of the query. Also, you'll find out if it doesn't exist in any of the financial tables.

    Kind regards,

    Leslie

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans