Gross Profit

Created by Datapel Integration, Modified on Fri, 6 Jun at 4:30 PM by Datapel Integration

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article