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 :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Add Vendor Doc. No. to...
Microsoft Dynamics GP (Archived)

Add Vendor Doc. No. to G/L Trial Balance Detail

(0) ShareShare
ReportReport
Posted on by Pete72 540

I know I've done this before but I can't seem to find the TK that describes how to add the Vendor invoice number as entered on the Receivings Transaction Entry window to the G/L Detailed trial balance. The originating document number field shows the voucher number.

Can anyone steer me in the right direction?

Thanks.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    If memory serves, it is the Originating Master Number that you are looking for.  Any of the Originating XXXX fields should pull the data direct from the source transaction.

    If that does not do it for you - post a reply and I will do more investigation.

  • Pete72 Profile Picture
    Pete72 540 on at

    Thanks for the suggestion, Bill. I don't see an Originating Master number. There is an Orig. Doc number and Orig. Master Id and Name. The doc number shows the voucher number when the transaction originates in POP. I know I've done this before some years ago but can't find the tk on it.

    Go Oilers!

  • 26P2ER Profile Picture
    26P2ER 1,775 on at

    I would try the ORDOCNUM found in GL2k table. In GP terms :- Originating Document Number of the Year to Date open table. The voucher number of the Purchasing Invoice (POP Invoice) is stored in Originating Transaction Number field (ORCTRNUM) of the same table.

  • Pete72 Profile Picture
    Pete72 540 on at

    Both of those fields store the same information, the voucher number. I don't believe the GL20000 stores the vendor document number when the invoice originates in POP. It easy to link the POP Receipt History table to the GL20000 in smartlists in order to get the invoice number but Report Writer is so restrictive in its table relationships.

    Thanks for the reply.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    As you would have to create the relationship in Smartlist to link the two tables, you would do the same in the Report Writer.

    Before doing anything backup the report you have already created - best to back up the Reports.dic just in case.

    In the report, you can select the table and create the relationship with the required POP or PM table.  Test and let us know.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans