Skip to main content
Question

Customized report (AP641000) duplicating bill lines.


Sagar Greytrix
Captain II
Forum|alt.badge.img+3

Hi Everyone,

I have customized the AP641000 report.

I've encountered an issue with the customized report. The problem is that it duplicates the bills included in the check, resulting in the respective number of lines being printed in the report. ex. if checks include three bills it displays each bill three times in the report.

I have attached a copy of my report and the mapping I've used to fetch bills. I would greatly appreciate any assistance or insights you can provide on where I might be making a mistake.

any help will be greatly appreciated,

Regards,

Sagar

 

Mapping I have used.
The output result.

 

10 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • December 26, 2023

@sagar07  Did you check the table joins?


Sagar Greytrix
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 112 replies
  • December 26, 2023

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

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • December 26, 2023

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

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

 

 


Sagar Greytrix
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 112 replies
  • December 26, 2023

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 


Connor Morse
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 50 replies
  • December 26, 2023

@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?


Sagar Greytrix
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 112 replies
  • December 27, 2023

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


Sagar Greytrix
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 112 replies
  • December 28, 2023

Hi Community,

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

Regards,

Sagar


Forum|alt.badge.img

Usually duplicate records causing by incorrect joins,

Please try the attached report


Sagar Greytrix
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 112 replies
  • December 28, 2023

Hi @MayomiRodrigo36,,

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • February 21, 2024

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


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