Chain Web v. 2.10.80
Released 3rd of September 2021
Report for showing bonus points
In order to report on bonus points we have created Bonus per store report. This report allows the user to see monthly bonus usage per store for last 12 months.
Report details Bonus per store | |
File name | 0950_BonusPerStorePerEndOfMonth |
Data source | Reporting Data Warehouse |
Selections | Comment |
Retail store | Default none, multiselection possible |
Columns - Report is grouped per store, showing one row per month. | |
EndOfMonth | End of month |
Earned bonus | Earned bonus |
Used bonus points | Used bonus points |
Balance | Balance |
Expired bonus points | Expired bonus points |
Automatic logoff in Chain Web
Automatic logoff is defined by system parameters:
AutoLogoutWhenIdle - possible values True/False, defines if automatic logoff is enabled/disabled, default value False;
AutoLogoutWhenIdleTimeoutMinutes - defines (in minutes) after how long the user is logged out automatically , default value 30.
When the AutoLogoutWhenIdle=True and AutoLogoutWhenIdleTimeoutMinutes <=10, then the notification that user will be logged out soon is displayed when half of AutoLogoutWhenIdleTimeoutMinutes will pass, when user is idle.
When the AutoLogoutWhenIdle=True and AutoLogoutWhenIdleTimeoutMinutes >10, then the notification that user will be logged out soon is displayed when 5 minutes are remaining to the automatic logoff, when user is idle.
When the user is active in at least one tab, then the user will stay logged in all opened tabs.
Search for bank card number in receipt journal
Searching for receipts paid with given bank card numbers:
1) Some payment providers save card number as ************0690 MASTERCARD. The user should then search for only 0690, or even better 0690 MASTERCARD to find the receipt.
NB! Due to technical searching limitations (in SQL Server) it is not possible to search with '' as this is removed from searching index. If the user pastes the whole card number *****0690 we remove ******* and use 'starts with' 0690 in the search.
2) Some payment providers save card number as xxxxxxxxxxxxxx6409-05. The user should then search with xxxxxxxxxxxxxx6409 (the whole string before '-'), with all the 'x' characters. If the users adds to few x, for example with xxx6409-05, the receipt will not be found.
NB! The the search technology saves the whole card number including 'x' as this is interpreted as a word, and the search uses 'starts with' to find the searching words in the index. The character '-' is removed, and also leading zeros are removed, so the user cannot in above example search for 6409-05, only for 6409.
Improvements
Balance | Balance summary (RTC-9741) |
Customer | Maximum credit limit when updating customers through ARTS Customer import (RTC-15225) Import of customer with invalid mobile number (RTC-9100) Requirement: BackOffice batch generator 1.5.3 |
Customer order | Search for offers (RTC-14959) Search for orders in Package deliveries (RTC-14960) Fix for refund (RTC-7054) |
Invoices | Search for invoices (RTC-13704) |
Receipt journal | POS unit filtering (RTC-9114) Fixed a problem where POS unit filter field were not removed as it should. Fix for timeout when searching in large receipt journals (RTC-15143) Filter for stock adjustment transactions (RTP-13122) Open drawer transactions (RTP-11413) Search for old receipts (RTC-7875) |
Reports | Store users of report 0010 (RTC-14884) New reports, with interactive sorting (RTC-14253)
New hidden parameter pKlarna - needs to be set to Klarna payment card number. Changes in report 0750_WetStock (RTC-14762) Font was changed from 10pt -> 8pt. Width and Hight of cells were changed. Following column names was reorganized and changed:
|
Stocktaking | Minor improvements in user interface (RTC-14104) Cleanup of old count groups (RTC-13902) Cleanup of old counting groups (http://RTC-15659) Exclude items with specific assortment codes when creating stocktaking (RTC-11066) System parameter AssortmentCodesToExcludeInStocktaking defines list of assortment codes, that will be excluded from the stocktaking basis. Created date in the count groups view (RTC-15733) Filter on supplier and brand when creating count groups (RTC-12666) |
User Management | Cashier permissions through cashier roles with system roles (RTC-12125) A predefined set of system roles for cashiers can be added to a cashier role (not directly to the cashier/user). When creating a new cashier or editing an existing one, System Roles are not displayed in dropwdown list. If user has a system role granted from previously, it is displayed only in Cashier roles window. After removing it, user isn't able to add System Role to the cashier again. |
Chain Web v. 2.10.70
New Report based on EOD
New report showing sales per item group where period is based on EOD (End of day). Made based on report 0600.
Report details Sales per item | |
---|---|
Filename | 0609_SalesPerArticleWithBreakage |
Data Source | Lindbak POS Reporting DW and Lindbak POS Message Service |
Selection | Comment |
Date from | Default last available End of day |
Date to | Default last available End of day |
Relevant hidden parameters: | |
pRetailStore | Store, default 1001 |
pReasonCodesExcluded | Reasons codes which will be excluded from breakage fields. Default 14 and 15. |
Columns - One row per item group | |
Article Group Key | Article group key |
Article Group name | Article text |
Quantity | Quantity sold |
VAT Class | Shows 4 if VAT% is 8, Shows 3 if VAT% is 15, shows 2 if VAT% is 25, shows 1 on all other values. |
VAT % | VAT percentage |
Ex. VAT | Shows sales excluding VAT |
VAT | Shows VAT amount |
Sales w/VAT | Shows sales including VAT |
Butikknr | Retail Store |
Net Cost | Net cost |
Breakage Quantity | Quantity of broken items |
Breakage Net Amount | Net cost of broken items |
New report showing top sales per item
In order to follow up on sales, a new report is created, showing top x sold items, grouped by area, item group or store.
Report require POS Reporting version 69.
Report details Top sales item | |
---|---|
File name | 0454_TopSalesPerItemWithItemInfo |
Data source | Analysis services (Cube) and Lindbak POS Reporting DW (Database) |
Selections | |
Date from | Default today |
Date to | Default today |
Compare date from | Default same day in same week last year |
Compare date to | Default same day in same week last year |
Retail store | Default all |
Article area | Default all |
Article group | Default all |
Grouping | Default area |
Count | How many items to show - Default 10. Default valuye can be change in hidden parameter pCount |
Sort type | If items sould be sorted by best or wors - Default best. Default value can be change in hidden parameter pSortType |
Sort measure | What mesure to sort by. Available measures are Amount, Quantity, Net Cost, Gross profit or Gross profit %. Default Amount |
Include VAT | If VAT should be included in sales amount or not. Default Yes. Default value can be changed in hidden parameter pIncludeVAT |
Vendor | Default all |
Subvendor | Default all |
EAN list | Default empty |
Columns - One row per item | |
Area | Article area |
Grp | Article group |
EAN | EAN |
Item name | Item name |
Article info | Label text 2 |
Date from | Date to |
Quantity | Quantity sold |
Turnover | Sales amount |
Gross profit | Gross profit |
Gr. prof. % | Gross profit percentage |
Compare date from | Compare date to |
Quantity | Quantity sold |
Turnover | Sales amount |
Gross profit | Gross profit |
Gr. prof. % | Gross profit percentage |
Sales Report per department/area based on EOD
New report showing sales per department in 4 tables divided by Article group numbers. Period is based on EOD (End of day).
Report details Sales per department | |
---|---|
Filename | 0608_SalesPerDepartment |
Data source | Lindbak POS Reporting DW database |
Selections | Comment |
Retail store | Store, default first store in list |
Year | Default current year |
EOD Date from | Default last available EOD |
EOD Date to | Default last available EOD |
Include nonsale | If nonsale is included in sale. Default true |
Relevant hidden parameters | |
pArticleGroupList1 | Add Article Group numbers for Articles to be displayed in first table (Fuels) |
pArticleGroupList2 | Add Article Group numbers for Articles to be displayed in second table (Retail goods) |
pArticleGroupList3 | Add Article Group numbers for Articles to be displayed in third table (Automatic Car Wash) |
pArticleGroupList4 | Add Article Group numbers for Articles to be displayed in fourth table |
pIncludeNonsale | If Include nonsale should be default true or false |
Columns - One row per distinct combination of Department, Article Area and Vat% | |
Department | Department number |
Dept name | Department name |
Area no | Article Area number |
Area name | Article Area name |
Quantity | Quantity sold |
VAT class | Shows 4 if VAT% is 8, Shows 3 if VAT% is 15, shows 2 if VAT% is 25, shows 1 on all other values |
VAT% | VAT percentage |
Ex. VAT | Shows sales excluding VAT |
VAT | Shows VAT amount |
Sales w/VAT | Shows sales including VAT |
Sales report per item/item group based on EOD
New report showing sales per item / item group where period is based on EOD (End of day).
Report details Sales per item | |
---|---|
Filename | 0607_SalesPerItemInGroup |
Data source | Lindbak POS Reporting DW database |
Selections | Comment |
Retail store | Store, default first store in list |
Year | Default current year |
EOD Date from | Default last available EOD |
EOD Date to | Default last available EOD |
Include nonsale | If nonsale is included in sale. Default true |
Article group | Default All |
Relevant hidden parameters: | |
pIncludeNonsale | If Include nonsale should be default true or false |
Columns - One row per item. Group by Item group / VAT | |
EAN | EAN |
Item | Article text |
Quantity | Quantity sold |
VAT class | Shows 4 if VAT% is 8, Shows 3 if VAT% is 15, shows 2 if VAT% is 25, shows 1 on all other values |
VAT% | VAT percentage |
Ex. VAT | Shows sales excluding VAT |
VAT | Shows VAT amount |
Sales w/VAT | Shows sales including VAT |
Receipt Journal Access
There is a new tab named Journal Access in user view. In this tab user is able to choose one of two options. This choice impacts to which stores user has access in Receipts Journal. After selecting the first option, available stores
match permissions given in User tab. When second option is chosen, user has access only to stores which are included in the selected configuration group. If user has "Manage receipts for all stores" access role, all stores are
available in Receipts journal view. If user has access to the configuration group which has become empty or inactive, available stores match permission from User tab.
Journal access tab in editing user view will be visible only if configuration parameter JournalAccessStoreConfigurationGroup is set to True (default value is False)
Password requirement when changing password in POS and Chain Web
New system parameter CashierPinCodeLength has been added. It defines the minimal length of the cashier password. Default value of this parameter is 6. When cashier's password is changed, it will be validated if it is shorter than the value defined in CashierPinCodeLength parameter. Additionally, the current password cannot be reused as the new cashier password.
Improvements
Module | Description |
---|---|
Accounts receivable | Manual adjustment of credit balance (RTC-8235) User with permission is able to correct customer credit balance. There is also a possibility to check the balance history. Corrections of the balance will be saved in the balance history as a recharge or as a deduction of funds. |
Balance | Receipt Journal requires store to be selected (RTP-12435) Receipt Journal requires store to be selected When a HQ user filter receipts in Receipt Journal and does not select a store filter - receipts for all stores will be shown by default.
When an active campaign price is lower than the originally paid price of an item it is refunded without errors. Add permission for edit balance older than x hours (RTC-9862) New system parameter "EditBalanceNotPermittedIfOlderThanHours" which defines time (in hours) after which the editing of balance will not be permitted if user is not HQ user or does not have proper permission. |
Customer Orders | Editing a row in Customer Order (RTC-10476) Net cost field has been renamed to Weighted net cost. This field's working principle didn't change - Weighted net cost is equal to the result of multiplying the UnitNetCost by the QuantityOrdered. There is also a new field named Net cost and it's equal to net cost field in the database.
When a click & collect order is deleted in EG POS, the order will be marked as deleted and also the picking order details with lines will be deleted from Chain Web. The picking order will be correctly marked in Chain Web with the PickingOrderStatus = Delivered after the picking will be finished in EG POS. |
General | Simple search (RTC-14386) Improvements were made to the "simple search" in the Items grid, in customer search of sales/ orders/ grids and and in the other Chain Web areas where the simple search is used. |
Gift card | Migrate all data (RTC-8096) New job AllGiftCardsExporter has been added to the GiftCards Integration package. It exports all giftcards (both active and inactive) with transactions to the blob GiftCardUpdated2 (contract in gifcardservice version 2). This job should be enabled only when giftcard service version 2 is used. Resend digital gift card (RTC-14111) There is a DigitalGiftcardEnabled in System Parameters. It decides which button to show in Gift cards view. If this parameter is set to true, user has the possibility to resend gift card. If this parameter is set to false, user has possibility to remind PIN. |
Item | Search for items per store (RTC-13062) User is able to see items for each store when using "Search for item" (simple search) in the Items' grid. |
Order Dispatch | Returning order lines (RTC-11715) It is not possible to return more order lines than allowed - for example, when user is trying to return the same order line in two separate browser windows. The proper message is visible in three languages - English, Norwegian and Swedish: |
Reports | Bestseller report (RTC-13118) We have changed name of "sum" column to clarify that amounts are in thousands Changed report: Bestseller (0041_BestSellerPerStorePerArticle) Sales statistics report (RTC-10886) Some improvements have been made in report Sales statistics. In some cases, values for gross profit % excluding campaign would show n/a insetead of percentage value. Changed report: 0714_SalesStatisticsWithDrill Report 8002 - Credit Sales (RTC-12775) Deleted receipts are no longer shown in report 8002. Selection on price channel in reports (RTC-13892) To improve reporting on sales from different channels, we have added Price channel as selection in following reports: Cashier statistics report (RTC-13893) To improve following up cashiers, we have created new report. Translation: "No reports available" (RTC-14193) If there aren't any reports in the Reports view, following message is displayed: "Ingen rapporter tilgjengelig". |
Shift Balance | Balance date is set to "End Shift" date (RTC-14353) When balance is configured to use shift, the balance date in shift balances is equal to the date of End Shift. Expected values on tenders while doing edit balance operation (RTC-14602) The proper expected values for tenders are displayed while editing shift balance or new cashier balance registration. |
Stocktaking | Stocktaking improvements (RTC-8023, RTC-7724) The following changes are implemented in the stocktaking module:
There are some changes in stocktaking's area. In some grids there are new columns: Created by, Modified Date and Modified by. Those columns are hidden by default. Also, Date column is renamed to Created Date. |
System | Logging in Integration Platform (RTP-12974) A logging issue with LIP in cloud where disconnected users was logged as exceptions is corrected. |
User Management | Filter on modified date (RTC-9094) User is able to filter modified date column in the User view. |
Chain Web v. 2.10.65
Released 12th of January 2022
Improvement
Missing shift settlement (RTC-18432)
Shift settlements from one cash register did not show in Chain Web when shifts with a Shift-ID that already existed from another cash register in the same store. This is improved.
Shift ID is no longer unique per store. The same shift ID within the same store can be used, but only once per cash register.
Chain Web v. 2.10.64
Released 21 September 2021
Improvement
Fix for permissions (RTC-15672)
When parameter UsersCanOnlyAssignRolesTheyAreAssignedTo is active and some user is editing the other one, the added/removed are changed only for that user (not for the user that are editing as well).
Chain Web v. 2.10.62
Released 8th of July 2021
New report - Sales per item
New report showing sales per item group where period is based on EOD (End of day). Made based on report 0600.
Report details Sales per item | |
---|---|
Filename | 0609_SalesPerArticleWithBreakage |
Data Source | Lindbak POS Reporting DW and Lindbak POS Message Service |
Selection | Comment |
EOD Date from | Default last available End of day |
EOD Date to | Default last available End of day |
Relevant hidden parameters: | |
pRetailStore | Store, default 1001 |
pReasonCodesExcluded | Reasons codes which will be excluded from breakage fields. Default 14 and 15. |
Columns - One row per item group | |
Article Group Key | Article group key |
Article Group name | Article text |
Quantity | Quantity sold |
VAT Class | Shows 4 if VAT% is 8, Shows 3 if VAT% is 15, shows 2 if VAT% is 25, shows 1 on all other values |
VAT % | VAT percentage |
Ex. VAT | Shows sales excluding VAT |
VAT | Shows VAT amount |
Sales w/VAT | Shows sales including VAT |
Butikknr | Retail Store |
Net Cost | Net cost |
Breakage Quantity | Quantity of broken items |
Breakage Net Amount | Net cost of broken items |
Improvement
Expected values on tenders while doing edit balance operation (RTC-14602)
The proper expected values for tenders are displayed while editing shift balance or new cashier balance registration.
One label "Counted" has been renamed to "To bank" in shift balance creation process in register bag step for a better user experience.
Chain Web v. 2.10.61
Released 30th of June 2021
New user interface for handling stores in Dispatch rules
The overview section in Dispatch rules consists of general information regarding current Web shop store, how many central warehouse stores, Dispatch stores or Pay & Collect stores are set:
The edit button in the overview section redirects user to the Stores grid:
User can filter the selected store/stores, set one or more stores as warehouse, P&C store or Dispatch store. In the grid there is a possibility to filter the stores and its current settings.
It is possible to set one or more stores as Warehouse, P&C store or dispatch store by using particular buttons - or to use new popup where the user can add/remove the settings for single store:
Additionally, user can save settings without activating or save + activate settings. Furthermore, it is possible to export store grid to Excel to get a complete overview of all stores and which store category they fall under.
Configuration of sub menu in PLU Board in POS Configuration
The configuration of PLU Boards (convenience sales mode) supports sub menus.
Sub menus are added like this:
Enter button title and upload the desired image for the button.
Sub menus are displayed like this in the parent page (arrow top right corner of the button):
Sales Report per department/area based on EOD
New report showing sales per department in 4 tables divided by Article group numbers. Period is based on EOD (End of day).
Report details Sales per department | |
File name | 0608_SalesPerDepartment |
Data source | "Lindbak POS Reporting DW" database. |
Selections | Comment |
Retail store | Store, default first store in list. |
Year | Default current year. |
EOD Date from | Default last available EOD. |
EOD Date to | Default last available EOD. |
Include nonsale | If nonsale is included in sale. Default True. |
Relevant hidden parameters: | |
pArticleGroupList1 | Add Article Group numbers for Articles to be displayed in first table (Fuels). |
pArticleGroupList2 | Add Article Group numbers for Articles to be displayed in second table (Retail goods). |
pArticleGroupList3 | Add Article Group numbers for Articles to be displayed in third table (Automatic Car Wash). |
pArticleGroupList4 | Add Article Group numbers for Articles to be displayed in fourth table. |
pIncludeNonsale | If Include nonsale should be default True or False. |
Columns - One row per distinct combination of Department, Article Area and Vat%. | |
Department | Department number |
Dept name | Department name |
Area no | Article Area number |
Area name | Article Area name |
Quantity | Quantity sold. |
VAT class | Shows 4 if VAT% is 8, Shows 3 if VAT% is 15, shows 2 if VAT% is 25, shows 1 on all other values. |
VAT% | VAT percentage. |
Ex. VAT | Shows sales excluding VAT. |
VAT | Shows VAT amount. |
Sales w/VAT | Shows sales including VAT. |
Sales report per item/item group based on EOD
New report showing sales per item / item group where period is based on EOD (End of day).
Report details Sales per item | |
Filename | 0607_SalesPerItemInGroup |
Data source | "Lindbak POS Reporting DW" database |
Selections | Comment |
Retail store | Store, default first store in list. |
Year | Default current year. |
EOD Date from | Default last available EOD. |
EOD Date to | Default last available EOD. |
Include nonsale | If nonsale is included in sale. Default true. |
Article group | Default All |
Relevant hidden parameters: | |
pIncludeNonsale | If Include nonsale should be default True or False. |
Columns -One row per item. Group by Item group / VAT | |
EAN | EAN |
Item | Article text. |
Quantity | Quantity sold. |
VAT class | Shows 4 if VAT% is 8, Shows 3 if VAT% is 15, shows 2 if VAT% is 25, shows 1 on all other values. |
VAT% | VAT percentage. |
Ex. VAT | Shows sales excluding VAT. |
VAT | Shows VAT amount. |
Sales w/VAT | Shows sales including VAT. |
Daily report for fuel sales
This report will allow the user to gain insight on the fuel sales per day and view the stock, and stock variance per day.
Report: 0751_DailyWetStock
Report for showing fuel and sales
In order to report on fuel stock and sales we have created a wet stock report. This report allows the user to monitor whether the actual fuel stock is correct compared with the amount of fuel sold.
Report details Wet stock | |
File name | 0750_WetStock |
Data source | Reporting cube (Olap) |
Selections | Comment |
Date from | Default 1. of previous month. |
Date to | Default last day of previous month. |
Retail store | Default all |
Relevant hidden parameters: | |
pVariance | Threshold when to color columns for Daily Variance orange. Default 200. |
pVariancePrc | Threshold when to color columns for Daily Variance %. Default 0,75% |
Columns - Report is grouped per fuel tank group, showing one row per day in selection. | |
Date | Date |
Opening Stock | Stock from automatic or manual reading. If not available it will be calculated. If calculated values will be shown with pink color. |
Deliveries | Delivery transactions (from Chain). |
Sales | Sales for tank group (from POSLog) |
Adjustments | |
Book Stock | Opening stock + Deliveries - Sales. |
Actual Stock | Stock from reading. |
Water Measure In Tank | Water in liters, if value is not 0 it will be colored red. |
Daily Variance | Difference between actual and book stock in liters. If value exceeds value from pVariance it will be colored orange. |
Daily Variance % | Daily variance divided by sales, in percentage. If value exceeds value from pVariancePrc it will be colored red. |
5 Day Cumulative Variance | Difference between actual and book stock in liters, last 5 days. |
5 Day Cumulative Sales | Sales for tank group, last 5 days. |
5 Day Cumulative Variance % | Daily variance divided by sales, in percentage, last 5 days. |
31 Day Cumulative Variance | Difference between actual and book stock in liters, last 31 days. |
31 Day Cumulative Sales | Sales for tank group, last 31 days. |
31 Day Cumulative Variance % | Daily variance divided by sales, in percentage, last 31 days. |
Improvements
Balance | Shifts receipts in Receipt Journal (RTP-11724) |
Customer | Import of item list in customer group discount (RTC-13360) |
Dispatch rules | Automatic Reassign: Issue with Delivery Method Configuration (RTC-11608) |
Invoicing | Date when adding payment of invoice (RTC-13609) |
Gift card | Resend digital gift card (RTC-8266) |
Order dispatch | Handle lack of delivery suggestions from DispatchService (RTC-13806) Issue deleting order lines with unsupported characters (RTC-10215) |
Reports | Deleted receipts in Store settlement report (RTC-12984) Changed report: 0450_StoreSettlementPerOperator. Report sales per profile (RTC-13527) 0100_WeekReport |
Shift balance | Fix for inbound amount (RTC-13861) Balance date is set to "End Shift" date (RTC-14353) |
Stocktaking | Item synchronization performance (RTC-10344) |
User Management | Create AD users (RTC-12968) All AD users created during the period that the bug was present will have to be deleted. |
Chain Web v. 2.10.55
Released 15th of October 2021
Improvements
Dispatch - Persist delivery status of order (RTC-16419)
Dispatch order grid and details view load under 1s.
Improvements Reporting (RTC-15732)
To make sure all reports using sub-report 1700_subSettlement and 1706_subStatistics, we have made sure reports will work with older versions of Reporting.
Shift balance - Expected values on tenders while doing edit balance operation (RTC-14602)
The proper expected values for tenders are displayed while editing shift balance or new cashier balance registration.
One label "Counted" has been renamed to "To bank" in shift balance creation process in register bag step for a better user experience.
Chain Web v. 2.10.50
Released 31st of May 2021
Update POS with order line split
Support for creating multiple picking store per one delivery line in customer order has been implemented. It is possible to a create dispatch order which could have one delivery line split into two or more lines to different stores with different quantities (according to the DispatchService suggestion). If one store are not able to deliver all items from one order line it will be split between one or more stores, so that the customer ultimately received the number of items ordered.
Shift Balance
(RTC-12255, RTC-12258, RTC-12259, RTC-12370, RTC-13386, RTC-12366)
Balance registration for retailers using shifts is available in menu Financials → Shift balances.
The grid shows created shifts sorted by newest on top, with standard functionality for filtering and sorting. User can create a new balance or edit an existing one for the selected shift. All changes are handled as a standard balance, which are displayed in Balances.
The user can preview document with details of given shift, and download the document as PDF:
Furthermore, access controls are available which allow granting or revoking permissions from users for Viewing, Creating and Editing Shift Balance. When POS Configuration for ReceiptStatistics is set to True, the receipt statistics are fetched and saved in Shift balance. Ingoing balance information is shown in the balance header. Shifts are sorted by Started Date descending in shifts' grid. Additionally, the user can see shifts' starts and ends in Receipt journal. They are located in Receipt type filter in System transactions -> Other.
When the task "StartEndShift" is enabled in POS Services worker, Shifts' tasks are created. Then the shifts are created in Retail database by balance service. Update EnabledTasks parameter in config of POS Services Worker with new value "StartEndShift".
New report for payment types per shift
New report showing relevant statistics related to payment for selected shifts (0851_PaymentTypesPerShift). This will allow retail chains using shifts to monitor and follow up on the transactions and events during specific shifts.
Report details | |
File name | 0851_PaymentTypesPerShift.rdl |
File name sub-reports: | 1700_subSettlement.rdl, 1706_subStatistics.rdl |
Data source | Analysis services (Cube) |
Selections | Comment |
Date from | Shows all shifts with stated date between Date from and Date to - Default today. |
Date to | Shows all shifts with started date between Date from and Date to - Default today. |
Retail store | Choose store. |
Workstation | Default all. |
Shift | Default all in chosen date range. |
Columns - Report shows 2 sub reports. | |
Settlement: (1700_subSettlement.rdl). 1 row per payment type: | |
Received | Sum of received payments for payment type. |
Balance | Sum of counted amount for payment type. This is only shown for Cash, Finance, Check and Total all coupons and Gift cards. |
Difference | Difference between received amount and counted amount for payment types that have counted amount. |
Quantity | Number of payments. |
Statistics (1706_subStatistics.rdl): | |
Description | 1 row per Cancelled receipts, Receipts with return, Returned items, Deposit refund received 12%, Deposit refund received 25%, Deleted items, Price change and Nullsale |
Amount | Sum amount, only for Returned items, Deposit refund received 12%, Deposit refund received 25%, Deleted items. |
Quantity | Quantity |
Share | Share of the sale. Only for Returned items, Deposit refund received 12%, Deposit refund received 25%, Deleted items. |
Improvements
Customer | Import customer in ARTS XML format (RTC-13193) |
Gift card | Synchronizing gift cards to cloud (RTC-13372) Gift cards are exported to the cloud also when there are committed transactions with amount =0. Fix for regive of gift cards (RTC-12236) When regive operation is done, ownerClaimType is set if it previously was empty. Requirement: Giftcards Integration package 1.4.0. |
Invoicing | Fix for resend of EHF (RTC-12240) When opening Resend EHF, list of not sent EHFs are displayed properly, without timeout. User can customize results by using filter in column sent. |
Receipt journal | View workstation startup transaction (RTC-12756) User can see workstation's starts in Receipt journal. They are located in Receipt type filter in System transactions -> Other. |
Stocktaking | Check if update of stocktaking is completed (RTC-13035) It is possible to enable/disable checking check if update of stocktaking is completed during creation of new stocktaking. System Parameter: CheckForCompletedPosLogsInChainEnabled True/False that decide if we are checking the last POSLog in Chain Classic or not. The main functionality was implemented in RTC-776. The Inventory transactions (POSLogs) that are cancelled (when the processing of all items will fail), will be excluded from check for the last processed transactions in Chain Classic during stocktaking creation. New column SourcePosLogCancelled was added in the StockAdjustmentBatch with the information if the POSLog was cancelled during the adjustment. If all lines failed, then the receipt is cancelled, if there is at least one not failed line, then POSLog is not cancelled and the StockAdjustmentBatch will be marked with the default value False in SourcePosLogCancelled column. |
Chain Web v. 2.10.40
Released 26th of May 2021
Cashier statistics
In report for cashier statistics (0018) three new columns are added.
Changed report: 0018_CashierStatistics_std / Cashier statistics
New columns:
Waste - Shows values for transaction type Breakage. It is possible to set up Report to show only Breakage with spesific Reason code. This is done by setting ReasonCode in parameter pReasonCodeWaste.
Discount - Shows number of articles with discount.
Scan % - Shows percentage of scanned articles (Scanned articles / Sum quantity articles).
Support shifts when counting per cash register
(RTP-4895)
Previously, drawer balance has been registered and validated per date and either per register/workstation, cashier or store. New parameter has been created to support shifts when counting per cash register.
New report for shift statistics
New report showing key statistics for retail chains working per shift.
Report details for Shift statistics | |
File name | 0850_ShiftSatistics.rdl |
Data source | Analysis services (Cube) |
Useful hidden parameter | |
pDeletedStatuses | Which deleted statuses to include for column "Deleted Amount" and "Deleted quantity". |
Selections | Comment |
Date from | Shows all shifts with stated date between Date from and Date to - Default today |
Date to | Shows all shifts with stated date between Date from and Date to - Default today |
Retail store | Default all. |
Columns - one row per shift. | |
ShiftID | Shift ID |
Start | Start time for shift. |
Stop | Stop time for shift. |
Cashier | Cashier name. |
Customers | Number of customers for shift. |
Nullsale | Number of nullsale and drawer openings for shift. |
Deleted amount | Amount of deleted items. |
Deleted quantity | Number of deleted items. |
Avg amount | Average transaction value (sold amount / customers). |
Cashier statistics report
(RTC-794)
A new cashier statistics report is created to analyze and investigate cashier behavior. In order to create this report, the following changes are implemented in Reporting:
Order history is stored in new table: FactOrderHistory
Order history data is added to Olap.
Report requires Reporting v. 67
Report details for Cashier statistic | |
File name | 0904_CashierStatistics |
Data source | Lindbak POS Reporting cube (Olap). |
Parameters | |
pCustomerGroupPersonell | Which customer group personell belongs to. Default value = 100. |
pDiscountReasonCodeType | Which reasoncodetype to include in Manual discount - Default LineDiscount. |
pManualDiscount | Which discount type to include in Manual discount - Default Line. |
Filters | Comment |
Date from | Default today. |
Date to | Default today. |
Retail store | Default all. |
Operator | Default all. |
Columns - one row per operator. | |
Cashier | |
No | Cashier number |
Name | Cashier name |
Returns | |
Qty | Quantity of returned articles. |
Amount | Amount of returned articles. |
Deleted receipts | |
Qty | Quantity of deleted receipts. |
Amount | Amount of deleted receipts. |
Deleted item lines | |
Qty | Quantity of deleted item lines |
Amount | Amount of deleted item lines |
Manual discount (discounts filtered by parameter pManualDiscount and pDiscountReasonCodeType ) | |
Qty | Quantity of manual discounts |
Amount | Amount of manual discounts |
Diff settlement (difference between tender cash and balance cash) | |
Amount | Difference in amount. |
Deleted web orders (orders with order type "WebShop Order" and order status "Deleted") | |
Qty | Quantity of deleted web orders. |
Amount | Amount of deleted web orders. |
New customer orders (orders with order type "Store Order" and status "Created") | |
Qty | Quantity of new customer orders |
Amount | Amount of new customer orders |
Offline coupons (tender coupons with coupon type = "O" | |
Qty | Quantity of offline coupons. |
Amount | Amount of offline coupons. |
Personell discount (discount with customers from customer group in parameter pCustomerGroupPersonell) | |
Qty | Number of receipts containing personell discount. |
Support for hiding homepage dashboard
(RTC-8234)
System parameter KpisEnabled is correctly handled and kpis's on home page are hidden when parameter is set to False.
Required Configuration
System parameter KpisEnabled = True kpis are visible on home dashboard
System parameter KpisEnabled = False kpis are not visible on home dashboard. Only reports and favorites should be visible.
Measure SLA fulfillment in hours not days
(RTC-9698)
The option that measures the SLA fulfilment in hours has been added to CustomerOrderDeliverSlaType in CustomerOrderDeliveryMethod config. To enable configuration of hours value for CustomerOrderDeliverSlaType_, the DeliverySlaValue was added to CustomerOrderDeliveryMethod config too. To ease providing appropriate value, the descriptions for CustomerOrderDeliverSlaType have been added to the system parameter.
Required configuration:
In System parameters-> CustomerOrderDeliveryMethod:
Possible values for DeliverySlaType are:
"1" - Today,
"2" - Tomorrow,
"3" - Days 3 to 4,
"4" - Days 3 to 10,
"5" - Hours (was added)
When Hours is set as DeliverySlaType (was added) , the DeliverySlaValue has to be set to the number of hours.
Improvements
Balance | Historical exchange rate in Balance (RTC-12275) |
Customer | Import of customers without SSN (RTC-12873) |
Customer order | Deleting an order line in payment mode in POS should not delete order line in Chain Web (RTC-12235) |
Dispatch orders | Dispatch Orders - Performance improvement (RTC-11645) |
Dispatch rules | Order line split (RTC-10889)
|
Item | Performance improvement in Item grid (RTC-10402) When opening Items grid, list of items is displayed. User can narrow and customize results by using filters in columns or write key word in simple search window to find a specific item. |
POS Configuration | "English text" on menu buttons (RTP-11379) |
Reports | Sales per department (RTC-12048)To make PDF print look better we have made minor adjustment to column widths. The formatting of some columns are improved to only show two decimals.
|
Chain Web v. 2.10.35
Released 17th of September 2021
Improvement
POS unit filtering in Receipt journal (RTC-9114)
Fixed a problem where POS unit filter field were not removed as it should.
Chain Web v. 2.10.34
Released 8th of September 2021
Improvements
Date when adding payment of invoice (RTC-13609)
When adding payment to the invoice, payment date from date picker is displayed and processed in correct format, according to user settings. When for example the user has Norge as region, the date is displayed in Norwegian date format.
Date when adding payment of invoice (RTC-13609)
When adding payment to the invoice, payment date from date picker is displayed and processed in correct format, according to user settings. When for example the user has Norge as region, the date is displayed in Norwegian date format.
POS API - Refund of active campaign items in Chain Web (RTP-12075)
When returning items in Chain Web and an active campaign price is lower than the originally paid price of an item, it can be refunded without errors.
Receipt Journal requires store to be selected (RTP-12435)
When a HQ user filter receipts in Receipt Journal and does not select a store filter - receipts for all stores will be shown by default.
View workstation startup transaction (RTC-16118)
User can see shift's starts/ends, workstation's starts and signing in/out in the Receipts journal. They are located in Receipt type filter in System transactions -> Other.
Chain Web v. 2.10.33
Released 11th of June 2021
Improvements
Support for hiding homepage dashboard (RTC-8234)
System parameter KpisEnabled is correctly handled and kpis's on home page are hidden when parameter is set to False.
Required Configuration:
System parameter KpisEnabled = True KPIs are visible on home dashboard.
System parameter KpisEnabled = False KPIs are not visible on home dashboard. Only reports and favorites should be visible.
Create AD users (RTC-12968)
We fixed a bug related to changes in AAD integration that broke the functionality in User Management for creating normal AD users.
All AD users created during the period that the bug was present will have to be deleted.
Chain Web v. 2.10.32
Released 02nd of June 2021
Improvements
POS Configuration - Configuration group - stores without PrivateStoreGroup triggers errors (RTP-11908)
Correct stores are properly returned and can be added in the store group configuration section without errors/ warnings. The stores which doesn't contain PrivateStoreGroup will not be available in this view, and will be unlinked from the configuration group after save of it.
Synchronizing gift cards to cloud (RTC-13372)
Gift cards are exported to the cloud also when there are committed transactions with amount =0.
Fix for regive of gift cards (RTC-12236)
When regive operation is done, ownerClaimType is set if it previously was empty.
Requirement: Gift cards Integration package 1.4.0.
Chain Web v. 2.10.31
Released 28th of April 2021
Improvements
Account Receivable | Validation of payment date (RTC-10893) |
ChainToCloud | Add support for new file types (RTM-236) Required: ChainToCloudIntegration package version 1.6. |
Customer | Importing item list to customer group (RTC-9646) Import of customers with SSN (RTC-11762) Default invoice by email to customers with email address (RTC-9742) |
Customer order | Bugfix: Calculation of gross profit (RTC-11944) When adding new items to customer order and changing the unit price and net cost, gross profit is calculated according to the new values. Offer expiration date (RTC-9887) Disable the order locking functionality by default (RTC-11511) Parameter description: Customers blocked for credit (RTC-11586) Preventing simultaneously changes to a customer order (RTC-908) Additional technical information: Order locking feature will work with versions EG POS 3.0.0.12401 or newer. |
Homepage dashboard | Refresh data automatically when changing store (RTL-133) Wrong Mapping For Sales Per Hour (RTC-3144) |
Invoicing | Summation per receipt (RTC-9721) |
Item | Performance improvement in Item grid (RTC-10402) |
Order dispatch | Partially delivered dispatch orders (RTC-10302) Update picking order with shipment number when delivered from AutoStore (RTC-7709) |
Order Management | Rejected order lines (RTC-10838) This is done by existing package FactOrderRetail. This package require Retail database version 2.10.0.7 or higher because of new procedures. Note: There are some limitations to this functionality: To get rejected status we need to fetch changes in Retail db and changes in POSLog. In some cases this can result in incorrect status for Order lines.
|
Reports | Swedish translations (RTC-12047) |
Stocktaking | View and filter stocktaking's (RTC-12540) |
Chain Web v. 2.10.24
Released 29th of April 2021
Improvements
Fix translations for Order Dispatch (RTC-12098)
Translations in Dispatch Rules has been improved and English and Norwegian version is working as expected.
Swedish translations (RTC-12047)
Swedish translation corrected for "Subvendor" in reports 0013, 0110, 0452.
Sales per department (RTC-12048)
To make PDF print look better we have made minor adjustment to column widths.
We have also improved formatting of some columns to only show two decimals.
Changed report 0453_SalesByProductAreaOrGroup.
View and filter stocktaking's (RTC-12540)
User can edit and view all types of stocktaking's. Also, when viewing selected stocktaking, it's possible to filter results in Out Of Scope column.
Chain Web v. 2.10.23
Released 13th of April 2021
Improvements
Customers blocked for credit (RTC-11586)
When opening a Customer Order with status Draft, Changed or Active, or when creating a new order directly from customer view, a message is shown to user when the customer is blocked for credit.
Partially delivered dispatch orders (RTC-10302)
When dispatch order is partially delivered, after removing the item line from the not-delivered order, the freight item is reassigned to the delivered line with correct quantity delivered amount (should be 1). This previously did not work as intended and has now been corrected.
Chain Web v. 2.10.22
Released 19th of March 2021
Include Order Documents in SMS
When sending an SMS with the order confirmation, receipt or credit note to the customer, it is possible to include a downloadable link. When the customer clicks the link they will be able to download a PDF of the respective order document. The user can include the order document in the SMS by using a new SMS variable in the SMS templates configured in Dispatch rules.
Required configuration:
Order Message Integration 1.4.0
CustomerOrderIntegration (from CustomerOrderService) jobs:
GenericImport - Default configuration
OrderMessageJanitor - Default configuration
OrderMessageProcess - Default configuration
StagingCleanup - Default configuration
Update picking order with shipment number when delivered from AutoStore
(RTC-7709)
The picking order's ShipmentNumber is updated by Chain Web based on ShipmentTrackingNumber from POSLog provided by AutoStore. That gives the ability for the tracking link to be included in the email sent to the customer.
Improvement
Customer order | Disable the order locking functionality by default (RTC-11511) The Customer Order locking feature is disabled by default, the user need to change the value of Chain Web system parameter "CustomerOrderLockingEnabled" to True, to enable it. Parameter description: If set to True Customer Orders will be blocked from being handled in POS and Chain Web at the same time. Preventing simultaneously changes to a customer order (RTC-908) When a customer order is being changed from POS, it will be locked for simultaneously changes from both POS and Chain Web to prevent loss of data. Information is shown in the order details view when the order is locked. Any update/change of the order is not allowed when the order is locked. Users that want to edit the order must wait and try again later. Additional technical information: Order locking feature will work with versions EG POS 3.0.0.12401 or newer. |
Order Management | Rejected order lines (RTC-10838) In order to display number of rejected order lines, Reporting imports this status from Retail database. This is done by existing package FactOrderRetail. This package require Retail database version 2.10.0.7 because of new procedures. Note: There are some limitations to this functionality: To get rejected status we need to fetch changes in Retail db and changes in POSLog. In some cases this can result in incorrect status for Order lines.
|
System | Upload RIGAL files to Cloud (RTC-849) DirectoryListnerJob job in FileListener Integration package can upload any files to FileService based on a list of predefined content type or a list of Regex'es. The job can be configured to upload Chain/POS files (butikk, vpi, pris and so on), RIGAL files (V, K, M, Varetran and so on) or custom files types based on Regex. Detailed documentation on how the job works and how to set it up can be found in the documentation tab in Integration Platform Management App. |
Chain Web v. 2.10.20
Released 12nd of March 2021
Tracking number as SMS variable
When defining the SMS template for Shipping Confirmation and Split Order Shipping Confirmation it is possible to include [tracking number] as an SMS variable.
It allows for messages generated in OrderMessage SMS to contain short tracking link or tracking number to track ordered packages. The tracking number will appear as a link that the customer can click to see the progress on the shipment.
Required configuration:
OrderMessage Integration 1.3.0.
CustomerOrderDeliveryMethod system parameter should contain "TrackingUrl", for example: "TrackingUrl": "http://www.postnord.no/nb/vare-verktoy/pakkesporing?searchquery=SHIPTMENTID#dynamicloading=true&integration=TrackAndTraceById&shipmentid={0}”-> the {0} at the end is to display tracking link where {0} will be replaced with tracking number.
Example of fake configuration that would display tracking number, but direct the customer to Google:
SMS templates for order documents
(RTC-727)
SMS templates for order documents, such as Receipt, Order Confirmation and Credit Note are been added to “Confirmation Messages” in Dispatch rules. Support for {first name}, {last name}, {order number} and {document link} as SMS variables are added as well, which enables messages generated in OrderMessage SMS to contain customer's first name, customer's last name, order number and short link to respective PDF document in SMS messages (See “Document Link SMS variable for more information).
It is only possible for user to get SMS messages if one of the communication channels is set to SMS.
Document link SMS variable
Support for {document link} in Order Dispatch confirmation messages is introduced the SMS templates for: Receipt, Order confirmation and Credit Note.
It is possible for SMS messages generated in OrderMessage to contain short link to a PDF document that the customer can click when receiving the SMS in order to view a PDF of the receipt, order confirmation or credit note.
Required configuration:
OrderMessage Integration 1.3.0
New status form AutoStore
(RTC-7951)
When a picking order is assigned to the central warehouse, the picking order gets the status “In Progress” in Chain Web after receiving a message from AutoStore that picking has started. Picking Orders do not have status “New” all the time until the order is paid. Instead, after Picking is started, Dispatch Orders gets status “In Progress”. This change is implemented in order to be able to easily distinguish between dispatch orders from AutoStore and other Dispatch orders.
Export of data from Count group view to Excel
The user is able to export the data from count groups view to Excel (from count groups and status tab). The user can choose which data to export to Excel by filtering the grid beforehand. This makes it easier to for example, check which stores that are not completing their daily counting and which groups that are often excluded from counting.
Deletion of yesterday’s count lists and stocktakings
(RTC-838)
When store staff forget to finish the Random stocktaking with at least one activated count list which contains count group link, then the unfinished/not completed stocktakings will be be deleted, during night job execution, so store staff can start on a new, empty stocktaking the next day. Not activated countlists which contains count group link will be deleted as well.
Requirements: Enable and configure new job StocktakingEraserJob placed under BackOfficeIntegrationSubscriber
Filter on vendor, subvendor and EAN list
(RTC-9806)
We have extended three existing reports with new filters for vendor, sub vendor and EAN list.
EAN lists is created and maintained in Report. This is not item lists created in Item management module.
Changed reports:
Sale statistics / 0013_SaleStatisticsWithDrill
Sale statistics / 0110_SaleStatistics
Top sales per item with compare date / 0715_TopSalesPerItemWithCompareDate
Update of name for workstation types in Report
(RTC-9822)
In reports for cash register frequency the names of workstation types are updated. This will make it easier for the user to know which workstations the report is printed for. It is also possible to maintain the list of available price channels.
Changes in following parameters:
pPriceChannels - Comma separated list of price channels available in selection. Price channels customer is not using can be removed from list.
pWorkstationISA (ISA) -Renamed from pWorkstationITAB, default value = 98
pWorkstationTypeSCO (SCO) - Renamed from pWorkstationTypeSO, default value = 41,42,43,44,45,46,47,48,49,61,62,63,64,65,66,67,68,69
pWorkstationTypeWebshop (WebShop) - New, default value = 91,92
pWorkstationTypeOther (Other) - New, default value = empty.
(Note that translation of price channel names are done in RTP-4265)
Report for breakage and waste items
(RTC-9812)
To be able to report broken items to supplier, a report which lists item transactions are created.
Report details for Item transaction list | |
File name | 0452_BreakageAndWasteTransactions |
Data source | Analysis services (Cube) |
Relevant parameter | |
pTransactiontypesToExclude | List of transaction types not to be included in Report. Default following transaciton types are excluded: ArticleService, StockAdjustment, Shrinkage, Inventory, InternalUse, InternalTransfer and DockingArea |
Selections/filters | Comment |
Date from | Default today. |
Date to | Default today. |
Retail store | Default all. If store user, store. |
Subvendor | Default all. |
Article area | Default all. |
Article group | Default all. |
Transaction type | Default all (does not show types excluded in pTransactiontypesToExclude). |
Reason code | Default all. |
Columns - one row per transaction. Grouping per store / supplier / EAN. | |
Item name | Item name. |
Item number | Item number. |
Number | Operator number. |
Transaction type | Transaction type. |
Reason code | Reason code used for transaction. |
Date | Date for transaction. |
Net amount | Net amount for transaction. |
Quantity | Quantity for transaction. |
Amount | Amount for transaction. |
Sales by product area or group
(Jira link: RTC-9810, RTC-10022)
Report 0453_SalesByProductAreaOrGroup has been created for customers to be able to report on sales per item area and item group over a period compared to a previous period.
Report details for Sales by product area / Sales by product group | |
File name | 0453_SalesByProductAreaOrGroup |
Data source | Analysis services (Cube) |
Selections/filters | Comment |
Report type | If report should be based on article area or article group - Default area. |
Date from | Default today. |
Date to | Default today. |
Comparable date from | Default same day in same week last year. |
Date to comparable | Default same day in same week last year. |
Article area | Default all (does not show if report type is Group). |
Article group | Default all (does not show if report type is Area). |
Retail store | Default all. |
Columns - one row per article area / article group | |
Item area | Item area number and name |
Date 1, based on sales between Date from and Date to | |
Sales | |
Sales Incl. VAT | Sales including VAT for Date 1. |
Sales ex. VAT | Sales excluding VAT for Date 1. |
Records | |
Quantity | Number of sold items for Date 1. |
Price pr. Art | Average price per article for Date 1. |
Gross profit | |
Amount | Gross profit amount for Date 1. |
% | Gross profit percentage for Date 1 |
Date 2, Based on sales between Comparable date from and Date to comparable. | |
Compare incl. VAT | |
Sales incl. VAT | Sales including VAT for Date 2. |
Diff. | Difference in sales amount (including VAT) for Date 1 and Date 2. |
Diff % | Difference in sales between Date 1 and Date 2 in percentage. |
Improvements
Customer | Remove reference text demand from local EHF (RTC-9743) |
Customer order | Customer with credit blocked (RTC-9880) Autosave for customer orders that are not submitted (RTC-3503) |
Invoicing | Invoice text "Foretaksregisteret" (RTC-10601) |
Reports | Translations in Report (RTC-10828)
Additionally, parameter pWorkstationType two values has new translations (“ITAB” is now changed to “ISA” and “SU” is now changed to “SCO”). Translations (RTC-10894)
Translations (RTC-10988)
|
Stocktaking | Count group status (RTC-10659) Improved transparency in count group grid (RTC-10793) Show items added outside the count group (RTC-948) |
Chain Web v. 2.10.14
Released 18th of March 2021
Improvements
Translations (RTC-10894)
The Swedish and Norwegian translation of the workstation type name "Other" in the dropdown list of parameter pWorkstationType (used in reports 0705/0706 and others) is updated with the following values:
Swedish: Övriga
Norwegian: Andre
Additionally, the text "Web shop" is changed to “Webshop”
Translations (RTC-10988))
The Swedish translations of two price channel names in the dropdown list of parameter pPriceChannels (used in reports 0705/0706 and others) are updated with the following:
ShopAndGoCheckOut - Självbetjäning (SCO)
ShopAndGoCheckTerminal - Självscanning (SU)
Chain Web 2.10.13
Released 2 March 2021
Export of data from Count group view to Excel
The user is able to export the data from count groups view to Excel (from count groups and status tab). The user can choose which data to export to Excel by filtering the grid beforehand. This makes it easier to for example, check which stores that are not completing their daily counting and which groups that are often excluded from counting.
Improved transparency in count group grid
When the counting of a count group has not yet started (including when counting was cancelled), the following fields will be blank: counted at, counted by and modified by. This was previously not the case and was confusing for the user. A modified date will be added for the count group with status "Not started", when the counting was cancelled, in order to show the user when it was cancelled.
Improvement
Translations in Report (RTC-10828)
The Swedish translations of the price channel names in the dropdown list of parameter pPriceChannels (used in reports 0705/0706 and others) are updated with the following Swedish translations:
Chain Web
Manuell kassa
InStore App
Självscanning (SU)
Mobilsjälvscanning
Självbetjäning (SCO)
Additionally, parameter pWorkstationType two values has new translations (“ITAB” is now changed to “ISA” and “SU” is now changed to “SCO”).
Furthermore, pWorkstationType has two new items in the list (Web shop and Other).
Chain Web v. 2.10.12
Released 25th of February 2021
Update of name for workstation types in Report
(RTC-9822)
In reports for cash register frequency the names of workstation types are updated. This will make it easier for the user to know which workstations the report is printed for. It is also possible to maintain the list of available price channels.
Changes in following parameters:
pPriceChannels - Comma separated list of price channels available in selection. Price channels customer is not using can be removed from list.
pWorkstationISA (ISA) -Renamed from pWorkstationITAB, default value = 98
pWorkstationTypeSCO (SCO) - Renamed from pWorkstationTypeSO, default value = 41,42,43,44,45,46,47,48,49,61,62,63,64,65,66,67,68,69
pWorkstationTypeWebshop (WebShop) - New, default value = 91,92
pWorkstationTypeOther (Other) - New, default value = empty.
(Note that translation of price channel names are done in RTP-4265)
Improvement
Count group status tab (RTC-10659)
When logging into Chain Web as a store user and navigating to the Count groups, only count groups available in the grid will be count groups that should be counted in the given store. The column "#items in stock" will display the number of items in the count group that the given store is expected to count.
Chain Web v. 2.10.11
Released 18th of February 2021
Create CustomerManagementToBatch2 job publishing JsonLines
In BackOfficeBatchGenerator package new CustomerManagementToBatch2 job, using the same contract as CustomerManagementToBatch job, publishes JsonLines batches. This job replaces the previous "CustomerManagementToBatch" job, if all subscribers (e.g. POS Import) are up-to-date and support JsonLine format.
Required version: BackOfficeBatchGenerator 1.4.1
Create Customer2 job publishing JsonLines
In BackOfficeBatchGenerator package new Customer2 job, using the same contract as Customer job, publishes JsonLines batches. This job replaces the previous "Customer" job, if all other subscribers are up-to-date and support JsonLine format.
Required version: BackOfficeBatchGenerator 1.4.0
Deletion of yesterday’s count lists and stocktakings
(RTC-838)
When store staff forget to finish the Random stocktaking with at least one activated count list which contains count group link, then the unfinished/not completed stocktakings will be be deleted, during night job execution, so store staff can start on a new, empty stocktaking the next day. Not activated count lists which contains count group link will be deleted as well.
Requirements: Enable and configure new job StocktakingEraserJob placed under BackOfficeIntegrationSubscriber
Improvement
Default price channel should be "None" (RTC-10067)
When creating new user, default price channel is not set by default.
Chain Web v. 2.10.10
Released 18th of February 2021
Version Requirements is located on the menu to the left.
User-friendly Item Texts
(Jira links: RTC-812, RTC-697, RTC-981)
Web shops often display user-friendly item texts. When front-end includes item text, color and size in the web order sent to POS API, these texts will be used in order messages (Order/Delivery confirmation) sent to consumer. When front-end does not include the user-friendly texts the order messages will use standard texts, usually provided by supplier. This functionality is created for the order dispatch module.
(Jira links: RTC-715, RTC-3836, RTC-740, RTC-859, RTC-827)
The Chain Web parameter "InStoreRejectedPickingOrdersStoreNumber" is used to determine to which 'fake store' the order will be reassigned.
The dispatch orders can be reassigned automatically if no picking store is available or maximum number of automatic reassigns has exceeded the set value (configured in the dispatch rules - see below).
The user can find the configuration of automatic reassign in the dispatch rules grid. Configuration includes:
Select the delivery methods that can be reassigned automatically.
Default time before order is assigned to a new store.
To limit the max number of reassigns - this number only applies to number of automatic reassigns. Orders can be manually reassigned infinite times.
Reassigned orders are logged with from store/to store, time stamp of when the reassign occurred and reason code called "time limit expired", which tell the user why it was reassigned automatically. For orders that cannot be reassigned, shall be logged with the reason code ‘No store available’. These orders will automatically be reassigned to the fake store defined in system parameter, to allow HQ users to handle them manually.
In the picking order history in Chain Web grid, new column has been added. In the picking order history, it is possible to check the reassign actions made by the user or automatic reassigns, reason for reassign and time stamp.
Note: Dispatch orders from central warehouse will never be automatically reassigned.
Cloud authentication for cashiers
(RTC-730)
For mobile devices using store local Wi-Fi (or VPN), a 'Proxy' can be installed OnPrem with Chain Web to provide login to Mobile Apps/cloud modules with cashier number/pin code. This requires implementation in each app, and for now it is only planned for Mobile POS app to make it possible for multi-user devices.
Improvements
Accounts receivable | Roundings in EHF files (RTC-9092) The PayableAmountRounding field is saved in EHF files only when there is a rounding amount (different than 0). Rounding of credit sale (RTC-7089) |
Balance | Registered balances can be edited (RTP-4041) It is possible to edit balances after registration when system parameter "NewBalanceRegistrationEnabled" is True. |
Cashiers | Export e-mail for cashier to POS (RTP-4001) Cashier e-mail will be exported to POS when updating cashier info in Chain Web and when mass exporting cashiers from Chain Web. |
Customer order | Preventing simultaneous changes to a customer order (RTC-832) Slow processing of customer orders (RTC-9676) |
Order dispatch | Not possible to delete "last not delivered" item (RTC-7099) Error handling of CompletePickingCriticalExceptions (RTC-10050) |
POS Configuration | Config changes for "Self-service on customer (secondary) screen" (RTP-349) After fixes function enabling the argument is called "Start self-service", the function in which we do not choose parameter is called "Start self-service (primary screen)". Configuration:
|
Stocktaking | Store number and store name in count group view (RTC-791) Splitting count groups which exceed 50 items (RTC-902) This is configured in the integration job CountingGroupImportProcessor in the parameter splitCountgroupsEnabled (default value False - splitting is disabled) and maxItems (default value 50). |
System | Default region/language for cashiers (RTC-800) |
Chain Web v. 2.10.08
Released 15th of December 2021
Improvements
Fixed changing password (RTC-16616)
User is able to change password of the cashier in "cashiers" and in "users". Changing ManageUsersAndCashiersIndependently setting has no impact.
Chain Web v. 2.10.06
Released 27th of April 2021
Improvements
Slow processing of customer orders (RTC-12567)
Performance when updating customers is much faster after improving code related to handling of communication channels.
Import of customers without SSN (RTC-12873)
When creating or updating customer by using import of customers in ARTS XML format, Social Security Number is not set on customer in Lindbak Retail database if it is not present in import file.
Chain Web v. 2.10.05
Released 22nd of April 2021
Improvement
Import of customers with SSN (RTC-11762)
When creating or updating customer by using import of customers in ARTS XML format, Social Security Number is updated properly on customer in Lindbak Retail database.
Chain Web v. 2.10.04
Released 18th of March 2021
Improvement
Configuration group - can't find store (RTP-3652)
Stores are properly returned and can be added in the store group configuration section.
Chain Web v. 2.10.03
Released 21st of January 2021
Improvement
Registered balances can be edited (RTP-4041)
It is possible to edit balances after registration when system parameter "NewBalanceRegistrationEnabled" is True.
Chain Web v. 2.10.02
Released 21st of January 2021
Improvements
Edit counted amount for weight items (RTC-713)
When editing the counted amount of item in stocktaking results view, weight items can be saved with decimals.
Performance and retry mechanism for export of large stocktakings (RTC-733)
Performance when exporting stocktaking results to 3rd party (inventory control) is improved for large stocktakings (>300K items). If something fails, a retry mechanism will wait a configured number of seconds before the next retry execution for this stocktaking.
Chain Web v. 2.10.01
Released 22nd of December 2020
Exporting cashiers to POS
IsActiveDirectory flag is included in the batch generated on CashierUpdatedEvent and CashierBatchExportEvent when exporting cashiers from Chain Web to POS. Previously, there was no support for exporting cashiers belonging to an Azure AD user.
Dependencies to another products:
BackOfficeBatchGenerator package in version 1.2.15 or higher required.
Chain Web v. 2.10.0
Released 21st of December 2020
ELMA Integration
(TFS: 185340)
The ELMA validation button has been added to the customer details view. It can be found in Invoicing tab when customer is a business customer and address is set in Norway.
The user can validate the organization number of Norwegian business customer against ELMA just by pressing 'Check if customer can use electronic invoice' button.
New balance registration
(TFS: 189541)
A new way of registering balance, where the user can see expected amount and difference on each tender, has been implemented. This balance is submitted without a bag, so there is no Bag registration step. After submitting tenders amount the balance is finished and the user can immediately create next balance for next active cashier. When there are no more active cashiers for the selected date, then a new balance registration cannot be created for this date.
In the new balance registration, editing of finished balance registration is disabled.
To use new balance registration, set up value of the new system parameter NewBalanceRegistrationEnabled to True. When value of NewBalanceRegistrationEnabled is equal to False, then the old balance registration will be present Chain Web.
Requirements: Reporting v.65, POS Services 7.77.03801
Stocktaking report with item area
(TFS: 189521)
New report showing stocktaking results divided by item area.
Inventory per item area | |
File name | 0451_StockTakingItemAreaLevel.rdl |
Data source | Lindbak Retail (database) |
Selections | Comment |
Date from | Default today. |
Date to | Default today. |
Retail store | Which store to run report for. |
Stocktaking | Shows all stocktaking's for selected store within date from - to range. |
Report shows inventory date and store number and name. | |
Columns, one row per item area. | |
Item area | Area number |
Area name | Area name |
Inventory value, Cost price | Sum cost price |
Inventory value, Ex. VAT | Sum salesprice ex. VAT. |
Inventory value, Sales amount inc. VAT | Sum salesprice inc. VAT. |
Improvements
Customer | Line note in Customer Sales grid (TFS: 185458) |
Invoices | Show the amount that is rounded in the invoice (TFS: 184868) |
Reason codes | Reason codes for overridden price (TFS: 189485) Requirements: BackOfficeBatchGenerator 1.2.13, ChainIntegration 1.5.1 |
Report | Able to use hyphen when renaming reports (TFS: 189086) |
Stocktaking | Random count - refresh stock status in count lists (TFS: 184420) New configuration parameters:
- default value: 1000 ReuseStockLevelExpiryTimeInMinutes - it is relevant, only for a small count lists (if sum of count lists lines < SynchronousUpdateCountListMaximumSize) - default value: 60 Don't allow creating new stocktaking if last stocktaking is not updated in Chain Classic (TFS: 189347) Related Chain Classic PBI with the requirements: Product Backlog Item 190077: 2.1.1: Sport1: Stocktaking: New proxy for checking that last stocktaking is finished |