Is there any way to tally purchases in finance module with purchase value in Distribution, tally inventories in finance with inventory value in distribution, how to get inventory valuation on (FIFO,Weighted average, LIFO) basis.
How to get invenory valuation of actual cost rather, Standard cost.

Hi,

At our site we do this reconciliation of inventory valuation with concerned GL accounts every quarterly. It works fine if the integration GL accounts are set-up properly and the manual entries to these GL accouts are identified through a customized report. It is a must for annual reporting for Statutory auditors. The standard cost of the items are used for inventory valuation.

If stock is to be valued at actual cost the only option is to have all items as lot controlled and in item master the cost price calculation is to be selected as "Lot price" and not as "Fixed Standard cost". In such cases the Inventory valuation report that is available in Lot control module will give the stock value at actual price. However, when the items are issued it will be at standard cost and variance with actual cost will be trigerred in the system.

Hope this information is of help.