• Subject: Re: Country Codes on Delivery Addresses
  • From: Bruce Stern <sternb@xxxxxxxxx>
  • Date: Fri, 05 Dec 1997 20:52:57 -0500

Jim Sehi wrote:
> Has anyone had a requirement where you wanted to identify a country code
> for the statement and delivery accounts and enable a search over the
> customer file by country code?  I have found that the country code exists
> in the customer address file (SLP05), therefore all addresses whether
> bill-to or ship-to do have a country code associated with them.... you just
> cannot enter or populate this field via the standard delivery address
> maintenance program.
> My solution was to put this field on the delivery address maintenance
> screen (OE020) and allow the users to key in the country code.  Next I
> looked at the sales analysis module to see if we could use the country code
> as one of our grouping criteria and we cannot!  That probably explains why
> our SA people put the country code in a group code.....
> ******************************

We put a country code, we call it a destination code in one of the group
code fields.  That allows pretty easy access.  In V3 this field can be
set to validate so that you can control what is in there.  We have
reports and extracts that use this field and it works just fine for us.

Bruce Stern
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to "JBAUSERS-L@midrange.com".
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.