Forum Discussion

SL_2023's avatar
SL_2023
User
10 months ago
Solved

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. ...
import
item sale
location
locationid
sale
  • gavin12345's avatar
    gavin12345
    10 months 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's avatar
gavin12345
Ultimate User

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's avatar
SL_2023
User
9 months 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's avatar
    Earl_HD
    MYOB Moderator
    9 months 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's avatar
      dp23
      User
      7 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's avatar
        Shella_A
        MYOB Moderator
        7 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