HB
Full Member
I love DBA
Posts: 216
Gender:
|
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
|