Importing inventory items error - specifying expense account for tracking costs

[Blueskies2810]

Hello,

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

I have exported the current item list, changed the item codes, added in 'I Inventorise' and the relevant COGs/Asset account.

Is this a company wide setting i need to change, or is there something i've missed in the CSV file?

[gavin12345]

Hi @Blueskies2810 

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.

Regards

Gavin

[Blueskies2810]

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

[gavin12345]

Hi @Blueskies2810 

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.

Regards

Gavin

[Blueskies2810]

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

[gavin12345]

Hi @Blueskies2810 

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.

Regards

Gavin