I was asked to add a bit flag to indicate an inactive ShipTo. I have created the UD field InActive_c in ShipTo table.
I added the checkbox into the CustomerEntry Form.
So far all is ok.
My goal was to not show the inactive shiptonum when user clicks on a shipTosearch button. I then created a BPM on ShipTo GetList. In the PostProcess I added the Set Argument widget. I then set the whereClause argument to “ttShipToListRow.UDField<System.Boolean>(‘Inactive_c’) = 0”
I checked inactive two shipto’s of my test customer, saved.
When I created a new sales order, I would have expected the shipto not having the two “inactive” adresses… But they are still present in the list…
Ok ended up doing the following:
Data directive that as soon as my Inactive check box is saved, I add ZZInactive at the beginning of the name.
In Sales order entry, clicking on the Shipto button and searching… I can see the inactive at the end of the list. (still unable to use the GetList preprocess… to remove them… )
If by mistake they choose an inactive adress I show a message to the user to choose another, and revert back to the original adress.
That is it.
But I am still wandering why the getlist way did not work… would have been much simpler…
Do this and use a pre-processing. The whereClause was not empty when you changed it and thus removed the CustNum filter that is there by default (that is why you got all the Ship Tos)
Create condition widget to check for whereClause = null
Dan your the man! It worked! I actually tought it was the issue, and tried to add Custnum from the available rows objects… but it was not working giving me errors…