Skip to main content
Answer

Unexpected items in Shipment Details by Customer report

  • July 18, 2023
  • 2 replies
  • 24 views
A
Freshman II

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.

    2 replies

    A
    Freshman II
    • Arran
    • Author
    • Freshman II
    • Answer
    • July 18, 2023

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

    Kandy Beatty
    Chris Hackett
    Kandy Beatty
    Captain II
    Forum|alt.badge.img+17
    • Kandy Beatty
    • Captain II
    • July 18, 2023

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

    Can you share the join?

    Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    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