Forum Discussion

SL_2023

2 years ago

Importing Item Sales with Non Inventoried Items

Hi, I'm trying to import our sales into MyOb AccountRight in Bulk using a txt file. A very common item that needs to be included isn't an inventoried item and therefore doesn't have a location. ...

gavin12345
2 years ago
Hi SL_2023

This may well be another situation the developers did not anticipate. Suggest you open an existing Sales invoice which has both inventoried and not inventoried items, export that sales invoice and examine the export file. This may give a glue. If this doesn't solve, try adding default inventory location. MYOB should not use the location, however the import tests may require it. Update post with results for the benefit of others in same situation.

Regards
Gavin

gavin12345

Ultimate User

2 years ago

Hi SL_2023

This may well be another situation the developers did not anticipate. Suggest you open an existing Sales invoice which has both inventoried and not inventoried items, export that sales invoice and examine the export file. This may give a glue. If this doesn't solve, try adding default inventory location. MYOB should not use the location, however the import tests may require it. Update post with results for the benefit of others in same situation.

Regards

Gavin

SL_2023
2 years ago
Hi,
The item was definately not inventoried and when exporting the file, the tab was blank.
We added the default location into the tab, even though it technically didn't have one, and it uploaded fine and the invoice in the system still had it as locationless.
Thank you for your help.
- Earl_HD
  MYOB Moderator
  2 years ago
  Hi SL_2023,
  
  Thanks for letting us know that your problem is now resolved and for providing us a solution.
  
  Feel free to post again, we're happy to help.
  Regards,
  Earl
  - dp23
    12 months ago
    Hi there,
    
    We have an identical issue to the one presented here, trying to upload a non-inventoried sales item and either hitting error -226 (i.e. can't be blank) or error -230 (when attempting to use or primary location).
    
    We have tried changing the Location ID to our "primary" (or default) location, but this has not worked for us.
    
    Any other suggestions?
    
    Thanks,
    
    DP