Translations in Excel exports (RTC-40943)

In all Excel exports, data in the "Transaction type", "Recount" and "Sales unit" columns are translated.

Grid improvements
Unknown sales units are displayed as "Pcs" in the Inventory grids.

Store access in count group views (RTC-42547)

Modifying a count group requires store access. The user must have "Manage count groups" permission directly in all stores or store groups selected in a count group in order to edit it.

Retry completing stocktaking (RTC-42688)

The option for keeping or resetting not counted items, is working as expected also when retrying completing the stocktaking.

Seasonal storage improvements (RTC-42668)

• The seasonal storage PDF export file has the same name as the storage
• Filtering on the "Storage ID" column is improved

Stock movements improvements (RTC-42670)

• The stock status chart shows a proper message, even if all stock quantities are equal to 0.
• Link to the stock status view from Transactions is present when the user has "View transactions" permission only.

StockBalance import (RTC-38230)

When StockBalance does not have WeightedCostPrice defined in the import, WeightedCostPrice is not exported separately by the Export job

Transactions view performance (RTC-41139)

Two indexes were added to the item transactions table.
The query that fetches item transactions is slightly refactored to improve performance.

Permission improvements (RTC-41317)

• Only the store and store group that the user has access to, is shown in the drop down lists.
• Creating transactions no longer requires the "View stock status" user permission.
• The New transaction modal only displays the transaction types that the user has access to.
• In the Transactions grid, links to Stock movements are no longer visible for users without "View stock status" permission.
  
  

Store picker (RTC-41317)

• Store pickers use the "Contains" filter instead of "Starts with".

Events from Item Service (RTC-42185)

When Inventory receives events from Item Service which contains some duplicated lines, each line is processed once.
The duplicated lines are not processed more than once, which ensure that duplicates are not created in the Inventory database.

Cleanup of inactive prices (RTC-33368)

Old and inactive prices are removed from the system on a daily basis.

Prices are deleted if:

• The "To date" is expired
• The price has status Deleted
• There is a newer, active price for given item/store (group)/price level combination, which is not deleted/expired

Virtual stock (RTC-40884)

A virtual stock cannot be created if no stores are selected.

Last counted date in StockBalance (RTC-41697)

The stock balance method response is extended by "lastCountedDateTimeUtc" field, which contains the date when the item was last counted.

Exceptions handling (RTC-41684)

Improved exceptions handling in Export and PoslogProcessing jobs.

Online return from order (RTC-41629)

When online returns from customer orders are done in a store, that does not have the returned item in their inventory, the item will be added to the stores stock. 

Transaction view improvements (RTC-40895)

• Validation of whitespaces/empty spaces has been added to the transaction note in New transaction modal
• The close button in New transaction modal has been removed
• The transaction filter is improved

Get recount items API (RTC-39604)

A list of items to be recounted can be retrieved for an active stocktaking in a given store.

Image Added

Count group API (RTC-39603)

• The "CountGroups" API returns information on all count groups used in active stocktaking in given store, alongside the number of related and counted items.
• The "CountGroups/Items" API returns the list of items related to a specific count group in active stocktaking in given store.

 Image Added

Add seasonal storage to stocktaking (RTC-37817)

Seasonal storages can be added to an active stocktaking through the "Add seasonal storage" button in the Stocktaking results view.
On add, a count list, containing items from the seasonal storage, will be created and assigned to the stocktaking.
The count lists are removed from the system if they are unassigned.

Image Added 

Stock status view performance (RTC-30587)

The performance of the Stock status view has been improved, and timeouts should no longer occur.
4 columns have been removed from the stock status view:

• Sub supplier no.
• Sub supplier name.
• Supplier item no.
• Supplier model no.

Filtering of item identifier columns (RTC-41698)

In the Stock status grid, the default filtering of item identifier columns (GTIN, SKU, Item number) has "Starts with" as default filtering type.

Internal transfer (RTC-34839)

When the sending store does not have a GLN specified, the internal transfer creation is blocked, and an error message is shown to the user.

Image Added

Seasonal storage (RTC-40971)

• When a seasonal storage is created in Inventory, a Put Away item transaction is created for the items in the storage.
• When a seasonal storage is unpacked in Inventory, a Put Back item transaction is created for the items in the storage.

Store access in Virtual stock (RTC-38065)

The user can view and manage Virtual stocks for profiles that the user has access to.

Improvements in item search and grids (RTC-27407)

Inventory management has been migrated to the Angular version 16 and Kendo version 13.
The item search modal has been extended with additional columns related to item identifiers and supplier information.

Item transactions (RTC-40275)

The validation of item supplier information in imported transactions is improved. 

Stock status and Transactions grid (RTC-34638)

The links leading to stock movements are now present in the Item text column instead of the stock quantity columns. "No item text" is displayed in the Item text column if the item text is missing.

Image Added

Inventory flag (RTC-39618)

For stores that have not selected "Inventory management in use" in Store management, item transactions and reservations do not update the stock.

Transaction type translations in Excel exports (RTC-36967)

In Excel exports for Stock movements and Transactions, translations for the Transaction type column are updated.

Receipts with both a customer order and added items (RTC-40759)

Receipts that contain both sales data and customer order data are processed in Inventory Service. 
For each such receipt, two events; Inventory.Sale.Import and Inventory.Reservation.Import, are created in Inventory - and the item sale is visible in Transactions.

Return from web order in POS (RTC-40396) 

When items from web orders are returned in a physical store, the return transaction is registered on the physical store, along with an increase in the stock.

Export of placeholder items and stores (RTC-38505)

Item transactions and stock values related to items or stores that are not yet created in Chain, will not be exported from Inventory, until the store or item is created.

Ordered quantity in Inventory (RTC-40056)

The Ordered quantity column in Inventory is displaying the ordered quantity for an item, based on the exported quantity from Procurement.

Line value on transactions (RTC-37776)

In the Stock status grid and Transactions grid, there is a column for Line value. This shows the value of the item transaction, price x quantity of items. If there is a weighted cost price on the item, it will show the weighted cost x quantity. If there is no weighted cost, it will show the net price x item quantity.

Stock Balance import (RTC-39413)

If quantity for InStock, Ordered, Reserved or PutAway is not present in the import, then the quantity for these fields are not updated in database.

Inventory (RTC-38903)

The item name length is supporting up to 255 characters.

Tandem items (RTC-38789)

When transactions are made on tandem GTINs (alternative GTINs) in POS or InStore App, the stock of the main article ID is updated in Inventory. 

The transaction is visible in the Inventory grids on the main article ID.

Source system column (RTC-37254)

In Transactions and Stock status there is a column called Source system, which shows in which system the transaction was created. 

Stock balance import (RTC-37999)

The weighted cost price is retrieved from the database if it is not present in the stock balance import file.

Returns (RTC-37840)

On all returns, the Reason code and Action code can be seen on the transaction in the Transactions overview.

Stock level for not counted items (RTC-36094)

When finishing a stocktaking, the user must choose what to do with the items that were not counted during the stocktaking. The user can choose to keep the stock level for these items, or choose to set the stock level to zero.

Net price in manual count lists (RTC-37202)

The net price in count list grid is filled for items in manual count lists.

Stocktaking error statuses (RTC-37169)

Stocktakings with the status "Error creating" can be deleted or scheduled for retry.
Stocktakings with the status "Error closing" can be exported to Excel or scheduled for retried closing.

Waste transactions (RTC-37169)

Stocktaking waste transactions are not exported.

Add item to a stocktaking (RTC-37204)

Items can be added to an active stocktaking, with the 'Add item' button at the bottom of the page. Only items that are not already part of the stocktaking can be added. In case the item already exists in the stocktaking, the user will be informed and the action must be canceled. 

Image Added

Complaints (RTC-36322)

When a return transaction with damage flag equals to True, a sale transaction with positive quantity and a complaint transaction is created for this return transaction. There is no change in the item's stock.

Stocktaking results grid (RTC-35995)

• The "Kept in stock" column is renamed to "Track stock level", and displays whether item has stock change tracking enabled.
• The "Out of scope" column is hidden by default.

Stock and waste reports (RTC-36081)

The stock and waste reports can be created for completed stocktakings from the stocktaking results view. The stock report includes all results with positive counted quantity, and the waste report includes all results with deviation in value.

Delete stocktaking (RTC-36346)

Only stocktaking with status 'Active' can be deleted.

Default store selection for a count group (RTC-35946)

When the user has access only to one store, team or profile, it is selected by default for corresponding store level option while creating or editing a count group.

Selecting count lists (RTC-36467)

Selecting one or multiple count lists in the grid activates the "Activate selected" button.

Created date (RTC-36020)

"Created date" column from transaction line is added to the stock movements grid.

Fix: Count group picker (RTC-35945)

The count group picker in New stocktaking view is no longer hidden when the user has access to a single store.

Cost price (RTC-35463)

When updating count lists from API, it will either update the cost price based on value from 3rd party, or if zero, use the existing cost price in Inventory module.

Only one active stocktaking per store (RTC-35889)

Multiple clicks are blocked for any button that saves/creates data in the Inventory module.

Terminology update (RTC-35669)

The price terminology in Inventory is unified with other services:

• The "Cost price" column in Transactions grid is renamed to "Net price". "Weighted cost price" column is added to the grid.
• The "Cost price" column in Stock movements grid is renamed to "Net price".
• The "Cost price" column in Stocktaking results grid is renamed to "Weighted cost price". "Net price" column is added to the grid.
• The "Cost price" column in Count lists grid is renamed to "Weighted cost price". "Net price" column is added to the grid.
• The new transaction modal displays "Weighted cost price" for item instead of "Net price".

Export of daily stock status (RTC-35561)

All changes to stock on a particular day are by default exported to third-party services every night, default by 01:00 AM in UTC time. This can be disabled or changed to another time of day.

Last stocktaking date for item (RTC-35525)

The stock status export includes the date of last stock counting in item data.

Customer order reservations (RTC-35153)

Reservations from dispatch and Click-and-Collect orders are properly handled in Inventory.
Stock is reserved in proper store - picking stores for dispatch orders, reserved store for Click and Collect.

When picking orders are completed stock and reserved quantity are properly reduced in proper stores.

Last stocktaking date for item (RTC-35525)

The date of when the item was last stock counted is tracked and displayed in the stock movements view.

Delete stocktaking (RTC-35473)

An active or completed stocktaking can be deleted from the Stocktaking results view. Once per day, all stocktakings with status deleted will be removed from the system.

By default this job does not delete old stocktakings (15 months older than today's date).
The job will delete old stocktakings when parameter "Old stocktaking deletion enabled" value is equal to True.

Stocktaking results view improvements (RTC-35473)

• The stocktaking action buttons, except Excel export, are visible only in active stocktakings and require "Manage stocktakings" permission.
• The row menu in grid is visible only in active stocktakings and require "Manage stocktakings" permission.

Fix: Update of suppliers item number (RTC-35398)

Supplier Item No is saved in for StockAdjustment transactions from InStore App or from 3rd party.

Cost price in manual created transactions (RTC-33105)

The cost price of an item is displayed in the new transaction modal and saved for manually created transactions.

Get stock (RTC-32910)

When GetStock request is sent for store-item combination that does not exist in Inventory.Stock database, returned stock values are equal to 0.

Access control (RTC-34732)

• The data in Count lists grid is displayed based on user's store access.
• The data in Count groups grid is displayed based on user's store access.
• The count group item source picking subpage cannot be accessed if a source was already selected.
• The stocktaking results page cannot be accessed without ViewStocktaking permission.
  
  

Sorting of stocktaking (RTC-35454)

Stocktaking grid is sorted by created date and time from newest to oldest by default, "Date" column is renamed to "stocktaking date".

Cyclic stocktaking (RTC-32826)

The items that will taken to the stocktaking are based on the count group selection during new Cyclic Stocktaking creation process.

Sorting of reason codes (RTC-33901)

When creating new transactions, reason and Action codes are sorted ascending by code.

Import API description (RTC-34085)

Each transaction have a short description. Required field are marked with red asterisk in schema view.

Transaction types (RTC-35020)

Reason code label, that is displayed above types of transactions in Reason Code register view, is named "Transaction types".

Reason and action codes for return (RTC-34517)

Reason and action codes can be defined for "Return to stock" transaction type.

Finish stocktaking (RTC-34666)

When finishing the stocktaking, the user is moved to the stocktaking result view with status "Closing".
"Finish stocktaking" button is available in count list tab in stocktaking result view.

"Status" column (not used) is removed from stocktaking result view.

Export to Excel (RTC-34622)

"Export to Excel" button is always active. When there are more than 100 000 rows in the filtered view, a message is displayed to the user.

Stocktaking values are aggregated (RTC-34564)

• The total deviation in value of a stocktaking is calculated and displayed in the stocktaking grid.
• The following values are displayed in the waste report after finishing a stocktaking:
  • Total deviation in value
  • Total deviation in quantity
  • Amount of items with non-zero deviation
  • Amount of counted items
    
    

Stocktaking results header (RTC-34564)

Fix: The stocktaking status header is displayed after page refresh in count lists tab.

Fix: Add count lists for inactive stocktaking (RTC-34588)

When user is trying to add count lists to inactive stocktaking, proper warning notification is displayed

Changes in menu (RTC-35019)

Transactions log submenu is renamed to Transactions.

Cost price and supplier item no (RTC-34478)

Cost price and supplier item no. columns are filled based on event's data. When cost price is empty in the message, then it is replaced by weighted cost price from stock. When supplier item no. is not defined in the event, then it is empty in the grid as well.

The user can create new/manage count groups (RTC-32440)

Count group can be assigned to:

• All stores;
• Stores selected by user;
• Teams selected by user;
• Profiles selected by user.

Items can be assigned to the count group in three different ways:

• With item list;
• With item group list;
• With item segmentation.

Cost price (RTC-33436)

GetStock method is returning in response the newest item's net cost price, when weighted cost price is equal to 0.

Created date column in Transaction log (RTC-34481)

The created date column is available in the Transaction log, which informs when the transaction was created in the system.

Internal transfer with goods receival (RTC-22728)

When the user makes an internal transfer, the stock in sender store is decreased and a purchase order is created in the Procurement module. After the order is completed and goods are sent, the stock in recipient store is increased.

Filtering panel improvements (RTC-33514)

• The transaction type filters from the filtering panel interact correctly with the grid's type filter, and correct data is displayed.
  
  

Excel export improvements (RTC-33514)

• The column order in exported Excel files from Transaction log and Stock movements is equal to the order in the grid.
• The transaction type filter is no longer shown in the Excel export modal if all types in the filtering panel are checked and grid's type filter is not used.