Skip to main content
Solved

Line Items Repeated on Sales Order Report


jens0910
Freshman I

When printing a sales report the items will be repeated for many pages but the total on the final page is correct.  In this case the line item was repeated for 65 pages.   How can I fix this?

 

Best answer by BenjaminCrisman

@jens0910 Thank you for the report file, I checked the setup and it looks like it comes down to at least one of the relations containing no data links:

I would recommend to add links to this relation or remove it if it is not needed, but because the table is joining to itself there could be duplicates coming in and an alias could be needed for the Child Table.

Hope this helps clean it up!

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

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3382 replies
  • March 18, 2022

Hi @jens0910  I’m assuming that you have customized this report and added/modified the table joins.

 

if possible, can you please share the report file here?


jens0910
Freshman I
  • Author
  • Freshman I
  • 8 replies
  • March 18, 2022

I think that our integrators customized the report and I downloaded it to test something and then this problem started.  I didn’t think I changed anything - I’m new to the report designer.


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 631 replies
  • March 18, 2022

Hi @jens0910 ! In this case you have uploaded a .rps file type which is not really something we can use to check the report.

What we will need is a .rpx report file, which can be created by clicking File > Save As in Report Designer with the report open.

This will generate a .rpx file which is the actual report.


jens0910
Freshman I
  • Author
  • Freshman I
  • 8 replies
  • March 18, 2022

Ok, I think this should be the rpx


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 631 replies
  • Answer
  • March 18, 2022

@jens0910 Thank you for the report file, I checked the setup and it looks like it comes down to at least one of the relations containing no data links:

I would recommend to add links to this relation or remove it if it is not needed, but because the table is joining to itself there could be duplicates coming in and an alias could be needed for the Child Table.

Hope this helps clean it up!


jens0910
Freshman I
  • Author
  • Freshman I
  • 8 replies
  • March 18, 2022

Looks like that fixed it, 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