Skip to main content
Answer

Only one item showing on report

  • August 17, 2021
  • 4 replies
  • 191 views
F
Freshman II
Forum|alt.badge.img

Hi Guys,

We have a custom report called AP invoice with 2 parameters:

This gets pulled from bills and adjustments:

But when i run the report it only displays the first line item on the report:

Schema setup as follows

:

What am I missing?

 

Thanks

Best answer by Naveen Boga

Hi @francoisroux96  Since you have custom columns in this report, I have removed those custom fields and worked on it.

Finally, I figured out the issue, please find the details below.

  • Removed grouping for Group 1
  • Moved all the fields to GroupHeaderSection2 to DetailSection1 and make it visible

 

Got this error due to the custom field
Bill document with multiple lines

 

Modified report and I can able to see all the lines here

    4 replies

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

    Hi @francoisroux96  We need to review the table joins with the conditions. 

    If your report is works with Sales Demo data, can you please attach your report here (If possible), so that I can review and help you out, if I can. 

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    F
    Freshman II
    Forum|alt.badge.img
    • francoisroux96
    • Author
    • Freshman II
    • August 17, 2021

    Hi Naveen,

     

    Attached is the file

    1 Attachments
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • Answer
    • August 17, 2021

    Hi @francoisroux96  Since you have custom columns in this report, I have removed those custom fields and worked on it.

    Finally, I figured out the issue, please find the details below.

    • Removed grouping for Group 1
    • Moved all the fields to GroupHeaderSection2 to DetailSection1 and make it visible

     

    Got this error due to the custom field
    Bill document with multiple lines

     

    Modified report and I can able to see all the lines here

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Chris Hackett
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • August 17, 2021

    Hi @francoisroux96  Please find the attached modified .rpx file for your reference.

    1 Attachments
    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Terms & ConditionsCookie settingsAccessibility 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