Topic Options
#19598 - 11/17/09 07:17 AM OE Formatting Invoices
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Since upgrading to OE 8.1C (090902) and AR 9.0A (090928) our customer's address on invoices from OE are printing a little differently. OE Invoice specification billing info is as follows:

C2 Customer Name
B8 Bill to Address 1
B9 Bill to Address 2
B10 Bill to Address 3
B12 Postal Code
B11 Bill to Address 4

When a customer has info in both Address 1 & 2 it prints as follows:

John Smith
123 Anystreet
RR#1
Anywhere, ON
K0H 1M0
Canada

When there is no info in Address 2 it prints as follows:

John Smith
123 Anystreet
Anywhere, ON
Canada

K0H 1M0

1. How do I eliminate the country from printing?

2. How can I pull the postal code up so it always prints on the line folling the City, Province?
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#19605 - 11/17/09 11:48 AM Re: OE Formatting Invoices [Re: SusanTennier]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11313
Loc: Vancouver, BC Canada
Hi Susan,

You have the wrong spec codes for your addresses. Codes B8 to B12 are the 'compressed' address codes, meaning that if an address field is blank, then subsequent address information (such as city, province and postal code) move to fill the gap. These address codes are meant to be used in sequence of address 1-4 followed by the postal code.

Because you are not using the address lines in that sequence, you should instead use the regular bill address lines B1 to B5 which prints the raw address information, whether it is a space or not. This gives you more control over the location of address information, but this also means that for your second example, there will be a space between the address and the city.

As for eliminating the country from printing, there is an option in the Receivables company profile to suppress printing the home country. There you can enter the home country into one field and set the option to suppress. This setting flows to Order Entry and any other Adagio program that prints forms and uses Customer address information.
_________________________
Regards,
Softrak Tech Support

Top
#19722 - 11/20/09 06:25 AM Re: OE Formatting Invoices [Re: Softrak Support]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Thanks, we are now using AR's "suppress home country" setting and the compressed codes B8-12 in their correct sequence. The result is excellent!
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 57 Guests and 2 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1847 Members
5 Forums
14236 Topics
69711 Posts

Max Online: 359 @ 11/18/19 09:08 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