EST 346238 Lot Code Validation

STATEMENT OF WORK CHANGE REQUEST ESTIMATE

Client	JBG	Project	DEV	Site	DEV
Client Reference		Aptean Reference	346238	Estimate Version	0.1
Prepared By	A N Walker			Estimate Date	9/10/17
Invoice Reference				Priority	3
Customer	Oak Furnitureland			System Version	4.X

Client Request

The requirement is to add validation to the lot number UDF scan for containers ("items") delivered to customers from the depots (the JBGSW site). The lot number that the user scans off the product label (GS1 barcode) in the UDF form should be validated against the container ID (item code) that the user scanned off the item label. This is to verify that the user has scanned both labels from the same box. ePOD doesn't have the product code for container deliveries so the change will require JBG to import the product code with the job details so that it can be validated.

Aptean Solution

The existing code for validating and extracting GS1 barcode types must be modified to allow extraction and validation against multiple components (AIs) of the barcode. The system will be modified to allow a new field type of "GS1 Barcode" to be configured in User-Defined Forms (UDF). This type will then allow the configuration of each AI value to be extracted from the barcode, specifying whether this is default AI value to be returned, whether the value is required to be found in the barcode and any validation against this AI value. This will be done through a list of items for the field. At least one must be specified. For this specific change, a field will be entered as "Scan Lot Number" of type "GS1 Barcode". The field will extract 2 items: AI "10 - Lot Number", required to be extracted, and validated as a numeric field from 1 to 20 in length. AI "91 - Agreed between Suppliers", not required to be extracted. If it is extracted, this will be validated as being the same as the value in EPL_CODE_2. Note: Although the above is the expected configuration, the Product ID AI (91) could also be made required. This configuration will be sent to the device for entry. On the device, when a field of type "GS1 Barcode" is encountered, the device will display an entry box for the barcode field as now. However, additional display-only fields will be added for each AI type specified as required underneath it. When a barcode is scanned or entered in this field, the device will extract all of the found values matching the list of AIs to be extracted. These will be displayed in the fields under the barcode scan entry field - the entry field will be left blank after values are extracted. For this specific configuration, the screen will display the barcode entry field and two fields below for the extracted AI values, as shown in the prototypes below. When a barcode is scanned in the field, the process will extract the values of the AIs configured and display them in the fields below. When a value has been scanned and extracted, the screen will change to display a button to clear the scanned values if required. Lot Number Entry Lot Number Entry, with extracted values When the user clicks Save on the form, the device will validate each extracted element with the validation specified against each field. For this specific configuration, the lot number is required and must be numeric. Product ID is not required to be extracted but, if it is, the value must match the value of the product ID sent in EPL_CODE_2. Note: Although the above is the expected configuration, the Product ID AI (91) could also be made required. The validation process will be changed to validate each specific extract. If any fails, the user will not be allowed to continue. The validation will highlight the field and the items in the field with the issues and show a generic error. When viewing already entered UDF, for GS1 fields, all values already saved will be displayed on entry into the form. The device will return the value in the first extracted item in the VALUE tag of the UDF. All extracted AI values will also be returned in additional VALUE tags within the ITEM tags, identifying the AI from which the value was extracted. For this specific configuration, the extracted lot number will be returned in the VALUE tag. Note: The completed UDF will be displayed in the C-ePOD Admin screen against the container (item), showing only the Lot Number label and the value for this. This change will be completed in the latest version (V4) of the CALIDUS ePOD application.

Warning:

Unknown costs for client/year (JBG/2017)

Cost Details
Activity	Hours	Rate per hour (£)	Cost (£ Exc. VAT)
Requirements	0.00	0.00	£0.00
Change Request Evaluation	0.50	0.00	£0.00
Functional Specification	1.25	0.00	£0.00
Technical Specification	0.00	0.00	£0.00
Development	5.25	0.00	£0.00
Testing and Release	1.00	0.00	£0.00
Implementation	0.25	0.00	£0.00
Project Management	0.50	0.00	£0.00
TOTAL	8.75		£0.00

Estimate excludes training, release to live and go live support.

Copyright © Aptean 2017. This estimate has an expiry date of 30 days from the specified Estimate Date. The information contained herein is supplied without liability for errors or omissions.