CounterPoint SQL
Enterprise Edition

System Features
 
 
  CounterPoint SQL Enterprise by Synchronics
System

System
CounterPoint can help any business run more efficiently, more profitably, and more securely.
Advanced users will benefit from the highly customizable user interface. Nearly every aspect of CounterPoint—its appearance, content, and behavior—can be customized. For example, you can:

  • Customize reports, field names, field sizes, fonts, color schemes, menus, toolbars, warning messages, Filters, LookUps, Zooms, and more
  • Hide unwanted/unused fields
  • Add new, user-defined fields to the system
  • Add new, user-defined screens or attach custom programs to the CounterPoint main menu
  • Print a report that identifies any customized columns, tables, triggers, stored procedures, etc.

Users and Workgroups
Each user is uniquely identified and tracked in CounterPoint, and each user is assigned to a workgroup. A workgroup is a group of users who share similar characteristics. Workgroups control the locations, stores, and features that a user can access, as well as the automatically-assigned Next numbers (e.g., next PO number, next item number, etc.).
Workgroups are also beneficial for grouping users in wide area networks (WANs) and Multi-Site configurations.

Security
Detailed function-level security is provided for each user. Function-level security determines whether a user is authorized to view costs, void tickets, enter returns, override credit limits, enter transactions for previous years, and much more.

CounterPoint can be password protected. Passwords can be required and can have a minimum length and an expiration date. Users can be forced to change their password after logging in. You can also see who is logged into CounterPoint at any given time, and, in many cases, which part of the software they're using.

For additional security, you can assign users to limited menus with fewer selections.

User security for Microsoft SQL can be handled using individual user identification and password or through Windows integrated security.

Menus and Toolbars

Multiple menu styles (buttons, single panel, dual panel, or dropdown list) are available to provide access to all system functions. Each authorized user may determine menu style preference and customize menu selections.
Multiple toolbar schemes are also available. An authorized user may select a toolbar scheme or design a custom toolbar. Toolbars can be the same or different for each screen.

An easy drag-and-drop design interface allows authorized users to

change the appearance and behavior of toolbars and menus, including:
 
  • Toolbar visibility
  • Toolbar position
  • Button/Menu actions
  • Button/Menu images
  • Button/Menu text
  • Shortcut keys
  • External programs

Touchscreen Interface

CounterPoint includes a simplified touchscreen user interface based on large buttons suitable for touchscreen, mouse, keyboard, and scanner input. A touchscreen monitor is not required.

A pop-up keyboard is available in Touchscreen Ticket Entry as well as from all standard maintenance forms, report parameter forms, and filter forms. With pop-up keyboards, users can enter information using touchscreen workstations that aren't equipped with a keyboard.

   
You can also display touchscreen-friendly LookUp forms throughout CounterPoint, allowing touchscreen users to easily look up items, customers, vendors, and other types of records.

Zooms

Zooms display complete details throughout CounterPoint. Zooms are available for items, customers, vendors, stores, users, drawers, gift certificates, store credits, location, and PO's from virtually anywhere in CounterPoint.

For example, while entering a ticket the Customer Zoom displays the customer's contact information, current balance, recent sales history, ticket history, current orders, images, and notes. The Item Zoom displays information about the item (price, category, extended description, etc.), the inventory (cost, quantity available, last sale date,

etc.), recent sales history, vendors, monthly history, substitute items, images, notes, and more.

Advanced users can use the Zoom Dictionary to create new Zooms and to control the appearance, content, and behavior of existing Zooms.

Inventory
Sales and returns can be entered on the same ticket. Items can be identified by typing the item number, scanning a barcode, or by searching for keywords that match any portion of the item number, description, vendor number, vendor item number, category, subcategory, or any other field designated as a keyword search field.

Item Zooms display substitute items, open purchase orders, sales history, recent sales, available quantities, and other item-specific information.

Define unlimited pages of notes for each item—item notes allow clerks to more fully inform customers about your products. Automatically display item notes to encourage the clerk to power-sell related items: Would you like some tennis balls with that racquet?

Notes can be automatically displayed based on the individual item, or on the item category or subcategory.

LookUps and Quick Reports
LookUps let you view a list of valid records (such as a list of items, customers, codes, etc.) that you maintain. LookUps are available from any field in which information can be looked up from a list of valid choices.

 

For example, when an item LookUp is requested, the LookUp window displays the complete list of items. The items can be ordered by item number, barcode, category, vendor, description, etc.

With user-friendly keyword searching, CounterPoint matches a keyword to any field designated as a keyword search field. Keyword searching finds, for example, an item based on a partial match of any keyword field (barcode, description, vendor, etc.).

 

All LookUps are customizable. From within a LookUp, you can zoom in on detailed information, preview reports (Quick Reports), or set Filters to display only the items you want. Authorized users can even add on-the-fly or make changes to existing records.

You can create a Quick Report from any LookUp window to print or save the information. Quick Reports can easily be added to a customized menu and function like standard reports. You can easily export the information in your LookUp to other applications.

Filters

You can use Filters to customize the information displayed in LookUps, standard maintenance screens, and reports.
Filters allow you to set conditions that limit the records that display. For example, you could choose to display only the items in category GOLF with a primary vendor of ADAMS.

Filters are automatically saved with LookUps.

You can even define your own filtering parameters by selecting the fields that interest you.

Indexes
Indexes increase the speed of LookUps and reports.

Adding an index allows you to quickly sort and look up information in an order other than the primary key.

For example, if you have tens of thousands of items on file, and you frequently look up items by sub-category, you may want to define a sub-category index to speed up the Item LookUp.

Batches
CounterPoint updates data in batches so that multiple users can operate independently without interfering with one another.

For example, two people at the same location can concurrently enter and post inventory adjustments or cash receipts. Posting one user's batch of data will not affect the other user's batch.

Renumbering
Utilities are provided to renumber items, customers, and vendors.

Automatic Workstation Updates
To simplify the installation of periodic software updates, newer software need only be installed on the server. Each CounterPoint workstation automatically detects the newer software version and updates itself as required.
Messages/Reminders
You can send an electronic message to a user or schedule a repeating reminder.

Importing and Exporting Data
CounterPoint includes Database Import and Database Export utilities to create and update CounterPoint data (item numbers, descriptions, prices, etc.). CounterPoint is also capable of importing and processing transactions (receivings and adjustments) from text files. Many third-party packages can create text files suitable for importing into CounterPoint.

Data can be exported using CounterPoint's Database Export utility or other applications such as Excel, Crystal Reports, or Microsoft SQL.

Crystal Reports
CounterPoint includes the Crystal Reports Viewer, so you can view and print reports outside of CounterPoint, and export reports to a variety of formats.

New forms and reports may be created, and standard forms and reports may be customized using Crystal Reports Designer (purchased separately). Custom reports may be used in place of any standard report, or they may be added to custom menus and used in addition to the standard reports.

Data Dictionary
The Data Dictionary allows you to easily customize the appearance and behavior of CounterPoint. You can change your information in one place, and your change is reflected on every screen and report throughout CounterPoint.

For example, you can display Client instead of Customer Number or Department instead of Category.

You can also define rules to control screen behaviors, such as specifying minimum or maximum values for numeric fields.

Triggers
For advanced requirements, additional processing can be performed using SQL triggers. A trigger is a set of SQL commands that execute automatically when information is added, updated, or deleted. Triggers are a powerful way to update your business records when certain conditions are met.

For example, you could define a Warranty Repairs trigger for billing the manufacturer (not the customer) for repair work. When a customer brings in an item for repair, the clerk enters a normal point-of-sale ticket, and the warranty work is paid for with a special A/R pay code. The trigger automatically charges the manufacturer's A/R account. At the end of the month, a statement of how much money the manufacturer owes you for the warranty work can be printed and mailed to the manufacturer.

Custom Fields

Custom fields allow you to easily record, track, and view additional information on existing CounterPoint forms. Custom fields are automatically available throughout CounterPoint in Zooms, LookUps, and Filters.

For example, if you wanted to track the name of the person who referred a particular customer and the date on which the referral was made, you could define custom fields for Referred by and Referral date and add them automatically to the standard Customers screen.

Custom Screens

Custom screens allow you to create new, user-defined screens within CounterPoint. Custom screens fully support LookUps and Filters.

For example, if you wanted to track customer-specific item numbers, you could create a custom screen that includes fields for the customer number, item number, the customer's item number, and a description.

Custom screens can be attached seamlessly to the CounterPoint main menu, to a touchscreen ticket entry button, or to any toolbar. You can

even add a button to the toolbar on the Customer maintenance screen that, when clicked, displays the customer's unique item numbers.

Custom Programs

You can create a user-friendly front end for your own custom programs. Custom programs and applications can be run from the Counter-Point main menu for a consistent interface. Custom programs can be created using any number of development tools.
For example, you may create a Visual Basic application named Batch Price Changes that changes the Price-1 values for a group of items up or down by a specific percentage. This custom program would be run from the CounterPoint main menu.

 
When you select Batch Price Changes from the CounterPoint main menu, CounterPoint can ask the user to enter the parameters to control which prices are affected. Using a standard looking CounterPoint screen, the user can specify the category, subcategory, or vendor to change, as well as the percentage by which Price-1 should change. CounterPoint will then pass these values to your Visual Basic application to change the Price-1 values for the specified group of items.

Printable Features List

    Software Demo >>

    Request More Info >>

  CounterPoint SQL Information
  Point of Sale
  Inventory Control
  Purchasing
  Customer Tracking
  Labels
  Apparel
  Sales History
  Accounting
  Credit Cards
  Ecommerce
  System
  Wireless
  New Features!
  View Demo
  Contact PHI Systems

PHI Systems, Inc.
24705 Riverchase Dr Suite 6104
Valencia, CA   91355

Phone: (866) 375-4767
Fax: (866) 527-5349
Email:
info@phipos.com

 
 
© Copyright 2006 PHI Systems. All rights reserved.