PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/27/2016 11:19 AM by  Sami117
GL20-Accounting Unit/Account Code Combinations
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Sami117
Senior Accountant
Private
New Member
(7 points)
New Member
Posts:5


Send Message:

--
08/09/2016 10:59 AM
    We have several accounting units that are mapped to various GL Account codes per GL20.2. We have one accounting unit for balance sheet transactions, but we discovered several income statement accounts with exists as "yes" on the GL20.2 for the balance sheet unit. We don't want individuals accidently coding transactions improperly so we need to turn the exists from "yes" to "no." We have shut off dynamic account generation to prevent the exists from being turned automatically to "yes" if someone keys the wrong GL account code.

    I also built an upload file to do one mass change for all the bad combinations (we have about 2000). The problem is when I upload, if the bad combination has any ANY activity, even though the balance is now "0," I get the following message. "cannot delete; account has actual activity." Is there any way to turn the exists from "yes" to "no" since we made the adjustment so the combination balance in the ledger is now "0," or are we stuck with these active bad combinations in our ledger that we will have to manually monitor?

    Thanks!
    Jeff Bednar
    Private
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    10/12/2016 9:12 AM
    Once the account has been posted to, you can only turn off the combination by inactivating it. To do that, click on the "More" button next to the posting account in GL20.2 and you will be transferred to GL20.3 (Account Options). Change the Status on the Main Tab from A or Blank to I for Inactive. This will prevent any future posting. You can also create an upload to do this, or run a GL122 Mass Account Change Delete job.
    Sami117
    Senior Accountant
    Private
    New Member
    (7 points)
    New Member
    Posts:5


    Send Message:

    --
    10/27/2016 11:19 AM
    Thanks! We will probably test this to make sure we can still pull inactive combos to our reporting software, but this would help prevent future errors.

    You are not authorized to post a reply.