I have having an unreal amount of difficulty with something that I believe to be super simple.
I have a Gi that is showing me, for each BOM FG Item, how much of each component is required. And taking into account how much is on hand, it shows me the most FG I can produce with what is on hand.
I would really like to also show the grouped Max amount I can make, meaning, If I look up an item that has 4 components, each component will show the most I can make with that Item, and then also the lowest quantity out of those 4. So the item that is limiting me making more, will show the same quantity in both columns.
To do this I made an identical GI that is just grouped by the BOMItem.InventoryID, and the buildable quantity is set at MIN for aggregation. Then I pulled that GI in as a sub GI, and related it through the same BOMItem.InventoryID.
This screen worked until the new 2025R1 upgrade came through, and now it is broken in a weird way. My GI works originally when you choose a inventory ID, but if you change one of the parameters, it breaks and give an error of “Object reference not set to an instance of an object.” Which is the most annoying error ever, I wish it could tell me what the issue actually is.
I would really like to be able to get this to work without an SQL or DAC since I don’t know how to do those yet. And it is really frustrating that it worked originally, but not with the new upgrade.
I don’t even have any Results in my Main GI that are coming from this sub GI. It purely breaks just because the Sub GI is linked in the table relations.
But again, it only breaks if I change a parameter, I have tried rebuilding these GIs several times and I cannot find an answer.
I have attached my GI if anyone could take a look. Thank you.
