I am trying to import invoices from excel to Adagio Account Receivable and I cannot figure out the format. I tried to find the file arimport.csv & arinv.csv (as suggested in technical discussions) and could not find them. Please help me.

Do you have a manual that goes over the import formats and field structures for ar,ap & gl as this would be soooo useful and save a lot of time for the end user.

Hi Laura,

The sample import files are in the sample data. If you have installed sample data, look in the softrak\crwin\samdata directory for these files:
ARCASH.csv
ARCREDIT.csv
ARDEBIT.csv
ARINV.csv
ARINVJC.csv

The manual does not cover the import formats. In many cases, you define them yourself. For batches, Import has a default template for each batch type. These default templates were set up to accommodate import files that were previously defined for Accpac Plus.

While you are working on a template, highlight a field under Import file fields. The properties for that field will be displayed. You can also print the template to see the properties of all of the fields you have selected.

I have tried importing invoices into A/R using the sample data file, and have come across a few errors when trying to import the file. This file has 89 records in it. example of errors received ?Value`,2030,1000,3.43,0,0? for field called ?Det-Distribution Code? of record 76 is invalid. Import halted.? In the file the field ?Det-Distribution Code? for this record has "" not what is indicated in the error message. Once I remove line 75( the line before the line mentioned in the error message) and try to import, I receive a message ?Import aborted. 80 records successfully imported. 0 records corrupt.? And the file is not imported. Then if I removed records 80 to 89 and then import, it goes through successfully.
I'm not sure why I am receiving these errors. It might be easier if I could send you the file for you to review.

Thanks

Hi Laura,

There probably is a missing/extra comma or a missing/extra quote on or around record 75. Because of this, the sequence of fields is being thrown off.

What you will need to look for is that the fields have the proper quotes when applicable (ie for string fields, not numbers), and that there aren't any missing or extra commas.

To aid in this search, you might want to open the CSV file in Word or some other text editor (ie not Excel), and also print out the Import Template within Adagio Receivables, and compare the records to the template.

Lastly, make sure that you don't have any fields that are too long. For example, I have seen a similar problem and the reason was that the document numbers in the import file had 13 characters; the maximum allowed is 12. It would be useful to look at your CSV file in a text editor and monowidth font, so that you can see extra spaces, differing field lengths, etc.

Regards,

For others reading this posting, part of the issue was the format of the import file. It was a CSV file and had probably been opened and edited with MS Excel. This affect the date fields.

Also, Adagio Receivables imports invoices using a 'Header/Detail' format, meaning that one row is devoted to a header, followed by a separate row for each detail. The import file used here had the header and all details on a single row, which confused the import process.

Here's the first line of the sample import invoice file mentioned above, for comparison purposes:

"I","CON01","IN5294","IN","Import invoice", "020901","NET30", "Net 30 days", "021001", "020901", 0.00, 550.00, "Reference", "AR","","", 0
"D", "CON200", "", "", 450.00, 0, 0.00
"D", "CON100", "", "", 100.00, 0, 0.00