Delete the Vendor# on those SO lines?

Would you see any possible complications down the road if I scripted the deletion of the vendor number if the BO Qty field is = 0?

I believe that field in SO line data is only used for the PO from SO process, so there should be no harm, but be sure to test.  It could always be added back manually.  (It's there so you could change which vendor is used for the created PO's).

I feel like this should be an easy script but I am missing something.  I've tried on a column post validate, table pre-write and table post-write.  Also tried using the "setnovalidate" to set the Vendor No value.  When the script does fire it deletes the whole line on the column post validate.  I used the QtyBo field and a UDF field I have.

'Delete Vendor No so qty ordered is not included on Auto PO generation

rVal = 0
QBO = 0
VendNo = ""
sType = ""
sItemType = ""


rVal = oHeaderObj.GetValue("OrderType$", sType)

if sType = "S" then

rVal = oBusObj.GetValue("ItemType$", sItemType)

	if trim(sItemType) = "1" then

	rVal = oBusObj.GetValue("QuantityBackordered", QBO)

		if QBO = 0 then

		rVal = oBusObj.SetValue("VendorNo$",VendNo)
		end if
	end if
end if

Pre-Write would be what I'd use... strange.  I don't see anything obviously wrong with the script.

You will have to clear both APDivisionNo & VendorNo, even if you aren't using divisions, it uses division "00" this will have to be removed as well.  You will need to clear the division first and then vendor number, as vendor number's validation uses both division and vendor number.

The removal of the APDiv No worked, and the script does as needed if the items are entered line by line.  However, this is over my head, we have the DSD IM-1220 enhancement for size and color options.  When items are entered through the grid for the enhancement the first line on the order does not fire the script, if the BO Qty is = 0 the vendor number stays on the line, any other lines after the first line come out correctly.  Not sure if any of you guys would have any input on how to go around this or if I just need to get with DSD.

Edited script below

'Delete Vendor No so qty ordered is not included on Auto PO generation

rVal = 0
QBO = 0
VendNo = ""
APNo=""
sType = ""
sItemType = ""


rVal = oHeaderObj.GetValue("OrderType$", sType)

if sType = "S" then

rVal = oBusObj.GetValue("ItemType$", sItemType)

	if trim(sItemType) = "1" then

	rVal = oBusObj.GetValue("QuantityBackordered", QBO)

		if QBO = 0 then
		
		rVal= oBusObj.SetValue("APDivisionNo$",APNo)
		rVal = oBusObj.SetValue("VendorNo$",VendNo)
		end if
	end if
end if