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.
Page 1 / 1
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.