Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Posting Setup for G/L Detailed Trial Balance

(0) ShareShare
ReportReport
Posted on by

Hello:

Recently, the Posting Setup window in GP was configured for setting Create a Journal Entry Per to “Transaction” for the Payables Trx Entry origin.

 

Yet, the G/L Detail Trial Balance is not showing the “Orig. Master Number” and “Orig. Master Name” fields. 

 

Why would the Vendor ID and Name not being showing, for these two fields, since we configured Posting Setup to post in detail?

 

If you have any ideas, I’d appreciate it very much! 

Thank you!!!

John

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Posting Setup for G/L Detailed Trial Balance

    Ah!  I think that I found the culprit!

    Just now, I took a look at the GL20000 table for the resulting journal entry in SQL.  The ORPSTDDT field is set to a date from before Posting Setup was configured!

    This field represents the date the originating transaction was posted.

    I bet that this is it!

    John

  • Community Member Profile Picture
    on at
    RE: Posting Setup for G/L Detailed Trial Balance

    Thanks, Mariano!

    Yes, I just re-read.

    The Posting Date is for after the Posting Setup window was configured to post in detail.

    John

  • Mariano Gomez Profile Picture
    26,225 on at
    RE: Posting Setup for G/L Detailed Trial Balance

    Please go back and read as I added more to the post.

  • Community Member Profile Picture
    on at
    RE: Posting Setup for G/L Detailed Trial Balance

    Hi Mariano:

    Yes, history is being maintained for these two vendors.

    Thank you, in any case, for the quick response!

    John

  • Mariano Gomez Profile Picture
    26,225 on at
    RE: Posting Setup for G/L Detailed Trial Balance

    Have you checked the vendor card setup to ensure that history is being maintained for both transactions and distributions? You also used the word "recently" in your statement. This means that prior to that your were creating a journal entry per batch, in which case you wouldn't have gotten the originating master information you are seeking either.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans