Announcements
We have several reports that pull sales data from the "G_L Entry" table directly. The report includes a lot of basic info about the sale, posting date, company, document number, country, GL code etc...
I often wondered, can we somehow include the Item No. here to show the sales figures by Item No. Then we could easily see the revenue generated by individual Item No.
So I have explored if its possible but haven't found a way yet.
Steps I've Tried:
Questions
1. Can anyone confirm this is the case, anything I'm missing?
2. Could there be some other way to do this that I'm missing with still using GL Entries as the main source of sales data?
Thanks.
It's definitely not the easiest thing to do. Every entry related to inventory transactions that is posted to the general ledger has an associated value entry but not necessarily an associated item ledger entry. The value entry table is the association from item ledger to general ledger. There is nothing gained by going from the value entry back to the item ledger.
You can use the Document No. from the general ledger to search/filter the value entry table. Source Code is too generic as sales shipments and sales invoices are both source code of SALES.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156