web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / scan serialnumbers int...
Microsoft Dynamics RMS (Archived)

scan serialnumbers into database

(0) ShareShare
ReportReport
Posted on by Michael Marmah 1,511

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: scan serialnumbers into database

    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.

  • Michael Marmah Profile Picture
    Michael Marmah 1,511 on at
    RE: scan serialnumbers into database

    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

  • Community Member Profile Picture
    Community Member on at
    RE: scan serialnumbers into database

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans