You’re offline. This is a read only version of the page.
Announcements
60
Hello Champions,
I need to know which TABLE in business central has these figures that are marked in RED. Basically the Sales Invoice Table does not seem to have the Invoice wise adjusted profit %age.
Can someone assist me in this ? I need to find the table and then make a powerbi report to show me invoice list with margins on each invoice. Thanks a bunch.
Regards,
Huzefa Rasheed
Hi
You can use page inspector docs.microsoft.com/.../across-inspect-page then find the page number.
Thanks. This solved my problem and I got the report I wanted.
I wanted to know how I could have known that the page on which the statistics report is present is page 397 ?
Incase I need to know the page number for other tables in MSD which in the best way to find out? Example If I need to know what page has the outstanding receivables data in MSD how can I know that ? I there a way to know the tables of the data that is showing on a page in business central ?
Hi,
All the Red marked fields are actually variables which dynamically calculates the values when you open the Statistics page from Posted sales invoice, those fields values are calculating from the Cust. Ledger entry.
If you want to display those values into your powerBi report, in that case you have to dig out the Page ID 397 in Business central and take out the same logic and use the cust. ledger entry table to show your fields values.
Or try with as MahGah suggested to run the Web service page id 397
Thanks.
Hi
Have you tried to Publish page 397 in Web Services?
Extra info:
Original Cost: has a direct relationship with "Unit Cost" of lines in Sales Invoice. If in your example you look at Unit Cost in line then you will see the same cost (since you have one line only). The unit cost populate from Item Card. Which is calculation from Item Ledger Entry.
Adjusted Cost: this is when you run "Adjust Cost- Item Entries". In a nutshell, this is a process that analyzes the Item Ledger Entries to ensure that all cost layers are accurately applied to sales (and other negative entries), thereby ensuring that the Inventory Valuation and Cost of Goods Sold entries posted within NAV are accurate. if any changes required between the time sales invoice created and after running "Adjust Cost - Item Entries" then it will reflect here.
The rest are calculation based on these calculation.
#1
André Arnaud de Cal...
294,110
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
