Release 08.11.2024
Stocktaking for stores 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 store 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
Area | Description |
---|---|
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 columns from one side of the grid cannot be disabled at the same time. |
User roles | Inventory roles (RTC-42671) The permissions for managing item transactions supports View transactions or Manage all transactions. |
Technical | .NET 8 InventoryService repository was updated to .NET 8. 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
...
- 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
Area | Description |
---|---|
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. |
...
- 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
Area | Description |
---|---|
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
Area | Description |
---|---|
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
Area | Description |
---|---|
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
Area | Description |
---|---|
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
Area | Description |
---|---|
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.
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. Seasonal storage (RTC-40971)
|
...
- /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
Area | Description |
---|---|
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
Area | Description |
---|---|
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
Area | Description |
---|---|
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
Area | Description |
---|---|
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
Area | Description |
---|---|
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. |
...
Info |
---|
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. |
Improvements
Area | Description |
---|---|
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. |
...
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
Area | Description |
---|---|
Reason codes | Update of reason codes (RTC-37894) Users with Norwegian or Swedish as selected language, can edit and save reason codes. |
Transactions | Training mode (RTC-38121) Transactions created by cashiers in Training mode are not imported to the Inventory module. |
...
Info |
---|
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. |
Improvements
Area | Description |
---|---|
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. |
...
Changes for virtual stocks are exported each minute as Inventory.VirtualStockStatus.Export event. The stock for each item in this event is the aggregated stock from all stores that are belonging to the same virtual stock location. More about this event can be found in the export part of the Inventory Service swagger.
Improvements
Area | Description |
---|---|
Item transactions | 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 | Stocktaking results grid (RTC-35995)
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. |
...
- Item has some stock, but for some reasons weighted cost price was equal to 0;
- Stock quantity was negative;
- Item did not have stock in given store yet.
Improvements
Module | Description |
---|---|
Item transaction | Reason/action codes and language changes (RTC-30933) Reason code field is displayed above action code in the new transaction modal. |
Stock status | Minor improvements to the Status tab in Stock details view: (RTC-30737)
|
Transactions logs | View item transactions per item (RTC-31429) Stock balance and sales transactions are shown in view for transactions per item, also when using filter panel. View transaction log (RTC-31429) Imported stock balance and sales are not available in filter panel for transaction log. |
...
In User Management there are permissions for "View transaction" and "Manage transaction" per item transaction type. Permissions are assigned to roles on store level.
Improvements
Module | Description |
---|---|
Stock transactions | Fix: Show store number and name (RTC-30944)
Supplier number is displayed in both Transaction log and Stock status views - grids were displaying wrong value from database (OrganizationNumber instead of ExternalSupplierNo). |
System | ItemService integration (RTC-31163) When InventoryService was receiving ItemChanges event with ItemReceiptText longer than 50 characters, then item merger was failing with conflicts in data model. Change in ItemReceiptText length from 50 to 255 resolves that problem. |
...