WinPrism Version 25 Release Notes

IMPORTANT INFORMATION

Currently Version 25.x.x of WinPRISM is not posted on the PCI Website for PA- DSS validation. If you require a validated version, please use V24 for upgrade or installation.
The following features are NOT available for use in Version 25:
Mobile Toolkit
Textbook Bundles
Tokenization and Point to Point Encryption
NBC will alert you when these features are ready for general use.
Winprism 25 now supports SQL 2012
Hardware and Software Requirements for Installing SQL Server 2012
Windows XP does not support any version of SQL 2012.
The 2003 Windows server operating system line is no longer supported.
POS Distributed servers must have the same SQL version, or a higher version, as the ICS server.
For Failsafe systems, if POS is running SQL 2012 the Failsafe must run SQL 2012 as well. Also the register must be running Windows 7 to run Failsafe. The register program will run under XP, but will not do Failsafe.
If POS is running SQL 2008 the Failsafe will need to be SQL 2008 as well. These failsafe registers can run XP or Windows 7.

INTEGRATED ACCOUNTING

IAS General Ledger

General Ledger Periods (477178)
In IAS > General Ledger, an issue was fixed with how the G/L compared fiscal period to calendar month. Recently changes were made in WinPRISM version 23.0.0 to stop the General Ledger period from being closed before the ICS calendar sales month was closed for the equal fiscal period. When General Ledger made its checks prior to allowing the GL period to be closed, it was comparing the G/L fiscal period to the ICS calendar period, instead of comparing the calendar period that equals the fiscal period to ICS calendar period. This has been corrected and now the system (ICS and General Ledger) will compare calendar periods.
GL Accounts (469883)
In General Ledger Accounts, when the description is changed on a G/L Account code, the new description will now print on any G/L entry that was entered previous to the change. The change will also print the new description on all G/L reports.
NCDTR for Canadian Partnership (477166)
Return NCDTR entries from the Partnership program now make entries to the General Ledger in the correct currency for Canadian users.
G/L Interface Transaction Report (483729)
The G/L Interface Transaction Report at Journal Entry Maintenance has been corrected so that, when generated as Non-Consolidated, each store's header page starts a new page and the locations are separated.
Report Headers (502051)
In Journal Entry Maintenance when running the report "G/L Interface Transactions" including multiple locations, the header for the next location would populate at the bottom of the page after the first location's details and totals. A change was made so that the header for the next location would populate at the top of the following page.
GL Help Files (518062)
GL Help files have been implemented in WinPRISM General Ledger.

IAS Invoice Maintenance -4001

Freight and Discounts on Invoices (477182)
When an ICS invoice transferred to A/P Invoice Maintenance contains freight and discount terms, an issue was found that the Invoice Total and the Computed Total didn't always match. Code changes have been made to prevent this from happening.

IAS A/P Generate Checks– 4012

Future GL Period and Check Date Allowed (477183)
The GL period entered in Generate Checks was not being saved, so checks generated would use the current A/P period as well as the GL Journal Entry. This has been fixed so that the GL period entered in Generate Checks will be saved and used in check maintenance and GL.

IAS A/R Customer Maintenance – 4101

Reset Customer/Account Balances for Individual Customers (469896)
The ability to reset customer/account balances for an individual customer has been added to A/R Customer Maintenance. In order to access this option, one must login as a super user. The option is available by right clicking in the detail grid of the customer maintenance record on the account code to set the balance for, and selecting "Reset Account Balance". Once the option is selected, the process will run and the available balance for that customer will reset.
Reset Customer Balance (507328)
New validation prompts have been added to the Reset Customer Balance utility available at A/R Customer Maintenance and A/R Account Maintenance. When the option is selected, before the process will run a prompt appears: 'Are you sure you want to change these parameters?.' Clicking 'Ok' will start the process. When the process completes, another message 'Changes have been completed' will appear. Clicking 'Ok' will clear the message. In order to run this process at Customer Maintenance, you must be logged in as a super user or the option will be greyed out.
Customer Account Report (509243)
The Customer and Customer/Account Report located in WPAdmin>Accounting
>Customer Maintenance have had the sort order option Customer Code changed to Customer ID. In addition, the column header on both reports has been changed from Customer Code to Customer ID.

IAS A/R Transaction Inquiry – 4111

Font Correction (477177)
The font on the A/R Activity Report located on the Reports menu at A/R Transaction Inquiry has been updated, so it uses the same font as other reports in WinPRISM.
Date Columns Added (469926)
In WinPRISM > Accounting tab > Receivables > Invoicing > Transaction Inquiry, and in WPAdmin > POS tab > Maintenance > Transaction Inquiry, a "Completed" column has been added to the Quick Search Results window. The "Created Date" column has been renamed to "Created". Each of the columns can be sorted by double clicking the column header.
Customer Sales by Date Report (489817 and 492414)
The Customer Sales by Date report now displays the correct amount in the Subtotal fields. Previously, when a discount was involved, the subtotal was incorrect. This issue has been corrected.
A/R Customer Sales by Date (477206)
The A/R Customer Sales by Date Report located on the Transaction Inquiry Reports menu had an issue corrected with an A/R return and a discount. The report was showing all items in a transaction had been returned, when only one item had. This has been corrected. In addition, there was another issue where discount amounts were causing the transaction totals in the Grand Total section to be incorrect. This has also been corrected.
A/R Activity Report (483737 and 565916, P8)
The A/R Activity report located at A/R Transaction Inquiry on the Reports menu has been corrected and will now include web refunds. Prior to this correction the report was picking up web orders, just not refunds. It will now also include transactions where the account is set to 'Invoice in Receivables' or to be Generated (autogenned). The report can be run by A/R Period or for a Date Range.
Transactions By Department (493967)
The A/R Transactions by Department report located on the Reports menu at A/R Transaction Inquiry has been corrected and the field 'Total Other Tenders' now matches exactly to the POS and Mail Order Register Totals Reports. An issue was found on the POS Register Totals Report which caused the total tax amount which is included in the 'Total Other Tenders' amount on the A/R Transactions by Department report to be incorrect.
A/R Transaction Inquiry Global Notes (503730)
At A/R Transaction Inquiry and in POS Transaction Inquiry, a Global Notes Column has been added to the detail grid. Previously, both modules only had a Global Notes column in the header. Even though the modules are alike the global notes do not transfer within the two options.
A/R Customer Sales by Date (511717)
The A/R Customer Sales by Date Report located on the Reports menu in A/R Transaction Inquiry has been corrected and is now handling split tender transactions correctly.

IAS Purge Applied Payments – 4154

Purge Applied Payments (489807)
Stores were receiving an error when purging A/R Applied Payments for the NMRP account. A problem was found when the system was trying to purge return rental transactions when rental history was still on file in Rental Maintenance. The issue has been corrected and Purge Applied Payments can be run without error on the NMRP account code.

IAS Journal Entry Maintenance– 4203

F9 More Detail (477189)
The F9 More Detail Report at Journal Maintenance has been corrected and will now detail a G/L entry for an ICS prepaid invoice. Previously, the report was not showing all parts of the G/L entry. The report should list all items in the original journal entry.

IAS Miscellaneous

A/P Export (469994)
The standard A/P Export has been changed, so that it now pulls the correct remit address, based on subsystem type of the invoice.
A/R Customer Balances Export (469921)
The A/R Customer Balances Export interface was changed, so that it would use the auto export flag. Previously, some stores had experienced an issue where customer balances that should not have been included in the interface were being included.
Membership Change (489795)
When multiple changes were made to a membership account via WP Admin, not all changes were being propagated to WinPOS. This has been fixed so that all changes made to a membership account update correctly to WinPOS.
A/R Display Issue (477152)
When the 'view settings' in the Windows Control Panel was set to WIN 7 or WIN Basics, various A/R modules displayed an arrow over the word "Selected". All libraries have been corrected and problem no longer occurs.
A/R Customer Export Customer ID (480993 and 469906)
The A/R Customer Export has been corrected, so it will handle a Customer ID that is up to 25 characters long. This change was made to the standard AR Customer ID Export.
A/R Receipt Export (484020 and 483780 and 480998)
The A/R Receipt Export has been corrected and now puts the Transaction Discount amount in the correct field, instead of the Item Disc Rate. The Item Disc Rate field was being used in the field position where the Transaction Disc should have been.
Transaction Export Using Transaction Date (477192)
A new version of WPConsole was built for version 24.1.4. The transaction export was built in the format of the A/R receipt header export, but will take the date from the transactions instead of the A/R invoices. These changes will be to all locations.
A/R Customer Balance Export (469937)
The A/R Customer Balance Export has been corrected. A problem was found with null values causing the export file to contain errors. Programming reinforced error handling in the code when values are unexpectedly NULL by assigning default values.
A/R Customer Export (469995)
The request was created due to an issue with the "AR Customer Export" failing with an error if the "Created Date" or "Active Date" were NULL. The issue has been resolved so that if either of these fields are NULL, then they will default to 1/1/1970. That means that these two fields will appear with the "1/1/1970" date in the export file.
A/R Invoice Maintenance (499387)
An issue was fixed in A/P Invoice Maintenance that when you enter the detail amounts of a manual invoice prior to entering the 'Invoice Total', the status would not change to posted when using the hammer option. This issue has been corrected.
Payment Report (515564)
A correction was made to the A/R Payment Report to fix an issue with multiple invoices applied at the payment screen showing incorrect amounts on the A/R Payment Report.
When this issue occurred, the A/R Payment Report was leaving the Invoice Number column on the report blank. This issue has also been corrected.
A/P Credit Memo Maintenance (523349) (P1)
The final return that is issued in the Partnership program will now just display the actual amount of the return in the detail and header fields in A/P Credit Memo Maintenance. In ICS, Resolve Credit Request, the final return does still show the 'Previous Rebate' amounts. In Version 24, this process was changed so the detail lines and the Credit Received field in the header displayed the total amount of all NCDTRS and the final return. In version 24, the Credit Total and Credit Used fields displayed the actual amount of the final return. The change in version 25 was made to correct a problem in the A/P Aging and Outstanding Credits reports showing the final return as not fully resolved.
Customer Balance Export (539528)
The Customer Balance Export has been corrected and now runs regardless of how the flag 'Disallow Auto AR Export' in WPAdmin AR General Parameters is set. The key is to not schedule the interface and just generate it by clicking start.
Calendar Date (546410, P6)
At Setup Recurring Journal Entries, a change was made that will allow you to set any calendar date within the period as the general ledger entry date. Prior to this change only a date of the 1st could be used.
Memberships (546406, P6)
In Memberships when a membership tier is purged the process has been corrected so it will not delete all membership adjustments.