ITEM BATCH

This module allows items to be controlled by batch numbers.

First, go to Tools >Next, go to Program Control > Then, click on Module Setting

Last, check the checkbox of Item Batch No. to enable it.

Set Item With Batch Number

First of all, lets create an item with batch number and maintain its opening balance.

Next, go to Stock > Then, click on Stock Item Maintenance

Now, create a new item; or select an existing item, click on Edit,

Then, check the checkbox of Controlled by Batch No.

After that, click on the tab of Item Batch,

Then, click on ‘+’ sign to add batch(es) number for opening quantity.

Batch No: key in batch number. Batch number after transacted can only be changed at Tools > Change Code> Change Item Batch

Description: key in batch description

Manufactured Date: key in a date this batch of goods being manufactured

Expiry Date: key in expiry date of this batch.

Last Sales Date: this date will be copied from expiry date (you may modify if needed) and it means the last date this batch can be sold. After this date, the batch number will not be displayed for selection.

Bal Qty: balance quantity of this batch.. for opening balance quantity, go to Stock > More Stock Maintenance > Item Opening Balance Maintenance.

Opening Balance Quantity By Batch

First, go to Stock > Then, click on More Stock Maintenance > Next, go to Item Opening Balance Maintenance

Then, define filter options, click on Apply Filter,

Now, click Auto Generate Opening Balance by Filter Criteria,

Next, assign batch number and opening quantity respectively,

At last, click on Save… the Bal Qty of Item Batch tab in Stock Item Maintenance will be updated immediately.

Purchase Item with Batch Number

First, go to Purchase >Then, click on Purchase Invoice

Next, add a new Invoice, select Creditor, and then select the item with batch number,

At Batch No column, click to select (Add Batch No)

After that, key in new batch number, description and manufactured/expiry dates

Then, click on Add,

Lastly, key in the quantity and Save.

Note: To edit batch details after saved, go to Stock > Stock Item Maintenance > Edit Stock Item> Item Batch (date must not be blank, any changes of date will update purchase record). To change batch number, go to Tools > Change Code > Change Item Batch.

Selling Item with Batch Number

First, go to Sales > Then, click on Invoice

After that, add a new Invoice, select Debtor, and then select the item with batch number,

Lastly, at Batch No column, click to select batch number….

Reports

First, go to Inquiry > Next, click on Batch Number Transaction Inquiry

Then, select item code and batch number, and then click on Search,

After that, the related batch transaction listing will be displayed, you may double click on any transaction row to view the details…

Now, go to Stock > Then, click on Expiry Item Batch Listing Report

Define filter options and click on Inquiry,

Now, In Stock >click on Stock Card,

As the result, each of the batches will be listed separately…

Contact us for a full product walkthrough

Contact Us​