D365 Finance & Operations and Dynamics AX Forum

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
------------------------------

Hi Kobe

Which version are you on?

Thanks,

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

Original Message:
Sent: Apr 23, 2020 04:57 PM
From: Kobe Peasah
Subject: Suspend GL Account Not Used >12 Months

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
------------------------------

Dynamics 365 Version 10.0.6. Thanks

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

Original Message:
Sent: Apr 24, 2020 09:17 AM
From: Arush Kuthiala
Subject: Suspend GL Account Not Used >12 Months

Hi Kobe

Which version are you on?

Thanks,

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

Original Message:
Sent: Apr 23, 2020 04:57 PM
From: Kobe Peasah
Subject: Suspend GL Account Not Used >12 Months

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
------------------------------

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
------------------------------

Original Message:
Sent: Apr 24, 2020 09:38 AM
From: Kobe Peasah
Subject: Suspend GL Account Not Used >12 Months

Dynamics 365 Version 10.0.6. Thanks

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

Original Message:
Sent: Apr 24, 2020 09:17 AM
From: Arush Kuthiala
Subject: Suspend GL Account Not Used >12 Months

Hi Kobe

Which version are you on?

Thanks,

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

Original Message:
Sent: Apr 23, 2020 04:57 PM
From: Kobe Peasah
Subject: Suspend GL Account Not Used >12 Months

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
------------------------------

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
------------------------------

Original Message:
Sent: Apr 23, 2020 04:57 PM
From: Kobe Peasah
Subject: Suspend GL Account Not Used >12 Months

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
------------------------------

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
------------------------------

Original Message:
Sent: Apr 24, 2020 10:28 AM
From: Geoff Faulkner
Subject: Suspend GL Account Not Used >12 Months

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

Original Message:
Sent: Apr 23, 2020 04:57 PM
From: Kobe Peasah
Subject: Suspend GL Account Not Used >12 Months

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
------------------------------