News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL forum Never used GL accounts...

Microsoft Dynamics SL forum

Unanswered

Never used GL accounts DSL

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi

Does anyone have a script to find never used GL accounts in DSL?

thanks

All responses Img

All responses (4)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Never used GL accounts DSL

thank you!
RayD 235 on at

Like (0)

Report

RE: Never used GL accounts DSL

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Never used GL accounts DSL

Thanks Raymond, I left out one parameter. Is there a way to make this company specific or identify the company?
RayD 235 on at

Like (0)

Report

RE: Never used GL accounts DSL

select * from Account where not Acct in (select distinct Acct from GLTRan)

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2

Martin Dráb 228,647 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans