JIA Website Design & Web Development - search engine friendly - Los Angeles South Bay

How to convert paper report to paperless online

Voucher Transaction Online - Material Transferring Record

Case Scenario: Purchase Dept. request a web application to help supervise the inventory control. This inventory control is based on item quantity adjustment on the MOs (manufacture order). Any material transferred between warehouse, purchase dept., production lines, SMT, RMA, QC or R&D, the vouchers must be created to record the action. The record includes item number, quantity, date and in/out.

Since most of the writing on the paper form voucher couldn't be easily read and there are extra input works from the voucher to inventory database. Can it be possible to do web browser input (in intranet page) and/or the voucher to be scanned by scan gun.

Example: Material Transfer Voucher in paper:

Result - Online Voucher :
To generate barcode vouchers for multi-users in intranet.

Case Study: The Voucher for material transferring contains two sections:

• The Upper Part—Voucher Header: Contains general info of the voucher
• The Bottom Part—Voucher Body: Contains item and quantity to be adjusted.

This voucher could be printed for barcode reader (such as scan guns) and also available to be submitted online to link directly to inventory database to complete the transfer processing with SQL 2000 database. The voucher data stored in the database, so it's easy to track back online for the record.

Voucher header input section:

Voucher item input section:

Voucher submit section: After submitting, the voucher's check box will be checked as submitted. The voucher detail will be locked and cannot be modified.

Coding Tips:

Voucher submit section: Declare the variables:

Dim intGridViewCount As Integer
Dim aryItem As New ArrayList()
Dim aryQtyOut As New ArrayList()
Dim aryQtyIn As New ArrayList()
Dim blnSubmit As New Boolean