Hi,
One of our clients started using Released Production Orders and noticed an flaw with the Subcontractor- Dispatch list report when there are multiple items in the Prod. Order Line.
What the report does is it shows the first item in the Prod. Order Line, but in the components it shows all the components of both items under consumption.
Example: We have 2 items on our Prod Order Lines in Released Production Order. Each Item has 12 Components.
What is shown in the Report: the item on the first line with "Components needed" showing 24 Components instead of 12 components.
The Resolution:
We added a grouping on [Table1_Group4] and grouped by LineNo_ProdOrderLine on the RDLC to remedy the problem.
Now the output shows The Item on the first line followed by 12 Components, then the item on the second line followed by 12 Components.
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156