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

Compare with Current View Page History

« Previous Version 31 Next »

Coming next release

AreaDescription
Item transactions

Item transaction grid improvements (RTC-25534)

The following changes were implemented:

  • Grid filtering of date and transaction type was added and it is now supported to mix it with panel filters.
  • Transactions log export to Excel is executed by job.
  • Transaction type is exported to Excel as a text.


Order numbers (RTC-32261)

OrderNo, SupplierOrderNo and ExternalOrderNo from GoodsReceipt transaction are properly saved on ItemTransactionLine level in InventoryService database.

Stocktaking

User permissions for stocktaking (RTC-31445)

Permissions for stocktaking can be defined for user roles.

System

Cleanup job (RTC-31439)

InventoryDataCleanup job is included in the InventoryIntegrationPackage.
The job deletes old processed transactions:

  • Using default settings, transactions references older than 3 days are cleaned up once a day.


Main supplier (RTC-31492)

Main supplier is assigned and displayed for every transaction created.



Release 31.05.2023

Goods receipt

(RTC-31715)

Goods receipt created when submitting deliveries in Procurement module is updated in Inventory.

Update of reserved quantity from customer orders

(RTC-30095)

POSLogProcessor job from InventoryIntegrationPackage is processing POSLogs with Customer Orders. Based on those POSLogs, job creates and publishes Inventory.Reservation.Import events which contain customer order data.

ItemTransactionImport job is importing and saving Inventory.Reservation.Import events into the staging tables in Inventory Service database.

Updated of reserved quantity

(RTC-30734)

ItemTransactionMerger job from InventoryIntegrationPackage has been extended with new merger that process Inventory.Reservation.Import events. It saves and updates data in Reservation tables.
This merger updates Reserved and InStock quantities on stock level.
When there are changes in InStock quantities, then Sale transaction is created with items that have updated stock.


Release 16.05.2023

AreaDescription
Item transactions

Update of item transactions (RTC-31113)

If both identifiers StoreNumber and ExternalStoreNumber are present in item transaction event, then store will be resolved by store number only.

Only StoreNumber is extracted from POSLog to the item transaction events. External store number is skipped in POSLogProcessing.


Update of item transactions (RTC-28028)

External refences of processed transactions are stored in [Inventory].[ProcessedTransaction] table.
If a transaction comes with already existing external reference in this table, then the processing of this transaction is skipped.



Release 09.05.2023

Calculate weighted cost price

(RTC-30449)

Incoming goods receipt transactions trigger recalculation of weighted cost price basing on this formula:

New weighted cost price = (Stock quantity * Old weighted cost price + Goods receipt quantity * Cost price of the item) / (Stock quantity + Goods receipt quantity) 
Goods receipt cost price will be set to as new weighted cost price (without calculation) when:
  • 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

ModuleDescription
Item transaction

Reason/action codes and language changes (RTC-30933)

Reason code field is displayed above action code in the new transaction modal.
Reason and action code fields are automatically prefilled, if there is only one code active or existing code.
Small improvements in Swedish translations.

Stock status

Minor improvements to the Status tab in Stock details view: (RTC-30737)

  • Donut chart - available part on the chart is thicker than the other parts and value in the middle of the chart is adjusted
  • Displaying numbers - decimals in the table and on the chart are displayed in the same way
  • Size picker in the breadcrumb is no longer cut
  • Pickers for items with no size/color available - removed size/color grid and dropdowns for non-model items
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.



Release 24.04.2023

Permissions for item transactions per store

(RTC-30977)

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

ModuleDescription
Stock transactions

Fix: Show store number and name (RTC-30944)

  • When an item has stock in only one store, then a store label with proper store's name and number is displayed;
  • For store users - store label with proper store's name and number is displayed.

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.



Release 12.04.23

Handle reason/action codes for returns in sales

(RTC-28027)

To avoid storing all sales we aggregate sales to see the stock changes in batches with exception for items sold with serial numbers. When return is done with damaged flag set, we treat that return as breakage, in result such return will create two lines, one as sale with amount increasing the stock, and one breakage line decreasing it again.

Improvement

ModuleDescription
Item transaction

Transaction logs performance (RTC-30106)

Transaction logs performance is improved significantly. The view is loaded under 500ms for 5 millions of rows in database.



Release 27.03.02023

ModuleDescription
Transactions in user interface

Create Internal Use from user interface (RTC-30100, RTC-30101)

New transaction types was implemented in modal and it allows user to create these transactions in the UI from "Stock status" and "Transactions log" views. The transaction types are:

  • Internal use
  • Stock adjustment (increase/decrease stock)
Stock Status

Stock Status per item (RTC-29742)

Providing a view displaying stock status for a given item that consists of three main sections: Stock status, Model and Other store. In Stock status section, a picker for selecting store is available. There is also a donut chart with key values: number of items reserved, put away, available and in stock. Model section is presented when the model contains multiple colors and sizes, otherwise, it is hidden. There is a possibility to switch between models using color/size field as a dropdown list. In Other store section stock statistics are shown for the given item in other stores.



Release 13.03.02023

ModuleDescription
Stock status

Reservation field in Stock Status (RTC-29562)

Field "Quantity reserved" was added to the Stock Status grid

Transaction in UI

Create breakage from UI (RTC-30097)

New transaction modal was implemented and it allows user to create breakage transactions in the UI from "Stock status" and "Transactions log" views

Stock Status per item

Grid view of movements for items in store (RTC-27199)

Providing a grid to see item transactions for a specific item in a selected store. The functionality is implemented using a hyperlink on Available quantity on Stock status view that takes users to a second level (tab Status), where they can choose store using the picker. In that place, user can also change color and size of selected item using pickers in breadcrumb if these properties are available. After that transactions for this item in a selected store are displayed in grid (tab Transactions). Implemented grid contains columns compatible with Figma. The ability to export transactions for item in a selected store to excel has also been added. 


System parameter: "DisplayIdentifier" has been added to [dbo].[ConfigurationParameter] to enable change type of Item identifier displayed in breadcrumb in tab Status.

This parameter can have two possible values:

  • GTIN (default value)
  • ItemNo (i.e. external item number)




Release 27.02.02023

ModuleDescription
Store integration extension

Store Management (RTC-29835)

Adding new columns: Gln and UseInventory to [Chain].[Store] table and new table [Chain].[StoreRelatedStore] in order to link stores with other related stores. 

After creating or updating the store in Store Management, values of Gln, UseInventory flag, related stores, profile, region and teams are correctly updated in the database based on information from an event from StoreService.

Export of data

Export item transactions (RTC-27531)

"Export" job has been extended to export item transactions. It publishes Inventory.ItemTransaction.Export events to both - BatchToProcess service bus topic and BatchToProcess container in Azure storage.
The Sale and StockStatusImport transactions are not exported.

"Export" job from InventoryIntegrationPackage needs to be enabled with default configuration (with the scheduled trigger for exporting Item transactions enabled).

Export stock status (RTC-29213)

"Export job" has been extended to export stock. It publishes Inventory.StockStatus.Export events to both - BatchToProcess service bus topic and BatchToProcess container in Azure storage.

"Export" job from InventoryIntegrationPackage needs to be enabled with default configuration (with the scheduled trigger for exporting stock status enabled).

Merger job

Internal transfer transaction merger job (RTC-27672)

ItemTransactionMerger support for Internal transfer transactions has been added. Internal transfer transactions are created in InventoryService and stocks are properly updated:

  • items' stocks are reduced in the origin store;
  • items' stocks are increased in the destination store.




Release 30.01.2023

ModuleDescription
Transactions

Non stock items (RTC-28406)
Stock for non stock items, in InventoryService marked as "TrackStock=0", is not updated while processing item or sale transactions. 

Reason Codes

Reason code resolved (RTC-28645)
Reason and action codes are now properly resolved for each transaction type. 

Export reason codes (RTC-25406)
Export job have been added to the "InventoryIntegrationPackage". It exports data that has been modified recently. Job is based on change tracking tables in the database. It publishes data as blobs to the "BatchToProcess" topic. Job is by default executed every minute. 

Export job right now supports reason codes, it publishes "Inventory.ReasonCode.Export" event to both "BatchToProcess" bus topic and "BatchToProcess" container in Azure storage. 



Release 16.01.2023

ModuleDescription
Transactions

Skip transactions (RTC-28556)
Receipts without lines or with all voided lines are skipped and events with those receipts are not published to the Inventory Service database.

Complaint transaction processing (RTC-27673, RTC-27340)
Added support for Complaint transactions when returning defect items. 

Support for Internal use transaction has been added to PosLogProcessing and ItemTransactionImport jobs.
Incoming poslogs with TransactionType="ReturnDefectItem" are properly processed and saved to the staging tables in Inventory Service.

ItemTransactionMerger support for Complaint transactions has been added. Complaint transactions are created in InventoryService and stocks are properly updated.

Stock Status (RTC-27495)
Added new item transaction type: StockStatus

This transaction type overrides stock value instead of adjusting the stock values.
Will be used when adding stock from third party stock master or correcting stock status. 

Reason Codes

Repository for reason codes in UI (RTC-23663)
There are two new views added:
Reason codes register and System parameters. In reason codes view, user can browse, edit and create reason/action codes for: breakage, internal use, stock adjustment, internal transfer and complaint. "

Countries" parameter which was added, allows user to modify languages displayed in reason codes register. Default value of the parameter is "[]". Then, in reason code creation view, only English name and description are displayed. Supported countries are: NO, SE, FI, DK, AT, DE, EE, PL, NL, BE.

Example of System parameter value is:

[{"countryCode":"NO","isDefault":false},{"countryCode":"SE","isDefault":true},{"countryCode":"AT","isDefault":false},{"countryCode":"DE","isDefault":false},{"countryCode":"PL","isDefault":false}]

where  "isDefault" parameter can be set on true only for one of the country codes. Dutch is common for BE and NL and German is common for AT and DE.



Release 16.12.2022

ModuleDescription
Stock Update

Stock update (RTC-27312)

ItemTransactionMerger job has been extended with stock update logic:

  • When item has stock in InventoryService, then stock for this item in sender store is properly update with stock value from incoming transaction;
  • When item has no stock in InventoryService, then new entry for this item and sender store is created with stock value taken from incoming transaction.

The stock changes from StockAdjustment transactions are properly registered and updated in InventoryService.

Sales transaction

Sales transaction processing (RTC-27311 ,RTC-27313)

Added support of processing receipts with type sale, updating stock in Inventory module based on sold amount. 

Support for Sale transaction has been added to POSLogProcessing and ItemTransactionImport jobs.
Incoming POSLogs with TransactionType="Normal" and with valid RetailTransaction content are properly processed and saved to the staging tables in Inventory Service.

The items' stock is properly updated in InventoryService based on sales transaction data.
Sales data is read from staging tables, processed and properly saved in the InventoryService database
Item transactions are created in each job's run,  single item transaction has all items with aggregated stocks within single store from all read events.

Internal Use

Internal Use transactions (RTC-27671)

ItemTransactionMerger support for InternalUse transactions has been added. InternalUse transactions are created in InventoryService and stocks are properly updated.

Grid View

Grid view of items and stock levels (RTC-22717)

Added grid view allows user to see, filter and sort stock of items. 
File exporter job has been added to the InventoryIntegrationPackage. It exports stock to excel and saves them into blob container named "Inventory"
Note: Function "Export to Excel" requires additional setup before enabled in each environment. 

  • No labels