ERPNext 15, I need assistance with calculating the basic rate for the output item in the Stock Entry (Repack). The calculation should be based on a percentage of the base amount multiplied by the total amount.
specifically for the output item. input item rates should remain unchanged
valuation rate = Valuation Rate in item master
input total cost = input item total price
calculation should be = (valuation rate/100)* input item total price = cost of out put item
Hi Raj,
You mean you want to mark up the repacked item by a certain percentage of the input item?
If you have perpetual inventory turned on, the mark up will hit the difference amount. You will need to write some scripts to achieve this. Or you can calculate manually and add it as the valuation rate in the item master.
Input rates need to be constant? You have two options of inventory valuation; FIFO and moving average. Based on what you select, input inventory valuation will be dependent on what you bought the input items at. You can try setting the valuation rates of all input items in the item master and if you do, and have perpetual inventory turned on the difference between the set value and the actual rate at which you bought it will charged to the difference account.
All of this will make your accounting fairly complicated. Keep it simple. Use Moving Average and let ERPNext calculate the valuation rates. It does a brilliant job of it.
Hope this helps.
Thanks
Jay