Licensing Agreement and Warranty

At Cougar Mountain Software, Inc., we strive to produce high-quality software at reasonable prices. We can only do this, how-

ever, if our rights as developers are respected. Even though we provide exceptional software at low prices, we do not consent to

unlicensed use of our software.

The software is owned by Cougar Mountain Software or its suppliers and is protected by United State copyright laws that pertain

to computer software and international treaty provisions. A license is granted for software which is owned by Cougar Mountain

Software, while a sublicense is granted for software which is owned by a third party from whom Cougar Mountain Software has

acquired a license to market the software. Such third party retains all ownership rights in its software. Third party software may

only be used in combination with Cougar Mountain Software with which it is distributed. A licensed user may make as many cop-

ies of the diskettes/CDs as needed for his/her use on a single personal computer, or in the case of a multi-user version, a single net-

work server but may not make unlimited copies.

It is strictly prohibited to give copies to another person, or to duplicate the software by any other means, including electronic trans-

mission. The software contains trade secrets and in order to protect them you may not decompile, reverse engineer, disassemble,

or otherwise reduce the software to human-perceivable form. You may not modify, adapt, translate, rent, lease, loan, resell for

profit, or distribute the software or any part thereof.

Cougar Mountain Software warrants the original disks/CDs are free from defects in material and workmanship, assuming normal

use, for a period of ninety (90) days from date of purchase. If a defect occurs during this period, you may return your faulty disk/

CD to Cougar Mountain Software. Cougar Mountain Software will replace it free of charge.

Except for the express warranty of the original disks/CDs set forth above, Cougar Mountain Software grants no other warranties,

express or implied, by statute or otherwise, regarding the disks/CDs and related materials. Their fitness for any purpose, their

quality, their merchantability, or otherwise, the liability of Cougar Mountain Software under the warranty set forth above shall be

limited to the amount paid by the customer for the product. Cougar Mountain Software includes sample and shell company data.

In no way do we claim that this data will match your company structure completely. The shell templates contain sample company

account numbers and formats which should be modified to fit your specific business needs. In no event shall Cougar Mountain

Software be liable for any special, consequential, or other damages for breach of warranty. The Agreement shall be governed and

construed in accordance with the laws of the State of Idaho.

Recognized Trademarks. This manual makes reference to the following trademarks: Novell, a trademark of Novell Inc.; LANtas-

tic, a trademark of Artisoft Inc.; and Microsoft, Windows, Windows 95, Windows 98, Windows NT, Windows 2000, and Win-

dows XP registered trademarks of Microsoft Corporation. Other brands or products are the trademarks or registered trademarks of

their respective holders and should be treated as such.

T A B L E O F C O N T E N T S

New Features in CMS Professional ...

Quick Reference of Version 12 Features ...

...2

New Features in Version 12.0 Release ...

..5

Version 12.0 Feature Descriptions...

Add a Date Block Range for Posting ...

Compare Financial Status with Target Goals in General Ledger ...

...6

Create Additional Custom Reports in Various Modules ...

..7

Filter GL Spreadsheet Export Report by Account ...

..8

Include General Ledger Account Impact Summary on Edit Reports ...

Include Posting Reference/Batch Number on Check Register ...

Monitor Your Business Status with the Financial Analysis Report ...

..10

Print Customer Statements from AR Customers Window ...

...12

Reindex All Modules ...

...12

Set Default Printing of Account Numbers on General Ledger Reports ...

.14

Set Up Query for Additional Reports ...

..14

Use Additional Report Groups in General Ledger ...

...15

Use Unapplied Payment Transaction Type ...

.16

View a Common-Size Balance Sheet and Income Statement in General Ledger...

...18

View Date Ranges on Budget Reports ...

..18

View More Information on AP GL Expense Distribution Report ...

...20

View Improved Balance Sheet, Income Statement, and Audit Trail Reports

in General Ledger ...

...20

View Snapshot Reports of Your Business ...

...22

New Features in Past CMS Professional Releases ...

.25

Quick Reference of Version 11 Features ...

.26

Version 11 Feature Descriptions...

..28

Create a Custom Options Menu in Any Module ...

...28

Create Custom Reports in Various Modules ...

..29

Decrease Payment Processing in Accounts Receivable ...

..32

Drill Down to Aged Analysis Report from Accounts Receivable ...

...33

Drill Down to Open Purchase Orders or Back Orders from Inventory ...

...34

Drill Down to Profit Margin Report from Accounts Receivable ...

..36

Drill Down to Vendor Performance Report from Inventory ...

..36

Include Subtotals in Sales Tax Code Summary Report ...

...38

Include User ID and Batch Number on Reports ...

...39

Monitor Monthly Movement of Stock Items ...

.40

Print Checks When Entering Bills in Accounts Payable ...

...44

Recalculate Your Payroll Taxes Reminder ...

..45

Set a Default Search in Lookup Windows ...

...46

Set Date Controls on Reports...

.47

Set Up a Query for Key Reports ...

...51

Quick Reference of Version 12 Features

Refer to the following table to see what new features for version 12.0 apply to the Cougar Mountain Software package(s) or

add-ons you purchased. For more information on each new feature, see the corresponding page(s) or the online help.

New Features in CMS Professional

Version 12.0

Add a date block for posting (page 6)

Compare financial status with target goals in

General Ledger (page 6)

Create additional custom reports in various

modules (page 7)

Filter GL Spreadsheet Export Report by account

(page 8)

Include general ledger account impact summary

on Edit Reports (page 9)

Include posting reference/batch number on

check register (page 9)

Monitor your business status with Financial

Analysis Report in General Ledger (page 10)

Print customer statements from AR Customers

window (page 12)

Reindex all modules (page 12)

Set default printing of account numbers on

General Ledger reports (page 14)

Set up query for additional reports (page 14)

Use additional report groups in General Ledger

(page 15)

Use unapplied payment transaction type

(page 16)

View common-size Balance Sheet and Income

Statement in General Ledger (page 18)

New Features

Version 12.0 Feature Descriptions

There are several new features in CMS Professional that might help you streamline your business

processes or make important financial decisions. For instance, you can view an impact summary of

general ledger accounts with your edit reports, and view snapshots of your business. Read about the

new features throughout the following content to learn how they can help with your business processes

and tasks.

Add a Date Block Range for Posting

Now you can set a start and end range of dates to block for posting transactions. This allows you the

options of blocking all posting in all modules for a specific period or periods within the fiscal calendar.

You will receive an error message if you attempt to post a transaction that is outside of the date block

range. This might help prevent errors such as posting a transaction for 2008 instead of 2007. To add a

date block range, in the Main Menu select Company/Organization > Fiscal Calendar from the menu

bar.

In the Date Block Period fields, enter the starting and ending range you wish to block and select OK .

For more information on working with the fiscal calendar, refer to the user’s guide(s) or online help

installed with your package(s).

Compare Financial Status with Target Goals in General Ledger

If you are an Accounting or Point of Sale Back Office user, you can use the new Financial Report

Codes to compare your business’ current financial activity to your target financial goals. When you

create a Financial Report Code, you set the values you want to use for comparison. Then, when you run

the GL Financial Analysis Report, GL Common-Size Balance Sheet, or GL Common-Size Income

Statement, you can use these codes to include the defined values under the Industry Averages column

to see how your business is currently stacking up to your target goals. For example, you might create a

code, T1 , for your target goals within your specific industry and another code, T2 , for your internal

target goals as your business. If your particular business overlaps industries, you could set up a code for

New Features

Version 12.0 Feature Descriptions

each industry that you fit into and compare them all at once. To create a Financial Reports Code in

General Ledger, select Options > Financial Reports Codes from the menu bar.

Enter a two-digit character code and description for this Financial Report Code. If you want the

description to appear as the column heading on reports that include this information, check the

Print Description On Report check box. If you leave this check box unchecked, the column

heading on the reports will read Industry Average .

The term options you can set for your code include the following: Current Ratio, Quick Ratio,

Sales/Receivables, Sales/Working Capital, EBIT/Interest, Debt Coverage Ratio (Net Profit + Depr.,

Dep., Amort./Cur.Mat. L/T/D), Fixed/Worth, Debt/Worth, ROI (% Profit Before Taxes/Tangible

Net Worth), ROA (% Profit Before Taxes/Total Assets), Sales/Total Assets, Cash & Equivalents,

Trade Receivables, Inventory, All Other Current Assets, Intangibles (net), All Other Non-Current

Assets, Notes Payable Short-Term, Cur. Mat. L/T/D, Trade Payables, Income Taxes Payable, All

Other Current Liabilities, Long Term Debt, Deferred Taxes, All Other Non-Current Liabilities, Net

Worth, Net Sales, Total Current Assets, Fixed Assets (net), Total Liabilities & Net Worth, Gross

Profit, Operating Expenses, Operating Profit, All Other Expenses (net), Profit Before Taxes.

The values you enter in the Value/Ratio Column fields appear in the industry average column on

the GL Financial Analysis Report (see “Monitor Your Business Status with the Financial Analysis

Report” on page 10), GL Common-Size Balance Sheet, or GL Common-Size Income Statement

(see “View a Common-Size Balance Sheet and Income Statement in General Ledger” on page 18).

Keep in mind that the values you enter in this window are percents. For example, if you enter 2.2 as

the value, this will show as 2.2% on the reports. Or, if you enter .25 as the value, it will show as

.25% on the reports.

For more information on working with general ledger accounts or reports, refer to the user’s

guide(s) or online help installed with your package(s).

Create Additional Custom Reports in Various Modules

This feature was introduced with version 11.0, but with the latest version you can customize

additional reports and then access them from within certain Cougar Mountain report windows. The

additional reports you can use with this feature are as follows:

Cougar Mountain Software

Version 12.0 Feature Descriptions

„ Accounts Payable: Dated Invoice/Payment Report, GL Expense Distribution Report, and

History Report

„ Accounts Receivable: Edit Reports, Dated Invoice/Payment Report, and History Report

„ Bank Reconciliation: Bank Register Report, and Edit Reports

„ General Ledger: Edit Reports, Audit Trail Report, Trial Balance Report, Balance Sheet,

Income Statement, Revenue and Expense Report (FUND only), Cash Flow Report, FASB

Reports (FUND only), American Red Cross Report (FUND with ARC only), Budget

Performance Report, and Budget Report

„ Inventory: Promotional Sales Report

„ Job Cost: Billing History Report, Profit Margin Report, and Sales Tax Report

„ Order Entry: Invoice Tracking Report, Sales History Report, Price Variance Report, Sale Tax

Report, Promotional Sales Report, Profit Margin Report, Back Order Tracking Report, and

Back Order Fulfillment Report

„ Payroll: Edit Reports, Print Checks Report, and Employee Benefit/Deduction Report

„ Point of Sale: Reprint Receipts Report, Sales History Report, Price Variance Report, Sales Tax

Report, Coupon/Buy Down Report, Promotional Sales Report, and Profit Margin Report

„ Purchase Order: Print POs/Reprint POs Report, Edit Reports, Open Purchase Order Report,

Expected/Late Items Report, Vendor Performance Report, and History Report

For detailed information on working with this feature, refer to “Create Custom Reports in Various

Modules” on page 29.

Filter GL Spreadsheet Export Report by Account

If you want to export your general ledger account information, you can now filter out only what you

want to export. You have the options of using the Account Filter or Advanced Filter options for this

report. Also, if you have more than one company, you can consolidate the ledgers into one export by

selecting the Print Consolidated Ledgers check box.

New Features

Version 12.0 Feature Descriptions

For more information on working with accounts, report filters, or reports in General Ledger, refer

to the user ’s guide(s) or online help installed with your package(s).

Include General Ledger Account Impact Summary on Edit

Reports

Do you ever want to see how transactions will affect your general ledger accounts before you post

transactions? Now you can with the new Print Account Impact Summary check box available in

all Edit Report windows (except in Bank Reconciliation). The image in this section shows the new

check box in the GL Print Edit Report window.

With this new feature, you can now see a summary of how your unposted transactions will affect

each general ledger account. This might help you notice incorrect entries if you have a large

number of transactions to post. When you select this check box and click OK , the Edit Report will

print first and then the GL Impact Summary Report will print. If during validation errors are

encountered, they will show on the report instead of the transaction information.

If you use batches in Order Entry, Point of Sale, or Purchase Order and you choose to print more

than one batch for which to see the impact summary, a separate impact report will print for each

batch. For example, if you selected three batches to print, then the edit report prints first followed

by the GL Impact Summary Report for the first batch, then the second batch and then the third.

For more information on working with the Edit Reports, refer to the user’s guides or online help

installed with your package(s).

Include Posting Reference/Batch Number on Check

Now before you post tranasctions in Accounts Payable, you can track the module, reference

number, transaction number, and batch number for every transaction. This might be beneficial, for

example, if there is an error in a transaction and you want to track it back to the individual who

Cougar Mountain Software

Version 12.0 Feature Descriptions

generated it. Because the check register only reflects unposted Accounts Payable transactions, once

you post the batch, the register is cleared and the posting reference is omitted from history.

In regards to the image in this section, the segments in the posting reference AP-00183-00002-AGJ

represents the following information:

„ AP is the module from which the transaction is posted

„

00183 is the posting reference number

„

00002 is the transaction number

„ AGJ is the batch number

Keep in mind that if you delete a batch from your system and then run the AP Check Register Report,

you might notice a skip in the sequence of the last posting reference number.

For more information on working with the check register, refer to the user’s guides or online help

installed with your package(s).

Monitor Your Business Status with the Financial Analysis

Report

If you are an Accounting or Point of Sale Back Office user, this new report provides an option for you

to view the status of your business from a financial perspective in one easy-to-run report. In General

Ledger, when you select Reports > Financial Analysis from the menu bar, you can enter the ending

New Features

Version 12.0 Feature Descriptions

period for the timeframe you wish to view and the Financial Report Code to use for comparison

purposes (see “Compare Financial Status with Target Goals in General Ledger” on page 6).

The amount shown in each row of the report is based on the following calculation:

„ Current Ratio: (Total Current Assets) / (Total Current Liabilities)

„ Quick Ratio: (Cash & Equivalents + Trade Receivables) / (Total Current Liabilities)

„ Sales/Receivables: (Net Sales) / (Trade Receivables (Net))

„ Days’ Receivables: 365 (days of the year) / ((Net Sales) / (Trade Receivables (Net)))

„ Total Cost of Good Sold/Inventory (rounded to one decimal place): (Total Cost of Goods

Sold) / (Inventory)

„ Days’ Inventory: 365 (days of the year) / ((Total Cost of Goods Sold) / (Inventory))

„ Total Cost of Goods Sold/Payables (rounded to one decimal place): (Total Cost of Goods

Sold) / (Trade Payables)

„ Days’ Payables: 365 (days of the year) / ((Total Cost of Goods Sold) / (Trade Payables))

„ Sales/Working Capital: (Net Sales) / (Net Working Capital)

„ EBIT/Interest: (Earnings Before Interest and Taxes) / (Annual Interest Expense)

„ Debt Coverage Ratio: (Net Income + Depreciation + Amortization) / (Current Maturities

Long-Term Debt)

„ Fixed/Worth: (Net Fixed Assets) / (Net Worth)

„ Debt/Worth: (Total Liabilities) / (Net Worth)

„ ROA (Return on Assets): (Profit Before Taxes) / (Total Assets) x 100

„ ROI (Return on Investment): (Net Sales) / (Net Fixed Assets)

Cougar Mountain Software

Version 12.0 Feature Descriptions

„ Sales/Total Assets: (Net Sales) / (Total Assets) x 100

„ Cash Flow from Operations (FASB 95): (Change in Net Income + Total Adjustments)

„ EBITDA (Earning Before Intrest, Taxes, Depreciation, and Amortization): (Operating Profit +

Depreciation + Amortization)

„ Business Cash Flow: (Net Income + Depreciation + Amortization)

For more information on working with the Financial Report Codes, see “Compare Financial Status

with Target Goals in General Ledger” on page 6. For more information on working with general ledger

accounts or reports, refer to the user’s guide(s) or online help installed with your package(s).

Print Customer Statements from AR Customers Window

In addition to the other new features in Accounts Receivable, you can also now print customer

statements directly from the AR Customers window. Select Customers > Customer Maintenance

from the menu bar. On the Credit/Collection tab, you will notice the new Print Statement button.

When you select this button, the statement for the selected customer only will print. This helps simplify

the process when you need to print, or reprint, one statement or you need to closely monitor a single

customer’s account.

For more information on working with customer accounts or reports in Accounts Receivable, refer to

the user’s guide(s) or online help installed with your package(s).

Reindex All Modules

Have you ever needed to reindex more than one module and grown tired of all the steps required to do

so? Well, now you can reindex all of your installed modules at the same time. In the Main Menu if you

select Options > File Maintenance > Reindex Data Files , you will notice a new option that allows

you to reindex all modules at once. When you select the Reindex All Modules radio button, the grid

will populate with file information from all of your installed modules including system files. Keep in

New Features

Version 12.0 Feature Descriptions

mind that this feature allows any user with security rights to reindex in the Main Menu to also have

the rights to reindex for all of the other modules too.

To further enhance CMS Professional and expand this feature, the option to reindex is also

available when you schedule a back up using the Backup Schedule feature. If you select the

Reindex all modules before backup check box, the system will automatically reindex your files

before starting the back up process. If a user is in the system when the reindex process starts, the

files in use are skipped and a message indicating this will appear in the back up log to which you

can refer. You also have the option of stopping the backup if the reindexing fails. To do this, click

the Advanced button in the CMS Backup Scheduler window and in the window that appears,

select the Stop backup if reindex fails check box.

If you select the Stop backup if reindex fails check box and the system skips a file during the

reindex process, this will constitute a fail and the backup process will terminate. If the backup is

terminated, be sure to review the log for important information on what failed before attempting the

process again.

Cougar Mountain Software

Version 12.0 Feature Descriptions

For more information on working with the Main Menu or scheduling periodic backups, refer to the

user’s guide(s) or online help installed with your package(s).

Set Default Printing of Account Numbers on General Ledger

Reports

CMS Professional has the option to include general ledger account numbers on certain reports, but now

you can set this option as a default instead of selecting it each time you print the report. In the GL

Module Preferences window, you will notice the new Select “Print Account Number” as default

check box. If you enable this check box, when you run the balance sheet, income statement, revenue

and expense report (FUND only), or either budget report, the general ledger account numbers are

automatically included. Access the Module Preferences window by selecting Options > Module

Preferences from the menu bar.

For more information on working with module preferences in General Ledger, refer to the user’s

guide(s) or online help installed with your package(s).

Set Up Query for Additional Reports

This feature was introduced with version 11.0, but with version 12.0 you have additional reports for

which you can set up a query to further define your report. The additional reports you can use with this

feature are as follows:

New Features

Version 12.0 Feature Descriptions

„ Accounts Payable: Dated Invoice/Payment Report and History Report

„ Accounts Receivable: Customer Statements and Dated Invoice/Payment Report

„ General Ledger: Audit Trail Report

„ Inventory: History Report

„ Purchase Order: History Report

For detailed information on working with this feature, refer to “Set Up a Query for Key Reports”

on page 51.

Use Additional Report Groups in General Ledger

In conjunction with the new GL Financial Analysis, GL Common-Size Income Statement, and GL

Common-Size Balance Sheet reports, there are now additional report groups you can use to track

your general ledger accounts. When you create, or modify, your general ledger accounts, you can

assign report groups on the General tab of the GL Master Accounts window.

Cougar Mountain Software

Version 12.0 Feature Descriptions

You can also select one of the new options from the Classified drop-down list in the Set Up GL

Account Groups window to set up groups for specific reporting purposes. This image reflects a

sample account group for current assets.

The new report group options include: All Other Non-Current (Other Assets) , Deferred Taxes (Long

Term Liability) , All Other Non-Current (Long Term Liability) , Interest Expense (Expenses) , and

Amortization (Expenses) . For more information on using these new groups with the new reports, refer

to “Monitor Your Business Status with the Financial Analysis Report” on page 10 and “View a

Common-Size Balance Sheet and Income Statement in General Ledger” on page 18.

Use Unapplied Payment Transaction Type

Do you need to cut a check to a vendor before the bill is posted? Do you allow customers to pay for an

invoice before the vendor bill is posted? Now, per customer requests, with version 12.0 you can enter

unapplied payment transactions in Accounts Payable to help accommodate these types of situations. In

New Features

Version 12.0 Feature Descriptions

For more information on working with transactions in Accounts Payable, refer to the user’s guide(s) or

online help installed with your package(s).

View a Common-Size Balance Sheet and Income Statement in

General Ledger

You can now view a Common-Size Balance Sheet or Income Statement in General Ledger. In the

report window for either the Balance Sheet or Income Statement, an additional option of Common Size

is available for selection in the Report Type field. When you select this report type, a new Financial

Reports Code field appears in which you can enter or use the Lookup to select a code to include pre-

set industry averages (see “Compare Financial Status with Target Goals in General Ledger” on page 6)

on the report. These new reports are beneficial because you can compare two years of financials along

with the industry averages, which might help you analyze your financial status. The image in this

section reflects the GL Income Statement window and GL Common Size Income Statement. Because

these reports print in landscape format only, you must use a laser printer.

For more information on reports in General Ledger, refer to the user’s guide(s) or online help installed

with your package(s).

View Date Ranges on Budget Reports

With version 12.0, when you run a Budget Report in General Ledger, you will notice two new date

ranges included in the header section of the report. These date ranges include the current and year-to-

date ranges for which the report data spans. Because these reports provide a view of both the current

New Features

Version 12.0 Feature Descriptions

For more information on reports in General Ledger, or working with general ledger account or budget

balances, refer to the user ’s guide(s) or online help installed with your package(s).

View More Information on AP GL Expense Distribution Report

If you have Purchase Order installed and integrated with Accounts Payable, you can now view

additional information on the AP GL Expense Distribution Report. This additional information

includes the detailed description from the purchase order.

For more information on working with Accounts Payable or Purchase Order, refer to the user’s guide(s)

or online help installed with your package(s).

View Improved Balance Sheet, Income Statement, and Audit

Trail Reports in General Ledger

Cougar Mountain made several changes to the layout and design of the Balance Sheet, Income

Statement, and Audit Trail Reports to make them more consistent and readable. These changes were

incorporated in response to customer requests to modify these reports. When you run one of these

New Features

Version 12.0 Feature Descriptions

reports, you will notice some significant changes that further clarify the usability and readability of

them. The image in this section shows the new look of the GL Classified Balance Sheet.

Also, when you set up the GL Audit Trail Report to print, you will notice a few new options from

which to choose. You can now skip accounts with zero balances, group the activity by module, and/

or print the report in landscape view (detailed or single line). If you choose a landscape view, you

must use a laser printer. These new options require the system to save additional data at posting.

Because of this, for any transactions posted prior to installing version 12.0, when you run the

report, the Post Date field will reflect stars (***

**) and the Posting Reference field will be blank.

Cougar Mountain Software

Version 12.0 Feature Descriptions

For more information on reports in General Ledger, refer to the user’s guide(s) or online help installed

with your package(s).

View Snapshot Reports of Your Business

Have you ever wanted to see a snapshot of your business with one click? Now you can with version

12.0 in CMS Professional. When you select the menu option, Snapshot Reports , now available in the

Main Menu, you can run vital financial reports for General Ledger, Accounts Receivable, Accounts

Payable, Inventory, Sales (OE/POS), and Payroll (post 12.0 release) at the same time. Plus, after you

make your selections on each tab in this window and select OK , the system retains the settings for the

next time you want to use this feature. This helps eliminate time spent continually selecting your

options for this report, or opening several report windows to run all of the snapshots you wish to view.

Once you select the modules on the Report Options tab that you want to include for the report, you

can also select the exact information to include for each module snapshot. Only the options you select

will show in the snapshot(s). The following options are available on the respective tab:

„ For General Ledger: You can print the financial data based on a period or date range and you

can print a graph of the total net income/(loss) per period for the current fiscal year.

„ For Accounts Receivable: You can print transaction totals, your top ten customers, and your

top ten delinquent customers along with a graph of the total receivables by period.

„ For Accounts Payable: You can print your top ten vendors, your top ten overdue items, the

next ten upcoming items due, and a graph of the total payables by period.

„ For Sales (OE/POS): You can print the top ten best selling items, worst selling items, most

profitable items, days for sales, weeks for sales, and the running/current sales in any open

batch(es) or register(s), along with a graph of the total sales by period.

„ For Inventory: You can print the top ten best selling stock items, worst selling stock items,

fastest turnover items, slowest turnover items, and understock items, along with a graph of the

total of inventory purchases by period.

„ For Payroll (post 12.0 release): You can print the total payroll expense by department, your

employees’ vacation and sick leave totals, your top ten employees by total vacation, sick, and

other time used, along with grand totals of all and a graph of the total payroll expenses by

period.

New Features

Version 12.0 Feature Descriptions

Once you select your report options and click OK , your report will look something like the image

in this section.

As with many CMS Professional features, you can set up security so that only the users you want to

run snapshot reports can do so. You will also notice with this new report that the corresponding

modules might need the data (accumulators) reset depending on your business’ reporting needs. In

General Ledger or Payroll you reset the accumulators when you close your year, or in Accounts

Receivable and Accounts Payable when you reset the year-to-date totals. However, for Inventory

there is a new Reset Accumulators option on the Period End menu. This option allows you the

opportunity to reset the accumulators for the Inventory Snapshot Report.

As with any task that clears, purges, or resets business data, we highly recommend you back up

your data before completing the task. For more information on backing up your data, or the reports

available in CMS Professional or printing them, refer to the user’s guide(s) or online help installed

with your package(s).

Cougar Mountain Software

Quick Reference of Version 11 Features

Refer to the following table to see what features for version 11 apply to the Cougar Mountain Software package(s) or add-ons

you purchased. For more information on each feature, see the corresponding page(s) or the online help.

New Features in CMS Professional

Version 11

Create a custom options menu in any module

(page 28)

Create custom reports in various modules

(page 29)

Decrease payment processing in Accounts

Receivable (page 32)

Drill down to Aged Analysis Report from

Accounts Receivable (page 33)

Drill down to open purchase orders or back

orders from Inventory (page 34)

Drill down to Profit Margin Report from Accounts

Receivable (page 36)

Drill down to Vendor Performance Report from

Inventory (page 36)

Include subtotals in Sales Tax Code Summary

Report (page 38)

Include user ID and batch number in transactions

(page 39)

Monitor monthly inventory movement (page 40)

Print checks when entering bills in Accounts

Payable (page 44)

Recalculate your payroll taxes reminder

(page 45)

Set a default search in Lookup windows

(page 46)

New Features

Version 11 Feature Descriptions

Several new features were included with version 11 that might help the efficiency of your business. For

instance, you can now set up a customized menu in any module, add access to custom reports from

within other report windows, set default lookups, and view monthly inventory movement. Read about

the new features throughout this chapter to learn how they can help with your business processes and

tasks.

Create a Custom Options Menu in Any Module

To enhance your interaction with Cougar Mountain and streamline business processes, you can now

create a Custom Options menu for any module. This Custom Options menu can include links to

frequently-used external programs such as Microsoft Outlook ® . You set up this customization in the

Main Menu of each module for which you wish to include a custom menu.

To accommodate this new functionality, the Define Custom Menus item is added to the Options menu

in the Main Menu module.

When the Define Custom Menus option is selected, the Define Custom Options Menu window

appears. In this window, you set up the various menu items, the path to the location of the items, and

the module in which you wish to create the Custom Options menu.

New Features

Version 11 Feature Descriptions

Once you define the custom options, when a module with this new menu is accessed, the list of

options are available. If no options have been defined the list will display <No Custom Options> .

As with many of the other features and functions of Cougar Mountain, a security option is also

available to ensure that only users that you want to have the ability to create custom menus can do

so.

Create Custom Reports in Various Modules

With this new feature you can customize a selection of custom reports from within certain Cougar

Mountain report windows. This means that if you have a custom report(s) created with Report

Writer that you currently use, you can now set up the system up to access it directly from within a

specific report window. Another benefit of setting up this type of report customization is that it

retains the reports in a separate folder location so your custom reports are not overwritten when you

upgrade your software. This customization is accomplished by setting up links to the custom

Cougar Mountain Software

Version 11 Feature Descriptions

As with many of the other features and functions of Cougar Mountain, a security option is also

available to ensure that only users that you want to have the ability to create custom report options can

do so.

Decrease Payment Processing in Accounts Receivable

The new Quick Pay feature available in Accounts Receivable allows you to decrease entry time by

paying multiple invoices at one time. In the AR Enter Payments/Adjustments window, a new Quick

Pay button is added.

When you select the Quick Pay button, the AR Quick Pay - Open Item Lookup window appears.

This window allows you to select multiple items to include in a single payment. To include an item,

click it once and a checkmark will appear in the Pay column. When all items you wish to include in

New Features

Version 11 Feature Descriptions

this single payment transaction are selected and you click OK , the selected items will appear in the

detail grid in the AR Enter Payments/Adjustments window.

If you find that you have included an item in error, you must remove it directly from the grid. For

more information on entering payments or adjustments in Accounts Receivable, refer to the

Accounting , Accounts Receivable , FUND Revenue Center , or Point of Sale Back Office user’s

guide.

Drill Down to Aged Analysis Report from Accounts

Receivable

Instead of running an Aged Analysis Report by setting all the specific criteria for one customer, you

can now access this same report with one click. A new Aged Analysis button is added to the Aged

Analysis tab in the AR Customers window. This quick-access button allows you to quickly view

the Aged Analysis Report for the selected customer.

Cougar Mountain Software

Version 11 Feature Descriptions

For more information on running reports in Inventory, refer to the Accounting , FUND Revenue Center ,

or Point of Sale user’s guide.

Drill Down to Profit Margin Report from Accounts Receivable

If you have Order Entry, Point of Sale, or Job Cost installed and integrated to Accounts Receivable,

you can now quickly view the Profit Margin Report for a specific customer directly from the AR

Customers window. A new Profit Margin button is added to the the AR Customers window. This

quick-access button allows you to view the Profit Margin Report for the selected customer.

When the Profit Margin button is selected, the profit report for the selected customer appears.

For more information on running reports in Accounts Receivable, refer to the Accounting , Accounts

Receivable , FUND Revenue Center , or Point of Sale Back Office user’s guide.

Drill Down to Vendor Performance Report from Inventory

If you have Purchase Order installed, when you are in the IN Stock window, you can now drill down

and view the PO Vendor Performance Report. This feature allows you to quickly view a vendor’s status

New Features

Version 11 Feature Descriptions

For more information on running reports in Inventory, refer to the Accounting , FUND Revenue Center ,

or Point of Sale user’s guide.

Include Subtotals in Sales Tax Code Summary Report

Including subtotals on the Sales Tax Code Summary Report is now available in Order Entry, Point of

Sale, and Job Cost. To meet customer needs in their business, Cougar Mountain added the option to

include subtotals per Tax Code, or, if desired, you can still run the report without subtotaling. When

you access one of the Sales Tax Reports, you will notice the added Subtotal field in the window. This

image reflects the PS Sales Tax Report window.

If you want to include Tax Code subtotals, select Tax Code in the Subtotal field. If you prefer to omit

subtotals on the report, select None . Keep in mind, this report option is only available if you select

Detail or Summary in the Report Type field. Once you set the other report criteria and select OK , the

report will print with the desired information.

New Features

Version 11 Feature Descriptions

For more information on Sales Tax Codes or running reports in Order Entry, Point of Sale, or Job

Cost, refer to the user ’s guide(s) or online Help installed with the software.

Include User ID and Batch Number on Reports

To help you track transactions back to the individual who entered them Cougar Mountain added

both the User ID and Batch Number information posted with transactions and available on certain

reports. This additional information helps you quickly see which clerk entered which transaction or

with which batch a specific transaction was posted. The User ID is determined by the login entered

by the user when accessing the module. This image is an example of the IN Transaction Posting

Audit Report showing the new tracking information.

If you wish to show both the User ID and Batch Number information in General Ledger posting

reports, make sure your integration setting is set to Detail or Report Only Detail . Otherwise, only

the Batch Number information is retained with the transaction data when posting to General

Ledger.

Please note that only reports printed on a laser printer will show the User ID and Batch Number.

Reports printed on a dot matrix printer will not show this information.

Reports Including User ID and Batch Number Information

This section provides a listing of the reports that contain the new information when posting in each

module.

„ Accounts Payable: AP Posting BR Report, AP Posting Inventory Report, AP Posting Pay

Report, GL Posting Audit Report, BR Posting Audit Report, Inventory Posting Audit

Report, and JC Billing Posting Audit Report

„ Accounts Receivable: AR Posting Audit Report, AR Posting BR Report, GL Posting

Audit Report, and BR Posting Audit Report

„ Bank Reconciliation: BR Posting Audit Report and GL Posting Audit Report

„ General Ledger: GL Audit Trail Report, GL Posting Audit Report, and GL Reprint

Posting Report

„ Inventory: Inventory Posting Audit Report and GL Posting Audit Report

„ Job Cost: AP Posting Audit Report, AR Posting Audit Report, IN Posting Audit Report,

JC Activity Posting Audit Report, JC Billing Posting Audit, and GL Posting Audit Report

„ Order Entry: OE AP Posting Audit Report, Point of Sale Posting Audit Report, JC Billing

Posting Audit Report, and GL Posting Audit Report

Cougar Mountain Software

Version 11 Feature Descriptions

„ Point of Sale: Point of Sale Posting Audit Report, PS AP Posting Audit Report, AR Posting

Audit Report, Inventory Posting Audit Report, and GL Posting Audit Report

„ Purchase Order: PO AP Posting Audit Report, PO Inventory Posting Report, PO Posting

Audit Report, JC Billing Posting Audit Report, and GL Posting Audit Report

„ Payroll: PR AP Posting Audit Report, PR Posting Audit Report, JC Billing Posting Audit

Report, BR Posting Audit Report, and GL Posting Audit Report

For more information on running reports in a module, refer to the user’s guide(s) or online Help

installed with your software.

Monitor Monthly Movement of Stock Items

Managing stock items is a key facet for any business with inventory. Now you can monitor your stock

item movement for each month in your Fiscal Calendar. This will help with reordering and maintaining

inventory levels pertinent to your business. By monitoring your inventory movement at a monthly

level, you gain valuable insight into what is selling and not selling to help determine items you might

need to discount. This level of monitoring also provides the ability to track inventory over time to see

what and if seasonal trends affect movement.

To accommodate this new feature, the option of Monthly Movement is added to the Reports menu in

Inventory. When you select this option, the IN Monthly Movement window appears.

There are a number of options you can set, or define, to tailor this monthly movement report to meet

your specific business needs. Review the options described in this section for specifics on using this

report.

Starting Period

For this option, select the starting period you wish to set for this report. The report will automatically

show a 12-month view based on the starting period and the dates you established in your Fiscal

Calendar. So, for instance, if you select to start with Period 3 and this period begins on March 17th of

the current year, your report will show March 17th through February 17th of the following year. These

periods are shown as column heads within the report and are in the format of MM/DD-MM/DD.

If you have 13th, 26th, and 39th periods set up for the purpose of entering adjustment transactions, any

movement within one of these three periods is rolled into the preceding period for the purpose of this

report. For example, if you have inventory movement in the 13th period, it will show under the 12th

period on the monthly movement report.

New Features

Version 11 Feature Descriptions

Starting and Ending Ranges: Inventory Code, Stock Number, Description, Location

(MLI only), and Product Type

These report options provide a means by which to view only specific inventory items. You can

choose to view only certain stock items based on their stock number, Inventory Code, description,

or product type. If you have the Multi-Location Inventory add-on installed, you can also choose to

view monthly inventory movement for a specific location or all of your locations.

Movement %

There might be times when you wish to view movement that falls within a specific percentage

range. For instance, you might want to view only inventory with a 5% or higher movement rate.

This is beneficial because it narrows the movement range for the purpose of planning an effective

strategy for future purchasing management.

Additional Filter and UDF Range

If you set up User-Defined Fields (UDFs) in Module Preferences in Inventory, you can use the

UDFs for filtering purposes. Once you select a filter option other than the default of <None> , the

UDF will appear as an option with starting and ending ranges.

Movement Check Boxes

To even further customize this movement report, you can choose to omit stock items with zero

movement or include movement generated by adjustment or transfer transactions. If you check the

Skip 0% Movement check box, stock items with no movement during the specified range will not

appear on the report. If you check the Include Adjustments/Transfers in Movement % check

box, then adjustment and transfer movement is included in the Movement % field on the report.

Once you set up the report criteria and select OK , the customized report will print. Because of the

magnitude of this report, it prints in Landscape layout to accommodate all of the information and

the layout cannot be modified. Depending on your selections, the report will look something like

this image.

This is a robust report that provides valuable information regarding your inventory movement. The

information in this section defines the basis and calculations used to obtain the figure information

in each row. We recommend you review this information closely to ensure you understand how

each figure is determined before planning any future purchasing or category management options.

When reviewing the information about the various figures included in the report, keep in mind that

inventory costs are determined at the time of purchase and do not reflect adjustments made

afterwards. Also, sales revenue is based on the sale price of the inventory item at the time of sale.

Cougar Mountain Software

Version 11 Feature Descriptions

Beginning Qty : For the first period in the report, this row shows the sum of the quantities of any

subtractions made on or after the first day of the period added to the on-hand quantity. Then, this total

has the sum of the quantities of any additions made on or after the first day of the period subtracted

from it to obtain the beginning quantity.

The formula for this calculation is: On-Hand Qty + (Sum of Subtraction Quantities) - (Sum of Addition

Quantities) = Beginning Qty. For subsequent periods, the beginning quantity equals the ending quantity

of the previous period. The YTD Totals column reflects the beginning quantity for the first period

included in the report.

Qty In : For each period, this row shows the quantity of inventory received for the month from

Accounts Payable, Job Cost, and Purchase Order transactions. This field also includes returns posted

from Order Entry and Point of Sale. The YTD Totals column reflects the sum of the quantity received

or returned for each period included in the report.

Qty Sold : For each period, this row shows the monthly per-item quantity sold in Order Entry, Point of

Sale, and Job Cost. This field also includes returns posted from Order Entry and Point of Sale. The

YTD column reflects the sum of the quantity sold for each period included in the report.

Add Inventory : For each period, this row shows the sum of all posted adjustment transactions from

Inventory with a Transaction Code that begins with 1. The YTD Totals column reflects the sum of all

inventory addition adjustments for each period included in the report.

Subtract Inventory : For each period, this row shows the sum of all posted adjustment transactions

from Inventory with a Transaction Code that begins with 2. The YTD Totals column reflects the sum

of all inventory subtraction adjustments for each period included in the report.

Transfer In : For each period, this row shows the sum of all posted adjustment transactions from

Inventory with a Transaction Code that begins with 3. These transactions represent inventory items that

are transferred in from another location, therefore this information is only available if the company is

using the Multi-Location Inventory add-on. The YTD Totals column reflects the sum of all inventory

transfer in adjustments for each period included in the report.

Transfer Out : For each period, this row shows the sum of all posted adjustment transactions from

Inventory with a Transaction Code that begins with 3. These transactions represent inventory items that

are transferred out to another location, therefore this information is only available if the company is

using the Multi-Location Inventory add-on. The YTD Totals column reflects the sum of all inventory

transfer out adjustments for each period included in the report.

Ending Qty : For each period, this row shows the sum of adding any addition quantities or addition

adjustments and subtracting any quantities sold or subtraction adjustments from the beginning quantity

for each item. If Multi-Location Inventory is used by the company, the beginning quantity is also

adjusted by adding or subtracting the transfer quantity. The formula for this calculation is: Beginning

Qty + (Qty In - Qty Sold ) + (Add Inventory - Subtract Inventory ) + (Transfer In - Transfer Out). The

YTD Totals column reflects the ending quantity for the last period included in the report.

Movement % : For each period, this row shows the calculated percentage based on the following

formulas:

„ If the Beginning Qty + Qty In + Transfer In = 0, then 0% is shown

„ If Beginning Qty is less than zero, then 0 is used as the Beginning Qty to calculate

the % shown

„ If the Include Adjustments/Transfers in Movement % check box is unchecked, then Qty

Sold / (Beginning Qty + Qty In) is shown

New Features

Version 11 Feature Descriptions

„ If the Include Adjustments/Transfers in Movement % check box is checked, then (Qty

Sold + Subtract Inventory + Transfers Out) / (Beginning Qty + Qty In +Add Inventory +

Transfers In) is shown

The transfers in and out are only included in the calculation if Multi-Location Inventory is used.

The YTD Totals column reflects the movement percentage for each period included in the report.

Value: Qty In : For each period, this row shows the sum of the cost of the inventory items received

in Accounts Payable, Purchase Order, and Job Cost transactions. This sum provides the inflow and

outflow of cash. The YTD Totals column reflects the sum of the cost of inventory items received

for each period included in the report.

COGS : For each period, this row shows the direct expenses of inventory items that were sold to

customers (commonly referred to as cost of goods sold or cost of sales) in Order Entry, Point of

Sale, or Job Cost transactions. Direct expenses include the actual cost of inventory items (goods)

and direct labor expenses in creating the salable goods. Cost of goods does not include any indirect

expenses (i.e. office, shipping, or advertising expenses) that cannot be attributed to a particular item

sold. The YTD Totals column reflects the sum of the cost of goods sold for each period included in

the report.

COGS Per Unit : For each period, this row shows the average cost to make or obtain the inventory

item. This average is derived using the formula: COGS / Value of Qty Sold.

Price Per Unit : For each period, this row shows the average sale price per inventory item. This

average is derived using the formula: Monthly Sales Revenue / Value of Qty Sold. The YTD Totals

column reflects the YTD Sales Revenue / YTD Value of Qty Sold.

Sales Revenue : For each period, this row shows the sum of the cash amounts received for each

inventory item sold in Order Entry, Point of Sale, or Job Cost. This figure reflects the actual

amount, including promotions or discounts. The YTD Totals column reflects the sum of sales

revenue for each period included in the report.

IN Turnover : For each period, this row shows the turnover ratio which is derived using the

formula: COGS / ((((Beginning Qty + Ending Qty) / 2) * COGS Per Unit)). The YTD Totals

column use the same formula. If the Beginning Qty + the Ending Qty = 0, then a dash appears in

this field. If COGS = 0, then IN Turnover = 0.

Gross Profit %: For each period, this row shows the gross profit for the inventory item. This

percentage is derived from the formula: ((Sales Revenue - COGS) / (Sales Revenue) * 100). If the

Sales Revenue is equal to zero, then the percentage shows 0.

GMROI : For each period, this row shows the gross margin return on inventory which is derived

using the formula: Markup % * Inventory Turnover. The Markup % figure is derived using the

formula: (Sales Revenue - COGS) / COGS. If COGS = 0, then GMROI = 0.

Cougar Mountain Software

Version 11 Feature Descriptions

As with many of the other features and functions of Cougar Mountain, a security option is also

available to ensure that only users that you want to have the ability to create custom menus can do so.

For more information on inventory reports, refer to the user’s guide(s) installed with your software.

Print Checks When Entering Bills in Accounts Payable

This new feature allows you to print immediate checks for bills with more flexibility. This feature

increases efficiency when printing immediate checks because as you enter bills, you can immediately

print checks from within the same window. This option is only available for users with security rights

to print immediate checks.

In the AP Enter Bills window, a new Print Check s button is added.

New Features

Version 11 Feature Descriptions

When you enter bill(s) for immediate payment by selecting the Immediate and Print Check check

boxes and then click the Print Checks button, the transaction(s) is saved and the AP Print

Immediate Checks window appears. The functionality of this window is the same as with previous

releases.

You can print an immediate check for a bill when you enter it or you can choose to print immediate

checks after entering a batch that contains bills that are set up for immediate checks. If you enter

multiple transactions and any of the transactions have the Immediate and Print Check options

selected, the Print Checks button remains available in the AP Enter Bills window. After you enter

all of the bills, you can select the Print Checks button and print all of the immediate checks in the

batch if you wish.

For more information on printing checks or entering bills in Accounts Payable, refer to the

Accounting , FUND Suite , or Point of Sale Back Office user’s guide.

Recalculate Your Payroll Taxes Reminder

When entering payroll adjustments for employees, it is important to make sure the taxes are

calculated so their W-2s and earnings reports are correct. To help ensure this occurs in Cougar

Mountain and to help streamline your payroll processes, a new recalculate payroll taxes reminder is

available. This reminder provides a means by which to alert you that a change is made for an

employee’s wages and to verify whether you want to calculate, or recalculate, the taxes at the time

of change.

Cougar Mountain Software

Version 11 Feature Descriptions

To set up this reminder, select the Recalculate Tax Reminder check box on the General Information

tab of the PR Module Preferences window.

This reminder only shows if the Calculate Taxes field in the PR Enter Adjustments window is set to

None . This way, if this field is accidentally changed during adjustment entry, or incorrectly set prior to

adjustment, you will be reminded of the change, and the employee’s W-2 and earnings reports will be

updated. When you are in the PR Enter Adjustments window and you make a change on the General

Information , Federal and Local Taxes , State Tax Information , or Notes tabs and click Save , the

reminder message appears.

If you select Yes , the message closes and focus returns to the Calculate Taxes field so you can change

the setting. If you select No , the message closes, the transaction is saved, and focus returns to the

Employee Number field to select another employee with which to work.

For more information on working with employee records or running report in Payroll, refer to the

Payroll or FUND Suite user’s guide.

Set a Default Search in Lookup Windows

This feature can increase the ease and speed of looking up information in several Lookup windows

within Cougar Mountain software. You can set a different default for each Lookup window. Keep in

mind that this sets a default for the entire system. When you access some Lookup windows, you might

New Features

Version 11 Feature Descriptions

notice the new Save as Default button. This image reflects the new button in the Available

Inventory Lookup window.

To set the default, click the Sort By button until the search option you wish to set as the default

lookup appears and then select the Save as Default button. The next time you access this Lookup

window, your sort choice will be in effect. For more information on the Lookup window setting

defaults in Cougar Mountain software, refer to the user’s guide(s) or online Help installed with

your software.

Set Date Controls on Reports

This new feature is added to several of the report windows in Cougar Mountain software and can

increase the speed of reporting. You can now select a specific date range with one click. For

example, in this image of the PS Sales by Items report window, when you select the Date Range

drop-down list, you can select one of the predefined ranges for this report.

There are several predefined date ranges available. This table provides an overview of each

different data range. Since you can only run Payroll reports for five quarters, some of the date range

options are not available in Payroll. Also, if you select an option that causes the start date for the

report to begin prior to the first period in your Fiscal Calendar, the report will begin with the first

period instead. For instance, if the current CMS date is 01/17/06, the first period in your Fiscal

Calendar begins on 01/01/06, and you select the date range option of Last Fiscal Year , your report

Cougar Mountain Software

Version 11 Feature Descriptions

will begin with 01/01/06 because there is no preceding year on which to report; history reports or

reports that pull information from outside the Fiscal Calendar are not affected by this.

Date Range Option

Start Date for Report

End Date for Report

All

The start date of the Fiscal

The current CMS date.

Calendar.

Today

The current CMS date.

This Week

The date of the Sunday

The date of the Saturday

immediately preceding or

immediately following or

equal to the current CMS

date.

This Week to date

The date of the Sunday

The current CMS date.

immediately preceding or

equal to the current CMS

date.

This Month

The first day of the month

The last day of the month

containing the current CMS

date.

This Month to date

The first day of the month

The current CMS date.

containing the current CMS

date.

This Fiscal Quarter

The first date of the fiscal

The last date of the fiscal

quarter containing the current

CMS date.

This Fiscal Quarter to

The first date of the fiscal

The current CMS date.

date

quarter containing the current

CMS date.

This Fiscal Year

The first date of the fiscal

The last date of the fiscal

year containing the current

CMS date.

This Fiscal Year to

The first date of the fiscal

The current CMS date.

date

year containing the current

CMS date.

Yesterday

The date immediately

preceding the current CMS

date.

Last Week

The date of the Sunday

The date of the Saturday

immediately preceding the

week containing the current

CMS date.

New Features

Version 11 Feature Descriptions

Date Range Option

Start Date for Report

End Date for Report

Last Week to date

The date of the Sunday

The current CMS date.

immediately preceding the

week containing the current

CMS date.

Last Month

The first day of the month

The last day of the month

immediately preceding the

month containing the current

CMS date.

Last Month to date

The first day of the month

The current CMS date.

immediately preceding the

month containing the current

CMS date.

Last Fiscal Quarter

The first day of the fiscal

The last day of the fiscal

quarter immediately

preceding the fiscal quarter

containing the current CMS

date.

Last Fiscal Quarter to

The first day of the fiscal

The current CMS date.

date

quarter immediately

preceding the fiscal quarter

containing the current CMS

date.

Last Fiscal Year

The first day of the fiscal year

The last day of the fiscal year

immediately preceding the

fiscal year containing the

current CMS date.

Last Fiscal Year to

The first day of the fiscal year

The current CMS date.

date

immediately preceding the

fiscal year containing the

current CMS date.

Next Week

The date of the Sunday

The date of the Saturday

immediately following the

week containing the current

CMS date.

Next 4 Weeks

The date of the Sunday

The date of the Saturday of

immediately following the

the fourth week containing

week containing the current

the current CMS date.

CMS date.

Next Month

The first day of the month

The last day of the month

immediately following the

month containing the current

CMS date.

Cougar Mountain Software

Version 11 Feature Descriptions

Date Range Option

Start Date for Report

End Date for Report

Next Fiscal Quarter

The first day of the fiscal

The last day of the fiscal

quarter immediately following

the fiscal quarter containing

the current CMS date.

Next Fiscal Year

The first day of the fiscal year

The last day of the fiscal year

immediately following the

fiscal year containing the

current CMS date.

Custom

The specific start date

This specific end date

entered in the Date Start field.

entered in the Date End field.

So, if the current CMS date is September 8th, and you select Last Fiscal Year to date in the Date

Range field, your report will look something like this image.

Reports Including Date Range Option

This section provides a listing of the reports that contain the new Date Range feature by module.

„ Accounts Payable: Aging Report, Total Debt Report, Cash Requirements Report, Prepaid

Report, Future Liability Report, GL Expense Distribution Report, History Report, and

Monthly Balance History Report

„ Accounts Receivable: History Report

„ Bank Reconciliation: Bank Register Report and Missing Check Report

„ General Ledger: Audit Trail Report (date option only) and Reprint Posting Report

„ Inventory: History Report, Movement Report, and Promotional Sales Report

„ Job Cost: Job Schedule Report, Cost Analysis Report, Work in Process Report, Job Cost

Report, Cash Receipts Report, Credit Card Receipts Report, Sales Tax Report, Sales by

Salesperson Report, Billing History Report, and Profit Margin Report

New Features

Version 11 Feature Descriptions

„ Order Entry: Cash Receipts Report, Credit Card Receipts Report, Sales Labels Report,

Invoice Tracking Report, Sales History Report, Sales by Salesperson Report, Sales by

Department Report, Price Variance Report, Sales Tax Report, Promotional Sales Report,

Profit Margin Report, Back Order Tracking Report, Back Order Fulfillment Report, and

Deposit Journal Report

„ Point of Sale: Cash Receipts Report, Credit Card Receipts Report, Sales History Report,

Sales by Item Report, Sales by Salesperson Report, Sales by Register Report, Price

Variance Report, Coupon/Buy Down Report, Sales Tax Report, Promotional Sales Report,

and Profit Margin Report

„ Purchase Order: Open Purchase Order Report, Expected/Late Item Report, and History

Report

„ Payroll: Department Report, Project Report, Employee History Report, Employee

Condensed History Report, and EFTPS History Report

The date control option is also included in the AP Prepare Payments Automatically window for

your convenience. For more information on running reports in a module, refer to the user’s guide(s)

or online Help installed with your software.

Set Up a Query for Key Reports

To enhance reporting capabilities, Cougar Mountain added querying functionality to several of the

reports. This query ability allows you to report information based on specified criteria. To

accommodate this new feature, the affected report windows now have two tabs to set report criteria:

Report Options and Search For . This image shows the new tabs in the BR Bank Register Report

window.

The functionality of the fields located on the Report Options tab is the same as with the last

release. Refer to the user’s guide(s) or online Help for information on these fields. The fields on the

Search For tab provide a means by which to further define your report query. The Search For

fields have the options of Amount , Batch Number , or User ID . The query fields (comparison

operator) have the options of Equal To , Not Equal To , Greater Than , Greater Than or Equal To ,

Cougar Mountain Software

Version 11 Feature Descriptions

Less Than , and Less Than or Equal To . The information in this table explains the differences of each

query option (operand).

Operand

Field

Equal To

The information returned is equal to the entered value or

the selected field’s value.

Not Equal To

The information returned is not equal to the entered value

or the selected field’s value.

Greater Than

The information returned is greater than the entered value

or the selected field’s value.

Greater Than or Equal To The information returned is greater than or equal to the

entered value or the selected field’s value.

Less Than

The information returned is less than the entered value or

the selected field’s value.

Less Than or Equal To

The information returned is less than or equal to the

entered value or the selected field’s value.

Once you select the search for option(s) and desired comparison operator(s), you will enter the amount

to use for comparison. This image shows the BR Register Report. If the report does not provide the

desired information, you can select the Reset button to reset the query options to the default settings

and try different query parameters.

The reports for which you can include custom query options are: GL Audit Trail Report, BR Register

Report, AP Aging Report, AP Total Debt Report, AR Aging Report, JC Billing History Report, JC

Profit Margin Report, OE Sales History Report, OE Profit Margin Report, OE Sales Label Report

New Features

Version 11 Feature Descriptions

( Search For tab is disabled), PS Sales History Report, and the PS Profit Margin Report. For more

information on running reports in Cougar Mountain, refer to the user’s guide(s) or online Help

installed with the software.

Update Your Inventory Cost on Purchase Orders Reminder

With the new Purchase Order Cost Reminder feature, when the cost changes for a stock item

included in a purchase order, a reminder will appear to notify you. This is beneficial, for instance,

for any receiving clerk so he/she can review the pricing of purchased items to make sure the correct

amount is accounted for. It is also beneficial to make sure that the costs are continually up to date so

that your business does not accidentally sell an item for less than it was purchased.

The new Show Alert When Cost Increases check box on the General tab in the PO Module

Preferences window is checked by default. If you wish to disable this functionality, you need to

uncheck this check box.

Also, as an added part of this new feature, you can run a report showing all cost changes. The new

PO Stock Item Cost Change Report is accessed when you select the OK button in the reminder

message.

Cougar Mountain Software

Version 11 Feature Descriptions

This report quickly shows the cost, sale price, and profit margin for each stock item before and after

receiving.

When you are finished printing the report and close the report window, the PO Receive POs window is

ready for you to continue working. For more information on working with purchase orders or stock

items, refer to the user’s guide(s) installed with your software package.

Use the Tiered Sorting Option in Bank Reconciliation

You can now sort the Reconcile Bank Statement - <Account> window and BR Bank Register

window grids with up to nine levels of sorting. This new functionality allows you to sort transaction

items according to the format of your bank statement for a faster reconciliation process. There are a few

additions to these windows to accommodate this new feature.

In the Reconcile Bank Statement window, the Activity Type options are now all visible upon opening

this window instead of displaying in a list box. Also, the Item # boxes are now adjacent to each other

for speed in entry.

New Features

Version 11 Feature Descriptions

In the Bank Register window, the Activity Types options are now available. The best part of this

new feature is the new options available in the Sort Items By field in both the Reconcile Bank

Statement and Bank Register windows.

The new sort options are:

„ Additions/Deposits , Checks , and Other Withdrawals : This option groups additions and

deposits together listed first, and then lists the checks and withdrawals. All entries are

ordered by date.

„ Deposits , Checks , Other Additions , and Other Withdrawals : This option first lists deposits

ordered by date, then checks ordered by check number, followed by additions and then

withdrawals both ordered by date.

„ Checks , Additions , Deposits , and Other Withdrawals : This options first lists checks, then

additions, deposits, and finally, withdrawals. All entries are ordered by date.

„ Type > Item # : This option sorts first by type and then by item number.

„ Type > Date > Amount : This options sorts first by type, then by date, then by amount of

the transaction.

„ Date > Type > Item # : This option sorts first by date, then by type, and then by the item

number.

„ Date - Most Recent First: This option sorts by date, with the most recent date appearing

first in the grid.

Cougar Mountain Software

Version 11 Feature Descriptions

When you are in the Reconcile Bank Statement window and you select the desired sorting options, if

you select the Refresh Grid button, the grid will auto-change according to the settings chosen.

In the BR Bank Register window, you can select all of the sorting criteria and then print a register

report according to the criteria chosen.

For more information on reconciling your bank statements or working with the bank register, refer to

the Bank Reconciliation or FUND user’s guide.

View Condensed History of Payroll Transactions

You can now view up to five quarters of payroll transactions in one easy-to-read report! The new

Employee Condensed Payroll Report is printed in landscape format and allows you to view one or all

New Features

Version 11 Feature Descriptions

of your employees’ payroll history. You access this report by selecting Employee Condensed

History from the Reports menu in Payroll.

You can sort this report by the employees’ number, department, name, or even social security

number. Also, if you wish, you can filter the report to show only employees with an active or

inactive status. Plus, you can have one employee’s history print on each page by selecting the Page

Break on Employee check box. Once you select the desired report criteria, a landscape view of the

payroll history appears. Due to its design, you can only print this report on a laser printer.

This report is only accessible to employees for which you wish the ability to view this type of

information. For security of your employees’ payroll information, an additional option is included

Cougar Mountain Software

Quick Reference of Version 10 Features

Refer to the following table to see what features for version 10 apply to the CMS Professional package(s) or add-ons you

purchased. For more information on each feature, see the user’s guide(s) or online help installed with your software.

New Features in CMS Professional

Version 10

Accept credit card payments from customers

Accept customer payments using the ACH file

transfer method

Analyze inventory with Advanced Understock

Report

Apply unapplied payments/credits during

payment process

Calculate sales tax based on the customer’s

shipping address

Generate customer orders quickly with the

Customer Order Guide

Make payments to vendors using the ACH file

transfer method

Pay multiple vendors invoices at once using

Quick Pay

Pay vendors by credit card

Process checks electronically using POS check

conversion

Reconcile vendor payments with 1099 Vendor

Summary Report

Retrieve the past two years of payroll information

Reverse payments made to vendors by credit

card

Cougar Mountain Software

INDEX

options menu, create 28

reports, create 7 , 29

account impact summary 9

accounts payable

customer

expense distribution report 20

payments, quick pay 32

printing statements 12

posting information on check register 9

print checks 44

unapplied payments 16

accounts receivable

date blocks 6

drill down to profit margin 36

date controls 47

drill down to reports 33

date range on budget reports 18

printing statements 12

default search 46

quick pay 32

drill down

accounts, including on reports 14

aged analysis 33

add date block 6

profit margin in accounts receivable 36

aged analysis report 33

to orders 34

analysis, financial 10

to vendor performance 36

back orders

employee

drill down in inventory 34

condensed history report 56

backup, include reindexing 12

entering bills, print

balance sheet, common size 18

checks 44

bank reconciliation

expense distribution report in accounts payable 20

tiered sorting 54

export spreadsheet by account 8

batch number

including in reports 39

on check register 9

features in past releases 25

block, dates 6

financial

budget reports

analysis 10

date range 18

reports 22

status 6

calculate payroll taxes 45

check register, including posting information 9

general ledger

common size reports 18

account impact summary 9

condensed employee history report 56

audit trail report 20

cost update reminder 53

balance sheet 20

custom

budget report date range 18

Cougar Mountain Software

common size balance sheet 18

common size income statement 18

payment

export by account 8

processing, customers 32

financial analysis report 10

unapplied in accounts payable 16

financial status 6

payroll

including account numbers on reports 14

condensed report 56

income statement 20

tax reminder 45

report groups 15

taxes, calculate 45

groups, general ledger 15

posting

batch number 9

batch numbers 39

date block 6

history, condensed employee 56

reference 9

user id 39

impact summary, edit reports 9

customer statements 12

including subtotals in sales tax report 38

print checks 44

income statement, common size 18

profit margin, drill down to 36

industry averages 6

purchase orders

inventory

cost update reminder 53

drill down to reports 34 , 36

drill down in inventory 34

monthly movement 40

update reminder 53

query 14 , 51

quick list 2 , 59

key reports, query 51

quick pay, accounts receivable 32

quick reference 26

lookups, default search 46

recalculate payroll taxes 45

reindexing modules 12

modules, reindexing 12

reminder

monthly movement report 40

inventory update 53

payroll tax update 45

reports

new features

aged analysis, drill down 33

version 10 59

audit trail 20

version 11 28

balance sheet 18 , 20

version 12 2 , 6

batch number, including 39

budget reports, viewing data ranges 18

check register, include posting information 9

condensed employee history 56

options menu, create 28

create custom 7 , 29

customer statements 12

Index

date control 47

edit, impact summary 9

expense distribution 20

financial analysis 10

general ledger accounts, including 14

general ledger groups 15

income statement 18 , 20

monthly movement 40

orders, drill down to 34

profit margin, drill down to 36

sales tax code, subtotals 38

setting up queries 14 , 51

snapshot 22

spreadsheet export 8

user id, including 39

vendor performance, drill down to 36

sales tax code report, including subtotals 38

default, lookups 46

setting target goals 6

snapshot reports 22

sorting, tiered in bank reconciliation 54

status, financial 6

subtotals in sales tax report 38

tax update reminder 45

tiered sorting 54

unapplied transaction type 16

update inventory reminder 53

user id, including in reports 39

vendor performance, drill down in inventory 36

version 10 59

version 11 28

version 12 2 , 6

Cougar Mountain Software