Using Sage 300 GL Unit Accounts 

Sage 300 CRE allows general ledger accounts to be setup with a type of “Units” to accommodate the need for special accumulators.  The unit account will have the same fields available as other GL accounts, but the entry to a unit account does not require a debit/credit balanced entry.

Examples of using unit account accumulators

1. Based on account “balances” like balance sheet accounts.  

2. In this case, the account field to report from is “Current Balance”.  It will not close at the end of the year.  
3. One entry is needed to establish the balance and subsequent entries are needed to record net changes.

1. Examples:

2. Property management unit / property square footage
3. Target financial ratios for comparison to actual

2. Based on “activity” like income statement accounts.  

4. In this case, the account field(s) to report from are any of the monthly activity amount fields in account setup.
5. Monthly entries are required for reporting.
6. If there is a need to clear the accumulator for current balance, use audit setup and change the amount to zero.
7. Examples:

2. External liabilities like bond amounts for informational reporting
3. Amounts from other modules like Cost to complete from Job Cost

Unit account setup in General Ledger

1. Setup > Prefix/Base > Base Account 

1. Examples for account numbers to reduce risk of mistaken entries for a (4) character base:

1. Alpha characters that represent the use of the units.  

1. SQFT

2. Numbers clearly outside the natural trial balance range.

1. If cash starts at account 1000, then use 0001 – 0999 as unit accounts.

2. Use a clearly defined account title.

1. Ex: Square Ft for Property XYZ

3. Select Account type of “Units”.
4. 

2. Setup > Accounts

1. Link the base unit account to appropriate prefixes for consolidation groups in AnterraBI and Statement Builder.
2. It will make no difference regarding the prefix at the balance sheet or income statement level – but might make more sense depending on how the activity will be reported.

1. For example: 

1. Link to a balance sheet prefix if the current balance will be reported.
2. Link to an income statement prefix if the monthly activity will be reported.

Entering transactions using unit accounts

1. Tasks > Record entries

1. Complete the one-line entry according to your company business rules.

1. There is no requirement for debits = credits on unit accounts.

2. Debits will be a positive amount and credits will be a negative amount in Anterra ASB reporting.

2. Tasks > Post entries if automatic posting is not set.

1. Note:  Posting to closed periods will require re-opening periods to complete the posting.

3. Data correction

1. Follow the steps for record entries.
2. Be sure to record the “net change” required and not what the original entry should have been.

Data sync to AnterraBI

Changes in Sage 300 will be transferred to the AnterraBI database at the scheduled update times.  This is usually once overnight and once during the day at a time your network admin requested during implementation.  Please submit an issue if an earlier sync is needed after making changes.

How to get help

Submit a support ticket.

Please email support@anterratech.com.  A new helpdesk ticket will be created, and an SME will get back to you within 24 business hours.  Be sure to include these details:

4. Describe what you need in the subject line if possible.
5. The steps you took to get to the place you need help (steps to reproduce).
6. What is happening now and the result you are expecting.
7. Best time and method to contact you.