Hi there,
we have inventory item with purchasing value of 120. We are selling this item for 150. The shipping cost for delivery to customer is 5 and we are not recharging anything to the customer – meaning that our sales revenue re this transaction is 150 (no revenue on shipping). Our gross result is 150-120=30 but I want to see that my profit is actually 30-5=25 because shipping expense (shipping on sales) is covered by us. So, the idea is to link this shipping cost to SO although we do not want to see this amount on invoice issued to customer. Also, in most of the cases, at the moment of selling the item we’ll have estimate of shipping cost, not the actual (because invoice will be sent by supplier at the month end). When we receive the invoice, we would like to update shipping cost on our sales order to actual.
I know that something similar could be achieved adding shipping as landed cost but we do not have advance inventory first of all and secondly this is really wrong approach - this is selling cost, it should not be included in the value of inventory for sure.
Thanks,
Vesna