Current Year
UPDATE PM00201
SET TEN99AYTD = 0
WHERE VENDORID = 'xxxxxxxx'
Life to Date
UPDATE PM00201
SET TEN99ALIF = 0
WHERE VENDORID = 'xxxxxxxx'
UPDATE PM00202
SET TEN99ALIF = 0
WHERE VENDORID = 'xxxxxxxx'
Last Year
UPDATE PM00201
SET TEN99ALYR = 0
WHERE VENDORID = 'xxxxxxxx'
PM00201 is the PM Vendor Master Summary, PM00202 is the PM Vendor
Master Period Summary. Life to Date amounts are stored in both
tables. Current Year and Last Year are stored only in PM00201.
If you need to clear by vendor class, you will need to do a query
joining the Vendor Master (PM00200) to the other two tables to pull
the VNDCLSID in.
Hope this helps,
Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
get your gptip42today at www.gp2themax.blogspot.com