Topic Options
#27004 - 04/21/11 12:08 PM E-MAil Setup for A/R Statements & Invoices
RFA Offline
Adagio Scholar

Registered: 07/03/06
Posts: 93
Loc: Plymouth, MA
I am trying to setup the e-mail in A/R and I exported all the relevant information is there for the entire customer database. I made the changes to the first client exported the proper fields and went through the information. There are some fields that have come up with specifications that I can't find and am wondering where they are so I can chcek them and prepare them to be used. These fields are
Inv. OE inv. email spec -------> OE0B1C~1
Inv. OE cn. email spec -------> OE$NBT~1
Inv. OE inv. print spec
Inv. OE cn. print spec


some of the customer database has filled the specifications with those noted above.

Where are these "specifications" found ???
_________________________
Thanks &
Best Regards,

Ricardo
rfa@rfa-associates.com

Top
#27009 - 04/21/11 06:26 PM Re: E-MAil Setup for A/R Statements & Invoices [Re: RFA]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3612
Loc: Toronto ON, Canada
Ricardo:
Those are short versions of the full specification name. You can create an Invoice with a very long name (i.e. "OE$Invoice for All USA Customers except Texas"). But Adagio isn't going to store that full length name. It has a field 8 characters long and stores a shortened version of the name. Having longer fields would slow performance.

It takes the first 6 characters of the name and adds "~1" to the end (the name above would become "OE$INV~1"). If there were another file with the same 6 leading characters, it gets "~2" on the end. This is the same technique that DOS used to use (and maybe still does) to name files with more than 8 characters.

So you should look for a file that starts with "OE$NBT". The other one looks odd since it doesn't have a $ sign in the name. Adagio recognizes OE specification files because they have a $ sign in the 3rd position.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#27011 - 04/21/11 07:55 PM Re: E-MAil Setup for A/R Statements & Invoices [Re: RFA]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Why are you exporting all the fields to "setup e-mail"?

If you are trying to load your customer's e-mail addresses, then just create an export template with Customer code, name and e-mail and then use an identical template to import that information back into the database.

Certainly the stored specification names (or most of the other fields) aren't required for the task you describe.
_________________________
Andrew Bates

Top
#27028 - 04/26/11 11:25 AM Re: E-MAil Setup for A/R Statements & Invoices [Re: Retired_Guy]
RFA Offline
Adagio Scholar

Registered: 07/03/06
Posts: 93
Loc: Plymouth, MA
Thanks,
I didn't export all the fields just the ones that I thought related to the E-mail fields. I didn't mean all the fields, sorry. I will import all the fields that I know and leave the others for me to figure out later.

Thanks
_________________________
Thanks &
Best Regards,

Ricardo
rfa@rfa-associates.com

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 82 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14459 Topics
70635 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