Part A - Pre-requisite

1. Inventory Valuation calculates and stores the In-Stock amount for each item for each period, using Process Code POS012
2. The Inventory IN-STOCK process recalculates the IN-STOCK amount using transactions, using Process Code POS017

Part B - Change

In Process POS017, we can use the values stored in the "Inventory Valuation" table for "CLOSED Periods" and compute the OPEN period amounts using transactional data. This will have two benefits:

1. In-Stock Calculate will only have to use OPEN Period Transactions saving computational effort and time
2. Since Valuation Data is correct, we will save time by using existing Known Data

Part C - Risks and Issues:

1. The Valuation data stored in the database needs to be correct

Added a new function (LT_INV_GetInStockAsAtFromValuation_fx) to calculate IN_STOCK using the Valuation table.

Next steps:

1. UAT and verify correct stock levels are returned
2. Document process and recommendations around where this is used

1. The change will be available in version: 114.90.0807

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

1. Added Parameters to Process POS010: "ReComputeSaleItemAvailableQuantity" to allow recompute based on the following input parameters:
   1. Item Category Code
   2. Item Number
   3. Location Code
   4. When Stock is Greater than a certain amount
   5. When Stock is Less than a certain amount
2. Users can now set these parameters and allow Stock Recompute to be based on these filters

3. Affected Areas:

1. Process: Replication General Process. This process is used to perform replication background tasks. Refer to the rules configured. Recommended Frequency: Every Minute [POS010] 

4. The issue was caused by:

1. Improvement

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT

1. The change will be available in version: 14.90.230810

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

1. Changed Inventory "In-Stock" recompute to work as follows:
   1. Pick up the "IN-Stock" amount from the last "Completed" valuation
   2. Compute, Using Transactions, the remainder of the days
   3. Example. Let's say you want to recompute the "IN-STOCK" amount as of the 15th of June 2023, and valuation has been completed as of the 30th of May 2023.
      1. We get the Balance as of 30th May from Valuation
      2. We compute, using transactions, the movement between 1st June and 15th June
      3. Add 2.1.3.1 and 2.1.3.2 together to get the "in-stock" as of 15th June

3. Affected Areas:

1. Process "POS017" - Recompute In Stock

4. The issue was caused by:

1. Performance Improvement
2. Allow ability to delete Inventory Transactions and not have an effect on IN-Stock recalculation

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT

Environment Details

1. OS version: Win11
2. Application version: 14.90.230814
3. Setup on:
   1. Server: LinkQA4
   2. Database: LinkSOFT
   3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
4. Login Details: Standard username and password for user "admin"

Next Step: Closure