Topic Options
#29237 - 10/05/11 11:44 AM Importing customer invoices
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4509
Loc: Wynnewood, PA
A client wants to import invoices from an Excel file and have Adagio assign an invoice number to each transaction, in sequential order.

Is this doable with standalone AR?

If not, is it doable in Invoices?

Thanks

Steve

Top
#29238 - 10/05/11 11:55 AM Re: Importing customer invoices [Re: Steve Schwartz]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
Hi Steve,

From the Adagio Receivables help file notes for Import requirements:

Hdr-Document Number is not required unless “Header fields on each record?” is selected. However, if the option is off and Hdr-Document number is not imported, the Batch and Entry number will be assigned as the document number, in a format 'B-E'.

AR standalone does not support an incrementing invoice number, but instead defaults a unique value derived from the batch-entry numbers.
-----------
From the Adagio Invoices help file notes for Import requirements:

If the Hdr-Invoice no is null in the import file (no characters nor spaces) and the ‘Increment’ option is selected in the Company Profile, then the next document number will be assigned. If Increment is not on, the imported invoice number will be the value in the same next document number field, but the same for all imported invoices.

If you don't import the invoice number field (or do import it but the import file value is empty), then importing will assign a sequentially incremented invoice number, provided that is how you have set up the Company Profile in Adagio Invoices for document numbering.
_________________________
Regards,
Softrak Tech Support

Top
#29240 - 10/05/11 12:30 PM Re: Importing customer invoices [Re: Softrak Support]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4509
Loc: Wynnewood, PA
Thanks, that's what I needed to know.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 48 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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