The latest version of BRdata’s Retail Boss software contains many major enhancements as well as numerous fixes to reported problems. Altogether, the version contains some 1,600 modifications made since the initial release of version 6.02.
In addition to the many enhancements and improvements made throughout and enumerated by program below, some notable enhancements made to Retail BOSS included in version 6.03 are:
• Windows Vista support for the BRdata Automator.
• Support for prices over $999.99.
• Support for Price File by Vendor.
• Receipt printout now includes User Name and Message.
• Utility for copying zones.
• New fields have been added to RBX and TCI exports.
Detailed additions and/or modifications made to Retail BOSS for version 6.03 (including the names of primary programs involved) are:
“Modeling Matrix” record. When a new item is being added to the Product Master, the “Report” field on the Product Master’s “Main” tab is changed to “Rule” with this option setting in effect.
• A new option setting, “Check Automator Status Prior to Export Process,” has been made available under the “Export‐2” tab, to have the Automator status checked prior to any export batch process.
• A new option setting, “Export Populated Vendor Item to ISS45 Vendor Labels?,” has been made available under the “Fujitsu” tab. Enabled, it exports the Warehouse Item in an export batch process if the Vendor Item is blank or if the vendor option is disabled.
• A new option setting, “Use STBRAND+STDES22 for Description,” has been made
available under the “File Setup” tab. Enabled, the setting specifies that STBRAND+STDES22 be printed in place of the Description on receipts/POs.
• A new option setting, “Increase Support to 99 Multiple Packs?,” has been made available under the “File Setup” tab. Enabled, it increases the allowable number of
packs by vendor from 9 to 99.
NOTE: For this option setting to have any effect, the one immediately above it on the “File Setup” tab, (“UPC Support of Multiple Packs by Vendor?”) must also be enabled.
• A new option setting, “Transfer TPR/AD to FRQ‐Ulink,” has been made available under the “Wholesaler” tab. Enabled, it specifies that TPR/AD be transferred to Frequent Shopper for Ulink file format.
• Product Master (FILA9450)
• The program has been enhanced to allow the Modeling Matrix file to be updated from the Product Master. Enabled/disabled via a new Application Personalization option setting, “Write/Update Item Modeling Rules Based on Item’s ‘Price Rule’”under the “Product Master‐2” tab, a “Modeling Matrix” record is created. When a new item is added to the Product Master, the “Report” field on the Product Master’s “Main” tab is changed to “Rule” when this option setting is in effect. If the “Rule” field is blank (if, for example, the field has been cleared), the record is removed from the Modeling Matrix file if it exists for the specific UPC. The program has also been modified to clear out GM rules when a switch is made to a competitor rule.
• The program has been enhanced with the addition of a “Percent Tare” field under the “Scales” tab; it accepts a percentage value to be applied as the tare amount. The
value is exportable from the BRdata host to store, and is importable from the preprocess import Excel option.
• The main vendor is set on the grid when the Application Personalization field “Disable Main Tab Cost Entry” (under the “Product Master‐1” menu) is used in conjunction with the “UPC Support of Multiple Packs by Vendor?” option setting under the “File Setup” tab. • The update vendor on the grid is set from the first item inserted into the cost listview when the Application Personalization option setting “Filter Vendors on GRID from Batch Store Selection?,” under the “Product Master‐2 tab, is enabled.
• Member promotion direct item maintenance can now be exported for ISS45; this requires that the Application Personalization option setting “Only Export ISS45
Cross Records” under the “Fujitsu” tab is disabled (unchecked).
• Support has been added for selected levels for ACS CM promotion “EligibleCustomers” field. The field for level selection is the “Freq. Shop Level” drop‐down menu selection in the “NCR ScanMaster Coupon Information” section under the “Coupons” tab.
• Movement can now be viewed for ScanMaster versions prior to v1.02.
• Support has been added to enter percentage allowance from the future pricing grid.
• A problem has been corrected that occurred with the Warehouse Item search function when the “Freeform Search for WH Item” option setting under the “Standard” tab of Application Personalization was disabled (unchecked).
• The “Print” and “Preview” buttons on the icon control bar have been disabled because they were not intended for use in Product Master , and clicking the “Print” button could result in the entire Item file being sent to an attached printer.
• A problem that was occurring with the “Override Batch Number” Direct Item Maintenance mode has been resolved. When this mode was in put into effect (by enabling – checking – the option setting “Override Batch Number” in the “Entry
Batch Information” dialog box), had not been creating an override batch at batch file creation, and also had not been displaying the override batch number on the Product Master title bar.
• Import POS Sales Movement (SALW9405):
• When movement is imported for Type 2 codes, the weight is calculated using the sale price instead of the regular retail price.
• Sales Movement History (SALW9407):
• A new costing option, “Report Net Cost as of Movement Date,” has been added under the “Options 2” tab. Enabled, it specifies that the report retrieve costs from the
future cost database.
• The “Use Weekly Summary” option will now print the daily movement for a single store as well for as multiple stores.
• A number of options have been added to the Mondo Sales Report (accessed under the “Options 1” tab). The “Consolidated” option consolidates all stores into the report; the “Print Details” option includes shrink and transportation service fees in the report; and the “Quarter to Date” option applies the reporting to that specific timeframe.
• A problem has been corrected where some units were printing as blanks in the output report.
• A problem with allowances in the Mondo Sales Report has been resolved.
• A sorting problem that occurred with negative numbers has been fixed.
• I16 errors that had been occurring have been addressed.
• Automated Calculation of Items Average Sale (BRDAVGSM):
• The program has been enhanced to calculate the average number of cases sold per week for the last 13 weeks; the Item file is updated with this calculation for inclusion on labels. A command line option is available for this option, as follows:
PLBWIN BRDAVGSM AUTO C D=91
• The program has been enhanced with a new option, (W)eekly. When used, the program calculates the weekly average without calculating a “Case” amount (that is, it does not divide pack into total).
• Zone Compare (BRDZNCMP):
• A new option setting, “Process TPRs Only,” has been added. Enabled, it comparesTPRs in the zone‐to‐zone comparison operation. When the “Create Pre‐process Batch” option is enabled as well, if a TPR discrepancy exists, the TPR price for
Store/Zone (1) is written to the pre‐process batch.
• Movement Utility (MVUTIL):
• Problems have been resolved that had been occurring with the fixed percentage sales change calculation in daily e‐mail reports.
• Rounding Routines Load Module (ROUNDMLT):
• A potential problem has been resolved where the alternate rounding file occasionally
was erased.
• Item Rule Search (BRWRULE):
• This new program allows users to search the Item Rule file from the Product Master.
• Item Rules Table (BRDRULE):
• Item rule codes have been changed from 2 digits to 4 digits.
• The program has been enhanced with the addition of a Private Label rule; it can be used to apply either a specific negative amount or a percentage less than the national
brand for that item.
• Inventory Valuation Gross Profit (MTIW9404):
• A number of new reporting options have been added under the title “Slow Movers/Inventory List with Movement.”
• Pre‐Process Batch File (FILW9494):
• The program has been enhanced to create a Modeling Matrix record based on the new “Item Rules” table. If the new Application Personalization option setting,
“Write/Update Item Modeling Rules Based on Item’s ‘Price Rule’” under the “Product Master‐2” tab, has been enabled and the user is importing merchandiser code (IMPSMRPT), a new record is added to the Modeling Matrix. The Modeling Matrix file will be updated based on the Rule imported. If the user imports a “Target GM%” value, the system will use it when updating the Modeling Matrix; otherwise it uses the “Target GM” value from the Item File. If the user imports a value of “0000” in the “Report Code” field (which becomes the item’s “Rule Code” when the Application Personalization option setting is in effect), the system will delete the Modeling Matrix record.
• Enhanced price fields are now printed on the Pre‐Process Batch report.
• A problem has been corrected wherein the “Discontinued Date” field on the Product Master “Misc” tab was not exporting to the store if it contained a blank value at the host. In this case, if the store had the item with a discontinued date, the host was unable to remove the date.
• A problem has been corrected that was introduced by build 6.02.0349, where preprocess price and price type were not clearing when the enhanced pre‐process was used.
• Batch File (FILX9471):
• Program now copies export configuration from the header when batches are split.
• The batch header file can now be updated with Batch Type data.
• Batch Type Master (BATCHTYP)
• An option setting, Export Vendor Item, has been added. Enabled, it specifies that the Vendor Item rather than the UPC is to be exported.
• Daily Edit List Recap (and Receiving Guide) (DSDW9423):
• The program has been enhanced by the addition of two new report format options: “Daily Receiving Guide,” — which shows Ad item received — and “AD Cap Exceptions,” which indicates preset cost discrepancies. Ad cap costs are entered on
the “Receipt” tab using vendor “ADCAP.”
• A new option setting, “Receipts Only,” has been added. Enabled, it specifies that the report will print receipts only, without purchase orders.
• A new option setting, “Merchandise,” has been added to process the report by merchandise department.
• Two new sorting options have been added: sorting by vendor name and sorting by item description.
• Sales Order Entry (SALW94X1):
• When access for the logged‐in user has been limited to a single store in the User Master, access to the ellipsis button (…) that provides a list of stores is now disabled and the Customer Code is automatically filled for search and entry options.
• Quantity totals are now printed.
• An error caused from JS58 has been corrected; numbered 0105, the error occurred when UPDORDTL and RDORDTL were entered from other programs (e.g., Receipt‐PO Entry).
• Order Entry Edit List Recap Report (Invoice Edit List) (SALW9423)
• A new report option, “Adjustment Report,” has been added; enabled, it reports on store order adjustments.
• Receipt‐PO Entry (DSDW94X1):
• The program has been enhanced with the addition of a “Check Deals” button that provides a means of checking the allowance information on the items in the order or
receipt.
• A process has been added to generate customer pick tickets upon receipt of warehouse distribution. This feature is in effect when the “Distrib Receipt” flag is set and two Application Personalization option settings are enabled (checked): “Auto
Create Sales Orders When Logging Distribution Receipts” under the DSD/PO‐2 tab, and “Allow PO Distrib Entry” under the DSD/PO‐1 tab.
• The program now uses the “Vendor Pack” value from the Vendor Cost file for warehouse purchase orders, rather than the default Retail Pack.
• STBRAND+STDES22 can optionally be printed in place of the Description onreceipts/POs. The option is enabled by an Application Personalization setting, “”Use STBRAND+STDES22 for Description,” under the “File Setup” tab. (Also applies to
the “Automated Receipt‐PO Print” program ‐ DSD99420).
• When items are added to the grid by unit, they are marked with a “P” for pieces; formerly this had taken place only when items were added by unit in the main screen, with the result that the printed reports contained incorrect unit extensions.
• The number of Vendor Items can now be optionally increased from 9 to as much as 99; this is accomplished via an option setting in Application Personalization, “Enable UPC to Support Multiple Packs by Vendor?” under the “File Setup” tab. It works in conjunction with the setting immediately below it, “Increase Support to 99 Multiple Packs?”
• The program has been enhanced with an option to link a Vendor Contact to the purchase order header. A new field, “Contact” accepts a Contact Code, and an ellipsis (…) button presents a searchable list of existing contacts to select from.
• A problem has been corrected where the received item status was not displaying the number of lines yet to be received when new items were being added from the grid.
• A problem has been fixed where the listview in the main screen lost focus once the “Detail” listview was opened then closed.
• RF Program for IBM/2127/ACS/ISS45/DSD (RFT99401)
• Program has been enhanced to issue a user alert when an item being ordered is specified to include linked items yet the item is not linked.
• The program has been enhanced with support for updating ACE Age Verification on both the character‐based and GUI entry screens.
• Case Cost and Unit Cost have been added to both the character‐based and GUI inventory posting screens (reading from the Stock file).
• Min/Max has been added to the Item Maintenance screen (view and edit) under the Misc tab.
• View‐Apply Future Prices (CFDW9416)
• The program has been enhanced with the addition of a new future price method, “Start/End Date.” This mode updates future prices based on start date, priority, and end date. For overlapping prices that have the same start date and priority when being applied from future to current, the last posted future transaction is applied to current.
• The Store Override database has been integrated to retrieve the Primary Vendor for costing calculations.
• The ON record is not exported if the price exists on a higher priority.
• A problem has been corrected where items were being applied to incorrect batches when batch creation was in use.
• The standard Windows close window (X) icon in the upper‐right of the “Price, Cost, Allowance Search” dialog box is now operational.
• A problem that prevented updating of case costs allowance values when the “Block Copy” function is used.
• An error (F02) that occurred when more than 10 stores were selected has been corrected.
• Receipt‐PO Apply‐Lookup (DSDW9421):
• The program has been enhanced to increase the “Check Deals” process.
• New Query/Reporting options have been added. “Unsched Only” and “Sched Only” permit filtering to narrow the query to unscheduled or scheduled deliveries. "Will Call Only” and “No Will Call” permit filtering to narrow the query to only those entries flagged to receive calls, or those not so flagged. (“Will Call” details are printed from the Contact Master on the detailed edit list using the “Receiving Guide” reporting option.)
• A message prompt displays when the ”Check Deals” button is clicked, asking whether or not the user wants to check for items that were not ordered with ending deals and advising that the process could take several minutes, depending on the
department.
• An option has been added to use STBRAND+STDES22 for the Description on receipts/POs; the option — “Use STBRAND+STDES22 for Description” — is set in
Application Personalization under the “File Setup” tab.
• A problem with the “Check Deals” process, where it printed items that were in the orders department, has been resolved.
• BRdata Price Generation Engine (BRDIMPWH):
• The program has been enhanced with the ability to optionally process vendor groups.
• The program has been enhanced with the option to check for a TPR rule on the Vendor File. If a rule is found, it will override the Zone or Store TPR rule.
The program has been modified to fix several issues with the new sliding TPR routine. Problems with generating TPRs have been resolved; a potential F02 error has been fixed; and expired TPRs are cleared before the Audit file is written to. In
addition, TPR calculation is skipped if an item is processed with a current TPR having a higher priority.
• A problem has been resolved where the monthly movement file was not being correctly written to. In this case, only the first record was written to the file; the remainder were being written to slmhs.txt.
• Export Batches (FILX9482):
• The program has been modified to check all stores if either no batches or no stores have been selected for the “Store Automator” function. Both “Success” and “Failure” indications display in a “Status” field in the listview.
• An Application Personalization option, “Check Automator Status Prior to Export Process,” has been made available under the “Export‐2” tab, to have the Automator status checked prior to any export batch process.
• An Application Personalization option, “Export Populated Vendor Item to ISS45 Vendor Labels?,” has been made available under the “Fujitsu” tab. Enabled, it exports the Warehouse Item if the Vendor Item is blank or if the vendor option is disabled.
• The ISS45 Vendor Label number is now always right‐justified.
• A cross‐reference table mapping ISS45 unit of measures with BRdata unit of measures has been activated.
• Do not export the bottle deposit value to TCI for any stores that have the “Disable Bot. Deposit,” option setting enabled (checked) under the “Options” tab in the “Store Master” program.
• Support has been added to maintain PLUEXT.QDX for the Pricer ESL interface.
• The program now exports ACE Restriction codes to TCI (similar to IBM).
• The program now exports member levels to ACS PMT.
• A problem has been corrected wherein the “Discontinued Date” field on the Product Master “Misc” tab was not exporting to the store if it contained a blank value at the host. In this case, if the store had the item with a discontinued date, the host was unable to remove the date.
• A problem where the Value Card flag was not being properly set to IBM ACE POS has been corrected.
• The program has been enhanced to support exporting to TCI’s ISP 22 “Coupon Item” field for IBM.
• A problem has been resolved that occurred when the “Convert PLU to Batch” program for ScanMaster versions 2.01 and greater was run. Modifications prevent sporadic spaces in the Report Code field, Adjective Code field, Sub Department
field, and Coupon Code field.
• Reorder Report (ITEW9413)
• The “Buyers Report” option now includes the average cost, last cost, and Warehouse Item Code.
• A new radio button, “Merch Code,” has been added, along with “From Merch” and “To Merch” fields. Enabled, the report is processed by Merchandise Code. The entry fields specify the range of merchandise to use in processing. An ellipsis button (…) beside each field presents a searchable list of Merchandise Codes and descriptions from which to select.
• A new field, “Store,” has been added. It accepts a Store Code to specify the store that the report is to be processed for. An ellipsis button (…) beside the field presents a searchable list of Store Codes and descriptions from which to select.
• Warehouse Buying from Store Orders (BRDBUYER):
• A new program provides the ability to generate item‐driven purchase orders with multiple vendor assignments; it is accessed by selecting the “Create Store Orders” option from the pull‐down “Inventory” menu on the Retail BOSS main menu bar.
• BRdata Order Import (BRDPOIMP):
• An option has been added to create a custom order export when importing orders from stores.
• SIL Interpreter (BRDSIL):
• The program has been modified to include an ending date for Nash Finch; the logic is removed when the new future pricing, start/end date, is used.
• TPR/AD can now be transferred to Frequent Shopper for Ulink file format; this is configured using the “Transfer TPR/AD to FRQ‐Ulink” option setting in Application Personalization under the “Wholesaler” tab.
• Export Item File / Print Labels (BRDEXCSV):
• A problem that occurred when a price book was printed for various vendors has been corrected; a forced page break that happens automatically when the vendor changes had stopped working, but has now been restored.
• A problem has been corrected where items on TPR/ADP had an obviously incorrect dates (year) when exports were processed by pre‐process batch.
• BRdata File Import Utility (BRDIMPRT)
• A problem has been resolved that occurred when the “Create Batch Records for Linked Items” option was used; in this case the program would change the description for items on link to that of the item with a main link from the import file.
• Minimum/maximum order quantities have been added.
• Configure FX Output Format (BRDBATCH)
• The program has been enhanced to support exporting to TCI’s ISP 22 “Coupon Item” field for IBM.
• The program now provides the ability to export Family, Category, etc. to RBX per user specification; this is designated via an Application Personalization field.
• Profit Analyzer (BRDOPTIM)
• Numerous improvements have been made to the program’s grid editing capability in order to optimize it, make it more universal, and increase its reliability.
• If the category rule method is other than “Gross Margin or “Amount,” a message prompt announces when the desired gross margin is being approached.
• Search by all items functionality has been added, and an optimization batch can be created from the results.
• A number of problems were addressed: some listview displays had problems with the Suggested GM, Suggested GM$, and Suggested $ fields; the rule logic was sometimes not properly setting and ordering rules when there were zero weights; intermittent gaps occurred in the operation of the Zone/Store selection; the Apply Future Price operation had been defaulting to Zone A when writing the date and price; the opt session detail in the Retail listview was not clearing for each process; a changed record warning was displaying when category options were updated.
• Delete Price Records With No Store Record (DELPRITA)
• Program deletes PRIT994 records with no DSTOR994 record.
• Write All Vendors to Excel File (FIXVENAP)
• This new program writes all vendors and all related fields to an Excel (CSV) file.
• Update Stock Cost and Pack From Price File (FIXSTKRO)
• This program addresses problems that had been occurring with the Stock file cost and Pack; it reads through the Stock file and uses UPCVEND to obtain the cost from the Vendor Price file.
• Store Master (FILX9460)
• A new store option setting, “Disable Bot. Deposit,” has been added under the “Options” tab. Enabled (checked), it disables the bottle deposit for the selected store.
• Customer Master (FILW9446):
• Modifications have been made involving SQL functions for the program. The SQL interfaces Macio/Macro for Dynamic ADOB Load using UPFiles Values have been modified, as have SQL processes to get ACSNCR.INI values and Environment for
SQL.Open DB/Tables. The program has also been modified to convert certain integer values before processing SQL Write/Update tables.
• An option has been added for loading SQL using All ADO DB connection values from UpFiles settings.
• Host‐Store Compare (FILW9483):
• A new option for command‐line initiation, “‐CUSTOMRT,” restricts the compare operation to custom retails only.
• An intermittently occurring problem has been addressed in which the incorrect host reduced prices were loading. This happened when the expired TPR price option was
used with an item that has no custom and/or zone price.
• And intermittent issue has been addressed where the program was loading zero regular retail into the pre‐process batch for items that lacked host pricing records.
• Export Batches (FILX9482):
• The program has been enhanced to support exporting to TCI’s ISP 22 “Coupon Item” field for IBM.
• Profit Analyzer (BRDOPTIN):
• The ability to edit the listview has been completed with the addition of the ability to modify and save the suggested price, which updates the suggested gross margin.
• Problems with the listview not populating properly with mouse clicks has been fixed.
• A problem where the column colors were not working in edit mode has been corrected.
• RBX File Importer (BRDRBXIN)
• The program has been changed to use a calculated date rather than simply using the date on the record for the end date of the ADP record; the date is calculated as the batch date + 7 days.
• Computer Generated Order Process (BRDORDER)
• A problem has been corrected where files using 3‐digit store codes were not being accommodated by the “Warehouse Store” field in the CAO Configuration file.
• CAO Configuration File (BRDCAOCF):
• A new option setting, “Create Custom Order Export,” has been added. Enabled, it creates a specific order file format defined by KeyFood when an order is imported into the BRdata Host.
• Read Vendor Price File and Delete if Not Main Vendor (FIXVNPYY)
• New program reads through the Vendor Price file and deletes vendors that are not the main vendor.
• Keyfood ScanMaster Elec. Coupons Import (BRDSMKE3):
• Cross‐promotional enhancements have been made to the program.
• AG Seattle Import Program (BRDAGSEA):
• An option has been added to assign a check digit when EAN 13 (12‐digit) codes are imported.
• A sporadic problem with importing type 70 records has been resolved.
• Convert Vendors to Broker Master (BRDCVBRK)
• A new program has been created that imports KVmart vendors to the BRdata Broker Master.