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

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.

     

     

    • gavin12345's avatar
      gavin12345
      Ultimate User
      4 years ago

      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

      • rochelle98's avatar
        rochelle98
        Contributing User
        4 years ago

        Thank you both, Gavin & Mike.

         

        All sorted! 👍🏻👍🏻

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.