Hi, I'm trying to hide rows in the planning details base on a variable in CSI 10 Cloud. Here are the details. I needed to add the whse to the planning detail, then have the records filtered by the item, and whse. To accomplish this, I have a whse variable that's being populated via the IDOClient.LoadCollection function using the refNum, RefLineSuffix, and RefRelease, for the IDOs based on the reference field on the form. This works great. Now, I need to be able to "filter" the records by the item and whse. I'm thinking this could be done in form script.
I've tried adding a derived field to the IDO. However, because the planning detail is using a custom load method, the derived field doesn't work.
Any guidance with this is greatly appreciated.
Thanks