Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Clear Unit Accounts BBF

Status
Not open for further replies.

barbola

Technical User
Feb 27, 2003
1,132
CA
Every year I need to delete the balance forward for unit accouts after year-end is run. I can select the accounts using the following:

SELECT dbo.GL20000.OPENYEAR, dbo.GL20000.TRXDATE, dbo.GL20000.DEBITAMT, dbo.GL20000.CRDTAMNT, dbo.GL20000.SOURCDOC, dbo.GL20000.ACTINDX, dbo.GL20000.REFRENCE, dbo.GL00100.ACTNUMBR_2, dbo.GL00100.ACTDESCR, dbo.GL00100.ACTNUMBR_3, dbo.GL00100.ACTNUMBR_4
FROM dbo.GL00100 INNER JOIN dbo.GL20000 ON dbo.GL00100.ACTINDX = dbo.GL20000.ACTINDX
WHERE (dbo.GL00100.ACCTTYPE = '2') AND (dbo.GL20000.SOURCDOC = 'bbf')

What would my delete statement look like? Normally I use "Where ACTINDX in ('....and have all the unit account indexes here, but there are more and more each year.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top