Account Group Set Up

One our accountants created a new account group and catergorized it as an Asset.. Then a main account was assigned to this group, and a GL account created assigned to the Main account.  A/P then processed an invoice and used the GL account that was created.

The Problem:  This Account group should have been categorized as an operating expense, not an asset.  I've tried to go back in and correct it, but since there is main account assigned to it, it won't let me.  I've tried to fix the Main account, but it too will not allow me to correct it since there is activity in this account. 

Is there a way to correct this? or do these Group/Main Accounts become useless and have to be inactivated??? any help on this would be great thanks!!

Mas90 (ERP 100) v4.3

 

 

  • 0

    If this were my problem, I would use Data file display and Maintenance on all three tables effected.  This can cause issues, so I would do it in the morning before any activity was entered, and only after making sure that our systems backup for the previous evening completed successfully.

    the tables associated are:

    GL_AccountGroup

    GL_MainAccount

    GL_Account

    The data is not complex, it's almost in English, however If you are not familiar with using this function, or you don't have much knowledge of relational databases, then I would not experiment in a live company.

    Thanks,

    Blorf