News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Never used GL accounts...

Microsoft Dynamics SL (Archived)

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

*This post is locked for comments

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2

Martin Dráb 230,370 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans