- Print
- DarkLight
- PDF
Release 10.12.2024
Last counted date in Stock status (RTC-45769)
In Stock status, the column for Last counted date shows the last time the item was counted in a stocktaking.
The column can be used to get an overview of items that has not been counted since a given date, by filtering or sorting.
The column is included in the export to Excel.
Performance of adding seasonal storage to stocktaking (RTC-42055)
The process of assigning seasonal storage to a stocktaking has been moved to a background job.
This change greatly improved the performance of assigning seasonal storages to stocktakings.
Permission to View transactions
When the Mange all transactions role is checked, then View Transactions is automatically checked as well.
Release 08.11.2024
Stocktaking for stores that are not using Inventory management
When a store is not using Inventory Management, the purpose of doing stocktakings is to count all items in the assortment and create a stock list for financial reporting purposes.
Store that are not using Inventory management have not checked "Inventory management in use" in Item Management.
For stores that are not managing their inventory:
The only available stocktaking type is Periodic, which includes all items with a price from the stores' active assortment.
Waste and stock aggregates in the stocktaking are always zero.
Deviation and stock aggregates on the items are always zero, and weighted cost price is always the net price.
Deviations on the count list is always zero.
Deviation on count list items are always zero, and weighted cost price is always the net price.
Completing the stocktaking does not create any waste transactions, nor create or update stocks.
"Items not counted" step in the complete stocktaking view, and waste reports, is not shown.
Improvements
Transactions | Reserved quantity (RTC-44968) The reserved quantity is not increased, and the delivered quantity is correctly increased, when a poslog with ordered and delivered items arrives in the Inventory module in one operation. |
Stocktaking | |
General | Columns improvement (RTC-40938) All fromcolumns one side of the grid cannot be disabled at the same time. |
User roles | Inventory roles (RTC-42671) Managing item transactions individually has been removed. The permissions for managing item transactions supports View transactions or Manage all transactions. With Manage all transactions, the user gets access to manage all transactions types: Breakage, Internal user, Stock correction, Internal transfer, Return to supplier. |
Technical | .NET 8 InventoryService repository was updated to .NET 8. Validation of optional fields are displayed in the Inventory Service swagger. The item integration have been extended to fetch ItemTypeName and ItemTypeCode data from Item Service. |
Release 23.09.2024
Replace recounted items
Recount is a type of count list which causes overwriting of the previously counted value, when assigning the recount list to the active stocktaking.
When a recount list is assigned to a stocktaking, the user is notified that this will overwrite the previously counted quantity for the items, and the user can assign it or cancel the assignment.
Inventory service has two GET requests for recount groups:
Store - Returns a list of recount groups with number of items to be recounted for an active stocktaking in a given store.
It returns no results if no stocktaking is active in the given store.Items - Returns a paged list of items tagged to be recounted.
Improvements
Stock | Changing picking store caused negative reserved quantity (RTC-43837) The stock is no longer updated on already delivered items, when the picking store is changed. |
Release 09.09.2024
Count group status
Count groups in stocktakings can have the statuses "New" (by default), "Count In Progress" or "Count List Submitted".
The "Inventory.CountList.Import" file import has an optional "countGroupId" field, which allows linking a Service type count list with a specific count group. Linking the count group will change its status to "CountListSubmitted" in the active stocktaking of count list's store.
Deleting a count group or updating its store level removes its links to all count lists.
The "CountGroups/Get" API is extended by the count group status through the "countGroupStatus" field.
The "CountGroup/Status/Patch" API allows changing count group status between "New" and "CountInProgress".
Improvements
Grids and exports | Translations in Excel exports (RTC-40943) In all Excel exports, data in the "Transaction type", "Recount" and "Sales unit" columns are translated. Grid improvements |
Stocktaking | 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 | Seasonal storage improvements (RTC-42668)
|
Transaction / Stock status | Stock movements improvements (RTC-42670)
|
Release 12.08.2024
Improvements
Stock import | StockBalance import (RTC-38230) When StockBalance does not have WeightedCostPrice defined in the import, WeightedCostPrice is not exported separately by the Export job |
Transaction | Transactions view performance (RTC-41139) Two indexes were added to the item transactions table. |
User access | Permission improvements (RTC-41317)
Store picker (RTC-41317)
|
Item | Events from Item Service (RTC-42185) When Inventory receives events from Item Service which contains some duplicated lines, each line is processed once. |
Release 25.07.2024
Improvements
Price | Cleanup of inactive prices (RTC-33368) Old and inactive prices are removed from the system on a daily basis. Prices are deleted if:
|
Virtual stock | Virtual stock (RTC-40884) A virtual stock cannot be created if no stores are selected. |
Stock gateway | 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. |
General | Exceptions handling (RTC-41684) Improved exceptions handling in Export and PoslogProcessing jobs. |
Release 05.07.2024
Improvements
Transactions | 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)
|
General | POSLogs with errors (RTC-41423) Incoming POSLogs with an error status, a missing poslog envelope or poslog version 0, are skipped in the poslog processing. |
Release 01.07.2024
Improvements
Inventory service | Get recount items API (RTC-39604) Count group API (RTC-39603)
|
Stocktaking | 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.
|
Stock status | Stock status view performance (RTC-30587) The performance of the Stock status view has been improved, and timeouts should no longer occur.
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. |
Item transaction | 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.
|
Release 11.06.2024
Import Count lists from Excel
Count lists can be imported from Excel. From the Count Lists overview, an empty count list template can be downloaded.
The buttons for Export empty template and Import count list are at the bottom of the Count list page.
The Excel file can be imported from the same page, with the "Import count list" button.
The Excel template contains the following columns: "SKU", "GTIN", "Item number", "# Counted" and "Net price".
One identifier is required. The quantity and net price is optional, but can not be negative.
The net price and quantity will update Inventory when the stocktaking is completed.
Maximum 10,000 rows can be imported in the same import.
The user is notified when the export and the import is completed.
Seasonal storage
Seasonal storage is a register of items that have been temporarily put away.
These items are still in stock, but not part of the available stock.
The Seasonal Storage overview shows all the seasonal storages for the stores which the user has access to.
The content of seasonal storages can be printed, to be attached to the seasonal storage.
Seasonal storages can be printed from three dots in the overview, or opened and printed from there.
Seasonal storages can be created in the Inventory module via Inventory.SeasonalStorage.Import file import from file service.
When Inventory.SeasonalStorage.Import file is fetched by InventoryIntegrationPackage, a seasonal storage with the next free storage number is created in the Inventory module,
and the put away quantity is increased for the items in the seasonal storage.
The first Seasonal storage is created with number 100000 and then each next number is incrementally increased by 1. Each seasonal storage can contain up to 10000 items.
Seasonal storages in InventoryService
/api/SeasonalStorages - fetches all seasonal storages from InventoryService database (without items)
/api/SeasonalStorages/identifier - fetches details of seasonal storage with selected identifier from InventoryService database (with all items)
/api/SeasonalStorages/identifier/unpack - unpack seasonal storage with selected identifier, the seasonal storage is marked as unpacked, the put away is reduced for all items from unpacked seasonal storage
Improvements
Virtual stock | Store access in Virtual stock (RTC-38065) The user can view and manage Virtual stocks for profiles that the user has access to. |
Stocktaking | Stocktaking view improvements (RTC-40888)
|
Stock import | Item identifiers (RTC-41140) All items identifiers (SKU, GTiN, External item number) are unique in EG Inventory Service database, so duplicates should not occur. |
Reason codes | Reason code improvements (RTC-40885)
|
Release 23.05.2024
Improvements
General | Improvements in item search and grids (RTC-27407) Inventory management has been migrated to the Angular version 16 and Kendo version 13. |
Transaction | 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. |
Stock | 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. |
Reports | Transaction type translations in Excel exports (RTC-36967) In Excel exports for Stock movements and Transactions, translations for the Transaction type column are updated. |
Release 10.05.2024
Improvements
Transactions | 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. 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. |
Stock export | 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. |
Release 11.04.2024
Improvements
Stock status | 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. |
Item transactions | Return (RTC-39979) For online returns, the stock is always returned in the original store of the returned customer order. |
Release 26.03.2024
Improvements
Item transaction | 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 status | Dispatch orders from warehouse (RTC-39589) When dispatch orders are fully picked in the warehouse, the stock in Inventory is adjusted in the selling store and picking store. Ordered quantity (RTC-37210) In Stock status, the Ordered quantity column shows the ordered quantity on the item. |
Menu | Changes in the menu (RTC-38977) "Archive" and "Stocktaking results exports" are removed from the menu, as they are not in use/not yet implemented. |
Release 08.03.2024
Trigger stock export manually
All stock values can be manually exported from the stock status view. The 'Export stock values' button is available from the '...' button.
The user is notified when the stock export is completed.
To have access to trigger the stock export, the user role needs the permission: Trigger stock export.
Note: All stock changes during the last 2 days are automatically exported every night. All stock status changes are also exported automatically throughout the day, every 1 minute by default.
This manual export should only be used when there has been incidents that has affected the stock updates, for example downtime or disruptions at 3rd party.
Improvements
Stock | 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. |
Stocktaking | Stocktaking summary (RTC-38837) When a stocktaking has an active status, the user cannot access the Summary step. Creating a new stocktaking (RTC-38703) A new stocktaking cannot be created if there are any stocktakings with one of these following statuses for the selected store:
Finish stocktaking (RTC-37396) Improvements have been made to prevent timeouts, when resetting the stock quantity of Not counted items in a stocktaking. |
Excel report | No duplicates in Stock status Excel export (RTC-39183) The Excel report that is generated from the Stock status view has been improved to not contain duplicate item rows. |
Release 19.02.2024
Remainder stocktaking
The remainder stocktaking can be used to count items that have not been counted since a specified date.
The remainder stocktaking is typically used for counting items that were not previously counted during cyclic stocktakings throughout the year.
One can choose to include all items or only items from a count group. If items from count groups are selected, only the items that were not counted since the specified date are included.
If all items are included, all the items that were not counted since the specified date are added.
General | Inventory (RTC-38903) The item name length is supporting up to 255 characters. |
Transactions | 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. |
Stocktaking | Deleting a stocktaking (RTC-36552) A stocktaking with 500,000 items can be deleted without timeout. |
Release 07.02.2024
Transactions | 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.
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. |
Stocktaking | Add count group to a stocktaking (RTC-35682) Count groups can be added to an active cyclic stocktaking, with the "Add count group" button at the bottom of the stocktaking page. Random stocktaking (RTC-38132) Count lists can't be unassigned from a random stocktaking. If a count list needs to be removed, the stocktaking must be deleted. |
Release 22.01.2024
Virtual stock
With virtual stock, multiple stock locations can be combined and made available for a stock location without its own stock. For example, a web shop without its own stock can have the combined stock values from several selected physical stores, which the customer can get their items delivered from.
The permission Manage virtual stocks must be active for the user role to be able to view and manage Virtual stocks.
Only one virtual stock can be created per profile, from the active stores that are in the profile. Stores can be added and removed from the virtual stock. The user must input a code of their choice for the virtual stock. The virtual stock code must be unique among other virtual stocks and actual store numbers. Virtual stocks can be created, edited, activated, deactivated and deleted.
Random stocktaking
With a random stocktaking, the stocktaking is empty upon creation.
The items to be included in the stocktaking are added by activating the relevant count lists.
The stock basis is taken from the count lists. If an assigned count list needs to be removed, the stocktaking needs to be deleted - and created again.
Improvements
Release 12.01.2024
Recount item
Items in an active stocktaking can be marked for recount, by clicking the three dots on the item line and selecting Recount item. Multiple lines can be selected at the same time.
The user will be asked if the selected items should be added to an existing recount group, or if they wish to create a new recount group.
When items have been added to a recount group, the items will have a recount symbol in the stocktaking, and the name of the recount group is filled out.
The Recount column can be filtered on Awaiting recount and Recounted. The Recount group column can be filtered on the recount group names.
When the item as awaiting recount, the recount symbol is blue. When the quantity has been manually edited, or the item has been manually set to Recounted, the symbol will be grey.
The item can manually be set to Recounted, or the recount can be removed by selecting Do not recount.
The items marked for recount can be exported to Excel for recounting in the store.
Note: If the recounted items are added to the stocktaking automatically from a regular count list, the recounted quantity will be added to the previously existing counted quantity. The recount symbol will not be updated.
If the recounted value should replace the previously counted value, the recounted quantity must be added manually to the items in the stocktaking by editing the item. This will update the recount symbol to grey.
Improvements
Internal transfer | Export net price on internal transfers (RTC-37779) When creating internal transfer, the items net price is exported if the weighted cost price is 0 (zero) or missing. |
Inventory | Focus in Counted field when editing row (RTC-37548) When editing a row in a stocktaking, the focus is placed in the Counted field when the modal is opened. |
Item transactions | Prices are retrieved when importing (RTC-37252) The net price and weighted cost price is retrieved from the system if they are not present in the transaction import. Import of external reference (RTC-36379) In some of the Inventory file imports, an External reference (number) can be sent on line level. |
Release 05.01.2024
Item transactions | Items not stocked (RTC-36703) The stock of items with disabled stock change tracking is not created nor updated by transactions made through inventory management. |
StockGateway | StockBalance performance improvements (RTC-36061)
|
Stock status | Net price in stock status (RTC-36799) In the Stock status overview, there is a column for net price. This column shows the current net price for the item at the given store. The data in this column is updated daily at 4 am, by default. |
Stocktaking | 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. 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. |