Customizing CPSQL

Customizing CPSQL

I recently had a user ask me to notify NCR that a certain field in the customer table should be added as a search field because of how technology is advancing.

When this Counterpoint user added customers to their system, they were using the customer’s landline phone number as the customer account number.  Fortunately, in Counterpoint besides having a landline phone number field there is a mobile phone number field.

With more people choosing to not have a landline anymore, this user wanted to use the mobile phone number as a lookup field and wanted to give their mobile technicians an easier way to look up their customers when away from the office.

This can be accomplished easily in NCR Counterpoint by adding the mobile phone number field as a “keyword” to be used during lookups. As a matter of fact, just about any field can be set as a keyword field to be used for lookups.  Keywords can also be configured for item lookups, ticket history lookups, and most other table/field combination you need.

If you are not familiar with using some of the more advanced features of NCR Counterpoint, give the CCS Retail Systems Support department a call at 800.672.4806 or email us to help you make lookups more useful for you and your crew.


Windows Domain Networking

Windows Domain Networking

I have recently run into a few customers network domain issues.  When their Internet goes down so does the customers’ ability to run some of their software.

The reason for this is they have set up a Windows Domain controller node. You would think that this should not make that much of a difference but how you set this up can make all the difference.

There are pros and cons to Windows Domain.  If you are thinking about setting up your network in this way, you should weigh both the positives and negatives before you implement.

Here an example scenario.

There are 3 stores in a Domain.  The Domain Controller is located offsite at corporate headquarters. All stores have a connection to headquarters via the Internet and VPN.

As long as there is an Internet connection networking is functional.  When the Internet goes down, at either the stores or at corporate, the networking problems start.

A Windows Domain requires managing user accounts, Windows Updates, security and permissions to be centralized.  Being centralized, you can add, update, disable many different settings from one Server instead of going to each workstation to make these changes.  In medium and large companies can be a big time saver. That’s one of the pros of having a Windows Domain.  The big con in this scenario is, if the Internet goes down, the workstations now cannot authenticate to log in or resolve hostnames resulting in cascading issues. One of the biggest issues is that the workstations no longer have a way to “find” your application server on the network, so the software will not run.

There are a few different ways to approach resolving the issues mentioned above.   When your connection to your Domain Controller (or Internet) is lost, you will still be able to do business and get your customers through the checkout line.

If you are thinking of setting up a Windows Domain, or are already set up in a Domain, contact the CCS Support Department to help with setting up a fallback resolution when your Domain Controller (or Internet) is inaccessible.


XR7 And XR5 Terminals

 XR7 And XR5 Terminals

Ready for a sleek new look to your retail cash wrap? Look no further, The NCR XR7 and XR5 Terminals are here!

Here are some of the features of the XR7

The NCR RealPOS XR7’s sleek, modern appearance—with its slim profile, zero-bezel design, and elegant styling—sets it apart from other point-of-sale solutions. Powered by 4th-generation Intel® Core™ processor technology, the NCR RealPOS XR7 delivers amazing performance and future-proofs your investment. On-board “odometers” capture vital health and usage statistics to help us keep you up and running.

The NCR RealPOS XR7with its rugged die-cast aluminum chassis, long-life LED display, projected-capacitive or resistive touchscreen, and enterprise class solid state drive (SSD) or hard disk drive (HDD), the RealPOS XR7 is built to last. Our comprehensive environmental and compatibility testing, along with stringent manufacturing standards, ensure years of dependable operation.

The NCR RealPOS XR7 represents the latest evolution of NCR’s design and usability thinking around point-of-sale terminals. The product form, materials and user interface builds on over a century of knowledge and global experience. The result is a culmination of design, functionality, and quality that goes beyond any point-of-sale solution in the market.

The XR7 comes Pre-loaded with Windows 7 Pro or Windows 7 Embedded (64-bit)

Here are the XR5 Features

The NCR RealPOS™ XR5 is powered by the latest Quad core Intel® Celeron® processor-based system-on-chip (SoC) technology to give you high energy efficiency, lower operating temperature, and uncompromised performance. This means lower power cost and higher reliability. The associate display provides support to boost associate productivity and lets them interact in a way that is familiar to them.

Like our NCR RealPOS XR7, the XR5 was With its rugged die-cast aluminum chassis, long life LED display, resistive touchscreen, fan-less design, solid state drive, and long life components, the RealPOS XR5 will provide years of reliable operation.

The XR5 comes pre-loaded with Windows 10 (64-bit)

Both terminals were designed to offer the sophisticated elegance of the latest consumer technology, but with the robustness and reliability of industrial grade, purpose built POS technology – giving you the best of both worlds.

Both terminals also offer built-in encrypted card swipes (P2Pe) to further enhance the security of your environment. Along with NCR Secure Pay payment gateway, your customers data is safe and secure.

For more specs and information, please contact the CCS Retail Systems sales department at sales




Are You Ready For EMV Security?


Are You Ready For EMV Security?

Before you start taking chip cards (EMV) with your NCR Counterpoint System there are a few thing that need to be done.

  • First, you must be on at least NCR Counterpoint version, although this version of the software will work with EMV, it is recommended that you upgrade to the latest version of 8.5.3 so you may benefit from any fixes and new features.
  • With 8.5.3 in mind, it is also necessary that your operating system is at least Windows 7, as of 8.5.2, Windows 10 is supported. Windows 7 and above support the latest encryption protocols to help keep your data safe. Windows XP does not have these updated protocols and will not be updated by Microsoft to include them.
  • If you are already taking credit cards but have not updated to NCR Secure Pay, that will need to be done as well. With NCR Secure Pay, it will protect you and your customers data as it is no longer kept on your system and is tokenized to further protect the data. You may also need to update your merchant account to support NCR Secure pay. CCS can work with you and your merchant services rep to get your account ready for NCR Secure Pay and EMV processing.
  • You must be using an Ingenico ISC250 Pin Pad that has the correct version of firmware to work with your software AND NCR Secure Pay EMV processing. Firmware will vary depending on NCR Counterpoint version. CCS can help find your current firmware version and update (if necessary) to the correct version.
  • Pay codes (Touchscreen and Regular ticket entry) – the following pay codes must exist and be assigned to the store setup (but do not necessarily need a button) VISA, MC (or MasterCard), DISC (or Discover), AMEX (or American Express). Also there must be an EMV pay code button to activate the chip reader when processing a chip card. Note – If a card has a chip, it must be inserted into the reader, if a card does not have a chip it may be swiped just like before. In the case of a chip that will not read, a Manual EMV button can be setup to allow the customer to manually type in their card information securely through the Pin Pad.
  • Once the above has been complete, CCS can test the setup in a test environment to be sure that all settings both on the bank and the software side are correct. Once confirmed working, CCS can setup a time to implement and go through a test transaction so you can see the flow of an EMV chip card transaction.

If you need help with any of the above, please contact the CCS Retail Systems Support Department @ 800.672.4806 or send us an email to get you started on your way to EMV processing


Be Proactive On System Problems


Be Proactive On System Problems

Are you experiencing an issue with your software? If so, don’t let it fester and create frustration for you or your team.

CCS Retail Systems is here to help, if you do not report your problems, they cannot get fixed.

I recently was speaking to a customer about a slow system, as we were going over some of the basic troubleshooting questions, the customer brought up another issue and was explaining how they were resolving it over the last few days.

If CCS was informed of the issue sooner, it would have been resolved in a matter of minutes. Now I understand, everyone is busy, sometimes calling right away is impossible or impractical, but reporting an issue in a timely matter will make those impossible times far less likely because the issue will be resolved, which will free your time up for more important matters.

When reporting issues, the more detail you can give, the better. Some of the basic information we can use is

  • Date and time the issue occurred – This information helps with looking at all the information log files keep and help narrow down issue to a few lines instead of hundreds (or thousands)
  • Were there any error or other messages presented to you – Try and get the exact and entire message, using your phones camera or taking a screenshot can be used. This also helps with log files in the same way as the date and time as well as where to look in the software.
  • What Screen were you in – Examples would be Ticket Screen or Purchase Request
  • What user and workstation received the message. – An example would be John was using the backoffice PC
  • Any information that may be helpful – For example there may have been network issue, we had a power outage, Internet was down.
  • Do you notice any pattern – An example would be, every time I click on the “Go” button an error comes up.

So, If you cannot call right away, the best thing to do is to jot down the information so when you can call you are ready for the any questions we may ask.

A good example of the above may look like this.

On 9/18/17 at 3:30PM John was receiving a “Not On File” error on the backoffice workstation every time he clicked on the Save button in the Inventory/Items screen. We were having power issues earlier in the day and the Internet went down twice.

With the above information, CCS has a good starting point at where to look to resolve the issue quickly.

You can call CCS directly at 800.672.4806 or email us.


Migrating To NCR CPSQL

So you have decided to update your V7 Counterpoint to CPSQL. CCS Retail Systems is here to help!

One of the first steps to a successful update, is to make sure CCS has all the data from your current version.

We will usually ask for a complete backup of your entire V7 Counterpoint installation. This can be from a tape backup, a USB flash drive, or even a copy of the installation directory to a Dropbox or Google Drive account.

Once we have the backup, we can start with a test upgrade that will give us a more complete picture of how much time it will take when the final cutoff date is agreed upon.

The test upgrade is an important part of the upgrade process. Not only does it give us a complete picture of what it will take to get you upgraded efficiently, it will also allow you to review the data and test your equipment and infrastructure.

For example, let’s say you have older receipt printer, this is the time to test them out to be sure your receipts look professional, your cash drawer opens, and the performance of this equipment is optimal for your business.

This is also the time to put the new system through its paces to iron out the little tweaks and changes that may need to be made so when the final upgrade is complete, we have all the settings that were made in the test to transfer over to your live database so you are ready to go on your first Live day of use. When I say “put the new system through its paces”, I mean do everything you would do in a normal day. Put a few tickets in the system, if you use orders, put a few of those in as well, test your printers, all of them, print/review the different reports offered, create a PO and receive it, add a new item, new user, new category. I think you get picture. Test, test and test some more until you are satisfied that everything is working as expected.

In the many upgrades that CCS has done, I find that the more people test the different function of CPSQL, the more the learning curve lessens, less issues with hardware and everything is in place for happy customers and a successful first day using the new system.

Are you planning on updating your V7 Counterpoint to CPSQL?

CCS has done many migrations to CPSQL, it is not an easy tasks and requires a significant amount of time to properly upgrade.

If CCS Retail Systems is helping you with your upgrade, we have plans in place to help make the process easier for you.

Part of our plan is to do a test upgrade and let you (our customers) see the end result and check that the all data that has been upgraded is there and settings are set for the way you do business.

This test upgrade is the time when you should test every part of your business in the new software, to be sure work the way you expect.

This would also include testing your hardware and your environment to be sure all your devices, network, and report printers will work.


Contactless Payments.

Contactless Payments.
Contactless payment systems are credit cards and debit cards, key fobs, smartcards or other devices that use radio-frequency identification for making secure payments. The embedded chip and antenna enable consumers to wave their card or fob over a reader at the point of sale.
Some suppliers claim that transactions can be almost twice as fast as a conventional cash, credit, or debit card purchase. Because no signature or PIN verification is typically required, contactless purchases are limited to US$25 in the U.S., A$100 in Australia, NZD$80 in New Zealand, €25 in most euro area countries (€15 in Ireland) and £20 in the UK (to be increased to £30 from September 2015).Those unauthorized may still take advantage of contactless payment systems as no identification occurs before payment except for certain devices. However, owners may block transactions which may provide relatively short time frame, if any, for fraudulent activities to occur of any kind.
Research indicates that consumers are likely to spend more money due to the ease of small transactions.[2] MasterCard Canada says it has seen "about 25 percent" higher spending by users of its PayPass-brand RFID credit cards.
NCR Counterpoint will be supporting Contactless Payments with a Service Pack update to version 8.4.6 due out in mid May 2015 and in the 3rd quarter of 2015 for version 8.5  
If you would like more information about Contactless Payments, contact the CCS Retail Systems Support Department @ 800.672.4806 or email us.

How do EMV chip and PCI DSS work together?

Sourced from EMV Connection

How do EMV chip and PCI DSS work together?

EMV chip has strong security features that have been proven to reduce counterfeit card fraud at card-present retail environments. The PCI Data Security Standard (PCI DSS) provides other complementary levels of security necessary when the cardholder information reaches the merchant’s system. The PCI DSS contains 12 key technical and operational requirements. Rather than focusing on a specific category of fraud, the PCI DSS seeks to protect cardholder and sensitive authentication data anywhere this data is present within the payment eco-system, thus limiting the availability of this data to fraudsters. When used together, EMV chip and PCI DSS can reduce and enhance the security of the payments ecosystem.

If you have any system questions or concerns, contact the CCS Retail Systems Support Department at 800.672.4806 or email us.




What is the proven impact of EMV adoption on payment card fraud?

Sourced From EMV Connection 

What is the proven impact of EMV adoption on payment card fraud?

Countries implementing EMV chip payments have reported a decrease in card fraud. As an example of the impact of EMV, the UK Cards Association has reported a dramatic reduction in fraud since the introduction of EMV cards.
“Fraud on lost and stolen cards is now at its lowest level for two decades and counterfeit card fraud losses have also fallen and are at their lowest level since 1999. Losses at U.K. retailers have fallen by 67 percent since 2004; lost and stolen card fraud fell by 58 percent between 2004 and 2009; and mail non-receipt fraud has fallen by 91 percent since 2004.” Similarly, the national roll-out of EMV in Canada in 2008 had a dramatic impact on fraud. Losses from debit card skimming in Canada fell from CAD$142 million in 2009 to CAD$38.5 million in 2012, according to the Interac Association[i]. Interac debit card fraud losses as a result of skimming hit a record low in 2013, decreasing to $29.5 million.

The experiences of the U.K. and other countries that have adopted EMV have shown a reduction of domestic card-present fraud. But their experiences have also shown a migration to other types of fraud, namely card-not-present (CNP) fraud and cross-border counterfeit fraud (particularly ATM fraud). Fraud migration offsets some of the savings from the decrease in domestic card-present fraud. This reality reinforces the need for a layered approach to security, even with EMV deployment, to address fraud migration and other security vulnerabilities.

EMV can also address CNP fraud, as described in my blog here.

If you have any system questions or concerns, contact the CCS Retail Systems Support Department at 800.672.4806 or email us.


Where has EMV been adopted?

Where has EMV been adopted?
Eighty countries globally are in various stages of EMV chip migration, including Canada and countries in Europe, Latin America and Asia. According to EMVCo, as of December 2013: 
  • 2.37 billion chip payment cards are in use
  • 99.9% of terminals in Europe are chip-enabled
  • 84.7% of terminals in Canada, Latin America, and the Caribbean are chip-enabled
  • 86.3% of terminals in Africa and the Middle East are chip-enabled
  • 71.7% of terminals in Asia Pacific are chip-enabled
The United States is one of the last countries to migrate to EMV chip technology. American Express, Discover, MasterCard and Visa have all announced their plans for moving to a chip-based payments 
infrastructure in the U.S.
In August 2011, Visa announced plans to accelerate chip migration and adoption of mobile payments in the United States, through retailer incentives, processing infrastructure acceptance requirements and 
counterfeit card liability shift.
In January 2012, MasterCard announced their U.S. roadmap to enable the next generation of electronic payments, with EMV the foundational technology.
In March 2012, Discover announced implementation of a 2013 mandate for acquirers and direct-connect merchants in the U.S., Canada and Mexico, to support EMV.
In June 2012, American Express announced its U.S. EMV roadmap to advance contact, contactless and mobile payments and plans to begin issuing EMV-compliant cards in the U.S. in the latter half of 2012.
Within the U.S., the contactless credit and debit cards that are being issued already include some EMV security features.
A number of major U.S. issuers are already issuing or have announced plans to issue EMV chip cards.

If you have questions about PCI compliance, EMV Support in NCR Counterpoint, or other system concerns contact the CCS Retail Systems Support Department at 800.672.4806 or email us.