Skip to main content
Solved

Duplicated Line Items after adding SOLine.ShippedQty - SO, Invoice


Forum|alt.badge.img
  • Jr Varsity II
  • 24 replies

 

Best answer by arjan

Hi @Naveen B i sent the original report, before making those changes. thought maybe there is a issue with the report itself and how it was setup in first place. However, when i have both ARTran-SOOrder and ARTran-SOLine (LineNbr added) setup, report works just fine with ShippedQty and no duplication.

 

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

15 replies

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 24 replies
  • November 4, 2021

 


gprice27
Jr Varsity I
Forum|alt.badge.img
  • Jr Varsity I
  • 25 replies
  • November 4, 2021

Hi - you are getting this because the SO is the parent of SOLine (One to many) and so if there is more than on line in the SO - you get duplicates.

Try joining the ARTan to the SOLine first - and then to the SO - that way you maintain the one to one with the ARTran - and use the SO as a ‘lookup’

Also - your join is not correct - you need to join SOLine to SO by RefNbr 

Hint : Try this in a GI first - you can use the related tables feature to find how to join the tables.

Best

G


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 4, 2021

Hi @arjan   The SOOrder and SOLine join is wrong, and it should be like below.

 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 24 replies
  • November 8, 2021

Hi @Naveen B ,

 

it is still the same after following all the guidance.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 9, 2021

Hi @arjan If that is the case,  we need to check all the joins conditions, whether we have properly applied or not.

I’m seeing one more on this issue with the joins. Please find the details below.

  • REMOVE the Join records between (ARTran and SOOrder) and (SOOrder and SOLine) 
  • Add new join between ARTran and SOLine with the below conditions (since you wanted to see only SOline Shipped Qty → no need to join with SOOrder). 

Please find the screenshot for reference.

 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 24 replies
  • November 15, 2021

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 16, 2021

Hi @arjan  The above issue is NOT with the newly added JOINs, you might need to check the other areas where it is causing this issue. 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 24 replies
  • November 16, 2021

Hi Naveen,

can you please expand more on other areas that need attention?

report preview works when changes above haven’t made.

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 16, 2021

Hi @arjan  In report, what value you have provided for the SHIP ? 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 24 replies
  • November 16, 2021

@Naveen B     SOLine.ShippedQty

 

along with your suggestion above, i also added table relation for ShippedQty. throws same error.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 16, 2021

Hi @arjan  There is something wrong! Can you please share your report here.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 24 replies
  • November 16, 2021

@Naveen B  please see attached zip file.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 17, 2021

Hi @arjan  I just reviewed your report, and it seems you have NOT added the SOLine Joins in the RELATIONSHIPS tab.

You made join between ARTran and SOOrder but NOT ARTran and SOLine, hence you are getting that issue.

Add the SOLine with ARTran as suggested abouve and verify. 

 

Here is the screenshot for your reference.

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 24 replies
  • Answer
  • November 17, 2021

Hi @Naveen B i sent the original report, before making those changes. thought maybe there is a issue with the report itself and how it was setup in first place. However, when i have both ARTran-SOOrder and ARTran-SOLine (LineNbr added) setup, report works just fine with ShippedQty and no duplication.

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 17, 2021

Awesome @arjan  Thanks for sharing the update.


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