@sagar07  Did you check the table joins?

Hi @Naveen Boga ,

Thank you for the prompt reply. I have reviewed the joins, and they seem fine to me. However, I am unable to identify the root cause of the issue. I have attached my report. Could you please provide some insights on joins? Is there anything I am missing?

Regards,

Sagar

@sagar07  I just don’t see the duplicate lines issue.

Have you tried by removing the joins one by one and verified?

Hi @Naveen Boga ,

The issue is replicated when we create a check for more than two bills. I have tried removing joins one by one, but it does not help me resolve the issue.

Regards,

Sagar 

@sagar07 - I typically see this occur with the “Inner” and “Cross” joins. Naveen is on the correct track as it is most likely related to a Table Join. Have you tried changing them to Left one at a time?

Hi @Connor Morse,

Thanks for the response. I've already attempted changing Inner and cross joins to Left, but unfortunately, it hasn't resolved the issue and still produces the same result.

Do you have any other suggestions or areas I should check?

Appreciate your assistance.

Regards,

Sagar

Hi Community,

Is anyone have any other suggestions to restrict duplicated entries from the report?

Regards,

Sagar

Usually duplicate records causing by incorrect joins,

Please try the attached report

Hi @MayomiRodrigo36,,

I have tried with the provided report by you, but still, it is duplicating records.

Hi @Sagar Greytrix were you able to find a solution? Thank you!