I am trying to import a csv file from my payroll software into Ledger and get the error "Invalid Date '05/31/2006' in field called 'Fiscal Date" in record 1". I do not get an error on the transaction date however. It is set to ascii YYYYMMDD format.

I tried to change the date format on my system to mm/dd/yyyy but that did not fix it.

I had no issue with this previously but recently I installed a Ledger patch.

Which payroll program are you using?

Can you copy and paste the import file (or at least a small portion of it) into your response so that we can have a look at it?

Hi Sheldon,

I am able to duplicate the problem where the import process does not like the M/d/yyyy format - I have seen this in other Adagio applications as well with specific versions. I can forward this to development for you. Likely the problem occured in the installed service pack.

Make sure that in the import template, you use the M/d/yyyy format instead of the ASCII YYYYMMDD format (which expects dates to be "20060531" instead of "05/31/2006").

We are using Avanti payroll but I create the file with an Excel Macro from exported data.

Here are three records from the import file.

D,1,20060820,7,492,101,GLJE,Avanti,20060731,To Accrue July Payroll,3173.07
D,1,20060820,7,492,102,GLJE,Avanti,20060731,To Accrue July Payroll,24895.53
D,1,20060820,7,492,103,GLJE,Avanti,20060731,To Accrue July Payroll,1356.2
Type,Entry#,FiscalDate,Period,Acct,Dept,SourceCode,Reference,TransactionDate,Description,HomeAmt

I prefer to use an ascii format for the date rather than a typical date format as it is easier to work with when creating and saving the files.

Thanks for your help,
Sheldon

If the dates are 20060820, then the field date format should be set to ascii YYYYMMDD. On the second screen of the import batch function, highlight each date field on the right. Make sure that the date format as displayed at the bottom is YYYYMMDD.

The file is consistent with the date formatting. The error is on the "Rate Date" which I have set as a defaulted field because I am not importing it.

The error is "Invalid data '08/31/2006'for field called 'Rate Date'.

As a test I added that to the records I am importing and it worked for me. It just will not if I do it as a defaulted field.

Sheldon

Any ideas how I can fix this yet?

Hi Sheldon,

It looks like for now, you'll have to add Rate Date to the import file. Can you open your file with Excel and add a new column? Copy/Paste can be useful here.