Barcode System with Stock

Visual Catpro

Barcode System with Stock

This article is based on system implemented at Malhotra Jewellers. They deals in artificial Jewellery. A single product contains various parameters like Company, Size, Color and Style Number. Visual Catpro automatically creates Batch No. with every item in purchase module.

Handling Purchase

In Purchase DocType mention '*AutoBatch*' and '*PrintBarcode*' against 'DocProperties' property. The '*AutoBatch*' property creates a auto batch with every purchased item. The auto batch is always unique. The '*PrintBarcode*' is to print the Barcode labels after saving the purchase document.

Following are the Column and their database fields:

Column	ColFieldNameData
S_NO
BATCH_NO	BatchNo
PRODUCT_ID
SIZE	ISize
STYLE_NO	StyleNo
COLOR	Color
MRP	Mrp
QUANTITY	Quantity
RATE	Rate
AMOUNT	Amount

*Use same Database fields to view Doc Column wise Stock Report.

Note:

BATCH_NO column must be placed before PRODUCT_ID column.

You may set '2' against the COLSELLIST property of the Size, Style_No, Color column to view the selection list of the existing values in purchase document.You purchase data entry module may looks like the following screen:

After saving it opens the Barcode Printing module.