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
See Item Image Guide
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.
-
Write on date
-
Original Cost Price
-
Showroom indicator
-
Can’t sell indicator
-
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 |
|
new layout - added Stock ID |
|
|
Banner SO |
Fixed Balance to Pay box not showing New vat relief form added New Terms & Conditions |
|
Revised layout |
|
|
Refreshed Layout / Made to fit page |
|
|
Customer types 1 to 6 added |
|
|
Refreshed Layout / Made to fit page |
|
|
Refreshed Layout |
|
|
Added delivery date to output |
|
|
Added confirmed delivery date |
|
|
Added new customer type levels 1 to 6 |
|
|
Fixed issue with spaces trailing the location name |
|
|
Refreshed Layout |
|
|
Include cancelled lined whether or not on-hold status chosen |
|
|
Add Ticket size sequence and supplier range selection |
|
|
Customer types 1 to 6 added |
|
|
New barcode logic for accessories |
|
|
added stock detail / reworked report layout |
|
|
Refreshed Layout |
|
|
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. |
|
|
New report listing load failures New |
|
|
New Label design New |
|
|
New Label design New |
|
|
New Label design New |
|
|
New Commission - General New Commission - Salesperson New Commission - Supplier |
Added Booked Quantity and ability to pay Spiff payment per SKU. New Commission - Supplier is a new report New |
|
new export version of the OO report New |
|
|
New Design |
|
|
Added Order Total |
|
|
Refreshed Layout |
|
|
Product Extract |
Added print sequence to Ticket_Size uses Ticket_Size_Seq attribute Now includes option and item choice attributes |
|
new export version of the chase report New |
|
|
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. |
|
New |
|
|
Added confirmed delivery date and refreshed the output |
|
|
Make output Excel compatible |
|
|
Added SKU sequencing |
|
|
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
See Product Creator - Spreadsheet v1207
Spreadsheets are access via Product Creator (Spreadsheet)
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
Feedback sent
We appreciate your effort and will try to fix the article