I want some help...,
My problem is my, inventory valuation method is FIFO basis.
The amount in Rawmaterial Account is (ex:5000)
But inventory Status report system is showing (Ex:5400). I am taking Status Report based on Last Purchase Price,Last Evaluated Price) than also my staus report and Audit report is not matching.
My inventory audit report system is showing (Ex:8000).Inventory audit report is based on Quantity*Item cost(Last Eavluated Price).
All inventory reports in SAP B1 are not matching to my G/L balance.
How can i take Inventory closing Report.(Inventory report Total has Excatly match to my G/L amount)