Company: Link Technologies
Case No: L12133. Project: 12.30: LinkSOFT Version 12.30
Logged By: Sanjay (Link Technologies) on 11 Jan 2021 04:52PM
Priority: Low
Product: Point of Sale
Group: New Feature
Time Taken: 6.00 (Weight: 6.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Friday, 15 January 2021 11:59 PM [1410 days since logged date]
Status: Closed
Subject: Add functionality to Import Inventory Adjustments from File (excel csv)
Summary:    

Add the ability to Import Inventory Adjustments as some customers using high volume inventory adjustments could find the Adjustment entry form time-consuming.

OTGL have requested the adjustment  import

Design:

  1. Create adjustments in Excel
  2. Save as a CSV
  3. Use standard File Import
  4. The import will NOT handle Lot/Bin, Serial, Color or Size numbers in this release
Audit Notes:Edited by sanjay on 25/02/21 08:44. Edited by sanjay on 13/01/21 08:33. 
13 Jan 202108:31AM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 15-01-2021 08:29 AM Time Taken: 1.00

PART A - Development work for this case has been completed.

1. The change will be available in version:12.30.0113

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

  1. Added "Inventory -> Stock Adjustment -> Detail lines" upload template.
  2. When the unit cost is left blank in the upload file, the system uses the default inventory cost in the adjustment.

3. Affected Areas:

  1. Inventory -> Stock Adjustment. Use the template to upload and post the adjustment

4. The issue was caused by:

  1. new feature

5. Notes
6. Next Step
: UAT

----------------------

PART B - Development Reference:

1. Changes implemented was according to the approved design (Y/N):

2. Variations to the approved design:


13 Jan 202108:31AM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 15-01-2021 08:31 AM Time Taken: 1.00
System test completed.

13 Jan 202108:33AM Comment 3 by Sanjay (Link Technologies) ETC was changed from 15/01/2021 to 15/01/2021
14 Jan 202110:42AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 20-01-2021 09:20 AM Time Taken: 4.00

Development Notes

  1. When the unit cost in the blank, cust is extracted from Inventory Masterfile
  2. When the unit cost is "0", the item is imported with ZERO cost?

UAT by Sanjay/Alvis

Setup:

  1. Upgraded QA6 LinkSOFT DB to 12.23.0113
  2. Using template created 10 lines to import. 10 Valid Lines and 5 Invalid lines
  3. Invalid lines contain ",", invalid adjustment numbers, invalid Part numbers and invalid Adjustment

Test Results

  1. Upload validated 10 correct adjustment lines and failed the invalid lines
  2. MISC/Obsolete line was imported - this should not be allowed - Change will be available in 12.30.0114
  3. The change was applied to QA6 and retested.

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12133 in the subject line of all emails regarding this issue.

Document size: 4.3 KB
For call complaints, please contact the Managing Director of the company using this form