Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / RM Historical Aged TB ...
Microsoft Dynamics GP (Archived)

RM Historical Aged TB and Applying Transactions

(0) ShareShare
ReportReport
Posted on by Jim Lines 2

Hi, I've been busy this week...

I'm trying to help a client reconcile their QuickBooks Open AR as of 12/31/2012 to GP as of the same date.  They've been entering everything in parallel since August and the YE Open AR should tie out.  However, I am running into a ton of issues and I'm not sure if I am missing something or the system needs some maintenance.

Example, I have an 2012 invoice that was paid by a check in 2012.  In GP, I apply it with a 12/31/2012 date and run the paid transaction removal with a date of 12/31/2012.  However, when I run my HATB both the check and invoice still appear as open.  When I do a customer inquiry, they are both in history and applied properly.  

Do you know if, even though I set the dates as 12/31/2012, the transactions wouldn't clear because we are in 2013?  Again, all dates were set to 2012.  

Any help is appreciated.

Jim

*This post is locked for comments

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: RM Historical Aged TB and Applying Transactions

    OK.... so Microsoft support has confirmed that I have records in RM20201 that also exist in RM30301 where the CURTRXAM = 0 in RM30101.  In other words, there are some fully paid transactions in history where the payments still exist as not fully applied in RM20201.

    Since I am not an expert is writing select statements that query multiple tables, perhaps someone could help translate this into query langague for me....

    "IF the Payment is referenced in the APFRDCNM field of the RM30201 table AND the Payment is referenced in the APFRDCNM field of the RM20201 table AND the Payment has a ‘0’ CURTRXAM in the RM30101 table THEN DELETE"

    Of course, I don't want to delete anything until I review it first, so I can edit that out.  Also, yes, I am doing this all in test before production.

    Any help with the SQL Query is greatly appreciated.

    Jim

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: RM Historical Aged TB and Applying Transactions

    Hi Jim,

    Boy, I will follow this post to see what the answer is. Thank you so much for being willing to share it with us!

    Kind regards,

    leslie

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: RM Historical Aged TB and Applying Transactions

    Hi Leslie,

    Thanks for responding!

    I've made sure that none of the transactions or apply dates are in 2013.  They are dated 12/31/2012.  Since I am using a test database, I've been able to restore and try it more than once to make sure that all the transactions are dated correctly.

    I've opened a case with Microsoft and will see what they have to say.  I'll follow up with the results.

    Thanks again Leslie!

    Jim

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: RM Historical Aged TB and Applying Transactions

    The HATB calculates its balances based on the apply date. What was the apply date of the check? It will default to the date the check was applied regardless of the date on the check. So, if the transaction was applied in 2013, it will show open as of 12/31/2012

    Does this help?

    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans