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

SL_2023

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
- Shella_A
  MYOB Staff
  12 months ago
  Hi dp23,
  
  Thank you for your post and welcome to the MYOB Community Forum. I hope you find plenty of useful information.
  
  We're sorry to hear you're having an error uploading sales item to MYOB. We have a script that needs to run for this. I've sent you a private message to gather more information to assist you further.
  
  We will be waiting for your response.
  
  Cheers,
  
  Shella