I'm 99% sure I'm screwed here, but I thought I'd toss it out anyway just in case...
Because in Canada we have a refundable value added tax (the Gruesome Super Tax, or GST) ALL of the data files I'm trying to import into AP have this tax in line with the other data:
InvoiceInformation, ExpenseAmount, TaxAmount
but the import file structure is:
InvoiceInformation, ExpenseAmount
InvoiceInformation, TaxAmount

is there a way to configure the import spec to get the latter from the former?
Thanks for your thoughts!

Hugh:

Almost always solving import issues involved some experimentation which requires the actual import file and database. Almost always we end up having to create a little utility program to manipulate the import file into something that Adagio can understand.

If your dealer can't assist you please feel free to contact me.

Hi Hugh,

The short answer is that if you are importing an invoice with a Distribution code on the detail that is defined as a 'Tax-included distribution', it is possible to import an expense amount that includes taxes, and a tax amount that is either automatically calculated or specifically determined in the import file that overrides this calculation. This note is from the Help file for import invoices notes:

Det-Tax Amount/Base: For overriding tax amount on Tax included purchase distributions or tax base on Tax distributions. Import 0.00 and these amounts will be calculated from the tax rate on the Distribution code.

Discussing how to do this in the most efficient and correct manner in the way your company requires is best handled with your Adagio consultant.

Thanks for that!
So at this point I've got it all sorted EXCEPT that even though I'm importing a value for Det-Tax Amount it's not overriding the calculated amount....
Grrrr....

*edit* Figured it out! Thanks gang!

damn. didn't work out. I CAN make it successfully import my Det-Tax Amount but the method, although it yields an identical look on the screen, fails to post based on the totals not working out.
According the quote from the manual it should allow me to import my own tax value unless I leave it at zero in which case the calculation associated with the distribution code takes over. However, if I make the distribution code for Tax In Purchase it ignores the amount I import for Det-Tax Amount and puts in the calculated amount.
Seems buggy to me.

Have you carefully reviewed the Import/Export Tech Tips regarding this import?

If there seems to be a bug in the import, then you can ZIP both the import files and the database and email them to me and I'll take a look.

Still working on this, but meanwhile, is it possible to import a multiple expense file without duplicating the header information?
As In, can I import a file that goes like this:

HeaderInformation, GL Account 1, Amount 1, GL Account 2, Amount 2, GL Account 3, Amount 3

Or does it have to be this:

HeaderInformation, GL Account 1, Amount 1
HeaderInformation, GL Account 2, Amount 2
HeaderInformation, GL Account 3, Amount 3

If I know it can't be done then I can stop trying!
And yes, I know I could manipulate a file that looks like the former so it ends up like the latter, but I'm trying to save input time so I'm not wanting to spend a lot of time massaging the file for input. If that's the case then I might as well just key it in directly....
Thanks!

Hello Hugh,

You can do it if the format is a CSV file and you identify the Header row with a "H" and Detail entries with "D".

But it's easier to set up an Excel Table that duplicates the Header information for each row as you key in the details.

Way easier.

Thanks Andrew!