Our business wants to know if they can have real-time FIFO inventory valuation;
At a give point, When we perform and update the material prices through the Balance sheet Valuation - FIFO procedure; system automatically revaluates the inventory at FIFO with offsetting to an expense account.
However, the requirement is to have FIFO real time without performing any month end tasks/ postings to calculate and update the material prices.
Given that the existing material price controls (S and V); Is the above possible ?
With Material Ledger; some of the standard functionalities can be leveraged i,e to have one valuation for std/ actual and the other to have FIFO valuation but the business thinks this is too much of an effort to maintain this functionality. Since, even for this option - the business has to run month end jobs.