Skip to main content

Running the Shipment Details by Customer report and getting some unexpected rows. I’ve added a couple of new columns to the report but it’s otherwise as per the original template.

All the rows below are from the same order EC001956, but it indicates they are all on shipment SH003464.  However, only the yellow row is on shipment SH003464 which is on the date of the report, the rest of the rows were on other shipments on other dates.

Why does the report pick up shipments from other days and how can i stop it?

Little bit flummoxed.

Thanks for any suggestions.

Arran

I managed to fix this, it was a problem with a join in one of the new columns.


I managed to fix this, it was a problem with a join in one of the new columns.

Can you share the join?


Reply