Hi
Does anyone have a script to find never used GL accounts in DSL?
thanks
Hi
Does anyone have a script to find never used GL accounts in DSL?
thanks
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)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,647 Most Valuable Professional
nmaenpaa 101,148