Small and medium business | Business Central, N...

Business central sales amount expected actual

(0) Share

Report

Posted on by Omer Zenkin

Hello everyone, I am pulling data from the business centre and I want to show it in power bi, there are two different data called sales amount actuall and sales amount expected, which of these data should I take, I will calculate profitability and margin, which one should I calculate this by looking at which one, what happens if I take both data?
Is there anyone who can explain and guide?

(the same applies to cost amount actual and expected)

Translated with www.DeepL.com/Translator (free version)

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

DAnny3211 11,201 on at

Like (0)

Report

RE: Business central sales amount expected actual

hi

I would recommend that you use the sales amount actual data to calculate profitability and margin. This data represents the actual sales revenue that your business has earned, whereas the sales amount expected data represents the sales revenue that your business was expected to earn.

Calculating profitability and margin based on the sales amount expected data could potentially give you inaccurate results, as it does not reflect the actual performance of your business. However, you could still use the sales amount expected data to compare your business's actual sales revenue to the expected revenue, and analyze the reasons for any discrepancies.

Similarly, I would recommend using the cost amount actual data to calculate your business's actual costs, as this represents the true cost of goods sold. The cost amount expected data may not accurately reflect the actual cost of goods sold and may give you inaccurate results when calculating profitability and margin.

If you use both actual and expected data in your analysis, it's important to clearly distinguish between them and use them appropriately. Combining both actual and expected data could help you identify trends and make informed decisions for your business.

DAniele

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 28,359 Super User 2025 Season 2 on at

Like (0)

Report

RE: Business central sales amount expected actual

are you looking at the value entry or item ledger entry table?

if so, the expected amount is what is posted when a PO/SO is received/shipped, but not yet invoiced. When the PO/SO is invoiced, the expected amount gets reversed, and an actual amount is posted. To simplify it, if you sum all expected amounts you should get zero, and any amount left over will be items shipped/received not yet invoiced.

For this reason, if you want a report on fully invoiced items you should take the actual amount. The actual amount will also display any adjustments made, so its the correct column to take.

If you take the expected and actual amount you will get both fully invoiced items and items received/shipped and not yet invoiced, but it will not duplicate your data or anything like that.

Was this reply helpful? Yes No

Community site session details

Business central sales amount expected actual

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Business central sales amount expected actual

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates