
I have this issue with Picking Report, the first two items get duplicated when I'm running the report designer.
I have this issue with Picking Report, the first two items get duplicated when I'm running the report designer.
Hello
Could you please share the report to check on this?
Also sharing the PDF file of the report which has issues
Duplicate lines on a report are nearly always related to incorrect Join on the tables. For example, is the table joined on only one field when the table has multiple key fields? Was Join Type Left when Inner Join type is needed?
If you review the joins and you can’t solve the problem… To help us find your problem, please post a screen shot of the Relationships/Joins in your report with highlights on the custom changes that were made → identify the tables that were added that were not part of the standard Picking List report.
Thank you.
Hello
Could you please share the report to check on this?
Also sharing the PDF file of the report which has issues
PICK LIST Will be printed with the lines if the Item is allocated to multiple locations.
Item name “Sample SKU ” has 10 Qty shipped from A warehouse but Item is allocated from 3 different location
Warehouse | Location | Qty Shipped |
A | A-000 | 5 |
A | A-001 | 3 |
A | A-002 | 2 |
In this scenario, the lines in the pick list will display in three lines as per the standard behaviour.
Thanks
Try this change once and let me know
If not resolved please share the Report version so that we can help you
Thanks
Hi
I sent a DM to you. could you please send a zoom link to meet you?
Thank you
Hello
I will try to help, although I am not the world’s best table joiner… I admit my weakness to you because (like me) you sometimes have 59 versions of the same report.
Thank you!
Hello
I will try to help, although I am not the world’s best table joiner… I admit my weakness to you because (like me) you sometimes have 59 versions of the same report.
Thank you!
Hi,
Thanks
Hello, I will need the two screen shots, in order to help further. Thank you.
Hi
I tried a couple of shipments to replicate the issues in My local environment, probably you can reach out to Acumatica for help or else you can ask your developer to check the relations once.
Thank you
Hi
To generate the .rpx file just open the report and click File > Save As… and then attach the resulting document.
Then we can open it and view the report and the build schema
I am hesitant to request more details and screenshots as it could still be difficult to know, but I do see several joins at the bottom of the report which I would recommend to start with removing to see if this is resolved.
Anytime you are making changes to a report there are a couple tips I started incorporating which makes this kind of issue easier to solve.
First, I would recommend to make smaller, incremental changes and save a new version of the report so you can test for breaking changes and easily revert to a prior report as sometimes a breaking change can mean being unable to load the report screen to de-activate/remove the problem version.
Second, for this issue I would start at the bottom, comparing to out of the box Pick List report, start dropping the relations and then checking to see if this was the cause of the issue.
Third, I hard code parameters into the report based on the parameters being entered in on the report printing screen, this can greatly speed up editing the report because it means you no longer have to save and run from the site each time you want to see how it runs (just make sure to remove them once you are done).
Lastly, you can test relations and filters/conditions in a GI which can be easier and quicker to work with than a report. If you have similar joins in a GI does the extra record still get brought in?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.