web
You’re offline. This is a read only version of the page.
close
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) / Activating and inactiv...
Microsoft Dynamics GP (Archived)

Activating and inactivating a range of accounts for a transition period.

(0) ShareShare
ReportReport
Posted on by Community Member

I am wondering if there is a way for us to mass re-activate accounts after they have been inactivated?  I’m familiar with using Mass Modify in GP to set up accounts on new locations and using Mass Modify to mass inactivate accounts, but didn’t know the best approach to re-opening accounts on locations.  The reason I’m asking is for COMPANY X, when we bring over their GL activity each month we are going to want to open accounts for those locations and then inactivate after we are done making entries to prevent users from accidentally posting additional transactions to those locations.  We want to do this so that we can tie back to the figures provided by Company X at least until the accounting is transitioned to Main Location. 

And also, is there a way to mass inactivate locations’ accounts because with Mass Modify, I think I’m limited to doing it on a location by location basis.

 

Thank you

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi,

    If the re activate is same set of accounts you can record the changes on macro and play the macro each time to re-activate the accounts.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi Along the line Babu mentioned. I recommend you do a 'mail-merge' macro. Use a spreadsheet with your accounts that you want to reactivate as your source and use Word to create a giant macro. You can use the macro template over and over. Where you would normally type your account number, you put a field from your data source. Below is what the macro would look like to update two different accounts. Put the ActivateWindow etc on the same line. No word wrap.

    Kind regards,

    Leslie

    ActivateWindow dictionary 'default'  form 'GL_Account_Maintenance' window 'GL_Account_Maintenance'

     TypeTo field 'Account Number CS':'Account_Segment_Pool1' , '000'

     MoveTo field 'Account Number CS':'Account_Segment_Pool2'

     TypeTo field 'Account Number CS':'Account_Segment_Pool2' , '2101'

     MoveTo field 'Account Number CS':'Account_Segment_Pool3'

     TypeTo field 'Account Number CS':'Account_Segment_Pool3' , '02'

     MoveTo field 'Account Description'

     MoveTo field 'Account Alias'

     MoveTo field Inactive  # 'TRUE'

     ClickHit field Inactive  # 'FALSE'

     CommandExec dictionary 'default'  form 'GL_Account_Maintenance' command 'Save Button_w_GL_Account_Maintenance_f_GL_Account_Maintenance'

    ActivateWindow dictionary 'default'  form 'GL_Account_Maintenance' window 'GL_Account_Maintenance'

     TypeTo field 'Account Number CS':'Account_Segment_Pool1' , '000'

     MoveTo field 'Account Number CS':'Account_Segment_Pool2'

     TypeTo field 'Account Number CS':'Account_Segment_Pool2' , '2130'

     MoveTo field 'Account Number CS':'Account_Segment_Pool3'

     TypeTo field 'Account Number CS':'Account_Segment_Pool3' , '00'

     MoveTo field 'Account Description'

     MoveTo field 'Account Alias'

     MoveTo field Inactive  # 'TRUE'

     ClickHit field Inactive  # 'FALSE'

     CommandExec dictionary 'default'  form 'GL_Account_Maintenance' command 'Save Button_w_GL_Account_Maintenance_f_GL_Account_Maintenance'

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans