Forum Discussion

rochelle98's avatar
rochelle98
Contributing User
3 years ago
Solved

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
    3 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?

Mike_James's avatar
Mike_James
Ultimate Partner

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
3 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
    3 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
      3 years ago

      Thank you both, Gavin & Mike.

       

      All sorted! 👍🏻👍🏻