Skip to main content
Solved

Duplicate lines in GI when joining SOLine and SOLineSplit

  • 27 September 2023
  • 2 replies
  • 103 views

jhouser
Captain II
Forum|alt.badge.img+1

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. 

 

 

 

 

 

Best answer by dcomerford

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 

View original
Did this topic help you find an answer to your question?

2 replies

dcomerford
Captain I
Forum|alt.badge.img+14
  • Captain I
  • 597 replies
  • Answer
  • September 27, 2023

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 


jhouser
Captain II
Forum|alt.badge.img+1
  • Author
  • Captain II
  • 103 replies
  • September 27, 2023

@dcomerford That worked, thanks so much!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings