Forum Discussion

bob4122's avatar
bob4122
Contributing Cover User
5 months ago
Solved

Account Right Importing Items

Hi All I am trying a test import of an inventory item and continually receive the error message; Summary of errors Error -4012: You must specify an expense account for tracking costs. I began by ...
  • bob4122's avatar
    bob4122
    5 months ago

    Thanks for your reply

    Yes, I did try with and without the hyphen but it made no difference.

     

    What I did try was to export the existing items using every field, then I deleted the field columns (that were obviously not being used) from the spreadsheet and ended up with around 20 columns. Next I deleted all of the items except one and used this as a template for the new items I wanted to import, I then tried the import again and it worked !

     

    I can only assume that the COS account was correct but there must have been a related field missing.

     

    Many Thanks

    Rob

Genreve_S's avatar
Genreve_S
MYOB Moderator

Hi bob4122, 


Thanks for posting your concern in the forum. 

 

I'm sorry to hear about your difficulties in importing. If you tried removing the hyphen and the import still does not work, I recommend reordering the fields according to how Mike_James has suggested in this other Community Forum post. 

 

Let us know the results and let us know if you require any further assistance with this. 

 

Thanks,
Genreve

bob4122's avatar
bob4122
Contributing Cover User
5 months ago

Thanks for your reply

Yes, I did try with and without the hyphen but it made no difference.

 

What I did try was to export the existing items using every field, then I deleted the field columns (that were obviously not being used) from the spreadsheet and ended up with around 20 columns. Next I deleted all of the items except one and used this as a template for the new items I wanted to import, I then tried the import again and it worked !

 

I can only assume that the COS account was correct but there must have been a related field missing.

 

Many Thanks

Rob

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    5 months ago

    Hi bob4122. 


    Thanks for the response and the update. 

     

    I'm glad you managed to make your import work. It's also likely that there was a related field missing from the import file. 

     

    Let us know if you require any further assistance. 


    Thanks,
    Genreve