Calculations
Calculations allows the Systems Administrator to maintain calculations for Account totals such as, Total Guest Count or Cash Over/Short.
This activity is available on the Smart Client ONLY.
How Do I Maintain Business Calculations?
Once you have opened Calculations, perform the following
- Right click on the 'NUMBER' column and make the appropriate selection if necessary
- Number auto-populates when a calculation is added. This is the order in which a calculation occurs.
- A calculation that is included in another calculation must occur prior to the calculation in which it is included.
- Calculation Name describes the calculation for the account.
- Enter the dates in the 'FROM DATE' and 'THRU DATE' columns
- Link the calculation in the 'POST TO ACCOUNT' column
- Only those accounts that are designated asCalculated in the 'MODE' column under Accounts will populate in this list.
- Select the Unit in the 'UNIT' column to restrict use of the calculation to a single unit
- The 'UNIT' column defaults to Global Calculation. This applies the account calculation to all units.
- Enter Comment in the 'COMMENT' column if needed
- Activate the calculation by putting a check mark in the 'ACTIVE' column box
- If there is not a check mark in this box, the line will turn pink for easy identification.
- Select Balance Forward flag if the account allows the balance to carry over each month
- Royalty accounts or any account that needs to be accumulated across time and/or partially depleted after a payment.
- 'FIXED', 'DAILY/PERIOD', and 'AMOUNT' columns are all read-only and are defined within the calculation.
- Expand details to view or modify calculation details
- Select the appropriate option in the 'CALCULATED FORMULA' column to apply to the account
- Define Operands for the calculation
- Click Done
How Do I Create A Fixed Calculation?
Once you have opened Calculations, perform the following
- Click Add
- Enter the line information
- Click Actions
- Select Create Fixed Amount
- Enter the information for the Fixed Amount
- Click Actions and select one of the following:
- Clone Calculation: comes in handy when you have a calculation that is already set up and a date or a unit are different, so you do not have to enter it all by hand again.
- Verify Calculation: check the calculation errors
- Show Recalculation Status: view the last time a line was recalculated and for which units
- Force Recalculate: recalculate an account or the entire list for a particular time frame
How Do I Create Business Calculations?
- Open Accounts activity
- Click Add
- Assign that account to the appropriate meta-account
- Set the account to Calculated in the 'MODE' column
- Open Calculations activity
- Click Add
- Assign a name to the calculation
- Select the beginning and end date for the calculation
- Select the account to which the result should post
- Expand the calculation details
- Select the type of calculation necessary
- Build out each line of the calculation
- Click the Active check and send
- Click Actions
- Select Force Recalculate to test the calculation
- It's best to run the recalculation for a small portion of data (one or two days for one unit) until the calculation has been validated
- Validate the calculation using the Daily Business Summary Report or DBS Calculation Scheme Report