Anyone else having problems importing large accounts data into Sage Cloud Line50?
I have an Audit Trail I'm trying to import of just over 600,000 lines. Yeah ok, it's a bit big, but that's not the problem.
The first error I get is on line 8414. This is right in the middle of a batch of SI lines with nothing wrong with any of the lines.
The second is in line 18762. Non-existent Purchase Ledger Supplier. The supplier has appeared before in the Audit Trail and it didn't choke on it then, so why now?
I extracted these error lines, together with a few lines either side into a small dummy import file, which would have imported correctly, had I not put a fake record in at the end so that Sage rejected it.
Now 18762 is round about double 8414. Not in accounting terms it isn't, but if you look at the number of characters in the file at each of those points, it's about double (1,459,000 bytes approximately). This doesn't equate to any "magic number" that I can see e.g., 2 to the power something.
Anyone else experiencing the same issue?
In the meantime, I'm going to have to chop up my import into chunks of about a megabyte each, making sure that the file does not split up journal entries.