You’re offline. This is a read only version of the page.
15
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)
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
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.
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,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (