Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

scan serialnumbers into database

Posted on by 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

  • Community Member Profile Picture
    Community Member Microsoft Employee 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.

  • Michael Marmah Profile Picture
    Michael Marmah 1,491 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 Microsoft Employee 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.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,316 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans