Invoice wise Profit (Adjusted profit %age)

(0) Share

Report

Posted on by HzJ

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.

Screen-Shot-2022_2D00_07_2D00_05-at-2.30.27-PM.png

Regards,

Huzefa Rasheed

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
HzJ 60 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

You can use page inspector docs.microsoft.com/.../across-inspect-page then find the page number.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Invoice wise Profit (Adjusted profit %age)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Invoice wise Profit (Adjusted profit %age)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates