Welcome, Guest. Please Login.
11/19/24 at 05:26:37
News:
Home Help Search Login


Pages: 1
Send Topic Print
Ship To listing (Read 347 times)
Prier Scott
Browser
*


I Love YaBB 2!

Posts: 1
Gender: male
Ship To listing
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!
Back to top
 
 
  IP Logged
HB
Full Member
***


I love DBA

Posts: 216
Gender: male
Re: Ship To listing
Reply #1 - 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
Back to top
 
 

Helmut Bode
General Pencil Co.
DBA Classic 2004.1 w/IS Tech update 7/25/13
EVO-ERP
Pervasive 11
Win2008 Server
Terminal Server
12 Users
Email   IP Logged
Pages: 1
Send Topic Print