Hi when I prepare either a CSV or a tab delmited text file and try and do an import, the system gives me the error in the title and for some reason, a 0 is inserted into the import file and immediately fails. Why is this happenng?
Hi Danmnbc,
The main thing causing this issue is that your import file needs to have a blank line between each separate invoice. Without those blank lines, the system reads everything as a single block, which can lead to weird results—like that “0” popping up and the import failing.
To make this easier, I’ve attached a template you can use. This one is set up as a tab-delimited file (so each column is separated by a tab, not a comma), just like MYOB expects for this type of import.
I hope this helps!
Regards,
Earl
Thanks Earl, I tried a single line entry and multi line entry. Neither worked. Also, I don't want to use the invoice as the number changes all the time, but the PO for all clients is the same. Is it possible to do this, attached is a fuller import file. Appreciate any help you can offer.
Hey Danmnbc,
Thanks for giving it a red-hot go with both single and multi line entries, and for sharing your import file. Since your PO stays put but those invoice numbers love to wander, the best way to get this sorted is to contact our team. You can reach them on Live Chat via our virtual assistant, MOCA, or by submitting a support case via MyAccount.
Cheers,
Doreen
