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