151
Dear Experts
how we can link or get details GL Entry table and Value entry table or 5823 - G/L - Item Ledger Relation to be able to drill down to an Document Number, Item Number, etc in a single page.
is there any way to bring these details in one page to see the from GL entry
Regards
Thanks for the reply.
is there any other option to get crack of this.
From the response i get the idea and while navigating through BC i can get both ILE and value Entries of Related Transactions. but when exporting these ILE, GL and G/L - Item Ledger Relation tables cant able to identify which all the fields we need to take for extracting the data.
could you pls help me on this
That is the hard one. But I try to explain G/L for Invoice and go from there:
For G/L entry Document Type = Invoice
I get the Document No that has my SO No Series (let say start with PS-InVXXX) then by having this Invoice No from Posted Sales Invoice Table I find the Sales Order No. When you have Sales Order No you can look into Posted Sales Shipment and find the shipment no. Now you can filter Item Ledger Entry based on Sales Shipment No. From there you can get Item Ledger Entry and then filter Value Entry based on those Item Ledger Entry.
I know this is not an straightforward path
Hope this help
Hi
You need a development for that or using simple object designer to make that
The other methods are
1) Using Power BI
2) Publish those pages as ODATA then use Excel to consume and create Power Query and build the report
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#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
Share
Report
All responses (
Answers (
