Skip to main content
Solved

Only one item showing on report

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

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

    4 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 3404 replies
    • 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

    Hi Naveen,

     

    Attached is the file

    1 Attachments
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 3404 replies
    • 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
    1 person likes this
    • Chris Hackett
      Chris Hackett
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 3404 replies
    • 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/

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

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