fbpx

SERIAL NO

This module allows items with serial numbers, including transactions and reports.

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

Now, check the checkbox of Serial No. to enable it.

Maintain Item With Serial Number

First, go to Stock > Then, go to Stock Item Maintenance

Add/Edit an item, check the checkbox of Controlled by Serial No

SN1.png

Maintain Opening Balance for Items with Serial No.

Go to Stock > More Stock Maintenance > Item Opening Balance Maintenance

Define filter options, then click on Apply Filter,

Click on Auto Generate Opening Balance By Filter Criteria,

SN2.png

You may key in quantity under Quantity column, and then click on the button under Serial No column to maintain serial numbers;

OR, you may directly click on the button under the Serial No column to maintain serial numbers, and then let the system auto-generate its opening quantity.

Click on the SN3.png button,

SN4.png

Click on the ‘+’ sign to add a new row.

If it is a continuous running S/N, by keying in Starting and Ending S/N, quantity (Qty) will be calculated automatically,

(You may scan serial number from Bar Code (for Starting and Ending S/N))

(You may also click on Import to import serial numbers from a text file.)

Click on Close,

The total opening balance (Quantity column) is filled.

Click on Save.

SN5.png

Purchase of Item with Serial Number

Go to Purchase > Purchase Invoice (or Goods Received Note or Cash Purchase)

Click on Create A New Purchase Invoice

SN6.png

Right-click on the ‘+’ sign to select an item with a serial number, the Serial Number window will be prompted to scan/key in the Starting and Ending S/N, then click on Close, (you may also key in the Starting S/N and Qty so that the Ending S/N will be automatically filled.)

SN7.png

You may notice that the quantity (Qty) field is filled and you may click on the Serial Number button to bring up the Serial Number window again.

Click on Save & Preview, the printout will look like this,

SN8.png

Sale of Item with Serial Number

Go to Sales > Invoice (or Delivery Order, or Cash Sales ….)

Click on Create A New Invoice

Click on the ‘+’ sign to add a transaction row, select an item with a serial number, the following windows will be displayed:

SN9.png

There are several ways to assign serial numbers during the transaction:

a) Scanning S/N barcode (place cursor on the field of Scan Serial Number Bar Code); or

b) Double click on a serial number from the Available Serial Number table; or

c) Click on the ‘+’ sign and key in the Starting and Ending S/N… (if numbers are continuous).

(note: you may also scan / key in serial numbers that are currently not in the list of Available Serial Number)

Click on Close

SN10.png

Then, click on Yes to acknowledge the message and proceed to the transaction screen.

SN11.png

If you change to quantity to 5, the following windows will be displayed:

SN12.png

Now, click on Close

SN13.png

Then, click on Yes

SN14.png

After that, click on Yes to update the quantity in the Qty column.

And then, click on No if you do not want to update the Qty with the serial no

Now, let say if I click no,

SN15.png

After that, click on Save & Preview.

SN16.png

Then, click on ok if you want to proceed.

SN17.png

Lastly, It will show 5 quantity with 4 serial no.

Available Serial Number Inquiry

First, go to Inquiry > Then, go to Available Serial Number Inquiry

After that, Select an item with a serial number, and all serial numbers that are still available will be listed:

SN18.png

The serial number ‘D1001’ is indicated with a ‘-1’ quantity, this is because I have sold this serial number while it was not in the available list.

Something must be done to get rid of this ‘-1’ quantity so that the stock report will be corrected.

What needed to be done is to add back one unit of this item with this serial number ‘D1001’, by using one of the following documents:

a) Stock > Stock Receive or Stock Adjustment (if there was an omission or miscount of stock)

b) Stock > Stock Transfer (if the serial number was physically transferred from other location but not yet recorded)

c) Sales > Credit Note (if there was a return of this Serial Number but not recorded)

d) Purchase > Goods Received Note or Purchase Invoice or Cash Purchase (if there was a good received but not recorded)

Serial Number Transaction Inquiry

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

Now, select an item code. select a serial number, and all the transaction records of such serial number will be listed:

SN19.png

Serial Number Stock Card Report

First, go to Stock > Second, Stock Card Report

Define the filter option, click on Inquiry.

SN20.png

Then, click on Preview

SN21.png

To view the details of serial numbers, select Stock Card No Cost With SerialNo Info,

SN22(2).png

Serial Number Stock Balance Report

Go to Stock > and then, click on Stock Balance Report

Define the filter option, click on Inquiry.

SN23(1).png

Click on Preview

SN24.png

To view the listing of serial numbers, select Stock Balance for Available Serial Number

SN25(1).png

Serial Number Invoice Listing

First, go to Sales > Next, click on Invoice

Then, click on Print Invoice Listing

SN26(1).png

Click on OK,

SN27(1).png

Define filter options, click on Inquiry,

After that, check the related invoice(s)

Click on Preview,

SN28(1).png

Select Invoice Listing With Detail (Serial No),

Lastly, click on OK,

SN29(1).png

Serial Number Quantity Not Match Inquiry

First, go to Inquiry > Next, go to Serial Number Quantity Not Match Inquiry

SN30(1).png

The report shows the unmatched quantities, you may double click to drill down to the source documents and modify accordingly.

Negative Serial Number Quantity Inquiry

This is used to inquire for any negative quantity associated with all serial numbers up to the selected date.

First, go to Inquiry > Negative Serial Number Quantity Inquiry,

Define a Date and click on Inquiry:

As the result, a list of Serial Number that contains negative quantity will be listed (if any).

SN31(1).png

Contact us for a full product walkthrough


Contact Us​

1 thought on “SERIAL NO”

  1. Pingback: AutoCount Module - AutoCount Software

Comments are closed.

WhatsApp chat