Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Sales Order Line Estim...
Finance forum
Unanswered

Sales Order Line Estimated Margin

Posted on by 119
Hi all,
 
I'm using Dynamics 365 F&O.
 
Within the Sales Order // Lines screen there is an Estimated Margin field with a % value - I am trying to workout and replicate this in a data warehouse.
 
Under normal circumstances the calculation would be: (Sales Unit Price - Cost Price / Sales Unit Price) * 100
 
However, we have some forward orders whereby a cost price does not yet exist but D365 is still calculating an Estimated Margin - how is it doing this?  If it helps were are using the FIFO Inventory model and are using trade agreements.
 
Here is an example:
 
Item Number:           ABC123
Sales Line Qty:          1
Unit Price:                 75
Discount %:              14
Net Amount:             64.50
 
Estimated Margin %: 58.33
 
How is it calculating the 58.33?
 
If I use the formula:
 
(Sales Unit Price - Cost Price / Sales Unit Price) * 100
 
That would mean the Cost Price is 26.88 but I cannot find this value anywhere.  Does anyone have any ideas?
 
Thanks,
 
Michael

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans