Hello,
I am trying to create a indented BOM query that also includes current on-hand inventory from multiple warehouses. I have a subquery created that is getting the summation of the on-hand quantities, which seems to be working. Also, the Indented BOM seems to be working pretty well. What I am struggling with is the on hand quantity does not show up for the last level in the indented BOM (essentially the raw material or purchased part level). I am not sure why this is not showing up.
Does anyone have any thoughts to why I am not getting these values to show up?
Top-Level BAQ for indented BOM. See SubQuery 3 for the on-hand inventory for the top level.
Lower-level subquery used per level for the indented BOM. See SubQuery3 here also for the onhand inventory per level.
