Customer Primary Bill To Contact

(Cathy Bennett) #1

I am creating a BAQ to be used in a DMT to update a user defined field on the CustCnt table.

I have the Table relationship to the customer:

PrimBCon to ConNum

However, I am getting more than more than just the primary Bill to Contact.

Example - the PrimBCon and ConNum are 1 -
I am getting 3 records because there are 2 ship to - where the ConNum is 1 for each shipto.

I tried using a the ? as a null and a negative for ISNULL and I still get the same results.

Any suggestions on how I fix this?

(Brad Boes) #2

You could try changing the ConNum table to first instead of each.

Brad Boes

(Jim E. Terranova) #3

Criteria or Filter on ShipToNum = “”

(Cathy Bennett) #4

Thanks - I was thinking that ShipToNum was numeric but, it is a character field.