Hi,

I'm just inquiring if there is Field for importing date of invoices in the "Import Invoice"?
The default version only have the Due Date, but I need the Date field to be updated as well. Right now, the date is being defaulted to the date of which user has logged in.

If you need additional information, please let me know.

Kind regards,
Shafeeq

Shafeeq:

Yes, you can definitely import the Invoice date.

Three steps: (1) add the Invoice date as a column to your import file (placed among the other header fields) then (2) modify the Import template to include the field "Hdr-Transaction Date" in the appropriate position then (3) while that field is highlighted, look at the bottom of the Import screen and select the right date format.

Note: If you are using the template named "Invoices Default" or you don't see "Hdr-Transaction Date" as an option, first select the tab named "Field Defaults" and unselect the field "Hdr-Transaction Date" (highlight the field then click on the arrow that points to the left). Now you can go back to the tab named 'Import Field Selection" and "Hdr-Transaction Date" will be available to select.

Here is a 5-minute YouTube video on Adagio importing: Video on Import Templates

Imports can be finicky (to quote someone), so if you have troubles with the process, ask your Adagio consultant for guidance.

Thank you Bruce, I initially did not see the Hdr-transaction date.
It works as intended now.

By any chance, would you know how to attached a pdf to each invoice? There is a field "Hdr-Attach PDF" but I have not seen a description of this function of how it works.

Your help is much appreciated.

Kind regards,
Shafeeq

Shafeeq:

You need to own the Adagio module DocStore - used to attach PDF documents to records. If you do, you would put the PDF filename and the full path to the file into that field.

Thank you Bruce! Appreciate your help. Yes, I own Doc store, so I should be able to make this work.

Kind regards,
Shafeeq

Here are transactions of an invoice in AP invoice batch detail list

Vendor No / Name
PAC002 Pacific General

Entry Document No Date Description
1 95339 02-10-24 C123975

Due 31-03-25 Terms 180 180 days

Ty Dist Acct Dept Tx Document Amount
PU 11 1021 0 1,172.91
PU 1331 1 0 -175.04
PU 1339 1 0 68.99
1,065.96

Here are transactions of an invoice in AP invoice batch detail list

Vendor No / Name
PAC002 Pacific General

Entry Document No Date Description
1 95339 02-10-24 C123975

Due 31-03-25 Terms 180 180 days

Ty Dist Acct Dept Tx Document Amount
PU 11 1021 0 1,172.91
PU 1331 1 0 -175.04
PU 1339 1 0 68.99
Totalinvoice 1,065.96

Appreciate that some one can teach me the parameters to import

Thanks

Please ignore earlier posting.

Hello

This kind of question is not the kind that lends itself to being answered on the forum, especially not the General Inquiries forum.

There is documentation on the Client Portal of the Softrak website on how to import in Adagio - https://portal.softrak.com/resources/adagiotips.php

I will email you the PDF on importing AP invoices. If this doesn't help, you will need to contact your consultant.

Steve

Dear Steve
Received your email and PDF.
Will study the details.

Terima kasih (thank you in Malaysia)

Hello:

In addition, you can see actual import files and import templates. Open the Payables sample data (located in \Softrak\Payables\Samdata folder). If you look at File - Import - Invoices, you will a number of import templates. There are several choices in recent versions, fewer in older versions. But you should see at least one - "Invoices Default". It imports a file named "APINVIM.CSV". This template is the bare minimum. Using the documentation from Steve, you can convert the CSV file to Excel, add columns and adjust the import template.

Also, here is a 5-minute video from Softrak on Import Templates: YouTube video on Import Templates

Dear Mr Gardner
Glad to hear from you.

We are using Invoice import and export templates and they are exceptional and work very well.

We don't use AR invoice

As for AP we don't intent to use its import templates because the its copy feature serves us better. Moreover most of the fields are constant except date and vendor account no.

Thank you for your feedback.

My previous comments

Variable fields are date, vendor number and
line items values