Skip to main content
Solved

Unexpected items in Shipment Details by Customer report


  • Freshman II
  • 4 replies

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

Best answer by Arran

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

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

2 replies

  • Author
  • Freshman II
  • 4 replies
  • Answer
  • July 18, 2023

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


Kandy Beatty
Captain II
Forum|alt.badge.img+16
Arran wrote:

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

Can you share the join?


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