News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Modifying General Post...

Microsoft Dynamics GP (Archived)

Modifying General Posting Journal Report

(0) Share

Report

Report

Posted on by STeam

20

I would like to modify the General Posting Journal report to include the DOCNUMBR when an issue happens. Currently when printing the report after posting the JV,it just prints the transaction reference as "Transaction Entry" .

In the sy00500 table the Bachnum(char 15) has to be joined with TRXSORCE(char 13) of the IV30300 table. But when i take the report to modify and choose Table Relationships and select the primary table as Posting Definitions master and the secondary table as Inventory Transaction Amounts History. I am not able to capture the relationship. How could i go forward.

Thanks

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

sueconrod 335 on at

Like (0)

Report

Re: Modifying General Posting Journal Report

Your going way overboard. Use the table Year-to-Date Trx Open and then go after the field Originating Document Number. If you ever take a look at what is in the GL200000 you will see that all of these fields exist. You can also see the Originating Master Name (Vendor Name, Customer Name, etc) and the Originating Master ID (VendorID, Customer ID, Employee ID). I think if you look at the fields available on that table. Also, when you are modifying you are modifying for all your GL not just your IV module.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans