Finding out Actual Cost for Sales Order
In this post I will show how to find out actual cost for materials sold to customer. It will be for process where we purchase the goods that we sell and these goods are valuated with moving average price.
The business flow will be the following:
- Sales order creation for externally purchased material.
- Creating Purchase Order towards vendor
- Goods receipt for the Purchase Order
- Invoice Receipt for the Purchase order
- Posting Delivery Cost towards Customer Sales order
- Delivery creation towards Customer
- Invoice towards Customer
- Checking the actual Cost of Sales for the sales order created
Creating the sales order
I have created a customer sales order with material R1000. This material we will have to purchase from a vendor in order to sell it as we hold no stock at the moment.
The material is set up with Moving Average price which is 75 at the moment.
In the sales order we have list price of 120 per 1 PC and Cost of 75 (the moving average from the material master). Therefore that leaves us with Profit Margin 37,5% at the moment. At this point we don’t know the actual cost or the actual margin for this sales order, this is just the planned margin.
Purchase order towards the vendor
I have now run the MRP and released the purchase proposal and can create the order towards the
In the purchase order I put price of 82 per 1 PC and send it off to the vendor.
Goods & Invoice receipt for the Purchase Order
Now that we have the order created we can receive it, post the goods into the warehouse and also post the invoice from the vendor.
This is straight forward:
And here we can see the responding journal entries for those postings:
Now that the goods are in the warehouse and invoice is received we will enter one more vendor invoice for transportation costs.
Invoice for transportation costs
To be able to post transportation invoice for Sales Order can use the Post Invoice Without Purchase Order reference and assign the cost to a sales order using the cost distribution option:
Here we assigned G/L account and Sales order/item. Note that this same option allows us to assign the cost to project, service order, cost center etc.
Now that’s done we can go ahead and create delivery and invoice the customer.
Delivery & invoicing the customer
Nothing interesting in the delivery & goods issue.
Invoicing is pretty straightforward also. Notice we get the same pricing/cost elements as we had in the sales order.
Now that we have issued the goods to the customer and also invoiced them we can find out the real costs and contribution margins for this sales order.
Actual costs on the sales order
To find out the actual costs and contribution margin for this sales order we can use the work center Cost and Revenue.
We will find out Sales Order here and we can use reports to find out details about the order:
Lets select report named Profit Detail by Contribution Margin Scheme for Sales Order Item:
And here we are. This is the Invoiced Profit which we’ve seen before. Total Cost of Sales were 375.
This here is the earned profit. This will take into account the actual payment to vendor and also the extra 50 we posted against the sales order for the transportation. This gives us total cost of 460. This comes from 82 per 5 pc-s and 50 for the transportation: 82 x 5+50 = 460.
Of course as with all reports we can add more details, for example we can add Journal Entries to see exactly where each amount is coming from.
This is it, hope you have enjoyed the reading.
If you want to read about produced(standard cost control) items when you can read it from here – https://allbyd.com/actual-costs-sap-business-bydesign-price-control-standard/