ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Ship To listing
http://www.istechforum.com/YaBB.pl?num=1218220935

Message started by Prier Scott on 08/08/08 at 11:42:15

Title: Ship To listing
Post by Prier Scott on 08/08/08 at 11:42:15

Is there a way to get a listing of "Ship to" customers that are related to a single "Bill to" Customer?

In our system, we will "Bill to" one address and use multiple ship to locations. I need to find out if there is a way to list all of the ship to addresses that co :(rrespond to to a single "Bill to" address?

Thanks for your help!

Title: Re: Ship To listing
Post by HB on 08/08/08 at 19:35:29

As far as I know, there is no DBA report that will yield the info you need. Nevertheless, there is a way to gt the info by using a simple report run on BARCUST using Crystal Report.
Write a report that lists customer addresses and also the field BKAR_CUST_YEAR. The last field lists the bill to association of the customer code that is listed as a shipto. It helps if the shipto codes resemble the make up of the billto code (i.e. cust_A = billto, CUST_AA = shipto, CUST_AB = shipto) That way they are listed consecutively in order. See sample

BKAR_CUSTCODE BKAR_CUSTNAME BKAR_CITY BKAR_CUST_YEAR
ABSBOO ABSO BOOKSTORES SAN DIEGO
ABSBOO-001 MIRAMAR COLLEGE BOOKSTORE SAN DIEGO ABSBOO
ABSBOO-333 ECC COLLEGE BOOKSTORE SAN DIEGO ABSBOO
ABSBOO-555 CITY COLLEGE BOOKSTORE SAN DIEGO ABSBOO
ABSBOO-999 MESA COLLEGE BOOKSTORE SAN DIEGO ABSBOO