Subject: | Linksoft inventory valuation report changes |
Summary: | ---Meeting with Sanjay,Alvis--- We have agreed to proceed with option 2 as this is the least amount of effort to achieve objectives Design for valuation as at a date.
Objectives: 1. ability to run stock valuations at the end of a month. 2. the current stock valuation report takes a long time to run, we need this under 20 seconds 3. User should be able to backdate a transaction to a specified number of days. ---------------------------- Design Option 1: 1. Introduce the concept of periods 2.a transactions can be entered in open period only 1. Inventory Adjustment IN/OUT 2. Stock take 3. Transfers 4. Purchase receive 5. Cash sale 6. Credit sale 7. Returns 8. Layby completion 2.b Replication 1. Period needs to replication from Headoffice to all branch 3. Users control the open and close of periods 4.a Periods can be defined at any length of time (daily,weekly,monthly) Recommend to align periods with months. 4.b If period does not exist, the system creates the next period. 5. When a period is marked as closed, flag the period for recalculation. 6. Recalculation process performed by a scheduled process. 7. Show progress on period recalcuations ---------------------------- Option 2: 1. Create a period table with monthly dates and recalculate flag. 2. As transactions are created, the transaction period is flaged for recalculate 3. Scheduled process computes stock valuation for all periods marked as recalculate on a nightly basis. 4. The valuation report allows the user to picks periods where recalculate = 0 5. No replication required
Stock valuation table definition ID Period (Year/Month) PartNo Location Recalculate AvailableStock Cost TotalCostValue SellPrice TotalSellPriceValue 1. Issue Description (Current behaviour and expected behaviour): Vineet, further to our discussion, we have carried out below tasks for Audit purposes. Compared inventory value with Jiwa inventory value Result: There is a difference of 279,442
|
Audit Notes: | |
20 Mar 2017 | 02:58PM Comment 1 by Alvis (Link Technologies) Case 8430 added to project 8.10.001 |
23 Mar 2017 | 10:04AM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-03-2017 10:04 AM Time Taken: 12.00 |
| Development work for this case has been completed.
The change will be available in version: 8.10.001 Documentation update required(Yes/No. Add change details below): Yes QA required(Yes/No.Include areas that require testing): Yes
The following changes were made(Include Database object names, Program classes and any other relevant information): - Added a new table to hold calculated valuation values. TableName: LT_INV_Valuation.
- Added a scheduled process to calculate valuation values
- Changed valuation report to use a period and pick values from the valuation table defined in 1. above.
- Changed the following areas to mark items for recalculating valuation.
- OS transaction process
- Adjustment IN/ Adjustment OUT
- Stock Take
- Transfer
- Purchase Order receive
Documentation details: |
|
28 Mar 2017 | 11:46AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 29-03-2017 12:00 AM Time Taken: 1.00 |
| Hi Alvis, I have tested the case in Qa1 with LINKSOFT database. The cost is not correctly updated in the LT_INV_VALUATION table. We did a adjustment for part number " CASE8430" with quantity as 100 and cost as 5. When we generated the Valuation Report, the report was blank. This is because the cost in the database in the table LT_INV_VALUATION was updated with 0 instead of 5. Refer to the image below.
Regards Rashna |
|
29 Mar 2017 | 10:37AM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 29-03-2017 10:37 AM Time Taken: 1.00 |
| Hi Rashna, I have resolved the issue of zero cost showing on report. Please retest. |
|
04 Apr 2017 | 07:17AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 05-04-2017 12:00 AM Time Taken: 2.00 |
| Hi Alvis, I am in the process of testing the Valuation Report in Qa1 810.001 But the Recompute process does not run when we do a adjustment out. The line in the inventory valuation report becomes red. Transactions after adjustment out do not recompute. _____________________________________________________________________________________________________________________________________________________________________-
Test Plan so far: Test No | Test Description | Status | | 1 | Tab Order is correct on report filters | Passed | | 2 | Spelling and Content is readable | Passed | | 3 | Search by description and code | Passed | | 4 | Adjusment on 03/04/2017 of 100 pieces at 5 Dollars. Report Generated on 15/01/2017, 02/02/2017, 31/03/2017 has a valuation of 500 as no other transcation was made against the item | Passed | No data for January to March. April Valaution is 500 | 5 | Sold 5 pieces at 7.00. Cost should not change | Passed | | 6 | Adjusted 15 @ 6.5 on 30/03/2017. Cost in March 6.50 | Passed | | 7 | Adjusted 10 @ 5 on 27/03/2017. Cost in March 5.90. | Passed | | 8 | Adjustment Out | Failed | Recompute does not occur at adjustment out. | Regards Rashna |
|
06 Apr 2017 | 09:19AM Comment 6 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 06-04-2017 09:19 AM Time Taken: 2.00 |
| Hi Rashna, Added Adjustments out to the valuation Recompute. The update will be in 810.BETA2 Regards Sanjay/Alvis |
|
10 Apr 2017 | 07:30AM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 10-04-2017 07:30 AM |
| Hi Alvis, As per the GTM on Friday, the Process for valuation report is not running. This is in QA1 with 810. Beta 2 Regards Rashna |
|
10 Apr 2017 | 11:50AM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 10-04-2017 11:50 AM Time Taken: 2.00 |
| Hi Rashna, I have resolved the issue and the update will be in beta3. beta3 will be released once all items marked with reference beta2 and status UAT has been tested. |
|
19 Apr 2017 | 07:26AM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 20-04-2017 12:00 AM Time Taken: 2.00 |
| Hi Alvis, The valuation report is not correctly computing the instock value at HQ. The instock value does not accommodate sales made at branch. This causes a mismatch of instock on the valuation report and the inventory movement report. However, at branch, 519, Inventory movement and Inventory Valuation report have the correct instock.
The above have been discussed with Alvis, Sanjay and Vineet via net meeting Regards Rashna |
|
19 Apr 2017 | 09:11AM Comment 10 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 19-04-2017 09:11 AM Time Taken: 3.00 |
| Hi Rashna, we have made the following changes to the way valuation is computed: - Added two new columns in valuation table: LastTransactionDate, LastValuationDate
- Added functionality to mark items for valuation recompute when stock values are changed from replication.
- If a new transaction is replicated to HQ, the valuation will pick the items for recomputing as a newer transaction date is available.
These changes are in beta4. |
|
20 Apr 2017 | 03:07PM Comment 11 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 21-04-2017 12:00 AM Time Taken: 3.00 |
| Hi Team, As per the meeting with Sanjeet, Sanjay and Vineet. I am passing the case with the objectives in the header. A new case will be logged for the desired functionality of the valuation report. Objectives: 1. ability to run stock valuations at the end of a month. - Pass 2. the current stock valuation report takes a long time to run, we need this under 20 seconds - Pass, (recompute is dependent on the process but the report generates fast) 3. User should be able to backdate a transaction to a specified number of days. Pass (Adjustments can be posted for previous dates which are computed) Regards Rashna |
|