Forum Discussion

Liam98's avatar
Liam98
Contributing User
12 months ago
Solved

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
    12 months 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

Liam98's avatar
Liam98
Contributing User

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
12 months 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