D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Suspend GL Account Not Used >12 Months

  • 1.  Suspend GL Account Not Used >12 Months

    SILVER CONTRIBUTOR
    Posted Apr 23, 2020 04:57 PM
    Hello,

    Would like to suspend G/L accounts not used in >12 months in Dynamic 365. I want to know how I can download this data with the Account balances in Excel. After that will make changes and do mass upload to suspend these accounts. Any help on this?

    Thank you

    ------------------------------
    Kobe Peasah
    National Vision, Inc
    Duluth GA
    ------------------------------


  • 2.  RE: Suspend GL Account Not Used >12 Months

    GOLD CONTRIBUTOR
    Posted Apr 24, 2020 09:17 AM
    Hi Kobe

    Which version are you on?

    Thanks,

    ------------------------------
    Arush Kuthiala
    Western Computer
    Toronto ON
    ------------------------------



  • 3.  RE: Suspend GL Account Not Used >12 Months

    SILVER CONTRIBUTOR
    Posted Apr 24, 2020 09:38 AM
    Dynamics 365 Version 10.0.6. Thanks

    ------------------------------
    Kobe Peasah
    National Vision, Inc
    Duluth GA
    ------------------------------



  • 4.  RE: Suspend GL Account Not Used >12 Months

    GOLD CONTRIBUTOR
    Posted Apr 24, 2020 10:03 AM
    Hi Kobe

    You can use Data Management to export the entity General Journal Account Entry, this will export all GL transactions. Then in Excel you can look for accounts that haven't been used and can suspend them in the Account form.

    Thanks,

    ------------------------------
    Arush Kuthiala
    Western Computer
    Toronto ON
    ------------------------------



  • 5.  RE: Suspend GL Account Not Used >12 Months

    Posted Apr 24, 2020 10:29 AM
    Edited by Geoff Faulkner Apr 24, 2020 10:43 AM
    To download accounts with balances you run a Trial Balance, which is under:
    General Ledger > Inquiries and Reports > Trial Balance

    You can set the date range on the trail balance. Save this output in Excel using the Office button in the menu bar at the top.

    Once you have figured out which accounts need to be disabled you can use the Main Account entity to perform an update. I think you will need to include the columns:
    ChartofAccounts, MainAccountID, and IsSuspended.

    ------------------------------
    Geoff Faulkner
    Network and Systems Manager
    Musco Family Olive Co
    ------------------------------



  • 6.  RE: Suspend GL Account Not Used >12 Months

    Posted Apr 28, 2020 02:10 PM
    One more way
    once TB is available for 12months
    download COA and use vlookup in Excel to find which acocunts are not being used
    then use data management to update them to suspend

    ------------------------------
    Best Regards
    Rahul Mohta
    Partner - Real Dynamics
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role