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

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