CounterPoint Updates
CounterPoint Version 8.3.9 Service Pack
A new Service Pack for CounterPoint SQL Version 8.3.9 (CPSQLSP.EXE) is now available from the Support area of the website at http://www.counterpointpos.com/support/software-cpsql.htm. This service pack updates CounterPoint SQL version 8.3.9 to version 8.3.9 Jun03.
* * * * * * * I M P O R T A N T * * * * * *
This service pack includes data model changes. After you install the Service Pack, CounterPoint will not function until a system administrator applies the ServicePackUpdateFor8.3.9.sql script to your database(s).
Before you install this Service Pack, you should review the data model changes described in the Service Pack Log to ensure that any custom modifications you may have implemented will not be affected.
Please review the log below for details of the specific data model changes.
The following updates are included in this service pack:
Tracking #: 0E26AKM
Description: In Ticket Entry and TSTE, the "Enter Weight" form has been updated to pull the number of decimal places from the Item
Record's Quantity decimals setting instead of a hardcoded value of 4 places.
Tracking #: 0F01BKM
Description: The ability to view unencrypted card numbers in View tickets & ticket history has been removed.
Tracking #: 9H27APC
Description: The following data model changes are included in this service pack. Review these changes to ensure that apllying these
changes does not overwrite any customizations you may have. Refer to ServicePackUpdateFor8.3.9.sql for details of the changes.
Views
VI_PS_VALIDATED_RETURNS_LIN
VI_PS_DOC_LIN
VI_PS_LWY_HIST_LIN
VI_PS_ORD_HIST_LIN
VI_PS_TKT_HIST_LIN
VI_PS_VOID_HIST_LIN
VI_INV_HIST_CELL_QTY
VI_INV_HIST_CELL
VI_IM_CATEG_SUBCAT
VI_PS_DOC_PMT
VI_PS_DOC_HDR
VI_PS_LWY_HIST
VI_PS_ORD_HIST
VI_PS_TKT_HIST
VI_PS_VOID_HIST
Stored Procedures
USP_DM_GET_KPI
USP_PRICE_CALC_PRICE_FOR_ONE_RULE
USP_RS_PROCESS_TKT
USP_GET_NEXT_GEN_ID
USP_RPT_IM_PHYSICAL_COUNT
USP_RPT_IM_PHYSICAL_COUNT_NO_GRID
USP_CONVERT_838_PS_VOID_HIST_LIN_PRICE
USP_MS_POPULATE_PS_STR_DAY_SUBSCRIBE
USP_PS_TE_UNCOMMIT_GFCS
USP_PS_TE_UNCOMMIT_STCS
USP_RPT_TKT_HIST_TOTS
USP_RPT_SA_BY_X
USP_FORCST_HIST_DATA
USP_RPT_PS_TKT_HIST_TAX
USP_FORCST_AGG_DM_SAL_LOC_ITEM_SEAS
Constraints
SY_TIMCRD_LIN
PS_DOC_DISC
PS_TKT_HIST_DISC
PS_VOID_HIST_DISC
PS_ORD_HIST_DISC
PS_LWY_HIST_DISC
AR_OPN_APPLY_TO
tables
SY_ACCTG_INTFC
SY_EDC_HIST
Tracking #: ACA303;ACA007; ACA644; ACA004; ACA771;ACB603; ACB897; ACI089
Description: Offline V2 - Drawer Session records and Customer records are being resent from an offline workstation back to the server
when there has been no local activity for them. This will cause a Drawer Session to become reactivated after counted and
will cause customer records to loop back and forth between the server and workstation continuously. To apply this fix
after installing the service pack on the server:
1. On the server, execute RadSyncInstall.exe from the CounterPoint SQL Top-Level>OfflineFiles directory
2. Provision the site server database
3. On each offline workstation browse to the site server's Top-Level>Offline Files directory and execute OfflineInstall.exe
4. From the site server's Management Console, select to rebuild all offline workstations."
Tracking #: ACI352, ACJ695
Description: The Barcode Management form shows information from a Custom Maintenance form when one is enabled in the data dictionary on the IM_ITEM
table; the Standard Form to allow custom inputs.
Tracking #: ACI452
Description: The Pie Chart on the Sales Analysis by Group report is not displayed on a 64bit system running Windows 2008.
