So I'm trying to import a number of Manual Cheques from an Excel file, all of which happen to be from the same vendor, but represent a large number of different invoices/payments. I correctly tick One detail per entry as seen here:



HOWEVER, what I get in the batch is one giant invoice with all the individual entries under the first invoice number. All the ensuing invoice numbers are ignored and their lines of detail are added.

Anyone have any thoughts? I've read all the notes... it appears to be yet another import feature that doesn't work...

Hi Hugh

I know this works, since it was my client that requested this feature, and they use it regularly (and they print 20,000 checks per month this way). It has to be the layout of your import file.

Steve

I know it works too, but as always,
Sorry, I know that's not much help.

Try changing the order of the fields.

that is whack yo!

I changed the order of the fields and added some blank columns to match a file format that I know imports the vendors separately and it worked...
SAME data... NOTHING added other than blank columns to line up with 'Filler for Field X'...

So does anyone actually know how this works or is it just trial and error? I was contemplating hiring my local Adagio agent to work on my tax import problem, but I don't want to pay consultant rates if they're just going to thrash around like I'm doing...

If you have "Fillers" in the Import Template then you must have a column to match the Filler. "Fillers" allow you to skip fields in an incoming file where you cannot control the format coming in. If your incoming data does not have any fields to skip, then you shouldn't have any Fillers in your Import Template.

Adagio Consultants have usually set up many more imports than the average Adagio User and understand the relationship between the Import Template and the import file. Many consultants will quote you a fixed fee to set up the import if you will give them a copy of the import file and your data.

yes, I have no problem with the concept of 'fillers'... the issue is how adding or deleting an empty column of data and adding or deleting the corresponding filler with NO CHANGE OF DATA results in the import being handled differently...

How can you tell in an Excel spreadsheet if the column is empty or contains spaces (blanks) at the end of a spreadsheet? By definition, a blank column between two non-blank columns is not empty.