Forum Discussion

nicole1213's avatar
nicole1213
Contributing User
4 months ago

Import error -28 item is not sold

Hi,   I have tried to import sale reports. some of them were imported successfully. But some shown the error of item is not sold. I realized the failed importing was missing item numbers. It shifte...
  • Mike_James's avatar
    Mike_James
    4 months ago

    Hi Nicole, I found a comment elsewhere about item numbers (codes) being case sensitive. In your original log, the following item numbers failed:

    Boiler Organic

    Cockerel_Spare Rib
    SYD_Hot Pot_HDL_Mushroom
    SYD_Chicken herb_soup
    SYD_Herb_Soup
    Cockerel - Fresh
    Cockerel_Giblet_BAG
    Cockerel_Hearts_BAG
    Cockerel_Liver BAG

    Can you check each one in turn with the code in MYOB and make sure that the case of each word (ie the use of upper and lower case) matches exactly? And that there is no space character at either end of the MYOB code?

Mike_James's avatar
Mike_James
Ultimate Cover User

Hi nicole1213 , you mentioned that you are seeing numbers in place of item numbers. The import log output was changed a year or two back to show the internal ID number instead of the item number, and the same for other records like account numbers. The advantage of this is that a missing or invalid item number will show a blank space, which makes it easy to find the problem item. 

nicole1213's avatar
nicole1213
Contributing User
4 months ago

Hi Mike,

 

thanks for you reply. The problem was I have successfully imported some reports which contains exact items. But some of those reports didn't go through. 

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    4 months ago

    Hi nicole1213 , are you able to post an example of the text file you are importing? (This is a public forum). If so, also tell me which lines had this error.

    • nicole1213's avatar
      nicole1213
      Contributing User
      4 months ago

      Hi Mike, 

       

      please see attached 2 files which i had problem with importing. 

       

      As you can see the last a few lines showing names (Cockerel_Spare Rib) as item number (this is how we set on our MYOB  for item number). But the top lines were shows numbers. 

       

      • Mike_James's avatar
        Mike_James
        Ultimate Cover User
        4 months ago

        Hi nicole1213 , what I would like to see (if possible) is the text file that is being imported, as well as the import log for that text file, it may be (?) one of the above files. 

         

        I presume you are importing the file as item sales.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.