Hi Mike_James
We are having a similar issue. Is there any way to import Service Sales into MYOB Accountright as a CSV NOT a Txt file?
The reason being is that our other system only allows us to export our Invoices as CSV. I have set up the Report in our other system to have the same column naming conventions as those required in the MYOB import file to make it as easy as possible for Users to extract the data and then import it into MYOB.
However, if we convert the CSV file to a txt file manually, we have found that all of the items end up on 1 invoice instead of multiple, regardless of whether the invoice number is Unique (Invoice number 14053 and 14054). We think this might be because the txt. file does not have a blank row/gap between where one invoice ends and another starts. That's the only difference we have found between the txt. export file from the old system (which works perfectly) vs the one we have attached.
Any help or advice would be greatly appreciated.