
Dear All
At one of my Customer we ran Inventory Closing as on 30th June 2012, on 30th June 2012, at a movement it was stopped and through an error “Cannot create a record in Price (InventItemPrice). Item number: PM-0074, the record already exists”.
I have read in some blog that if we unmark Latest Purchase Price and Latest Cost Price check boxes on item master this will resolve the above error, so I did that.
At that time we did not notice that Inventory Closing was paused in process because In Invent Trans we could see Inventory Closing Transactions.
Now next day we realized that we have to cancel Inventory Closing as some of the transactions were not posted, since Inventory Closing was paused in between so before cancelling I have to complete closing first.
Now when I am resuming the inventory closing system is throwing error “The transactions on voucher ICV-1112-000001 do not balance as per 6/30/2012. (Company currency: -0.00 - secondary currency: 0.00)”
Please help
Regards
Muhammad Saad
*This post is locked for comments
I have the same question (0)Check your journal for missing values like ledger or bank accounts (as offset account) as it does not balance.
If you have a voucher per line, it must be very easy to find by validating the journal and look into the error(s).
Also try to find the line(s) based on the difference amount.