I’m not really sure of how this is going to play out, but I am trying to generate a Generic Inquiry invoice whereby the parent is the bill_to_name with the child customer no and ship_to_name associated with the child account. At one point I did manage to get both but in most case, the child account was duplicated multiple times including the invoice number and total sales. I did try it by using one instance of customer as a parent, and a right join on another instance of customer as a child, and it worked until I startted putting the bill_to_city, bill_to_state and the child ship_to_city, ship_to_state. It really got convoluted. If anyone has anything that they’ve done in the past along these lines, please share. I’ve tried using some of the Out-of-the-box GI’s and modify them but so far no joy.
On another note, the joins for the “parent” and “child” have been tried with Left, Right, and Inner Joines. The right join worked until I started adding other fields such as ARTran.CuryTranAmt, or invoice numbers.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.