Skip to main content
Question

Adding warehouses breaks SOOrder

  • September 18, 2025
  • 4 replies
  • 58 views
K
Freshman II
Forum|alt.badge.img

Hello,

I’ve gone through so many readings and videos and i still do not understand how relations work and how to see which parent childen to use.

Example: when i enable INSite, it breaks all of my SO objects. and vise versa. I get get them to show on their own, but never together. 

Which relations would i use to get SO to talk to SO and print the warehouse its assigned to?

Is there a resource that’ll explain relations and how they work together? I’ve used the Merged DAC Relations page and the inspect elements to match them up. This worked to get the SOOrder to stop duplicating..but i cannot figure out this INSite portion..The DAC relations are pages and pages long with no explinations

    4 replies

    jhouser
    Captain II
    Forum|alt.badge.img+6
    • jhouser
    • Captain II
    • September 18, 2025

    Hi ​@kdolgner Each table you add after the first one must be joined to an already added table. So you need to join SOOrder to INSite. 

    If you go to Data Sources tab and click on the SOOrder table (it’s hyperlinked), the DAC Schema Browser will open. Scroll down to Outgoing References until you see INSite in the Parent DAC column. To the left and right you will see the key fields for joining the two tables. 

    If you want SiteID of the detail line, you would join SOOrder to SOLine, then SOLine to INSite. 

    Hope this helps!

    Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
    Chris Hackett
    ricoybanez
    Jr Varsity III
    Forum|alt.badge.img+3
    • ricoybanez
    • Jr Varsity III
    • September 19, 2025

    ​@kdolgner 

    Please check your Table Relations

     

     

    Rico P. Ybanez
    Chris Hackett
    K
    Freshman II
    Forum|alt.badge.img
    • kdolgner
    • Author
    • Freshman II
    • September 19, 2025

    Hi ​@kdolgner Each table you add after the first one must be joined to an already added table. So you need to join SOOrder to INSite. 

    If you go to Data Sources tab and click on the SOOrder table (it’s hyperlinked), the DAC Schema Browser will open. Scroll down to Outgoing References until you see INSite in the Parent DAC column. To the left and right you will see the key fields for joining the two tables. 

    If you want SiteID of the detail line, you would join SOOrder to SOLine, then SOLine to INSite. 

    Hope this helps!

    I think i understand but is there a reference i can read more on?

    I can get the columns to show, but no data to pull. I’ve found countless forum postings and even looking into how the SQL is read; i’m still struggling to wrap my head around what to reference, and then how the parent children relationships work. every reiteration i try breaks what i have successfully pulled. 

    If its nesting, then once i get deep in the nest i’m lost. 

    jhouser
    Captain II
    Forum|alt.badge.img+6
    • jhouser
    • Captain II
    • September 19, 2025

    ​@kdolgner If you would like help beyond the online resources, PM me and we can discuss scheduling a session. 

    Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
    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