Forum Discussion
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?
- gavin123459 months agoUltimate User
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
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.