Skip to main content
Solved

Customized Sales Order Report Issue

  • November 5, 2021
  • 1 reply
  • 42 views

Forum|alt.badge.img+2

I have created a customized Sales Order Report which works as expected in the dev instance and sandbox, but running the report in the UAT environment gives duplicate lines. I have attached the report as well for further clarity. 

 

Best answer by Naveen Boga

Hi @TharidhiP  The duplicates issue with the Join conditions. 
I’m assuming that this might be reason and also check for other join conditions as well.

 

Can you please also add the BAccountID condition for the BAccount and Contact tables join below.

 

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

1 reply

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3393 replies
  • Answer
  • November 5, 2021

Hi @TharidhiP  The duplicates issue with the Join conditions. 
I’m assuming that this might be reason and also check for other join conditions as well.

 

Can you please also add the BAccountID condition for the BAccount and Contact tables join below.

 


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