importing error

Question

Hi Support&nbsp;&nbsp; I keep getting errors when importing payments and purchases.&nbsp;&nbsp;&nbsp;&nbsp; We were using MYOB&nbsp; AccountRight Premier V19.16 on the server..&nbsp;&nbsp; We migrated everything over to &nbsp; AccountRight Plus&nbsp; V2022.3.0&nbsp;&nbsp; cloud version&nbsp;&nbsp;Every month I have to export/import the sales, payments &amp; purchases into myob from our POS.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The old MYOB was fine, but now we are having heaps of problems.&nbsp;&nbsp;Error -2: Account Number is too long.&nbsp;&nbsp;&nbsp;&nbsp; from my payments import&nbsp;Error -25: Invalid amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from my purchase imports&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Only the sales seem to be ok.&nbsp; The Payments &amp; Purchases are all getting rejected.&nbsp;&nbsp; I have attached an example.&nbsp;&nbsp;

gavin12345 · Answer

Hi&nbsp;Mickraves&nbsp;&nbsp;Have you modified your import to suit AR2022 import fields? - these are not the same as v19 import fields. Posting the import file as well as the import log file provides more info about the cause than posting the just the import log.&nbsp;Also having amounts like&nbsp;$1,014.00 in a CSV file is bound to cause errors, don't use commas in amount fields.&nbsp;RegardsGavin&nbsp;

mickraves · Answer

Thanks I will look into those things you have mentioned.I have attached the import file.

gavin12345 · Answer

Hi&nbsp;Mickraves&nbsp;&nbsp;The import file looks ok to me, automatch won't work properly unless you change the column headings to match exactly the headings as required by AR2022.3, for example instead of 'Invoice #', use 'Invoice No.'.&nbsp;&nbsp;Fix the column names, avoid formatting in amount fields, remove the dash from account numbers - this should get it all working as expected.&nbsp;FYI using Card ID or Record ID is safer than using Co./Last Name. Some files have 2 cards with same name - import will fail. CardID and Record ID are unique.&nbsp;RegardsGavin

Forum Discussion

importing error

3 Replies

Looking for something else?

Related content

4077 Import Error

Import Spend Money Error 19

Importing Error 4077

Import error: import file not loaded

MYOB Import Errors

Importing sales error -25

Import Item Error

Import Error 25