There are certain serious issues with Finance & Distribution inventory especially when the items are valued at lot prices (You may note that the accounting standards require that the inventory should be valued at 'cost', which is nothing but lot prices). Hence we can not value at FTP.
But in BaaN the lot prices are dynamic and the lot price history is not stored anywhere, unlike the standard price history. Hence if you want to value inventory as on a particular date, say at the month end, you will get inventory as on the month end, but valued at CURRENT lot price. But finance postings consider the value based upon the posting period. Hence the Finance & Distribution inventory can never match, with the standard mechanism. We have overcome this problem with the following procedure.
We take a back up of lot price as at the month end. (At 12o'clock night, precisely). This price represents the result of all transactions, variences etc that has taken place during the month. Anyway, ledger posting is based upon the fiscal period. We close the period sharply at the month end. We have customized a report of inventory valuation by Cost price components, based upon the above table (table created for the purpose of backup). Finance mapping is maintained based upon Cost price Components.
With this, the Finance Inventory & Distribution inventory must tally. Anyway, there some difference still, and this is because of our own operation issues, like the user changing the cost price component/item group in the item master level, at the middle of the month, etc. Otherwise, the inventories must tally.
Himanshu, can you please forward me also the program logic. My email id is firstname.lastname@example.org