Description
Gross Profit is displayed on many of the Sales Reports in WMS, the Gross Profit Calculation is explained below.
Detail Steps
Gross Profit
Gross Profit = Sale line total - Line Cost
Sale line total
Sale line total = selling price x Qnty
Line Cost
Line Cost = CostPrice * Qnty
Cost Price
Cost Price =
If UnitEstCost = 0 then
if AverageCost > 0 then
AverageCost
else
If LastCost > 0 then
Last Cost
else
StandardCost
else
UnitEstCost
UnitEstCost
UnitEstCost = A manual entry field per line on the Sales Order entry form. The per user preference “Use extended lines for Sales to Purchasing.” needs to be turned on to access this feature.
AverageCost
AverageCost = MYOB Avg Cost: The items Average Cost(as recorded at last MYOB-WMS replication) is recorded at time of original record of the sale order and updated with MYOB's actual Avg cost when the invoice is sent to MYOB.
Last Cost
Last Cost = MYOB Last Cost: The items Last Cost(as recorded at last MYOB-WMS replication) is recorded at time of original record of the sale order and updated with MYOB's actual Last cost when the invoice is sent to MYOB.
StandardCost
StandardCost = MYOB STD Cost: The items Std Cost(as recorded at last MYOB-WMS replication) is recorded at time of original record of the sale order and updated with MYOB's actual Std cost when the invoice is sent to MYOB.
Related Information
None