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) / Duplicate deposit show...
Microsoft Dynamics GP (Archived)

Duplicate deposit showing in checkbook for reconcilation

(0) ShareShare
ReportReport
Posted on by Georgia 184

Duplicate deposit showing in checkbook register only for reconciliation. Did not hit GL. We had issues with server that day and I believe that is what caused duplicate posting. What tables would our IT dept look at?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Jamie Harris Profile Picture
    Jamie Harris on at

    Hi Georgia,

    I apologise as I'm on my mobile at the moment so I can't have an in depth look at this for you at the moment, however your IT department could use something like the script defined in the following link:

    [View:http://hanssens.com/code/search-entire-sql-server-database-and-all-tables-for-a-specified-string/]

    They could use this and search for the deposit reference which may aid in finding the tables you require.

    Apologies for brevity

    Kind Regards,

    Jamie

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

    Hi,

    In order to research deposit amounts in the checkbook register, I would look in the following tables.

    CM20200 - Checkbook Transactions. WHERE  (CMTrxType = 1)

    CM20201 - Transactions Totals - this is information for posted deposits

    CM20300 - Receipts. This doesn't reflect a deposit, but it will show you if the receipt was duplicated. It also indicates whether the receipt has been deposited.

    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
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans