Solved

Duplicate lines in GI when joining SOLine and SOLineSplit

  • 27 September 2023
  • 2 replies
  • 72 views
jhouser
Rank
Userlevel 4
Badge +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. 

 

 

 

 

 

icon

Best answer by dcomerford 27 September 2023, 16:35

View original
1 Attachment

2 replies

dcomerford
Rank
Userlevel 7
Badge +12

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 

Dermot Comerford
jhouser
Rank
Userlevel 4
Badge +1

@dcomerford That worked, thanks so much!

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved