We have a database that where many of our cash receipts are entered and it is capable of exporting to ACCPAC Plus (it was setup when we were using version 6.1). It looks to me like I have the fields set up correctly in Adagio. But when I try to import the file I get an error "invalid data '70723' for field called fiscal period of record 1. The start of record 1 is E[11spaces]120070723[5spaces]4[2spaces]5084[6spaces]GLCRDES[1space]2194[4spaces]20070723. It is a text file and I have the file type as ASCII fixed length (this is import detail only) and the fields in order are:
Record Type string width 1
Entry Number number width 12
Fiscal Date ASCII date YYYYMMDDD width 8
Fiscal period number 6
Account code string width 6
Department code string width 6
Source code string width 4
Reference string width 12
Transaction date ASCII date YYYYMMDD

all offsets if any are 0 or blank - I'm not sure what those are for.

Is there something I'm missing, or have wrong - it seems to be picking up the wrong characters for the fields, but I'm not seeing why.