Solved

Unexpected items in Shipment Details by Customer report


Userlevel 1

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

icon

Best answer by Arran 18 July 2023, 15:39

View original

2 replies

Userlevel 1

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

Userlevel 7
Badge +16

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

Can you share the join?

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved