1,491
Hi All,
I need to scan about 1 Million (1000000) serialnumbers for a serial item,am trying to use vb.net to create a small utility to do that but it takes forever to do that.
Does anyone have a better solution to help me achieve it.
Thank you all
*This post is locked for comments
Your difference between the end serial number and start serial number is 100,000. I have never come across this scenario in retail, where you have a hundred thousand in stock of the same item. Serial items primarily help you track if the client bought the item from you, when it comes to servicing a warranty (you don't want to service the warranty on an item bought at your competitor). Now, I don't know if the serial number tables can handle this number or serial items, or what the performance will be when scanning a serial number at POS. I highly recommend you engage your business partner with this issue. If you have set up the item in question as item type = serialized, then you can create the ran yourself in the SERIAL tab of the item's properties - select ADD, and enter the start/end range. Click the HELP button on the SERIAL screen to get some online help with this feature; but again I highly recommend you work with a BP should you have questions or issues with this large a number of serial numbers. Maybe one can post an update on this forum.
Hi Fernando, Thanks for your reply.
I have received a quantity of 1 Million for a serialized item
On the box the Start serialnumber is 89233020500900000 and End Serialnumber is 89233020501000000
Now if the cashier scans the first serial and last serial it should generate the individual serialnumbers withing this range into the database so it can easily be sold, each quantity corresponding to one serialnumber
Thank You
Michael - keep in mind this is a retail management application; retailers only really need to track the serial numbers of what they receive into their inventory, and what they sell / transfer out of their inventory. I have a hard time wrapping my mind around your objective here - why do you need to track a million serial numbers for a serial item? Also, scanning a million serial number barcodes is going to make some index finger quite sore, lol...
Tell us what you are trying to accomplish - maybe there is another or a better approach. If you have the list of serial numbers on an excel sheet, or a flat file, you can import the file onto a temporary database in your RMS database, then INSERT against the serial number tables from that temporary database.
Hope this helps.
#1
André Arnaud de Cal...
291,703
Super User 2024 Season 2
#2
Martin Dráb
230,433
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
