Company: Link Technologies
Case No: L12625. Project: 13.20: LinkSOFT version 13.20
Logged By: Vineet (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 26 Oct 2021 12:08PM
Priority: Low
Product: Point of Sale
Group: Enhancement
Time Taken: 12.00 (Weight: 16.00)
Version: 13.20.1215
Assigned To: Development
Circulation: Development, Sanjay, Vineet
Resolve By: Friday, 10 December 2021 11:59 PM [909 days since logged date]
Status: Closed
Subject: Improvement to Purchase Order Form
When we implement the LINSOFT Inventory Module for a new customer or a new site the creating a Purchase Order is a big hassle. There are a total of 45 local vendors in Fiji. Of these, some provide over 1000 line items example Punjas, FMF, CJ Patel, Motibhai, Tappoos, Ashabhai. When invoices are sent, each invoice has over 500 lines. Creating these on the web, reconciling, and receiving takes over 6 hours per Purchase Order. Below were our observations from our recent implementation at Dannys Supermarket.
  1. There is no line number on the Purchase Order form. When items are saved, these are auto arranged by Description. When there are discrepancies, the user has to search and reconcile item by item which is a very time-consuming task. Need to re-introduce line numbers at Purchase Order form 
  2. Creating a Purchase Order from the web for 500 lines takes a user more than 4 hours. Just enter the data and save. If there is are discrepancies then this would take another 2 to 3 hours to reconcile.

Improvement Suggestions:

  1. Create a form similar to Stock Take and Roster Edit with an Add Item Feature.
  2. Add line number on Purchase Order detail to ensure data is saved in the same order user has entered for reconciliation Purpose.
  3. Add a feature to show only the supplier items in the dropdown. Users can choose to show all items to add to the Purchase Order.
Section C - Provide a Test plan - List out at least two scenarios that will be used to verify.
  1. Enter Purchase Orders, on saving the Products should be saved in the same sequence as they were entered.
  2. Enter a 300 line Purchase Order. Should not take more than 1 hour.
Audit Notes:Edited by sanjay on 08/12/21 16:13. Edited by sanjay on 08/12/21 14:53. Edited by sanjay on 08/12/21 14:52. Edited by sanjay on 01/12/21 11:57. Edited by sanjay on 29/11/21 10:46. Edited by sanjay on 03/11/21 15:35. Edited by sanjay on 28/10/21 16:14. Edited by sanjay on 27/10/21 13:20. Edited by vineet on 26/10/21 12:08. Edited by vineet on 26/10/21 11:13. 
27 Oct 202101:20PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-10-2021 05:18 PM Time Taken: 1.00
Added to project 13.20 for consideration. Case will need to be re-written.

27 Oct 202101:20PM Comment 2 by Sanjay (Link Technologies) Case L12625 added to project 13.20
03 Nov 202103:35PM Comment 3 by Sanjay (Link Technologies) ETC was changed from 05/11/2021 to 05/11/2021
29 Nov 202110:46AM Comment 4 by Sanjay (Link Technologies) ETC was changed from 05/11/2021 to 10/12/2021
01 Dec 202111:57AM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-12-2021 11:57 AM Time Taken: 1.00
Edited case header as it had irrelevant information to this request

01 Dec 202112:00PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-12-2021 11:57 AM Time Taken: 2.00

The following changes will be made in Version 13.20 with further design changes in a future release.

  1. Add the ability to upload PO line items. This should help with the 500 to 1000 line items you frequently order
    1. You can do Partial Uploads as well as Misc Items upload using the upload template.
  2. Add the ability to select multiple lines and delete. This will allow multiple lines that need to be edited, the user can export the items to excel, edit then Upload.

01 Dec 202112:02PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-12-2021 12:00 PM Time Taken: 7.00
PART A - Development work for this case has been completed.

1. The change will be available in version:13.20

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

  1. Add the ability to Upload Purchase Order Details
  2. Added validations on Import columns
  3. Added ability to select and delete Multiple PO items

3. Affected Areas:

  1. Purchase Order Details File Import
  2. Delete multiple Purchase Order Items at once

4. The issue was caused by:

  1. Improvement to creating 1000 line orders

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

15 Dec 202102:12PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-12-2021 01:54 PM Time Taken: 1.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Create PO using Web UI and Upload 1050 lines

The upload took under 2 sec
2Edited lines, deleted multiple lines, upload another 100 lines

Task took less than 4 min
3Approved, Posted and Received

Task took less than 4 min

If you have any queries regarding this support incident, please email and include the Case No: L12625 in the subject line of all emails regarding this issue.

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