Forum Discussion

Liam98's avatar
Liam98
Contributing User
2 years ago

Sales import file only picking up first line/sale

Hi there   I'm trying to get some additional sales data imported into a company on AccountRight. I'm using the Import Assistant and loading the file as a service (the data technically involves the ...
  • gavin12345's avatar
    gavin12345
    2 years ago

    Hi Liam98 

     

    Importing can be very tricky to get right. I suggest you spend some time in the Support area, search for importing.

     

    I can't tell what you are doing wrong, the info you provide is not consistent with the sample. If importing as Service sales, there should not be an Item column in your import. If you export as Sales > Item you must import as Sales > Item, likewise with Service.

     

    Follow the sample export file 'exactly' - including column order and name. If something imported correctly once, you may need to change it in order to import it again otherwise MYOB may reject it as a duplicate.

     

    Practice on a copy of your file. Or with small batches. A bad import can corrupt your file so take a backup beforehand.

     

    Regards

    Gavin

gavin12345's avatar
gavin12345
Ultimate User

Hi Liam98 

 

Export more than one sale of preferred type to create a sample template - this will show you what MYOB expects. In this case you need to add a blank line between each invoice. Multiple lines means multiple line entries on one invoice.

 

Regards

Gavin

Liam98's avatar
Liam98
Contributing User
2 years ago

Hi Gavin


Thank you for your response. I just gave it a go and it worked, however when I tried it with other data I started getting the -27 error message that a non-zero amount required an account. When I went back to my original file that worked the first time, I started getting the -27 error on that too although it definitely worked before. I've attached the file with the blank lines between each invoice (the one that worked before but for some reason isn't now). I tried adding new dummy income account numbers and changing them in the file however it hasn't made any difference, and I exported the services sales data already in MYOB to check the formatting and it appears to be the same as my file so I'm not sure what I've done to get it to stop working again. 

 

 

  • gavin12345's avatar
    gavin12345
    Ultimate User
    2 years ago

    Hi Liam98 

     

    Importing can be very tricky to get right. I suggest you spend some time in the Support area, search for importing.

     

    I can't tell what you are doing wrong, the info you provide is not consistent with the sample. If importing as Service sales, there should not be an Item column in your import. If you export as Sales > Item you must import as Sales > Item, likewise with Service.

     

    Follow the sample export file 'exactly' - including column order and name. If something imported correctly once, you may need to change it in order to import it again otherwise MYOB may reject it as a duplicate.

     

    Practice on a copy of your file. Or with small batches. A bad import can corrupt your file so take a backup beforehand.

     

    Regards

    Gavin

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.