Import Data

[FionaB]

I tried to Import a Transaction csv file (second file for today, the first file imported with no errors) and the Error is as below:

Summary of errors
Error -15: Account number not found in list of postable accounts.

-15,184,Batch ID 379,05/07/2022,Payroll Journal 05/07/2022 Batch ID 379,N,21354.32,344,Pay Item,,N
,184,Batch ID 380,10/07/2022,Payroll Journal 10/07/2022 Batch ID 380,N,1263.05,428,Pay Item,,N
,184,Batch ID 380,10/07/2022,Payroll Journal 10/07/2022 Batch ID 380,N,5512.21,419,Pay Item,,N
,184,Batch ID 380,10/07/2022,Payroll Journal 10/07/2022 Batch ID 380,N,7751.66,393,Pay Item,,N

the original file upload - I have deleted names and replaced with AAA.

 {}
"Account Number","Journal Number","Date","Memo","Is Credit","Amount","Job","Allocation Memo","Category","Is Year-End adjustment"
"5-6000","Batch ID 379","05/07/2022","Payroll Journal 05/07/2022 Batch ID 379","N","21354.32","AAA","Pay Item","","N"
"5-6000","Batch ID 380","10/07/2022","Payroll Journal 10/07/2022 Batch ID 380","N","1263.05","AAA","Pay Item","","N"
"5-6000","Batch ID 380","10/07/2022","Payroll Journal 10/07/2022 Batch ID 380","N","5512.21","AAA","Pay Item","","N"
"5-6000","Batch ID 380","10/07/2022","Payroll Journal 10/07/2022 Batch ID 380","N","7751.66","AAA","Pay Item","","N"

Why is Data being lost in the Import e.g. Account Number & Name?

[gavin12345 · Accepted solution]

Hi @FionaB 

Known bug introduced by MYOB around AR2020.3 (or so) - the import log displays the Record ID of the account and the Card instead of the account number and card name. MYOB refuse to fix this despite repeated requests.

This however is not the cause of your import error, simply how the import log is displayed.

Check that the account 5-6000 is in fact an existing and postable account - seems a strange place for wages (COS account) and that it is not a header account. If it is, try creating your import file column order to match the expected column order. For example Amount should come after Account Number. You may think this doesn't matter, however for some imports it does.

Regards

Gavin

[FionaB]

Hi Gavin,

Thank you.

I resolved the error myself.

[gavin12345]

Hi @FionaB 

Glad to hear, perhaps post how you solved as this might be useful for others who have the same error and read this post. That is one of the primary roles of a public forum, finding how to solve a problem you are having.

Regards

Gavin