"Naveed Pathan" je napisao u poruci
interesnoj ...
each product serial number that i sell and i will keep the record of the
unsold serial number as well.let me give the example the item i purchased
and

don't know how large is your stock, but basicly, you may use excel sheet,
filling one row for *each* separate serial number, having three columns:
1-item identifier
2-serial number
3-sold yes/no

like:
cobra 40001 no
cobra 40002 no
cobra 40003 yes
cobra 40004 no

now, using data-filter, you may show just "unsold" setting column filters,
item=cobra and sold=no

of course, you may have other columns as well, like date-in, date-sold, etc
....