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

Notifications

Announcements

No record found.

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

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

#2
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans