Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to Export all Acco...
Microsoft Dynamics GP (Archived)

How to Export all Account numbers associated with each Account Group Setup.

(0) ShareShare
ReportReport
Posted on by Napolo 756

I have added a few hundred Account Group ID's, based on how we plan to use them.  We have entered a program number before the description, which added quite a bit of setup.


I did use a macro to assist with updating the account numbers, however, I still had a few manual pieces to update.

I would like to export every account group ID and all Account Numbers associated to the ID, so that I can run a few formulas and make sure that the setup is 100% accurate.

Can you help?  Here is a screen shot of one ID.

account-group-setup.png

*This post is locked for comments

  • Napolo Profile Picture
    Napolo 756 on at
    RE: How to Export all Account numbers associated with each Account Group Setup.

    Thank you - Thank you!  I had found a script yesterday, but the data wasn't pulling even though it said successful.  

    This is exactly what I needed. Thanks again!

  • Verified answer
    Tom Cruse Profile Picture
    Tom Cruse 1,477 on at
    RE: How to Export all Account numbers associated with each Account Group Setup.

    There might be an easy SmartList for this but we just build views in SQL. I'm not sure what type of back-end system access you have so you might need the assistance of IT but here's the query you'll need to pull it.

    SELECT

    FA.ACCTGRPINDEX as GROUPINDEX,

    FA.ACCTGRPID as GROUPID,

    FA.ACCTGRPDESC as GROUPDESC,

    ISNULL(GL.ACTNUMST,'') as DEPRECIATION_EXPENSE,

    ISNULL(GL2.ACTNUMST,'') as DEPRECIATION_RESERVE,

    ISNULL(GL3.ACTNUMST,'') as PRIOR_YEAR_DEPRECIATION,

    ISNULL(GL4.ACTNUMST,'') as ASSET_COST,

    ISNULL(GL5.ACTNUMST,'') as PROCEEDS,

    ISNULL(GL6.ACTNUMST, '') as RECOGNIZED_GL,

    ISNULL(GL7.ACTNUMST, '') as NON_RECOGNIZED_GL,

    ISNULL(GL8.ACTNUMST, '') as CLEARING

    FROM FA41300 FA

    left join GL00105 GL on GL.ACTINDX = FA.DEPREXPACCTINDX

    left join GL00105 GL2 on GL2.ACTINDX = FA.DEPRRESVACCTINDX

    left join GL00105 GL3 on GL3.ACTINDX = FA.PRIORYRDEPRACCTINDX

    left join GL00105 GL4 on GL4.ACTINDX = FA.ASSETCOSTACCTINDX

    left join GL00105 GL5 on GL5.ACTINDX = FA.PROCEEDSACCTINDX

    left join GL00105 GL6 on GL6.ACTINDX = FA.RECGAINLOSSACCTINDX

    left join GL00105 GL7 on GL7.ACTINDX = FA.NONRECGAINLOSSACCTINDX

    left join GL00105 GL8 on GL8.ACTINDX = FA.CLEARINGACCTINDX

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans