PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/31/2017 3:15 PM by  Mark F. Hardy
Activate account for all accounting units
 8 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Paul
Private
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
11/21/2008 11:37 AM
    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
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    11/21/2008 12: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.com/Articles...ounts.aspx
    Thanks for using the LawsonGuru.com forums!
    John
    AliliaB
    General Ledger Accountant II
    Private
    Basic Member
    (12 points)
    Basic Member
    Posts:4


    Send Message:

    --
    03/31/2017 10:15 AM
    Can I deactivate AU&account combinations in GL20.3 using Addins? If so, what do I need to know? Thank you.
    Mark F. Hardy
    Sr Application Developer
    Bluegreen Corporation
    Veteran Member
    (124 points)
    Veteran Member
    Posts:44


    Send Message:

    --
    03/31/2017 10:33 AM
    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
    General Ledger Accountant II
    Private
    Basic Member
    (12 points)
    Basic Member
    Posts:4


    Send Message:

    --
    03/31/2017 10:58 AM
    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
    Private
    Private
    Veteran Member
    (535 points)
    Veteran Member
    Posts:193


    Send Message:

    --
    03/31/2017 11:10 AM
    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
    General Ledger Accountant II
    Private
    Basic Member
    (12 points)
    Basic Member
    Posts:4


    Send Message:

    --
    03/31/2017 1: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
    General Ledger Accountant II
    Private
    Basic Member
    (12 points)
    Basic Member
    Posts:4


    Send Message:

    --
    03/31/2017 3:02 PM
    I tested it and it works!!! I'm so happy. Thanks again for the help. I <3 software gurus.
    Mark F. Hardy
    Sr Application Developer
    Bluegreen Corporation
    Veteran Member
    (124 points)
    Veteran Member
    Posts:44


    Send Message:

    --
    03/31/2017 3:15 PM
    Awesome. When I have a similar request taken Off Hold, I will definitely refer to this thread.
    You are not authorized to post a reply.