Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

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.

...

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.

Improvement

...

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.

...

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)

...

.

...

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.

...

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.

...