Importing inventory items error - specifying expense account for tracking costs

Question

Hello,&nbsp;I am attempting to import a list of items into accountright so we can set up inventorising, and am returning the below error:Error -4012: You must specify an expense account for tracking costs&nbsp;I have exported the current item list, changed the item codes, added in 'I Inventorise' and the relevant COGs/Asset account.&nbsp;Is this a company wide setting i need to change, or is there something i've missed in the CSV file?

gavin12345 · Answer

Hi&nbsp;Blueskies2810&nbsp;&nbsp;This is not a file wide setting, done on Item basis. If using I inventory you must set 3 accounts, same as on screen when setting I Inventory. Don't use dashes in account number.&nbsp;RegardsGavin

blueskies2810 · Answer

I have done that.&nbsp; I have 3 accounts.&nbsp; Cost of Sales, inventory and income.&nbsp; No dashes.&nbsp;&nbsp;

gavin12345 · Answer

Hi&nbsp;Blueskies2810&nbsp;&nbsp;Provided those accounts exist in your file, and these Items Numbers do not exist, that should work. If not and you use auto match, manually check all fields matched correctly before doing the import.&nbsp;RegardsGavin

blueskies2810 · Answer

That is what is weird. I have been importing for years and since the latest update it no longer works.&nbsp;

gavin12345 · Answer

Hi&nbsp;Blueskies2810&nbsp;&nbsp;Unfortunately MYOB's track record with updates is not good. However as there are not dozens of posts by other users about this, the update itself may not be to blame. There might be something in your import file or company file that is the issue. Perhaps attach the actual import file. This may allow someone to spot the issue and suggest a solution. With AR2022 it is important to realise that the error message MYOB provides (Error -4012: You must specify an expense account for tracking costs) is often not related to the actual error.&nbsp;RegardsGavin

Forum Discussion

Importing inventory items error - specifying expense account for tracking costs

5 Replies

Looking for something else?

Related content

Importing inventory items error - specifying expense account for tracking costs

Inventory Import Problems

IMPORT PURCHASE Error -225: Insufficient quantity at Location specified.

Importing Item Sales with Non Inventoried Items

Inventory Issues

Import while specifying Tax amount

Import costs added to inventory

No location specified; default location cannot be substituted due to insufficient quantity.