Posts

Chart of Accounts when using Activities

The Chart of accounts is recommended to be consistent for GL and Activities.  The Activity field, when populated, already differentiates the JE entry line from one to the same account without an activity specified.  This allows for easily determining how much was booked to a specific account and also split the bookings to a specific account into project related or not.

Account Categories in the AC module also allow you to have a separate chart of accounts, if desired, from your GL Chart of Accounts.

Since an account category is required when an activity is entered, it allows for a separation of the GL and AC charts if separation is desired.

Many users default in the Account Category so this value doesn’t have to be specified on each transaction that uses an activity throughout the system.  The defaulting could occur on GL20 instead of GL00 if the accounting unit used in the transaction would alter the way you would account for the project/activity posting.

Can you have a single BL & AR company and have transactions post to more than one GL company?

The short answer is no.

However, there are some creative ways to accomplish having a single BL & AR company and still booking information to various GL Companies.

Option 1: Using allocations and getting creative with your Process Levels and possibly accounting units, you can move the amounts to various companies using the allocation module.

The AR process Level setup has a default accounting unit that allows you to book all transactions for this process level to the various accounting units and then setting up an allocation to transfer those amounts at the end of each period would allow you to see the AR amounts on your various GL companies in the financial statements.  I would make these allocations auto reversing so that you can show what you need to for financial reporting only.

Option 2: Setup the various AR and BL companies and use the National Account relationship for your processing.  This option will allow everything to book in the correct company, and still allow you to process payments and adjustments, produce various reports, create consolidated aging reports and all other AR reports.

So as often is the case, you can get what you want, you just need to think it through and see if it will work for your needs.