Consolidating Customer Addresses

Chris Kelleher

Chris Kelleher

Administrator
Staff member
I'm running Syteline 3.5b01b, progress 8.2C, Unix DB Server, Novell File
Server

I have a few hundred customer ship-to-addresses that I'd like to
programmically
remove without manually keying them in Syteline as that would be very time
consuming.
Syteline will not let you delete a ship-to-address if it's ever been used on
a customer order
or invoice register, etc.
I'd like to simulate the Syteline logic of searching all relative
tables prior to deleting the
ship-to-address via a batch program but cannot determine which tables to
"touch" since
the Syteline program is GUI and therefore was written via a UIB and I have
not been able to
locate all the components (I know I need a UIB developers class). Has
anyone done this
and is knowledgeable as to which tables to test against OR does anyone have
some code
that they would be WILLING to share?

Thank You In Advance For Your Time !!!
johbol@gorbel.com
 
Actually it is in the rules program which is not a uib program..

look in the as/rules dir, check all the rules related to customer
and custadder... you should find the delete procedure and all of the
delete validations...

Mike
 
I thank everyone for their input and in summary here is what was determined:

The UIB program for customer maintenance has some includes for non-uib code
and the one that looks thru various tables in determining if a customer
address
(custaddr) table can be deleted is in the subdirectory "/as/rules" of your
syteline code and the file is called "customer.p" and the procedure is
called "pre-delete".

The tables used in determining if a customer address can be deleted vary
depending
on whether it's a bill-to address (cust-seq =0) or a ship-to address
(cust-seq > 0).
More tables are scanned in evaluating a bill-to address than a ship-to
address. My
intentions involve removing ship-to addresses only but some of you that have
also
expressed interest in this subject may not.

I hope this helps others in the same fashion that others have offered their
help to me.
 
You must log in or register to reply here.
Back
Top