I've seen some posts in this forum that refer to UDS's running even during VI Import, but my script is not firing at that time and I need it to. Is there a special way to do it?
I have a UDS that calculates a value and populates a UDF on the Sales Order Line item. It works great in Sales Order Entry. I have it set to the table SO Sales Order Detail, and the events Column Post-Validate Itemcode, Column Post-Validate OrdQty, Table Set Default Values, and Table Pre-Write. I added Table Post-Read and Table Post-Write too, but they did not seem to help. Is there something else I need to do to get it to run?
We are on v4.4 PU5. Here is my script in case that helps:
Dim nPallets, nCases, nOrdQty
nPallets=0
nCases=0
nOrdQty = 0
retVal = oBusObj.GetValue("UDF_CASES_PER_PALLET", nCases)
retVal = oBusObj.GetValue("QuantityOrdered", nOrdQty)
if nCases <> 0 then
nPallets = round(nOrdQty/nCases,2)
retVal = oBusObj.SetValue("UDF_PALLETS_PER_ITEM", nPallets)
end if
Thanks, Hollie