• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

Activate account for all accounting units

 8 Replies
 1 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Paul
New Member Send Private Message
Posts: 1
New Member
11/21/2008 4:37 PM
I have a group of pre-existing accounts that are active in some accounting units and inactive in other accounting units.  I want to make these accounts active for all accounting units.  I have tried using GL 100 (Mass Chart Acct Change Delete) and GL 121 (Mass Account Addition).  Does anyone know how to do this?
John Henley
Send Private Message
Posts: 3351
11/21/2008 5:40 PM
If you have Excel Addins, you could upload against GL20.2.  See this article, which is for the chart itself (GL00); you'd have to adapt this idea to apply to GL20.2

https://www.lawsonguru.co...nd-Sub-Accounts.aspx
Thanks for using the LawsonGuru.com forums!
John
AliliaB
Basic Member Send Private Message
Posts: 4
Basic Member
3/31/2017 2:15 PM
Can I deactivate AU&account combinations in GL20.3 using Addins? If so, what do I need to know? Thank you.
Mark F. Hardy
Veteran Member Send Private Message
Posts: 45
Veteran Member
3/31/2017 2:33 PM
This is a similar issue we encountered many months ago and we opened up an Infor Enhancement Request. It is ERS #6869. Just today we received an email they are now researching it. For us, bottom line, if the status is changed to Inactive at the higher level file DBIFGLN in GL20.1, it should make all the corresponding lower level file records in DBIFGLM Inactive as well. We should not have to manually run an ADDIN and apply it against GL20.3 so the files are sync'd up.

I will attach this link ERS #6869, just so they know others clients have this issue.
AliliaB
Basic Member Send Private Message
Posts: 4
Basic Member
3/31/2017 2:58 PM
We had a temporary moratorium on inactivating the Accounting Units due to potential reporting issues, so we were inactivating all active account combinations to prevent users from posting to the accounting unit, but we were hoping to save some time by using Addins, and just weren't sure if it was possible.
Bob Canham
Veteran Member Send Private Message
Posts: 217
Veteran Member
3/31/2017 3:10 PM
There shouldn't be any issues with uploading that information using Addins. You just upload to the GL20.3 and provide it the FC, GLN-COMPANY, GLN-ACCT-UNIT, GDT-ACCOUNT, GDT-SUB-ACCOUNT and GLM-ACTIVE-STATUS. I think the FC there should take care of where you would normally do a change on GL20.2. If not, the fields are also available from the GL20.2 upload so you can go that way as well.
AliliaB
Basic Member Send Private Message
Posts: 4
Basic Member
3/31/2017 5:16 PM
Thank you for the tips. I will try from the GL20.2, because when I tried from the GL20.3, I got this message in the results: Window Changed - Update Form To Save. I didn't realize the GL20.2 had these same fields available. I didn't think to look.
AliliaB
Basic Member Send Private Message
Posts: 4
Basic Member
3/31/2017 7:02 PM
I tested it and it works!!! I'm so happy. Thanks again for the help. I <3 software gurus.
Mark F. Hardy
Veteran Member Send Private Message
Posts: 45
Veteran Member
3/31/2017 7:15 PM
Awesome. When I have a similar request taken Off Hold, I will definitely refer to this thread.