Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Anyone know what table the GL Distribution is stored in?

Anyone know what table the GL Distribution is stored in?

Anyone know what table the GL Distribution is stored in?

I am looking to query the RM20101 table of unapplied documents and I want to also link to the GL distribution records for each document.  Does anyone know what table that breakout is stored in?  For example, if I look up a document and then I click the document and then the distribution what table can I query to fetch that data.  Thanks all.

RE: Anyone know what table the GL Distribution is stored in?

You will find the Distributions in the RM_Distribution_WORK (RM10101) table.  This table is used for both Open and Work state transactions.  The RM_Distribution_History (RM30301) table is used for History transactions.

If you want to link back to the GL you would need to look in GL_TRX_LINE_WORK (GL10001) if unposted at the GL level; GL_YTD_TRX_OPEN (GL20000) if posted and in an open year; or GL_Account_TRX_HIST (GL30000) if in a historical year.

Hope this helps.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions


Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

RE: Anyone know what table the GL Distribution is stored in?

Thanks so much.  So would I first have to link to the RM10101 table and then link to the GL table?  What I am trying to do is there are many unapplied transactions going back to 2001, 2002.   Many are credits and payments that have no been applied anyways its a mess but I want to see out of all the open transactions in the RM20101 table which ones have hit the AR accounts through the distributions.  So I want to run a query in SQL Analyzer to pull up the docnumbr in the RM20101 table and then the Debit and Credit GL accounts for that document.  Hope this makes sense.  Thanks so much for your input winthropdc.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close