Documentation

Serial No
This module allows items control with serial numbers.
*Available on Ultimate Edition ONLY (VER 1.9).
Step: Go to Tools > Program Control > Module Setting

Check the checkbox - Item Batch No. to enable it.

Go to Stock > Stock Item Maintenance

*Select Item Code that want to control By Batch No.(If any)
*Press Edit.

*Tick the column - 'Controlled by Batch No'.
*Select'Item Batch' tab.
*Click '+' to add NEW batch number and detail.

*Keying New Batch No, Description and setup the Manufactured Date, Expired Date & Last Sale Date.
*After inserted, Press OK.

Go to Purchase > Purchase Invoice

*Click '+' to SELECT item with BATCH NO.
*Select (Add Batch NO.) to add NEW Batch No here.
*After select (Add Batch No.), the following table will be displayed:-

*Insert New Batch No, Batch No. Description,Manufactured Date, Expiry Date & Last Sale Date here.
*Press Add.
*After create and select Batch No > keyin qty & Unit Price > Press SAVE to save transaction.

Go to Sales > Invoice

*Click '+' to SELECT item, select batch number that want to selling out.
*Insert Qty & Unit Price.
*Press SAVE.

Note:
Item Batch No is based on the Last Sale Date to control stock out(When do sales entry).

Scenario1
✴️Sales Invoice transaction date exceed Last Sale Date.
*Last Sale Date for Batch No Candy001: 22/04/2020

*Sales invoice Date:25/04/2020

Result:
When Sales invoice transaction exceed Last Sale date, that batch No will not appear when select Batch No.

Scenario 2
✴️Sales Invoice transaction date does not exceed the last sale date, but exceeds the expiration date.
*Last Sale Date for Batch No Candy001: 30/06/2020

*Sales Invoice Date: 31/05/2020

Result:
When Sales invoice date exceed Expire Date but not exceed Last sale date,Batch No: Candy001 will shown.

Report: -
You may go to Stock Card Report to view each of the item details.
Step: Stock > Stock Card report

*Set Date Range
*Using Filter By Multi-select option to view specific item code.
*Press Inquiry.
*Press '+' the system will automatically divide the balance qty for each Batch No.

Batch Number Transaction Inquiry
Step: Inquiry > Batch Number Transaction Inquiry
*Select item code, Batch No,
*Click Search button.

*User may use this inquiry to view the transaction record of the items with Batch Number.

Expired Item Batch Listing Report
Step: Stock > Expired Item Batch Listing Report
Expiry Item By: Expiry Date / Last Sale Date option

*Users may use this report to view & check expiry date and last sale date for each of the item batch.

Item Opening Balance Maintenance
*To setup the item opening balance qty by Batch No.(if any)
Step: Stock > More Stock Maintenance > Item Opening Balance Maintenance

*Define filter options, click on 'Apply Filter'.
*Click the 'Auto Generate Opening Balance By Filter Criteria' .
*Specify the batch number and starting quantity separately, click 'Save'.
*The Bal Qty of Item Batch tab in Stock Item Maintenance will be updated immediately.