Any suggestion on valuation workflow in ERPNext where finished goods are valuated at a fixed percentage (such as 60%, 70% or 80%) of their selling price or at standard cost and whenever a selling price is updated, would like existing finished goods stock to revaluate accordingly and Stock Entries (Manufacture) to automatically pull this updated rate as the production value.
Interesting requirement! I think the key here is separating selling price from inventory valuation.
Normally, ERPNext calculates finished goods valuation based on consumed raw materials, manufacturing costs, and additional expenses. Changing the selling price doesn’t automatically revalue existing stock.
Have you looked into the Standard Cost valuation method available in newer ERPNext v16 versions? It allows you to define a standard cost for an item, use that rate during manufacturing, and revalue existing inventory when the standard cost changes.
For your 60%, 70%, or 80% requirement, you could potentially build a small customization that calculates the proposed standard cost from the selling price and then updates it through a controlled process.
I would avoid directly changing stock valuation every time someone edits a selling price, though. That could create unexpected accounting adjustments, especially with perpetual inventory.
One question: Are you trying to use this percentage for actual financial inventory valuation, or mainly for internal costing and management reporting? That distinction would make a big difference in choosing the right approach.