Saturday, August 11, 2012

Account specific Cost Center access.

Hi Everyone,

During financial system implementation I have faced this challenge.
How to choose specific valid account / subaccount (cost center) combination?

For example, all balance sheet accounts need to get tied to a single sub account, while Profit and Loss ones have to go to multiple, depending on the account nature and sub location.

Second issue - how to guarantee global validation rules for all these combinations. To say in Order Management or Purchasing when we choose a product, system should validate accounts and subaccounts based on predefined rules...

In most of the systems we should specifically indicate valid combinations, then make a template, to be used with each new account or sub added to the system. Looks tedious.
This approach seems to be not very effective, especially is you have hundreds of cost centers.

In Acumatica we have restriction groups, that can help to define validation rules.
I will be using Acumatica demo system to show how to configure it.
Let say we want all B/S account to get only tied to subaccount 00-00-00-00-000, while PnL account to all other subaccounts, excluding 00-00-00-00-000.

1. Open GL->Setup Section->Account Access screen. Lets Create a group Balance Sheet. In our case it should be group of type A. And because we do not need "by user" restrictions lets leave first tab intact and move straight to the second tab "Accounts":

My BS accounts are starting from 1,2 or 3. Lets make a filter to display only BS accounts on the grid for easier and faster selection :)

2. Lets select all BS accounts in the Accounts Tab. And then Save the group.

3. Lets get to Subaccount Segments Tab. And select 00-00-00-00-000 only.

Then Second segment, all the same 00 until Fifth:

4. Balance Sheet group is ready, now to make the restriction balanced we should create a group PnL to indicate possible subaccount combinations for PnL accounts. Lets make all except 00 available for them. Procedure is similar. Create a group, leave Users intact, mark all PnL Accounts, mark All Sub segments except 00, Save. Here are screen shoots:

Filter:

Accounts:

Subaccounts:

All till Fifth:

We are done, lets check on GL Journal Entry screen whether our look-ups and validation works. I will choose BS account and F3 on subaccount to see a look-up for values allowed:

Seems OK, only 00 is shown. Lets try to cheat the system and enter other than 00 subaccount then go to the next line and see if it validates the invalid entry:

System prompts for invalid Location Cost Centre (first segment) for my Subaccount.

Now lets try on PnL Account, should allow all except 00:

Seems OK, no 00 in the look-up list. Lets then enter 00 and try on the next line:


For the second line it was OK, because it does not contain 00 segments, but attempt to manually enter 00 sub in the third line resulted in Error message for all involved Cost Centres.

Have a nice day,
Sergey.

2 comments:

  1. How to identify the sub-account?

    ReplyDelete
    Replies
    1. During system setup Subaccount segments are defined at the Key Fields, then Subaccount screen.

      Delete