Hi All,

I'm trying to import cash invoices into AP. I haev a list of 42 'vendors'. Column A has the vendor name, column B the address, column C the amount i'm paying etc.

I've read the manual and checked out some of the sample data.

Am i right that it will not work this way? Do i have to do it in CSV if I have multiple vendors in a single invoice file with H-header lines followed by D-Detail lines?

Thanks all,

Cam

Which column has the Vendor Code?

There's a Technical Tip on our web site for setting up imports, and the Help is very detailed.

Imports are fiddley.

I'll check that out.

Thanks for the speedy response Andrew.

Have a merry Christmas!

Ok, i'm almost there.

One final error comes up at the end:

"Error SOURCE DECIMALS NOT SET occured when attempting to append record to manual chck batch detail"

I'm using CSV. It gets through all 45 record i'm importing and this comes up at the end.

Also, how do I enable the 'one detail per entry' option?

Thanks,

Cam

Hi Cam,

Are the checks you are importing for vendors on file, or cash invoices for miscellanous vendors? This could be important, as your company runs with multicurrency enabled, and if you are importing for misc vendors then the import may not know what currency to assign to the payment, since that comes from the vendor (control account set).

To allow 'once detail per entry', the option for 'Header fields on each record' must be selecting. This is a more 'Excel-oriented' layout where the Header and Detail lines are on the same row, as opposed to the Header line on one row and the Detail row on the next line.

Hi Folks,

I've got this working. I'm importing manual checks and cash invoices for existing vendors. It's CDN$. I've done the import file in excel and have it very simple: Hdr-Vednor Number, Hdr-Reference, Hdr-Description, Hdr-Check Number, Det-Amount Paid.

I've set the defaults as required.

Everything is working, except the Det-amount is showing as $0. The import comes in successfully and says there are 0 errors and all records were imported successfully.

I've got exchange rates all set at 1.000, distribution set defined etc.

Any idea why the det amount would be $0? We can just manually pound them in to each transaction, but that kind of defeats the purpose of the import!

Thanks,

Cam

Hi Cam,

Sorry, but this isn't enough information to go on. Attempting to define and save an import template for Manual Checks with only the fields you've indicated give errors that the minimum required fields have not been selected. You indicated that some fields have Default Values set on the 3rd tab of the Import Template, and knowing what you've done would be interesting.

When you look at the imported batch, see if the exchange rate on the cash invoices is actually 1 or 0.

You said you were default a distribution set, rather than a single distribution code? Distribution Sets are not actually importable, only individual distribution codes. More clarification is necessary.

On sample multicurrency data and Adagio Payables 8.1E, with the layout you indicated and the minimum field default values set for the cash invoice number (auto-generated), distribution code (account number already assigned to the code) and home currency bank code, the import batch I imported had non-zero amounts for all cash invoice distributions. I did not default a value for the exchange rate because for home currency vendors this is not required.

You probably will need to get assistance from your Adagio consultant if the results of the import does not give a clue as to the cause of the problem.