value for MISCELLANEOUS Customer

[StanKorn]

I am tweaking a service bureau report for customer billing activity. The report requires a shipper name, a consignee name and a bill to name. I am able to get info for consignee and bill to customers but one time shippers are tagged as a MISC shipper and have no name attached to the record. When a MISC shipper is created a coresponding Bill To customer is created. I can get the shipper name from the bill to cust name. Bill to is not always the same as shipper but it is attached to an invoice so a name is always present. The shiopper number is a 10 char field and the first 4 char are always MISC the last 6 are city (4) and state (2). The shipper number is indexed to Customer Master on Cust Number which mirrors shipper number in structure. Standard customers are coming through OK it is the MISC that are a problem.
I'm using CR 8.5 and VFP 7 for the report.
Can anyone help?
thanks,
stan



Remember - only dead fish go with the flow.

 

[synapsevampire]

It sounds like you want to use a formula to show the ship to akin to:

if custname = MISC then
bill to cust name
else
custname

Your post doesn't supply any table layouts nor the report layout, so I can't really help beyond this right now.

I'd also fire the database developer and get someone in place that understands a normalized database design.

I know some good VFP folks if you're interested.

-k

 

[StanKorn]

Hi,
Thanks for your help. In fact your solution is the one I was working with and that solved the problem.
Re the developers - they really don't want to share too much info with me including a complete set of data dictionaries as I try to figure out how they are linking data to the Accpac acctng modules. They tell me it is a training issue and I need to enroll in their program. I have spent a great deal of time (8 yrs) in an Oracle world and this is my first real foray into VFP since MS acquired it way back when so I am moving in fits and starts. I am grateful to people like you who are available as a sounding board.
Thanks much for your input.
stan
PS - I can't fire them yet, Ive only been with this company a month but I can probably reduce our support costs over time <g>


Remember - only dead fish go with the flow.

 

[synapsevampire]

Nae worries.

I also have Fox experience, fortunately I bailed out around the time MS acquired it too as it appeared that it wouldn't get the support that VB would.

Going from Oracle to VFP is a major stumble backwards, but it sounds like you're up for it, good luck!

-k