Company: Link Technologies
Case No: L11657. Project: 11.40: LinkSOFT Version 11.4
Logged By: Rashna (Edge Business Solutions) on 13 Aug 2019 10:18AM
Priority: Medium
Product: Point of Sale
Group: New Feature
Time Taken: 13.50 (Weight: 16.50)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Wednesday, 14 August 2019 12:00 AM [1714 days since logged date]
Status: Closed
Subject: Enable automatic "Product Code" based on "Category" and "Sub Category".
Summary:    

Express Auto Parts has requested for the below feature:

AutoMatic Product Code based on "Category" and "SubCategory". Product "X" has the following Details.
  1. Category 
    1. Code = ACC 
    2. Description = Accessories
  2. Subcategory
    1. Code = LL
    2. Description = Led Lights
  3. When product "X" is saved, the system should auto generate the code as ACCLL0000001.
Audit Notes:Edited by sanjay on 13/08/19 10:18. 
13 Aug 201908:10AM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 15-08-2019 12:00 AM Time Taken: 1.50

Hi Sanjay, 

For review and approval.



13 Aug 201910:18AM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 13-08-2019 10:18 AM Time Taken: 1.50
Approved for V11

13 Aug 201910:18AM Comment 3 by Sanjay (Link Technologies) Case 11657 added to project 11.0
13 Aug 201911:46AM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 13-08-2019 11:46 AM Time Taken: 5.50

Development work for this case has been completed.

The change will be available in version: 11.0.0813

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

  1. Added a configuration for "Automatic Product Code Method (M=Next Number Mask, C=Category, CS=Category + Sub Category. First 3 Characters of C or CS + 3 digit next number)"

2. The issue was caused by:

  1. Improvement

3. Next Step:

  1. UAT

4. Notes: 

When checking for the next number in the "C" and "CS" method, the system checks for product codes "beginning with" the category or subcategory being used.

For example:

  1. Automatic Product code method = C, Category code = TY, an existing product exists with code "TYX001". 
    the next number that will be picked is "TYX002"
    If the product code "TYX001" did not exist. The next number that will be picked is "TY001", followed by "TY002", etc.

16 Aug 201903:21PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-08-2019 03:21 PM Time Taken: 1.50
For UAT 

21 Aug 201901:36PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 21-08-2019 01:36 PM Time Taken: 2.50
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Set the configuration ""Automatic Product Code (Y/N)" to Yes.

  1. Set Automatic Product Code Method = "M- Next Number Mask" 
  2. Next number = P00001
  • Create a product in BO the product code should be P00001
  • Create a product in web the product code should be P00002
Pass
2

Create below category details

Category

  • Code = OF
  • Description = Office Furniture
  1. Set Automatic Product Code Method = "C- Category" 
  • Create a product in BO , set the category as OF. The product code should be OF0001
  • Create a product in web , set the category as OF. The product code should be OF0002 
Pass
3

Create below category  and sub category details

Category

  • Code = OF
  • Description = Office Furniture

Sub Categories

  • Code = CAB
  • Description = Cabinet
  • Code = HC
  • Description = High Chair
  1. Set Automatic Product Code Method = "CS- Category + Sub Category"
  • Create a product in BO , set the category as OF and sub category as CAB. The product code should be OFCAB001
  • Create a product in web , sset the category as OF and sub category as HC. The product code should be OFHC001 

Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.0.0816
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-11-RASHNA

Next Step

  1. Closure

    04 Dec 201909:01AM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 05-12-2019 08:50 AM Time Taken: 1.00

    Hi Sanjay, 

    Documentation has been updated at "Link web application portal - Company Administration - Configuration - Point of Sale".

    Thanks
    Rashna


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

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