CounterPoint Updates
CounterPoint V8.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 Apr07.
* * * * * * * 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:
Tracking #: 9H27APC
Description: The following data model changes are included in this service pack. Review these changes to ensure that applying 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_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
Tracking #: 0A29GKM
Description: When using the Epson TM88, you will get multiple paper cuts on receipt printers utilizing windows drivers.
Tracking #: 0C29ATS
Description: In table view, when you enter a new barcode or edit an existing barcode and scroll up/down to another record
which has a barcode, you get the error message "Barcode type must be unique. Another line with the same Barcode
type "ITEM" exists for this item”.
Tracking #: 0C31ATS
Description: Partial Authorization and Reversals
To better support prepaid credit and debit cards, CounterPoint can now obtain an authorization for an amount that
is less than the amount due for a ticket or order via CPGateway or CPDialup.
For example, if the Total for a ticket is $30.00 and the customer presents a prepaid credit card with a balance of
$25.00, CounterPoint will obtain an authorization for $25.00, and then prompt the user to tender an additional payment
for the remaining amount due.
In addition, CounterPoint now also supports full reversals of credit card authorizations, allowing authorized credit
and debit card payments to be deleted from a ticket or order before the document is complete. You do not have to perform
any additional configuration to begin using this feature.
Note: Partial authorizations are only possible for Visa, MasterCard, Discover, and American Express transactions.
Reversals are only requested for Visa, MasterCard, and Discover transactions.
Partial authorizations and Full reversals are only supported for FDMS North, Vital, and American Express.
Other pre-paid functionality such as activation, reload, and balance inquiry are not supported at this time.
Tracking #: 0D01AKM
Description: A simple UI has been added to provide a view of aggregated sales history. Users are now able to filter by "item" and/or
"season" and view the sales history in a grid format. Please refer to Online Help for more information on Forecasting.
Tracking #: ACE236, ACF814, ACG459
Description: When using the Bixilon printer with Crystal Receipts and Windows printing, receipt forms are being cut twice if the printer
is not defined as the Default Windows printer.
Note that as part of this fix, a new value for "Bixilon SRP" has been added to the "Crystal printer type" dropdown in the Crystal
receipt printer select window. Please see MySara Certified Hardware pages for full instructions on configuring the Bixilon printer.
Tracking #: ACH080
Description: CounterPoint tax reports do not give a total for Exempt sales or Tax override sales, needed for some states tax reporting.
Tracking #: ACH085
Description: CounterPoint closes without error when adding items to a ticket using TSTE and TSTE is configured for Pause at quantity and the
barcode is the same as the item number.
Tracking #: ACH157, ACH646
Description: In Ticket Entry, when a ticket has a document discount code with a minimum qualifying amount applied, a document discount is calculated
and displayed in the totals section before the ticket has met the qualifying amount.
Tracking #: ACH225, ACH665
Description: In ticket entry, when processing a validated return with multiple line items, will occasionally get the error message:
Violation of PRIMARY KEY constraint 'PK_PS_TRX_LOG'. Cannot insert duplicate key in object 'dbo.PS_TRX_LOG'
Tracking #: ACH677
Description: In the documentation for the Merge Customers Utility (Enterprise) the notes indicate "You cannot merge an A/R customer into a Cash customer,
or vice versa." This isn't true, merging a cash customer into an A/R customer is allowed. Merging an A/R customer into a Cash type customer
is not allowed.
Tracking #: ACH705
Description: The Drawer Alarm is not coming across in a Terminal Services environment.
Tracking #: 0D07AKM
Description: When aggregation picks up a sale transaction for a gridded item that was entered using the multi-cell grid, incorrect values are written into
the DM_trx_loc_item_seas for the color/size combination.
Tracking #: ACH215
Description: Bixolon receipt printer will feed approximately 1 inch of paper prior to “kicking” the cash drawer when the cash drawer is configured through
the receipt printer.
