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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Community Member Profile Picture
    on at

    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.

  • l-thomas Profile Picture
    1,325 on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans