Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Open RM transactions not appearing in RM HATB

(0) ShareShare
ReportReport
Posted on by 1,325

Hello All

We are on GP 10 and have genuine RM open transactions that are not appearing in the RM HATB for one customer. When I print the Aged TB with Options the respective transactions do appear. I've run checklinks, reconcile, customer aging however the problem still persists.

This is the first time I've seen something like this ever and don't understand why the report is not pulling the transactions. The open transactions also do exist in the RM20101.

Any ideas why this is happening GP people please?

Thanks,

Louella

 

 

*This post is locked for comments

  • l-thomas Profile Picture
    l-thomas 1,325 on at
    Re: Open RM transactions not appearing in RM HATB

    Hi Ian

    Thanks for answering. The RM document dates are definitely within the date parameters of the RM HATB.

    Actually, another MVP witnessed this error in the RM HATB with me as we were working on a SQL script together to replicated the Trial Balance. The GP report is definitely incorrect for not picking up these transactions. Ever seen anything like it?

    I will log this case with Microsoft support directly. Maybe they will be the wiser.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Open RM transactions not appearing in RM HATB

    Hi - check that the RM Document dates are within the 'Print/Age as of' date that is entered on the report set up window.

    Also, note that depending on the options you choose for 'Select Tranactions For Report Using'...the report will use eithre the Document Date or the GL posting date to determine if a transaction should be included.

    Make sure that the RM document dates are within the paramaters of the report - eithre doc date or posting date.

    Best regards,

    Ian.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans