Skip to main content
Question

Customized report (AP641000) duplicating bill lines.

  • December 26, 2023
  • 10 replies
  • 176 views
  • Translate All
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.

 

Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com

10 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20

@sagar07  Did you check the table joins?

Translate
Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
Sagar Greytrix
Captain II
Forum|alt.badge.img+3

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

 

Translate
Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com
Naveen Boga
Captain II
Forum|alt.badge.img+20

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

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

 

 

Translate
Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
    Sagar Greytrix
    Captain II
    Forum|alt.badge.img+3

    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 

    Translate
    Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com
    Connor Morse
    Jr Varsity III
    Forum|alt.badge.img+1

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

    Translate
    Connor Morse, Kensium - Please *Like* if our support has helped. Please mark it as *Best Answer* if we have provided an answer to your question.
      Sagar Greytrix
      Captain II
      Forum|alt.badge.img+3

      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

      Translate
      Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com
      Sagar Greytrix
      Captain II
      Forum|alt.badge.img+3

      Hi Community,

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

      Regards,

      Sagar

      Translate
      Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com
      Jr Varsity I
      Forum|alt.badge.img

      Usually duplicate records causing by incorrect joins,

      Please try the attached report

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

        Hi @MayomiRodrigo36,,

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

        Translate
        Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com
        Chris Hackett
        Community Manager
        Forum|alt.badge.img
        • Chris Hackett
        • Acumatica Community Manager
        • February 21, 2024

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

        Translate
        Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
        Terms & ConditionsAccessibility statement
        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