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.

I must assume you are doing a journal entry import into Ledger and not a Cash Batch in Receivables.

Entry number is a 6 digit field.
Fiscal period is a 2 digit field.

I believe your template is setup incorrectly. If necessary change the specific fields back to their defaults and use Fillers to pick up the extra spaces.

Thank you for your response, the import is now working.

You assumed correctly that it is an import into the Ledger not Receivables. As a non-profit/charity we don't have many Receivables but we do have many donations to process in our database, so we don't even have the Receivables module.

I went back to check defaults and put in a filler as you suggested for the entry number for 6 and changed that field to the default 6. The fiscal period default is 6, I don't know why, but it worked with that.