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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / RM Tables/Fields
Microsoft Dynamics GP (Archived)

RM Tables/Fields

(0) ShareShare
ReportReport
Posted on by Jeff Angelides 60

I'm hoping someone can help.  I am trying to write a querie that will give me a listing of RM payments from customers for the current year and include the customer class.  Here are the other fields I need:

 Doc Type (Payment)

Doc Date

GL Posting Date

Orig Trans. Amount.

 Can someone tell me what tables to use?  I can't locate the Doc Type field in RM30101.

 

Thanks.

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at
    Re: RM Tables/Fields

    The doc type field is RMDTYPAL.

  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at
    Re: RM Tables/Fields

    Jeff,

      In RM module fully Applied payments are not immediately move to history table( RM30101 ). In year end close or periodic paid removal process only it will move to history. All unapplied/partially applied payments are available in RM20201 table.

    Better you can get ddatas from RM20101 ,RM20201 and RM30201.

     Doc Type  is 9 for payment.

    Regards

    Jeganeedhi

  • Jeff Angelides Profile Picture
    Jeff Angelides 60 on at
    Re: Re: RM Tables/Fields

    Jeganeedhi,

     Thanks for the assistance.  RM30201 seems to work ok except it isn't returning results for Balance Forward Cash Payments.  We have a special customer class set up as BALFWD and the results I'm getting don't include these.  Do you know what I might be missing?

  • Jeff Angelides Profile Picture
    Jeff Angelides 60 on at
    Re: Re: RM Tables/Fields

    Thank you, Frank!

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: RM Tables/Fields

    Jeff,

    I think this question was also posted on the GP public newsgroup, but in case you did not see the answer there:

    This might help for a listing of tables and the common field values:
    http://victoriayudin.com/gp-reports/rm-tables/

    Doc Types are not stored anywhere in a table, they are hard coded.  :-(

    You might also find this useful for writing your query:
    http://victoriayudin.com/2009/04/24/sql-view-with-all-posted-receivables-transactions/.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans