Forum Discussion

rochelle98's avatar
rochelle98
Contributing User
4 years ago

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...
  • Mike_James's avatar
    Mike_James
    4 years ago

    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?

rochelle98's avatar
rochelle98
Contributing User

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's avatar
Mike_James
Ultimate Cover User
4 years ago

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

  • rochelle98's avatar
    rochelle98
    Contributing User
    4 years ago

    Sure Mike,

     

    I'd appreciate your input.

    • Mike_James's avatar
      Mike_James
      Ultimate Cover User
      4 years ago

      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?

      • rochelle98's avatar
        rochelle98
        Contributing User
        4 years ago

        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.

         

         

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.