Importing inventory items error - specifying expense account for tracking costs

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
rochelle98
Contributing User
7 Posts
Contributing User
Contributing User

7Posts

0Kudos

0Solutions

Solved: Go to Solution

Importing inventory items error - specifying expense account for tracking costs

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?

8 REPLIES 8
Mike_James
Ultimate Partner
5,839 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,839Posts

1,080Kudos

755Solutions

Re: Importing inventory items error - specifying expense account for tracking costs

Hi @rochelle98 , you cannot add the "I inventory" option either manually or via import, once the item has transactions on it. What people often do is export the existing items, set them up as you want, then manually add a prefix to all the existing items (because the item number cannot be changed via importing), so "ABCD" becomes eg "Z-ABCD"), then take a backup and import the items with their new definition. 


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

rochelle98
Contributing User
7 Posts
Contributing User
Contributing User

7Posts

0Kudos

0Solutions

Re: Importing inventory items error - specifying expense account for tracking costs

Hello Mike,

 

Yes thats correct.

 

Sorry i forgot to mention i have changed the updated the existing product codes in myob with a prefix so i can reimport the codes as new items to inventorise as per the below.

 

Have you seen the error code below before?

Error -4012: You must specify an expense account for tracking costs

 

I'm just unsure as to what this relates to so that i can rectify it.

 

Thanks!

Mike_James
Ultimate Partner
5,839 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,839Posts

1,080Kudos

755Solutions

Re: Importing inventory items error - specifying expense account for tracking costs

Hi @rochelle98 , would you be able to post the top 10 lines of your import file here?


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

rochelle98
Contributing User
7 Posts
Contributing User
Contributing User

7Posts

0Kudos

0Solutions

Re: Importing inventory items error - specifying expense account for tracking costs

Sure Mike,

 

I'd appreciate your input.

myob.png
Mike_James
Ultimate Partner
5,839 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,839Posts

1,080Kudos

755Solutions

Accepted Solution Solved

Re: Importing inventory items error - specifying expense account for tracking costs

Hi @rochelle98 , all the right data seems to be there, but I question the order of columns, which doesn't appear to match a typical item export. I've seen in earlier cases that this can lead to import errors. Can you re-order the columns in line with an item export, and try again?


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

rochelle98
Contributing User
7 Posts
Contributing User
Contributing User

7Posts

0Kudos

0Solutions

Re: Importing inventory items error - specifying expense account for tracking costs

Thanks Mike,

 

Could you please advise a typical order of columns?

 

I used the export assistant, therefore columns are exported in the order they are added to the export file in.

 

I've tried reordering a few different ways & am still coming up with the same error.

 

 

myob2.png
gavin12345
Ultimate User
4,953 Posts
Ultimate User
Australia
Ultimate User

4,953Posts

1,000Kudos

633Solutions

Re: Importing inventory items error - specifying expense account for tracking costs

Hi @rochelle98 

 

When you export, ensure you select 'Add All' to ensure all fields are exported. This will give you the complete export file in the correct order.

 

Regards

Gavin

(gavinw222@gmail.com)
rochelle98
Contributing User
7 Posts
Contributing User
Contributing User

7Posts

0Kudos

0Solutions

Re: Importing inventory items error - specifying expense account for tracking costs

Thank you both, Gavin & Mike.

 

All sorted! 👍🏻👍🏻

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post