clear 1099 history

any one have any scripts to clear 1099 history by vendor or vendor class?

Current YearUPDATE PM00201SET TEN99AYTD = 0WHERE VENDORID = 'xxxxxxxx'Life to

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

Thanks for the help."Frank Hamelly, MCP-GP, MCT, MVP" wrote:

Thanks for the help.

Anytime David . . .Frank HamellyMCP-GP, MCT, MVPEast Coast Dynamicswww.

Anytime David . . .

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com

get your gptip42today at www.gp2themax.blogspot.com