Skip to main content
Question

Linking SOShipLineSplit to POOrder

  • October 16, 2025
  • 4 replies
  • 43 views
M
Freshman I

I’ve built a report that pulls shipped item information from shipments for forecasting purposes.  I’m trying to link my existing tables to POOrder through POLine (ShipLineSplit to POLine on InventoryID) but am receiving grossly inflated shipped numbers.  Any ideas on how to solve this?  I’ve pasted a snapshot of my current relationships. 

Without the PO tables, the report works like a charm but I’m trying to exclude certain PO quantities (bulk / special orders) from a field that displays InSiteStatus.QtyPOOrders.  Thanks.

 

 

    4 replies

    darylbowman
    Captain II
    Forum|alt.badge.img+15

    I’m a little confused what you’re expecting to see. If your join is only on InventoryID, if you have two shipments and two POs using the same InventoryID, you’re going to see four resulting lines instead of two (which might be what you’re expecting). This will inflate exponentially.

    Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
    Chris Hackett
    M
    Freshman I
    • MSmithDPG
    • Author
    • Freshman I
    • October 20, 2025

    Daryl,

     

         I figured that was what was happening but I can’t think of a work around to prevent the duplications.  I’ll play with a copy of the report and see if I can figure it out in my spare time.

     

    Matt

    darylbowman
    Captain II
    Forum|alt.badge.img+15

    Could you try to explain what you’re hoping to see? Are you trying to determine if you are purchasing enough product to fulfil your shipments?

    Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
    Chris Hackett
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • November 6, 2025

    Hi ​@MSmithDPG were you able to find a solution? Thank you!

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    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