Hi ptantry
You could try to update the over 1800 items by exporting the Item Number and linked Asset account, changing the asset account and importing to update the existing items. Make a backup first or get someone who knows what they are doing if you are unsure.
There is no way to change the existing transactions, do a General Journal to correct the affect of the change on a monthly or quarterly basis.
Regards
Gavin
Hi Gavin
Thanks for the reply.
I will try exporting and importing the items along with the linked account numbers.
Just in relation to the journal to cleaing historical data. The Inventory tracking account was previously the asset account 'Petty Cash' which we want to clear out and move to the asset account 'Inventory'. But is it actually possible to do a Cr Petty Cash Dr Invetory.
I thought the initial inventory count is done to the Petty Cash account - we cant just journal it out?
Hi ptantry
Yes you can simply Dr Inventory Cr Petty Cash if this is what you need to do. The inventory count and value is stored in the Item Register, not in an account. The idea is to have the account balance and the value of the Item Register matching.
Regards
Gavin
