GL20-Accounting Unit/Account Code Combinations

Sort:
You are not authorized to post a reply.
Author
Messages
Sami117
New Member
Posts: 5
New Member
    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
    New Member
    Posts: 1
    New Member
      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
      New Member
      Posts: 5
      New Member
        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.

        anu singh
        Basic Member
        Posts: 13
        Basic Member
          Can any one tell me how to extract the GL20 data from Add-Ins. Can I get the name of the table field.
          anu
          You are not authorized to post a reply.