Home > News > CounterPoint Updates


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 Jul16.
 
*  *  *  *  *  *  *  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.
 
Note: If you are running Offline V2, you will need to re-provision and rebuild your Offline workstations after installing these updates.
 
Please review the log below for details of the specific data model changes.

The following updates are included in this service pack:

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
  VI_INV_COMMIT_TRX
  VI_INV_COMMIT_TRX_CELL
 
  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
  USP_AR_MERGE_CUST
 
  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 #: ABY943;ACA618, ACD271, ACE749, ACI861
Description: If you post loyalty points adjustments for two customers on the same date and then try to merge one customer into the
  other, the merge will fail with a duplicate primary key error.
Tracking #: ACF564 
Description: When a receiver against an allocated merged PO is saved,  the qty on PO is  being updated.  If recalc item quantities is
  run prior to posting the receiver, the item will be affected.
Tracking #: ACH559; ACH972, ACI054, ACK529
Description: CounterPoint will freeze when the station is defined to start tickets at customer number and  you cancel the customer number
  prompt after cancelling out of a quote recall or reprint ticket. 
Tracking #: ACH920 
Description: Data Sync config has been optimized for PO vendor config to avoid timeouts.
  Note, this fix will require you to re-provision and rebuild offline workstations. 
Tracking #: ACI026, ACI454 
Description: In Receivings/Enter, for an allocated/merged PO, when the quantity received for a normal tracked item is edited, the
  quantity to backorder is not updated. 
Tracking #: ACI646; ACJ634 
Description: The line type color indicator only fills in the first cell in Regular or TouchScreen ticket entry. Prior versions shaded the
  entire line which made it easier to determine which items on the ticket were order/back order/return etc. type lines. 
Tracking #: ACK317 
Description: "Phantom" drawer sessions created when replicating during offline ticket processing at a site server.
  Note, this fix will require you to re-provision and rebuild offline workstations.