You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 25 Next »

Chain Web v. 2.10.84

Document status: RELEASED

Date:  

Improvements 

Module

Description

Chain management 

Fix: Team view page shows linked stores (RTC-16495)

All linked stores are displayed properly in Teams, Profiles and Configuration groups views.



Chain Web v. 2.10.83

Document status: RELEASED 

Date:  

Version Requirements is located on the menu to the left.

Improvements

Module

Description

Balance

Store number is used instead of Id in all cashier balance (RTP-13797)

When creating summary for all cashiers the storeId is saved properly in database.

User management

Fix for permissions (RTC-16293)

When parameter UsersCanOnlyAssignRolesTheyAreAssignedTo is active and some user is editing the other one, the added/removed are changed only for that user (not for the user that are editing as well).



Chain Web v. 2.10.82

Document status: RELEASED 

Date:  

Version Requirements is located on the menu to the left.

Improvement

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

(RTC-14436)

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
BalanceBalance
Expired bonus pointsExpired bonus points

Automatic logoff in Chain Web

(RTC-15046)

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

(RTC-15074)

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:
BackOffice batch generator 1.5.3

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:

  • Water measure in tank -> Water
  • Daily Variance, Daily Variance% -> Daily on two cells merged above and below: Variance and Variance%
  • 5 Days Cumulative Variance,5 Days Cumulative Variance%,5 Days Cumulative Sales -> 5 Days Cumulative on three cells merged above and below: Variance, Variance% and Sales
  • 31 Days Cumulative Variance,31 Days Cumulative Variance%,31 Days Cumulative Sales -> 31 Days Cumulative on three cells merged above and below: Variance, Variance% and Sales
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

(RTC-14247)

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
Filename0609_SalesPerArticleWithBreakage
Data SourceLindbak POS Reporting DW and Lindbak POS Message Service
SelectionComment
Date fromDefault last available End of day
Date to

Default last available End of day

Relavant hidden parameters:
pRetailStoreStore, default 1001
pReasonCodesExcludedReasons codes which will be excluded from breakage fields. Default 14 and 15.
Columns - One row per item group
Article Group KeyArticle group key
Article Group nameArticle text
QuantityQuantity sold
VAT ClassShows 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. VATShows sales excluding VAT
VATShows VAT amount
Sales w/VATShows sales including VAT
ButikknrRetail Store
Net CostNet cost
Breakage QuantityQuantity of broken items
Breakage Net AmountNet cost of broken items


New report showing top sales per item

(RTC-14251)

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 name0454_TopSalesPerItemWithItemInfo
Data sourceAnalysis services (Cube) and Lindbak POS Reporting DW (Database)
Selections
Date fromDefault today
Date toDefault today
Compare date fromDefault same day in same week last year

Compare date to

Default same day in same week last year
Retail storeDefault all
Article areaDefault all
Article groupDefault all
GroupingDefault area
CountHow many items to show - Default 10. Default valuye can be change in hidden parameter pCount
Sort typeIf items sould be sorted by best or wors - Default best. Default value can be change in hidden parameter pSortType
Sort measureWhat mesure to sort by. Available measures are Amount, Quantity, Net Cost, Gross profit or Gross profit %. Default Amount
Include VATIf VAT should be included in sales amount or not. Default Yes. Default value can be changed in hidden parameter pIncludeVAT
VendorDefault all
SubvendorDefault all
EAN listDefault empty

Columns - One row per item

Area

Article area

GrpArticle group
EANEAN
Item nameItem name
Article infoLabel text 2
Date fromDate to
QuantityQuantity sold
TurnoverSales amount
Gross profitGross profit
Gr. prof. %Gross profit percentage
Compare date fromCompare date to
QuantityQuantity sold
TurnoverSales amount
Gross profitGross profit
Gr. prof. % Gross profit percentage

Sales Report per department/area based on EOD

(RTC-14074)

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
Filename0608_SalesPerDepartment
Data sourceLindbak POS Reporting DW database
SelectionsComment
Retail store Store, default first store in list
YearDefault current year
EOD Date fromDefault last available EOD
EOD Date toDefault last available EOD
Include nonsaleIf nonsale is included in sale. Default true
Relevant hidden parameters
pArticleGroupList1Add Article Group numbers for Articles to be displayed in first table (Fuels)
pArticleGroupList2Add Article Group numbers for Articles to be displayed in second table (Retail goods)
pArticleGroupList3Add Article Group numbers for Articles to be displayed in third table (Automatic Car Wash)
pArticleGroupList4Add Article Group numbers for Articles to be displayed in fourth table
pIncludeNonsaleIf Include nonsale should be default true or false
Columns - One row per distinct combination of Department, Article Area and Vat%
DepartmentDepartment number
Dept nameDepartment name
Area noArticle Area number
Area nameArticle Area name
QuantityQuantity sold
VAT classShows 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. VATShows sales excluding VAT
VATShows VAT amount
Sales w/VATShows sales including VAT

Sales report per item/item group based on EOD

(RTC-14037)

New report showing sales per item / item group where period is based on EOD (End of day).

Report details Sales per item
Filename0607_SalesPerItemInGroup
Data sourceLindbak POS Reporting DW database
SelectionsComment
Retail storeStore, default first store in list
YearDefault current year
EOD Date fromDefault last available EOD
EOD Date toDefault last available EOD
Include nonsaleIf nonsale is included in sale. Default true
Article groupDefault All
Relevant hidden parameters:
pIncludeNonsaleIf Include nonsale should be default true or false
Columns - One row per item. Group by Item group / VAT
EANEan
ItemArticle text
QuantityQuantity sold
VAT classShows 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. VATShows sales excluding VAT
VATShows VAT amount
Sales w/VATShows sales including VAT

Receipt Journal Access

(RTC-13766)

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

(RTC-12019)

New system parameter CashierPinCodeLength has been added. It defines the minimal length of the cashier password. Default value of this parameter is 6. When cashier's password is changed, it will be validated if it is shorter than the value defined in CashierPinCodeLength parameter. Additionally, the current password cannot be reused as the new cashier password.


Improvements 

ModuleDescription

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.
New role "Edit balance older than x hours" which allows user to edit balances older than time defined in "EditBalanceNotPermittedIfOlderThanHours" parameter. The user without this role is not able to edit old balances (this applies to the shift balances too).


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.
The job send message to the cloud service bus, where the GiftcardsImport job reads it and insert data (giftcards, transactions) to the Lindbak GiftcardService database.


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.
These options work for gift cards with or without email address/phone number assigned. If both a mobile number and an email address are assigned to the gift card, then information automatically will be sent only to the email.

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:
Top sales per item with compare date (0454_TopSalesPerItemWithItemInfo)
Sales by product area (0456_SalesByPRoductAreaOrGroupWithInteractiveSorting)


Cashier statistics report (RTC-13893)

To improve following up cashiers, we have created new report.
The report is identical to Cashier statistics (0018_CashierStatistics) with two new columns for manual discount. This shows data for all Line discounts given manually in POS.
Amount - Manual discount in amount for Line discount.
Percent - Manual discount in percentage for Line discount (discount / amount * 100)


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.
One label "Counted" has been renamed to "To bank" in shift balance creation process in register bag step for a better user experience.

Stocktaking

Stocktaking improvements (RTC-8023, RTC-7724)

The following changes are implemented in the stocktaking module:

  • The delete button is hidden in more button (...).
  • The count list button is grey and the refresh button has been renamed to refresh stock level.
  • For finished stocktakings (for all types), statistics have been changed. If it took 0s to finish the stocktaking, there is no information about the duration in the statistics on stocktaking dashboard.

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.
Grids affected by those changes: Count lists, Stocktakings, Count lists in given stocktaking and Archive.

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.64

Document status: RELEASED 

Date: 

Version Requirements is located on the menu to the left.

Improvement 

ModuleDescription

User management

Fix for permissions (RTC-15672)

When parameter UsersCanOnlyAssignRolesTheyAreAssignedTo is active and some user is editing the other one, the added/removed are changed only for that user (not for the user that are editing as well).


Chain Web v. 2.10.61

Document status: RELEASED 

Date: 

Version Requirements is located on the menu to the left.

New UI for handling stores in Dispatch rules

(RTC-13056, RTC-13053)

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

(RTC-13695)

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

(RTC-14074)

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.
VATShows VAT amount.
Sales w/VAT Shows sales including VAT.

Sales report per item/item group based on EOD

(RTC-14037)

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 fromDefault last available EOD.
EOD Date toDefault last available EOD.
Include nonsaleIf nonsale is included in sale. Default true.
Article group Default All
Relevant hidden parameters:
pIncludeNonsaleIf Include nonsale should be default True or False.

Columns -One row per item. Group by Item group / VAT

EANEAN 
Item Article text.
QuantityQuantity sold.
VAT classShows 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.
VATShows VAT amount.
Sales w/VATShows sales including VAT.

Daily report for fuel sales

(RTC-13540)

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

(RTC-12690)

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:
pVarianceThreshold when to color columns for Daily Variance orange. Default 200.
pVariancePrcThreshold 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.

DeliveriesDelivery 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 available 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 dependent 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.
These options work for gift cards with or without email address/phone number assigned. If both a mobile number and an email address are assigned to the gift card, then information automatically will be sent only to the email.

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.
This is corrected and cashiers with only deleted receipts will also appear in the report.

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
  0101_Monthreport
  0103_TotalSales
  0113_WeekReportNoEcommerce
  0114_TotalSalesNoEcommerce

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

(RTC-10570)

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

(RTC-11492)

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

(RTC-11456)

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. 


POS Configuration

New parameter

BalancePeriod

Defines the balance period type. Parameter can be set to "Date" (default) or "Shift".


Existing relevant parameters:  

BalanceTransactionType 

Can currently be set to Cashier, Workstation or Store. When BalancePeriod is "Shift", counting will always be done per cash register. 

New report for shift statistics

(RTC-11449)

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.

  • Changed report 0453_SalesByProductAreaOrGroup.



Chain Web v. 2.10.35

Document status: RELEASED

Date:

Version Requirements is located on the menu to the left.

Improvements

ModuleDescription
Receipt journal

POS unit filtering (RTC-9114)

Fixed a problem where POS unit filter field were not removed as it should.



Chain Web v. 2.10.34

Document status: RELEASED

Date:  

Version Requirements is located on the menu to the left.

Improvements

ModuleDescription
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

ModuleDescription
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

ModuleDescription
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.
For more information about changes in POS, please read release notes related to "Don't allow editing the same order in POS and Chain Web".

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.
Additionally, when 'View for all stores' is checked, the data in Homepage dashboard is refreshed automatically.


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.

  • Case1: We update changes in Retail database in one Rt-job, but not changes from POSLog. Status for order line will be ONLY Rejected. Before we update POSLog we will not have assign status for new store.

  • Case2: We update changes in POSLog in one Rt-job, but not changes from Retail db. In this case Rejected lines will have status "Reassigned" before we update correct status from Retail db.

  • Case3: We create order, reject it in Chain Web. If we update changes from Retail db before all POSLogs, we will only have reassigned status in Reporting.

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

(RTC-10169)

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.
For more information about changes in POS, please read release notes related to "Don't allow editing the same order in POS and Chain Web".


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.

  • Case1: We update changes in Retail database in one Rt-job, but not changes from POSLog. Status for order line will be ONLY Rejected. Before we update POSLog we will not have assign status for new store.

  • Case2: We update changes in POSLog in one Rt-job, but not changes from Retail db. In this case Rejected lines will have status "Reassigned" before we update correct status from Retail db.

  • Case3: We create order, reject it in Chain Web. If we update changes from Retail db before all POSLogs, we will only have reassigned status in Reporting.

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

(RTC-10875)

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

(RTC-10170)

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

(RTC-10606)

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:

  • Chain Web

  • Manuell kassa

  • InStore App

  • Självscanning (SU)

  • Mobilsjälvscanning

  • Självbetjäning (SCO)

Additionally, parameter pWorkstationType two values has new translations (“ITAB” is now changed to “ISA” and “SU” is now changed to “SCO”).
Furthermore, pWorkstationType has two new items in the list (Web shop and Other).


Translations (RTC-10894)

The Swedish and Norwegian translation of the workstation type name "Other" in the dropdown list of parameter pWorkstationType (used in reports 0705/0706 and others) is updated with the following values:

  • Swedish: Övriga

  • Norwegian: Andre

  • Additionally, the text "Web shop" is changed to “Webshop”, according to requirements.


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:

  • ShopAndGoCheckOut - Självbetjäning (SCO)

  • ShopAndGoCheckTerminal - Självscanning (SU)

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:

  • Swedish: Övriga

  • Norwegian: Andre

  • Additionally, the text "Web shop" is changed to “Webshop”


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:

  • ShopAndGoCheckOut - Självbetjäning (SCO)

  • ShopAndGoCheckTerminal - Självscanning (SU)



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

(RTC-10606)

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

(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.

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:

  • Chain Web

  • Manuell kassa

  • InStore App

  • Självscanning (SU)

  • Mobilsjälvscanning

  • Självbetjäning (SCO)

Additionally, parameter pWorkstationType two values has new translations (“ITAB” is now changed to “ISA” and “SU” is now changed to “SCO”).
Furthermore, pWorkstationType has two new items in the list (Web shop and Other).



Chain Web v. 2.10.12

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

(RTC-10471)

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

(RTC-10388)

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-812RTC-697RTC-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.
















OrderMessageIntegration package 1.2.0installation package available at:
\\nas_install\LRS\Lindbak Integrations\3.0\OrderMessageIntegration

POSServices 2.37.126.0

Automatic Reassign

(Jira links: RTC-715RTC-3836RTC-740RTC-859RTC-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:

  • ButtonConfig, function START_SELF_SERVICE


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:

  • SynchronousUpdateCountListMaximumSize - counted based on sum of all lines (unique SkuNumber) from all used count lists

- 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.

POS Configuration

ButtonConfig

Function LIST_USED_COUPONS can be configured on a selected button.

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.

Configuration

Both sub reports have a new parameter pDepositRefundArticleGroups

Default value is "{[Article].[Article Group].[ALL]} " which means report works as before.

Parameter should be set to item group number used for received deposit refund.


Example - parameter set to item group 501: {[Article].[Article Group].&[501]}

Example2 - parameter set to item group 501 and 502: {[Article].[Article Group].&[501],[Article].[Article Group].&[502]}

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.
In addition to that, 'Sales per Hour' and 'Customers per Hour' components displays the correct amount of Sales and Customers per concrete hour and day . They are compatible with loaded data and present visual results with appropriate/matching colors. It is also possible to click at this components and see a pop up with details in comparison with the same date last year or date set by user itself (same as in 'Sales per Department' component). 

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:

  • Approved for F-tax

  • Registered office

  • IBAN/BIC is always printed on the invoice

  • Organization number, in addition to the VAT number 


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
0059_CashierStatistics
0062_DashboardCashRegister_1
0066_DashboardCashRegister_PerTeam
0071_SecurityStatistics
0111_CashierSecurityStatistics
0160_CashRegisterReport
0301_CashierStatistics
0517_DashboardCashregister_std
3002_DashboardCashRegister_PerTeam
1011_subStatistics
1706_subStatistics

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.

  • No labels