SwanFRS Release notes for version 1207

Created by Migration Bot, Modified on Fri, 23 Oct at 2:29 PM by Migration Bot

Originally written by Will Miller, last updated Sept 01, 2023, on the Swan Retail knowledge base (FRS).


Release Date: 9th August 2023

Click to view the PDF download link

FRS-SwanFRS Release notes for version 1207-150823-131115.pdf

Key New Features

FRS-1034 - SwanFRS Wi-Fi Warehousing Application

This application offers an alternative to the batch warehouse scanning currently available and works in partnership with the back-office SwanFRS application.

Requirements:

  • Wi-Fi enabled barcode scanner with colour touch screen capable of running a web browser.

  • Wi-Fi capabilities within the stock holding location

Benefits.

  • Real-time barcode scanning updating SwanFRS of stock activities immediately.

  • Time savings / increased productivity

  • Dedicated users with access restrictions

FRS-1029 - Option pictures to show either as a pop-out or enlarged

SwanFRS can now be configured to show option choice images in both the front and back office applications.

Requirements:

  • Specification of option choice images within either Set Up Product Pricing or within the Product Creator Spreadsheet

Benefits.

  • Increased pictorial visibility of choices.

  • Easier to show the client / ensure the correct ‘option choice’ is made.

  • Consistent imagery with pick lists on linked websites

FRS-939 - Link to Confluence Details

SwanFRS now links to the knowledge base for maintenance and reports providing access to reference guides pertaining to the subject.

Requirements:

  • The operator must have a login to the knowledge base to view the guides.

Benefits.

  • Ability to view details of the report without having to run it first.

  • Access to maintenance guides provides direction as to the significance of a field therefore aiding the population of ‘static’ data within the database.

Support #: FRSSUP-5910

Product Creator

The product Creator spreadsheet now offers the ability to assign a ‘menu ticket’ name and optional printing sequence number to the SKU.

Taking the display capabilities to the next level is a new matrix control tab within the spreadsheet that offers a maximum of a 6 x 6 data grid allowing a table form of display ticket to be produced.

Default designs are available within the application making production of menu and matrix tickets a simple task.

Requirements:

  • SwanFRS’s product creator spreadsheet version 1207.

Benefits.

  • Improved display ticketing for menu and matrix designs

  • Ticket content sourced from the SwanFRS database ensuring prices are accurate to the ‘print date’ selected.

  • Works in partnership with the Promotional Ticket Style engine

New Features

FRS-1050 - Spiff Report

The 'General and Salesperson variants of the New Commission reports now use the flat rate commission value (where set) against the SKU, which is paid irrespectively of final selling price at time of confirming delivery of the goods or service.

This works in partnership with other commission protocols and is documented in the accompanying guide.

As part of this work a 'New Commission - Supplier / Vendor' report is available which produces commission values for items from a selected supplier.

Support #: FRSSUP-6463

FRS-1048 - Stock Items Marked as Display Not to Count Towards Website Stock 2/2

A new Application Parameter has been introduced, allowing the issuing of stock marked as ‘on display’ to be omitted from the available stock data export sent to the web via the GetStockQuantities and GetStockItemQuantities.

The application Parameter is BLOCK_DISPLAY_STOCK_TO_WEB and is documented within SET UP APPLICATION PARAMETERS

Support #: FRSSUP-5529

FRS-1032 - Mass stock upload

The mass stock upload, used to inform SwanFRS of large numbers of new stock (write on's) has been extended.

The load file structure now offers the following additional optional control fields.

The CSV file will be extended to accept the following fields.

  1. Write on date

  2. Original Cost Price

  3. Showroom indicator

  4. Can’t sell indicator

  5. Imperfect indicator

Full details can be found in the mass stock load guide.

Support #: FRSSUP-6493

FRS-1014 - Add cost / selling to Qlik Del Record

Cost and selling prices have been added to the Qlik Data export for purchase details (RMS / CSF Link)

FRS-1001 - Secondary Barcodes

SwanFRS label production for Accessory classed products has changed.

Pre release 1207, SwanFRS printed the SKU number when producing accessory classed stock tracking barcodes, however for clients using third-party product creators the SKU sent to SwanFRS has become large with elements of the SKU reaching 6 or more characters. This resulted in a SKU barcode which was either too wide to fit the stationery or become too small to scan.

The solution therefore was to move from printing SKUs for Accessory classed items to printing the SwanFRS internal tracking number. This makes the barcode length smaller and therefore removes (reduces) the issues relating to smaller label sizes.

To ensure consistency and to allow labels produced using the old SKU tracking barcode, SwanFRS will accept accessory labels with either the SKU or the secondary barcode.

This feature applies only to Accessory classed barcode.

All standard stock tracking labels have been modified to accommodate the new methodologies however it may be necessary to check with support should this feature be required.

Support #: FRSSUP-6307

FRS-981 - Stock Items Marked as Display Not to Count Towards Website Stock 1/2

Changes to the following APIs to omit items marked as display when communicating with the web and subject to the WEBSHOP_EXCLUDE_DISPLAY_STOCK application parameter being set.

  • GetStockItemsMarkedForWeb

  • GetStockItemsMarkedForWebForSKUSearchString

  • GetStockItemsMarkedForWebModifiedSinceDate

  • GetStockItemsMarkedForWebModifiedSinceDateForSKUSearchString

Support #: FRSSUP-5529

Changes to Existing Functionality

FRS-1118 - Description Limit of 60 Characters for Purchase Ledger Files

The description length has been restricted to a maximum of 60 characters when sending data to the RMS (CSF) accounting System

Support #: FRSSUP-6897

FRS-1060 - Block 04 record extraction

When sending data to the RMS (CSF) system, the generation of an 04 record has now been blocked.

FRS-1047 - Another change to BTA CSF

The RMS (CSF) interface has been changed to exclude posting types 10 and 24.

FRS-1042 - Logic Issue with BTA's CSF write on / off controls

The RMS (CSF) interface has been modified to take into consideration the posting account code set against the write on / off reason codes.

Where set the reason specific nominal code will now be used in preference to the system-wide application control write on & write off nominal codes.

FRS-1035 - BTA Creation of 60R CSF Posting

Modifications have been made to the RMS (CSF) interface to accommodate staff discounts processed against the sales order when sending confirmation of delivery / customer collections.

Two new staff discount checkboxes have been added to the set up discount reasons and set up discount types, enabling a discount to be marked as a staff discount. The discount applied to the order line is then reported as a separate entity within the RMS / CSF interface.

FRS-1026 - Sign change required for 41c BTA Export file

The signage has been reversed when sending type 41c records to the RMS (CSF) accounts system

Support #: FRSSUP-6530

FRS-997 - Web API - Add PWSupplierID to GetProducts and GetOptions results.

The GetProducts and GetOptions APIs have been adjusted to include the Supplier’s ID allowing the Web provider to differentiate between Option Questions which are replicated for different suppliers (for example - The question ‘colour’ may exist for several suppliers with different choices, adding the Supplier ID allows the data to be linked to the appropriate supplier)

FRS-995 - Shopify - Timing Out Issues

When sending specific data sets to Shopify, a time-out was encountered with specific scenarios. The interface has been changed to stop timeouts from affecting the data sending.

FRS-988 - Find Purchase Order

The find purchase order results page has been modified to provide more information relating to the various states of the purchase order.

  • New Status filter - Cancelled and not sent has been added which will show all Cancelled POs which have not been re-sent to supplier

  • A new SENT column right of status improves visibility of whether POs are deemed to have been communicated to the supplier.

  • The Sent method column has been rename to Printed to make it clearer for the operator.

  • The Status column has been extended to show SENT , NOT SENT , AMENDED and CANCELLED badges

Support #: FRSSUP-6140

FRS-950 - Menu Search - Customer Number

The keyword search option (top right of the menu) has been extended to include a customer number search

FRS-943 - Tablet - Available Stock buttons

The AVAILABLE STOCK button on the tablet version of the Catalogue Search will be coloured teal when available to ensure they stand out to sales staff.

FRS-942 - Direct Home Delivery

When adding a product to the sales order and the product is available for home delivery, SwanFRS will now show a notification in the top right of the page advising the operator the item could be ‘home delivered / direct shipped' if desired.

Support #: FRSSUP-6145

FRS-939 - Link to Confluence Details

SwanFRS now offers a link for ‘set up’ programs' and reports to the knowledge base.

Access to the knowledge base will be required in the form of a login.

The link will show in the system settings page and on the report list grid.

Support #: FRSSUP-5910

FRS-935 - Split Supplier Invoice Matching into Two Pages

The Accounts Menu has been changed to offer separate New and Find options for Ancillary Invoices, Invoice Matching and Credit Note processing.

  • Find Ancillary Invoice

  • New Ancillary Invoice

  • Find Supplier Invoice / Find Vendor Invoice

  • New Supplier Invoice / New Vendor Invoice

  • Find Credit Note

  • New Credit Note

Support #: FRSSUP-6214

FRS-901 - API Branch ID

The InsertSalesOrder API has been modified to accept the Branch ID and Salesperson ID (both of which much match records in SwanFRS).

Where set, the electronic order creation process will overwrite the system default settings for location and salesperson with those supplied by the web order creation software. This makes it possible to send web orders to variant selling locations commensurate with controls built into the web and to record sales across differentiating salespersons (be them pseudo salespeople.

Support #: FRSSUP-5806

FRS-894 - Search sales orders by SKU

The Find Sales Order program now allows the searching of sales orders by Supplier / Supplier-Range or SKU and for these settings to be saved as part of a search profile

FRS-891 - Stock Detail - New Parent ID Column

When looking at stock histories for accessory and measured goods the list of ‘child’ items now shows the ‘parent’ item. I.e. it is possible to see where the item originated. This shows the origin of the item.

In addition the Cut column now shows the NOT CUT and CUT badges making it clearer to see if the child is still ‘attached’ to the parent.

FRS-879 - Flat file data exports required for spreadsheet.

SwanFRS can be configured to send reference data used by the Product Creator Spreadsheet in the form of a data file which is then used by the spreadsheet to populate the product group, attributes, sales departments and relationships.

This allows all ‘static’ data to be maintained in SwanFRS and sent to the product creator spreadsheet to ensure consistency between systems.

If intending to use this feature, please log a ticket via the support portal as configuration is required to ensure smooth operation.

FRS-865 - Discontinued Control Logic

A new CAN_OVERRIDE_DISCONTINUED role privilege has been introduced to allow operators possessing it to place demand / purchase orders and to write on stock for discontinued products.

Support #: FRSSUP-5389

Fixes

FRS-1059 - SO30261 finance amount showing on finance claims report

The finance amount was not showing on finance claims report

Support #: FRSSUP-6600

FRS-1018 - Customer Signature on Legacy Order

When operating with digital customer signature capture, and processing a legacy sales order the routine no longer request s the capture of the customer's digital signature.

FRS-1017 - SwanFRS Tablet Discounting

Fixed an issue with the tablet version of Sales Order incorrectly requiring the user to have the privilege DISCOUNT in order to open sales orders.

Support #: FRSSUP-6462

FRS-1008 - Tablet - Allows discounting when order is accepted

The tablet ordering application has been modified to stop the operator from being able to discount an order when the order is in the accepted state.

FRS-1000 - Tablet - Home Page

When viewing the home page within the tablet, the page now shows the logout and desktop version buttons for both floating buttons and fixed button operation.

FRS-996 - Quick Search - Write Off Note

Fixed an issue where Write Off Notes created for “Multiple” locations were not returned by entering the Write Off Note number into the quick search field.

Support #: FRSSUP-6374

FRS-948 - Containers

Fixed an issue with updating the advised (expected) date on Containers, rippling through to attached purchase orders, when the confirmed checkbox has previously been checked.

Support #: FRSSUP-6228

FRS-947 - Containers - Acknowledgement date and Docking Date.

Container processing has been modified to ensure that when acknowledging import containers, the docking date is expected to be set to a date prior to the acknowledgement date.

Support #: FRSSUP-6228

FRS-940 - Sales Order Totals

When viewing the sales order where a mixture of line and order total discounts have been applied (and in particular in the US market where taxes are added to the selling price) it was difficult to establish the origin of the final order value.

For these orders, hovering over the order total produces a pop message (tool tip) showing the discount applied.

Support #: FRSSUP-4985

FRS-938 - Display Range & Debranded Range Names on Invoice Screens

Range and debranded range names added to invoice matching screens.

Support #: FRSSUP-6211

FRS-911 - Customer Update

Ensure that items returned for repair are processed using the settings as at the time of delivery, previously if the customer’s tax exemption status changed the return picked up the new rather than the original setting.

Support #: FRSSUP-6166

FRS-910 - Tablet - Line Discounts

Fixed an issue with the line discounting to ensure that discount types are not requested when the USE_DISCOUNT_TYPES parameter is not checked.

FRS-909 - Tablet - Line Discounts

The line discounting has been modified to show all individual lines along with the stock/inventory number to help users to differentiate the lines.

An issue with applying discount to order lines when there were multiple identical lines has been fixed along with an issue clearing discounts on the lines.

Support #: FRSSUP-6126

FRS-907 - Working Location

For mobile users, changing the location at login or via the “Swap Locations” option will now set the current workstation to the default workstation for the chosen location.

Support #: FRSSUP-6154

FRS-905 - Tablet - Sales Order Line - Discounted Price Field

Modifications to the tablet order line discounting have been applied to control when a discount can be added to the sales order line.

Support #: FRSSUP-6142

FRS-898 - Customer Service Details

Mobile numbers and original delivery address have been added to the service header display.

Support #: FRSSUP-5987

FRS-896 - Issuing a credit to cancelled order

Additional logic has been introduced to increase control relating to issuing a customer credit. The logic will now filter out ‘cancelled’ sales when looking for an order to add the credit to. If no sales orders are suitable, a new sales order will be created.

FRS-892 - Stock Detail - Disable Unscheduled Cut On Written Off Stock

It is now not possible to ‘unscheduled a cut’ once the measured stock item has been written off.

Support #: FRSSUP-5964

FRS-886 - Set Up Product Relationships

The set up product relationships program has been enhanced to stop the ability to add a product which already has a relationship built from being used as a related item.

FRS-885 - Pay and Take

The ordering process now checks the selling location to establish if it allows ‘pay and take’ items and prohibits the ‘pay and take’ choice for the sales order order line if not enabled for the selling location.

FRS-883 - Goods Receipt Note crashes when Purchase Order is 0.

The error produced when removing a previously processed GRN’d item ( in detail mode), where the item had previously had the number of units manually increased post purchase order creation, has been fixed.

FRS-870 - Service User - Notes

The logic relating to the list of recipients to entering an event within SwanFRS has been changed. Raising a note outside of service will offer any ‘active’ user as the note’s recipient (send message to). When in service only users with the ‘service operator’ checkbox ticked will be listed.

Reports

The following reports have been modified or created.

Report Name / Document Link

Details

Acknowledgement Discrepancy

new layout - added Stock ID

Banner SO

Process Related Reports

Fixed Balance to Pay box not showing

New vat relief form added

New Terms & Conditions

Barcode Bay Labels

Revised layout

Closing Costs

Refreshed Layout / Made to fit page

Duplicate Customer Addresses

Customer types 1 to 6 added

Customer Aged Debt Summary

Refreshed Layout / Made to fit page

Customer Aged Debt

Refreshed Layout

Customer Balance

Added delivery date to output

Customer Delivery Mail Shot

Added confirmed delivery date

Customer Event Audit

Added new customer type levels 1 to 6

Customer Export

Fixed issue with spaces trailing the location name 

Customer Payment Report

Refreshed Layout

Daily Sales Summary

Include cancelled lined whether or not on-hold status chosen

Display - Menu by Ticket Size

Add Ticket size sequence and supplier range selection

Duplicate Customer Addresses

Customer types 1 to 6 added

Single - 100mm x 40mm

New barcode logic for accessories

Goods Received Audit

added stock detail / reworked report layout

Free Stock Summary

Refreshed Layout

Labels

All standard labels have been modified to accommodate the new secondary barcode logic for accessories.

Run time prompts adjusted to show a meaningful question with defaults set where appropriate.

Multi bank label stationery format now off blank label specification

The restrictions relating to the class of the product wherever possible have been removed.

It is recommended that you review the label overview guide for a list of label formats.

Mass Stock Load Rejections

New report listing load failures

New

Display - Matrix Style - 1 Column

New Label design

New

Display - Matrix Style - Landscape

New Label design

New

Display - Matrix Style - Portrait

New Label design

New

New Commission - General

New Commission - Salesperson

New Commission - Supplier

New Commission System

Added Booked Quantity and ability to pay Spiff payment per SKU.

New Commission - Supplier is a new report

New

Open Orders Export

new export version of the OO report

New

Operator Access Log

New Design

Outstanding Order Report

Added Order Total

Payment Summary

Refreshed Layout

Product Extract

Added print sequence to Ticket_Size uses Ticket_Size_Seq attribute
Enhanced to accommodate Matrix Labels,

Now includes option and item choice attributes

Purchase Order Chase Export

new export version of the chase report

New

Sales Number Audit

Adjusted to fit the page

Sales Order Audit

Added a filter on event type to the Order Notes subreport to  ensure only Sales Order events are considered.

Sales Order Header Change History

New

SKU Sales

Added confirmed delivery date and refreshed the output

Stock Evaluation Enhanced Export

Make output Excel compatible
Added Category,PO, Receipt Date

Display - Menu by Ticket Size

Added SKU sequencing

Unallocated Payments by Customer

The Report was not sensing company Correctly

Product Creator Spreadsheet

The 1207 version of the spreadsheet has the following key developments.

  • Added Sequence number for use within menu ticketing,

  • Added matrix ticketing,

  • Fixed '0' alerts when adding new rows.

  • Added duplicate check to Options tab.

  • Fixed duplicate warnings being incorrectly issued.

  • Added option to add an image via a file select process

  • Block of row delete if exported

  • Auto Filter to hide / Show Include=N and discontinued lines

  • right click - show/add images

  • SKU finder

  • Alert on item attributes tab

  • Removed vlookup / background reference tables - speed improvement

  • Rework of mapping tabs

  • Enhanced control re setting paths and linked features

  • Added attributes to Options and Option/Choices - changes to Options and Choices tabs plus new Option Attributes and Option Choices tab added

  • Item tab shows green indicator if record changed since last export of XML data - right click on menu to hide / show amended lines & to reset control

Files from the Confluence page

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article