Hello,
I’ve joined SOLine and SOLineSplit so I can get the PO and AP bill associated with sales orders in a GI. When I activate the join, it shows multiple lines for an invoice / order with only one line as shown below. Been wrestling with it for a while and hoping someone can assist. XML of my GI attached. Thanks in advance.
From a quick look you will need to use the Grouping tab. So group by the ARTran RefNbr, LineNbr should elimiinate the duplicates you can then use Average as the Total Agregate function to get the correct results of the decimals fields
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.