Chain Web v. 2.10.82
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Module | Description |
---|---|
System | Fix for login for windows/AD users (RTC-16336) It is possible to login to Chain Web using normal and windows domain account. |
Chain Web v. 2.10.81
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvements
Module | Description | |
---|---|---|
Invoicing | Search for invoices (RTC-15345) In Invoices' view there is a simple search option. User can narrow and customize results by entering key word in the simple search window. (The search result is improved in this version). | |
POS Configuration | Removing pictures from buttons in PLU Board (RTP-13175) Pictures from buttons in PLU Board can be removed by choosing "Delete image" option while editing the button. | |
Receipt Journal | Summary for all cashiers (RTC-15875) There is a possibility to edit balances after balance summary is created. If user edits one of balances, summary is updated according to the changes. Fix for showing date interval (RTC-15396) There is a possibility to set date interval in the Receipts Journal. All digits from date are displayed even if scroll appears in the filters section. Access to receipt for stores after merging a store (RTC-14508) A user will have access to all receipts from a selected store even if the store prefix is changed. View receipt log (RTC-8483) The user are able to view a receipt log to inspect each activity that has been made on a selected receipt. This feature is developed for ordinary sales receipts and might not be useful when viewing receipts for credit sales and customer orders. | |
ServiceBus | ServiceBus configuration (RTC-13481) There is a parameter in ServiceBus that can be set on a topic named "Enable Filtering Messages Before Publishing". This should not be enabled and will cause this error when you have a lot (50-100) subscribers on a topic. | |
Stocktaking | Count group filtering (RTC-15949) When adding filter to counting group selection criteria, type is autoselected if there is only one option, placeholder in search input, extended dropdown list to 40 matches and info about narrowing the search criteria. Processing of count lists (RTC-9369) To prevent processing of count lists to fail, the CountListsProcessorJob has status "faulted" if some stocktaking's changes are made during its work. Then count list which couldn't be updated has status "ProcessingTerminated" in the database and task "ProcessCountListCommand" has status "error". Processing of such count lists can be retried. Information about this error situation should be added to the retailers stocktaking guideline, but most important: "Please do not modify the stocktaking while count lists are processed/updated." |
Chain Web v. 2.10.80
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
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
Module | Description |
---|---|
Balance | Balance summary (RTC-9741) After registering all balances for selected day, user will see a summary for all cashiers. This summary is available from Financials menu section called Balances summary. |
Customer | Maximum credit limit when updating customers through ARTS Customer import (RTC-15225) The default credit limit on credit customers in Chain Web is set in the system parameter DefaultCustomerCreditLimit. When updating or creating customers through ARTSCustomerImport the maximum credit limit must be less than three times the DefaultCustomerLimit or the update will be rejected. If the system parameter is blank, the default value of 50 000,- is used and the maximum credit limit when updating is 99 999,-. Import of customer with invalid mobile number (RTC-9100) If customer's phone/mobile number is invalid (contains illegal characters) then customer is exported with empty phone number. Requirement: |
Customer order | Search for offers (RTC-14959) In Offers' view there is a simple search option. User can narrow and customize results by entering key word in the simple search window. Search for orders in Package deliveries (RTC-14960) In Package Deliveries view there is a simple search option. User can narrow and customize results by entering key word in the simple search window. Fix for refund (RTC-7054) The refunded lines are properly displayed in the Refund summary/ Credit Note. |
Invoices | Search for invoices (RTC-13704) In Invoices' view there is a simple search option. User can narrow and customize results by entering key word in the simple search window (the search result is improved in this version). |
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) After entering Receipts Journal view receipts are properly displayed and no timeouts occur. User is able to customize and narrow the shown results by using filters. Filter for stock adjustment transactions (RTP-13122) In receipt journal the user can filter displayed results only to stock adjustment type of receipt. This type is in group of types named item transactions, so if user filters on all item transactions, receipts for stock adjustments are also shown. Open drawer transactions (RTP-11413) Open drawer transactions are displayed under System transactions and Other. Search for old receipts (RTC-7875) When searching for old receipts it is not possible to use all the standard filters. When 'date from' is older than defined in system parameter R_ceiptJournalOldReceiptsDate,_ a simplified filter is displayed. Please note that this system parameter is default blank. |
Reports | Store users of report 0010 (RTC-14884) If user has store level access, report 0010 shows only results for the user's store. New reports, with interactive sorting (RTC-14253) We have made to new reports (0455, 0456). They are the same as 0110 and 0453, but now they have interactive sorting in all columns. Changes in report 0450_StoreSettlementPerOperator (RTC-14255) New row "Klarna" in 1701_subCurrency section. The row shows payments done with Klarna. New hidden parameter pKlarna - needs to be set to Klarna payment card number. Changes in report 0750_WetStock (RTC-14762) Now the report fits on A4 format when exported to PDF. 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) Sticky columns have been added in Overview tab and No active stocktaking header has been made more visible. Counted by column in Overview and Count Lists tabs has been upgraded. The change for Counted By is done in POSLogProcessingWorker. New Count Lists from POSLogs have userId set to "operatorId - operatorName", for old records the value isn't changed. Cleanup of old count groups (RTC-13902) There is a job named CountingGroupsCleanupJob which cleans old count groups for an inventory control. User is able to set number of days after which the count group should be removed. Default values is 90 days. If count group was used in already archived stocktaking and is old enough, CountingGroupsCleanupJob deletes it. Cleanup of old counting groups (http://RTC-15659) Delete Counting Groups and dependencies will be done in batches. Batch size is configurable by 'Delete batch size' job parameter. Default value is 50, but it could be increased to 1000. 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) Bugfix: All dates in the count groups' grid are displayed properly. Filter on supplier and brand when creating count groups (RTC-12666) User is able to select "Supplier" and "Brand" as an attribute in item filter when creating or editing count group. |
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 itemgroup 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 |
Relavant 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.
NB! Report require Lindbak 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.
Improvement
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 | ReceiptJournal requires store to be selected (RTP-12435) ReceiptJournal 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. Refund (RTP-12075) 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. Deleting and Updating C&C orders (RTC-13761) 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.61
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
New UI 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
Module | Description |
---|---|
Balance | Shifts receipts in Receipt Journal (RTP-11724) New shift and end shift receipts are displayed in Receipt Journal in the same way as in printed receipt |
Customer | Import of item list in customer group discount (RTC-13360) A loading indicator is displayed when importing item list or item group list to a customer group (for discounts). When the import has finished, a green notification is displayed to inform that the import was successful, or an orange notifications to inform that an exception occured. |
Dispatch rules | Automatic Reassign: Issue with Delivery Method Configuration (RTC-11608) It is possible to configure automatic reassign for delivery methods defined in CustomerOrderDeliveryMethods system parameter. That means delivery methods for reassign order are expanded to include all delivery methods avaliable in CustomerOrderDeliveryMethod system parameter and are possible to be set in Dispatch Rules -> Reassigning Order as an option for automatic reassign. Additionally, Reassign Order Delivery Methods are no longer dependant on Delivery methods selected in Delivery Methods section. ** |
Invoicing | 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. |
Gift card | Resend digital gift card (RTC-8266) 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. |
Order dispatch | Handle lack of delivery suggestions from DispatchService (RTC-13806) Dispatch orders are processed correctly even if there are no suggestions available from DispatchService. Issue deleting order lines with unsupported characters (RTC-10215) Order line in a dispatch order can be successfully removed even if it contains special characters like: '()", Fix validation of dispatch rules (RTC-12099) Dispatch rules correctly displayed and can be saved with default values. Error messages are displayed correctly when invalid values are entered fields. This is done to increase user friendliness of the dispatch solution, as previously the user would get no indication as to why they were unable to save the dispatch rules. |
Reports | Deleted receipts in Store settlement report (RTC-12984) Previously, we did not show data for cashier if they only had deleted receipt and no sale. Changed report: 0450_StoreSettlementPerOperator. Report sales per profile (RTC-13527) In order to report sales per profile, Profile parameter is added to the following reports: 0100_WeekReport |
Shift balance | Fix for inbound amount (RTC-13861) The amount "Submitted to bank" for shift balances is calculated properly. The Inbound amount is not replacing drawer money when registering balance for shift. 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. |
Stocktaking | Item synchronization performance (RTC-10344) A new database index is added to improve general performance when synchronizing (deactivated/deleted) items from Chain Classic to Chain Web. |
User management | 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.50
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
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 Giftcards. |
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
Module | Description |
---|---|
Customer | Import customer in ARTS XML format (RTC-13193) When customer data is importing from ARTS Customer format, customer type is updated (employee etc.) |
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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
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
Module | Description |
---|---|
Balance | Historical exchange rate in Balance (RTC-12275) If parameter UseCalculatedExchangeRateInBalance is set to True in POS Configuration for POS WCF, the correct historical exchange rate is used when registering Balance in Chain Web. |
Customer | 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. |
Customer order | Deleting an order line in payment mode in POS should not delete order line in Chain Web (RTC-12235) Lines deleted in payment mode in POS are properly processed in Chain Web and are not deleted from the order. |
Dispatch orders | Dispatch Orders - Performance improvement (RTC-11645) Loading of rows in Dispatch Orders grid has been optimized. The loading time is not significantly visible for the user when opening the Dispatch Orders grid or when scrolling through the Dispatch Orders list. |
Dispatch rules | Order line split (RTC-10889) "Allow splitting line in web order" checkbox added to the Dispatch Rules configuration. It allows enabling/disabling of splitting order lines in the web order. The functionality for order line split will be released in 2.10.50. |
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) The field for "English text" has been added to menu buttons in ButtonConfig parameter. |
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.34
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvements
Module | Description |
---|---|
Invoicing | 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. |
Receipts journal | 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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvements
Module | Description |
---|---|
Homepage | 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. |
User management | 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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvements
Module | Description |
---|---|
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. |
Gift cards | 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. |
Chain Web v. 2.10.31
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvements
Module | Description |
---|---|
Account Receivable | Validation of payment date (RTC-10893) When adding payment to invoice, payment date cannot be earlier than invoice creation date. |
ChainToCloudIntegration | Add support for new file types (RTM-236) Added support in ChainToCloudJob to support new file types which are sent to cloud. New supported file types: budsjett (budget), vareliste (item list), stock. Required: ChainToCloudIntegration package version 1.6. |
Customer | Importing item list to customer group (RTC-9646) When an item does not have a price in selected store during import of item list to customer group, an error message is displayed to inform the user of what the problem is. 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. Default invoice by email to customers with email address (RTC-9742) When customers (private and credit) are created with email address in POS, the customer will default be updated with the flag checked for 'Invoice by email'. Inactive customer groups are default hidden (RTC-10439) When opening Customer Groups, inactive groups are default hidden. In order to see hidden groups, user needs to change filters in Inactive column. User can also narrow and customize search results by using filters in columns. |
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) When creating new offer, "Valid to" field is set by default to the expiration date (14 days from today's date). User can change it by date picker. It is also possible to change the default value under the "DefaultOfferExpirationDays" parameter in Chain Web system parameters. When viewing already created offer, "Date" and "Valid to" fields are set according to the offer's creation date and expiration date. 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. 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. 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. |
Homepage dashboard | Refresh data automatically when changing store (RTL-133) Data in Homepage dashboard is refreshed automatically when the store is changed to another one. Wrong Mapping For Sales Per Hour (RTC-3144) The mapping for sales per hour was corrected and presents correct values for customers per hour and sales per hour. Both comparison and main date are correctly loaded and return correct results. Furthermore, setting the comparison date greater than the main date and main date lower than the comparison date is impossible, and dates are automatically changed into the greatest or the lowest one possible. When setting the comparison date greater than the main date, it is automatically changed into the greatest one possible equal to the main date. The same happens when setting the main date lower than the comparison date. |
Invoicing | Summation per receipt (RTC-9721) When the invoice contains multiple receipts, there is an additional line with summation per receipt of total excluding VAT and total including VAT. |
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. |
Order dispatch | 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. 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. This gives the ability for the tracking link to be included in the email sent to the customer. |
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 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) Swedish translation corrected for "Subvendor" in reports 0013, 0110, 0452. |
Stocktaking | View and filter stocktaking's (RTC-12540) User can edit and view all types of stocktaking's. Additionally, when viewing selected stocktaking, it's possible to filter results in Out Of Scope column. |
Chain Web v. 2.10.24
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvements
Module | Description |
---|---|
Dispatch rules | Fix translations for Order Dispatch (RTC-12098) Translations in Dispatch Rules has been improved and English and Norwegian version is working as expected. |
Reports | 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. |
Stocktaking | 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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left
Improvements
Module | Description |
---|---|
Customer order | 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. |
Order dispatch | 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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
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
Modules | Description |
---|---|
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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
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 parameters | |
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
Modules | Description |
---|---|
Customer | Remove reference text demand from local EHF (RTC-9743) When the customer is marked to "Save electronic invoice locally" , the checkbox "Reference number required" is editable. When "Reference number required" is set to False, reference number and reference text are not required when creating credit sales and customer orders. This feature makes the sales process more efficient when invoicing is done in a 3rd party system. |
Customer order | Customer with credit blocked (RTC-9880) When creating customer order and adding customer with credit blocked, a warning message is displayed. Order can be saved but it is not possible to pay it by credit. For such customers credit sales cannot be created. Autosave for customer orders that are not submitted (RTC-3503) The integration job OrderSubmitter, included in the BackOfficeIntegrationSubscriber package, is responsible for submitting orders with statuses Draft and Changed which have not been submitted within a defined number of minutes. By default the job is executed every hour. |
Invoicing | Invoice text "Foretaksregisteret" (RTC-10601) Field name on top of the invoice was changed in English and Norwegian version to "Foretaksregisteret" to align with legal requirements. Text in Swedish is previously defined according to Swedish legal requirements. |
Reports | 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:
Additionally, parameter pWorkstationType two values has new translations (“ITAB” is now changed to “ISA” and “SU” is now changed to “SCO”). 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:
Translations (https://jira.eg.dk/browse/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:
|
Stocktaking | Count group status (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. Improved transparency in count group grid (RTC-10793) 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. Show items added outside the count group (RTC-948) Added column “Out of scope” to the Count list view to show items that is added outside of Count group in InStore App. |
Chain Web v. 2.10.14
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Modules | Description |
---|---|
Reports | 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:
Translations (https://jira.eg.dk/browse/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:
|
Chain Web 2.10.13
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
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
Modules | Description |
---|---|
Reports | 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:
Additionally, parameter pWorkstationType two values has new translations (“ITAB” is now changed to “ISA” and “SU” is now changed to “SCO”). |
Chain Web v. 2.10.12
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
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)
Improvements
Modules | Description |
---|---|
Stocktaking | 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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
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
Modules | Description |
---|---|
Cashiers | 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
Document status: RELEASED
Date:
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.
Automatic Reassign
(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
Modules | Description |
---|---|
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) In some instances, the rounding of items was wrongly calculated when creating a credit sale, causing a subtotal rounding of 0,01. This issue has been resolved. |
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) When a customer order is being changed from POS, it will be locked for simultaneous 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. Slow processing of customer orders (RTC-9676) Performance when updating customers is much faster after improving code related to handling of communication channels. |
Order dispatch | Not possible to delete "last not delivered" item (RTC-7099) Corrected an issue related to removing last line from "in picking". Error handling of CompletePickingCriticalExceptions (RTC-10050) An issue with storing the DeliveryReceiptID caused internal transfers to not be performed correctly for some dispatch orders. This is corrected and values like DeliveryReceiptId and ShipmentNumber are stored correctly in the database. |
POS Configuration | Config changes for "Self-service on customer (secondary) screen" (RTP-349) Function "Start self service" (START_SELF_SERVICE) has an option to set its argument "Run self-service on customer screen" to True or False when adding a button in ButtonConfig. 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:
Changes only in BackOffice. The functionality will be done and tested in the scope of this Product Backlog Item 188595: Self-service on customer (secondary) screen. |
Stocktaking | Store number and store name in count group view (RTC-791) Stocktaking results can be filtered on counted/not counted counting groups per store per day. Splitting count groups which exceed 50 items (RTC-902) Import of count groups with more than 50 items per department will be split into several count groups so that more store staff can be involved in the stocktaking of a department. 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) When creating a new cashier the region and language is based on the user who are creating the cashier. |
Chain Web v. 2.10.04
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvement
Modules | Description |
---|---|
POS Configuration | 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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvement
Modules | Description |
---|---|
Balance | 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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvements
Modules | Description |
---|---|
Stocktaking | 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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
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
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
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
Modules | Description |
---|---|
Customer | Line note in Customer Sales grid (TFS: 185458) When expanding the details on an item row, there is a column for Line Note. When searching for an item in the filter "Item name", the first 16 rows containing this item is automatically expanded. More rows can be expanded manually. This will enhance the user experience when looking through historical sales for a customer. |
Invoices | Show the amount that is rounded in the invoice (TFS: 184868) Sum of rounding is visible on the invoice to make the rounding more transparant. |
Reason codes | Reason codes for overridden price (TFS: 189485) The support for new reason code type "Change price" has been added. These reason codes can be created and maintained in Chain Web. Requirements: BackOfficeBatchGenerator 1.2.13, ChainIntegration 1.5.1 |
Report | Able to use hyphen when renaming reports (TFS: 189086) It is possible to use hyphen when renaming reports. |
Stocktaking | Random count - refresh stock status in count lists (TFS: 184420) The stock level in a new count list can be refreshed when a count list is added to a stocktaking or activated. To refresh the stock level, the checkbox "Get stock level again for items in selected count lists" must be checked. The stocktaking status will then be "Creating" while the stock levels are being updated for the count list. If the stock level is not refreshed, the stock level for when the count list was submitted, is kept. 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) The user will not be able to create a new stocktaking in Chain Web (also with the refreshed stock level for the assigned countlists) inside the same store, until the last POSLog related to previous stocktaking (previous stock results) will be processed/ updated in Chain Classic. 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 |
Chain Web v. 2.9.288
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvements
Modules | Description |
---|---|
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) In some instances, the rounding of items was wrongly calculated when creating a credit sale, causing a subtotal rounding of 0,01. This issue has been resolved. |
Chain Web v. 2.9.285
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvement
Modules | Description |
---|---|
Stocktaking | Don't allow creating new stocktaking if last stocktaking is not updated in Chain Classic (TFS: 189347) Now the user will not be able to create a new stocktaking in Chain Web (also with the refreshed stock level for the assigned count lists) inside the same store, until the last POSLog related to previous stocktaking (previous stock results) will be processed/ updated in Chain Classic. 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 |
Chain Web v. 2.9.284
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvement
Modules | Description |
---|---|
Customer order | Search for active orders shows both active and cancelled orders (TFS: 186790) The flag IsCancelled has been added to the response of the GetCustomerOrders3 method in CustomerOrder service. It shows if an order is cancelled or not. Requirements: POS Services 7.76.03703 |
Chain Web v. 2.9.283
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
Improvements
Modules | Description |
---|---|
Credit sale | Block "correction of credit sale" when original receipt was partly paid by another tender type (TFS: 169266) When credit sale contains other tender type than Credit, correction is not allowed. Dependencies to another products: POS WCF in version 3.0.0.12003 or 4.0.0.12002 or higher required. |
Invoice | EHFs rejected due to missing ref. number / ref. text (TFS: 188224) If a customer is changed to receive EHF invoices, after credit sale have been created, the reference number and text is set to 'None' when invoicing is done, so that the EHF won't fail due to missing input in these fields. |
Chain Web v. 2.9.280
Document status: RELEASED
Date:
Version Requirements is located on the menu to the left.
SLA calculation
(TFS: 179569)
New methods are added to CustomerOrderDeliveryMethod:
DeliverySlaType
DeliveryHours: SomeNumber
DeliveryHours is a constant number of hours used to determine delivery time since sendout.
By using DeliverySlaType method ( with different set value), it is possible to calculate the SLA date for order delivery.
It is possible to set for DeliverySlaType following values:
Today = 1,
Tomorrow = 2,
Days3to4 = 3,
Days3to10 = 4
When dispatch order is created, the calculated SLA date is stored in the DeliverySlaDate column in [Lindbak Retail].[CustomerOrder].[OrderDeliveryDetails] table.
Gift card number on item line in customer order
(TFS: 186006)
The gift card number is displayed on the order line, so the gift cards sold in an order can be identified.
Dependencies to another products:
POS Services in version 7.76.03505 or higher required.
Send gift card by email from item line in customer order
(TFS: 186007)
The gift card can be sent by email, from the order line view in a customer order.
Dependencies to another products:
POS Services in version 7.76.03505 or higher required.
See used and active coupons in POS
(Work ID: 179889)
Used and active EG digital coupons (and stamp card status) can be shown in POS. This makes is possible to inform about possible discounts and also to help the customer find out if a coupon was already used.
Chain Web version 2.9.271 or newer is required.
Price guarantee - accounting between business units
(TFS: 184327)
A new report is created which shows how much each business units owes each other, based on returns with reasoncode 6 (Price guarantee).
Business units are teams where team type is 1. To import team type from Chain we have created new package "TeamLC" which has to be enabled. This package runs within N-job.
For this report to work, one store can only be member of one business unit.
Example:
Store1 in Team1 sells item1 for 500,-
Item1 is returned with reason code 6 in Store2 in Team2. In same receipt same item is sold for 400,-
Report shows that Team1 owes Team2 100,-
Price guarantee | |
File name | 0115_PriceGuaranteeReconciliation.rdl |
Data source | Database “Lindbak POS Reporting DW” |
Selections | Comment |
Date from | Selection for sold date - default today |
Date to | Selection for sold date - default today |
Parameters: | |
pMainTeamTypeKey | Teamtypekey for business units- default 1. |
Columns for transactions | |
Team sold | Team number where item is sold |
Teamname | Team name where item is sold |
Store sold | Store number where item is sold |
Storename | Store name where item is sold |
Receipt | Receipt number where item is sold |
Sold date | Date when item is sold |
Team returned | Team number where item is returned |
Teamname | Team name where item is returned |
Store returned | Store number where item is returned |
Storename | Store name where item is returned |
Discount | Difference between returned price and sold price for same item. |
Date returned | Date when item is returned |
Columns for Settlement | |
Payer | Team who owes money |
Receiver | Team who receive money |
Amount | Amount |
Reporting on received deposit refund
(TFS: 188176, 187496)
We have adapted two settlement reports to support deposit refund as stock item
In report 0015 Store settlement, deposit refund section. Deposit refund received shows sale from item group indicated in parameter.
Changes are made in sub report 1005_subDepositREfund
In report 0709 Store settlement, statistics section. Deposit refund received shows sale from item group indicated in parameter.
Changes are made in sub report 1706_SubStatistics.
Report for free items
(TFS: 188574)
In report for free stamp card items (0152_FreeItemsFromStampCard) a new column: "Ordernumber" has been added, which shows supplier order number from article.
We have also added filter for store, EAN and order number.
Because of restrictions in Chain Web report viewer, we show max 20 store numbers in parameter list. If there are more stores selected, store list ends with ',...'
Max number can be changed in hidden parameter pParameterDisplayLimit
Requirements:
Lindbak POS Reporting v. 64.
Redispatch Pay & Collect orders if it cannot be delivered
(TFS: 185988)
It is possible to redispatch Pay & Collect orders to desired store and with desired delivery method.
It is done by adding the next DeliveryPointId and Method in the POSLog:
Improvements
Modules | Description |
---|---|
Cashier | Fields in Cashiers view should not be case sensitive (TFS: 166535) Search fields in Cashiers view are no longer case sensitive. |
Credit sales | View credit sales created by another user or from POS (TFS: 184581) To be able to edit credit sales created by another user or from POS, the user must have the access: "Edit credit sales". |
Customer | Invoice fee created for member with 0 credit (TFS: 183083) An Invoice fee receipt is created, regardless of the customer's credit limit. This can cause the credit limit to be exceeded by the invoice fee. |
Gift cards view | All column for owner email (TFS: 185904) A new column for 'Email' has been added to the Gift cards' grid. |
Homepage | Minor improvements (TFS: 181606) Swedish translations have been added for Default Settings component and the Change Settings component. Furthermore, margin settings have margin intervals on the same row with proper headers and more customer friendly translations. The Popup for comparison date has different margin colors compatible with settings to enable users to track stores or department performance in a better way. Department KIP in Homepage dashboard (TFS: 186140) 'Sales per Department' component displays a list of 1 to 8 department (according to user's settings) with their percentage performing values and appropriate margin colors (according to user's settings). Furthermore, the 'Sales per Department' component was expanded to view more details when comparing percentage values from the same date last year or day set by user itself. After clicking on a specific department more details displayed to the right in a a pop up window. |
Inventory Control | Max 1000 items in counting Group (TFS: 176822) The maximum amount of items in count groups has been limited to 1000. It applies to both count group imported via Inventory Control integration and count groups created in Chain Web. |
Invoices | Electronic invoice should not contain an empty "Description" field (TFS: 179958) When the line note on the line in the order or credit sale only contains white spaces, then the description field will not be created for this line in the Electronic invoice xml file. This change is made to avoid sending an empty description field, which causes an error when validating the EHF invoice. Changes to the PDF Invoice and user interface (TFS: 185463) For Swedish stores, the invoice shows information about:
Sum total VAT amount on Invoice (TFS: 186891) The Invoice has a new field for the total VAT amount. |
Reporting | New colors in reports (TFS: 175400) Changed color scheme for graphs in all reports to match the new EG design. Discount quantity (TFS: 191692 In sub report 1406_subDiscounts. Number of discounts are changed from number of articles to number of receipts. Reporting on cancelled receipts (TFS: 187201) We have updated the way we report on cancelled receipts in some reports. Cancelled receipts now include receipts cancelled with status "DeletedFromUnfinishedReceipt". Following reports are changed: 0018_CashierStatistics_std |
Stocktaking | Permanent solution for saving model items (TFS: 182799) The process of resolving model number has been solved permanently. Previously, some customers had issues with saving model items in retail database during synchronization of items. Additionally, improved logging in case of failed events has been added, so problems in the future will be easier to identify. Virtual scroll in Archive view (TFS: 183194) When working in the stocktaking archive view the bottom scroll is improved. Previously, there was a visual error causing the scroll bar to not stay in the bottom of the screen. Completed date in stocktaking view (TFS 185122) The "Completed date" column has been added to the stocktaking grid in Overview tab and also to the grid in Stocktaking tab. Users no longer have to open each stocktaking to see the completed date. This change is implemented to make it easier to work with stocktaking. Item sync: Support comma and backslash in the 'error' file name (TFS: 185487) Comma as a first sign is supported in the decimal fields. The date format included in "error message" file name will always have the same format "yyyy-MM-dd" - e.g. Failed single from batch ItemChanged 2020-09-29.txt. This is changed to avoid item synchronization to fail due to poor data quality. Increase stability in count list import (TFS: 185489) When the count list contains an item which doesn't exist in Chain Web and was attempted added more than once - it will not stop the import of the whole count list. Information about the one failed item will be logged. Support deleting one EAN when item processing type = full (TFS: 185490) It is possible to delete just one EAN from a count lists, regardless of the parameter value for ModelItemsProcessingType. |
Store | Support hyphen in account number for Swedish customers (TFS: 186256) Hyphen in bank account number is supported. The account number can look like this: 123-4567. |
System | Team view in Chain Web (TFS: 178777) All stores that are part of a team are displayed in Chain Web Team menu. |
User | First/Last Name is not mandatory for Azure users (TFS: 172957) It is possible to create Azure User in Chain Web without First/Last Name, which is still mandatory for standard user. |