Announcements
Hi
Does anyone have a script to find never used GL accounts in DSL?
thanks
*This post is locked for comments
thank you!
Declare @Cpny [char](10)
select @Cpny ='CpnyId'
select * from Account where not Acct in (select distinct Acct from GLTRan where CpnyId = @Cpny)
Change the value for Parameter @Cpny to your Company Id
You will get a list of accounts unused for that Company
Ray
Thanks Raymond, I left out one parameter. Is there a way to make this company specific or identify the company?
select * from Account where not Acct in (select distinct Acct from GLTRan)
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156