Job Advanced Report - Not Accurate for OSD and Gateway

[nmfujimoto]

This issue is repeatable in M4PL and Tracking apps.

In the Job Advanced Report if you select OSD options in the Gateway Title search criteria and generate the report the results will show orders in their current Gateway Status, e.g. "On Hand" or "Delivered". If you add the current Gateway Status as an additional search criteria in the Gateway Title control the results are 0.

Example:

• Select "Andrews" for Destination
• Select "Product Damaged", "Product Short" and "Product - Overage" for Gateway Title
• Hit Generate Report
• Results are 104 matching jobs (noticed some jobs are "Delivered" for Gateway Status

Now, to see the inaccurate results:

• Add "Delivered" to the list for Gateway Title , so it would contain "Product Damaged", "Product Short" and "Product Overage" and "Delivered"
• Results are 0 matching jobs

[nmfujimoto]

Only searching on the OSD (Damaged, Short, Over):

Now, add "Delivered" as we want to see all orders that have an OSD and are delivered:

Same issue in Tracking app (the count is 104 which matches M4PL):

[Madhusmi]

@nmfujimoto Testing completed on staging server and it is working as expected.