Topic Options
#70873 - 07/18/24 12:07 PM A/P Module - Invoice Import
Shafeeq Offline
New Guy

Registered: 02/09/22
Posts: 7
Loc: Canada
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

Top
#70874 - 07/18/24 09:20 PM Re: A/P Module - Invoice Import [Re: Shafeeq]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3513
Loc: Toronto ON, Canada
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.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#70876 - 07/19/24 10:02 AM Re: A/P Module - Invoice Import [Re: Bruce Gardner]
Shafeeq Offline
New Guy

Registered: 02/09/22
Posts: 7
Loc: Canada
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


Edited by Shafeeq (07/19/24 10:04 AM)

Top
#70877 - 07/19/24 11:27 AM Re: A/P Module - Invoice Import [Re: Shafeeq]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3513
Loc: Toronto ON, Canada
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.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#70878 - 07/19/24 02:52 PM Re: A/P Module - Invoice Import [Re: Bruce Gardner]
Shafeeq Offline
New Guy

Registered: 02/09/22
Posts: 7
Loc: Canada
Thank you Bruce! Appreciate your help. Yes, I own Doc store, so I should be able to make this work.

Kind regards,
Shafeeq

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 16 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1850 Members
5 Forums
14283 Topics
69894 Posts

Max Online: 359 @ 11/18/19 09:08 PM
July
Su M Tu W Th F Sa
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31