2 Replies Latest reply on Jun 25, 2010 1:10 PM by CouponKing

    Serialize a product

    CouponKing

      Title

      Serialize a product

      Post

      Hello and thank you in advance for your assistance. I have just recently setup FM Server 11 Advanced and all clients use FM11 Pro. Everything is running smooth however I do need a hand with something. I will try to keep my question as concise as possible. We have about 20 products that we sell and some of them we need to track. What I mean by this is that some of the products that we sell each have a serial number on them. Lets say I order 100,000 at a time of a particular product from the manufacturer. I'm looking for a way to enter all 100,000 serial numbers (they are sequential, thankfully) into FM and associate those numbers with a product code we have in our db. This way when I sell 3,000 of this product to someone, FM can track these serials and keep track of our inventory level as well. The product comes in boxes (250 items per) and each box has a barcode with the first and last serial number on it. We had a person to "try" and help set this up but his method involved making every serial number (100,000 of them for just one item we sell!) a product code. This was a mess. What I would ultimately like to do is this.

       

      - Enter a product in FM

      - Enter a stock quantity of the product as well as their serial numbers.

      - When I sell this product to a person, be able to enter the serial numbers they purchased

      - This persons FM record now shows they bought "x" amount of this product and the serial numbers that go with them.

       

      Does this sound like something that can be done with FM?

       

      Thanks again for any assistance.

       

        • 1. Re: Serialize a product
          philmodjunk

          Sounds like you need one table for products and a related table (linked by productID) of product serial numbers.

           

          You can then log in and track serial numbers with this related table.

           

          A script can then be written that takes either the starting and ending serial number or the starting serial number and the number of items and creates new records in this related table.

          • 2. Re: Serialize a product
            CouponKing

            Interesting concept. I will definately put some thought into that this weekend. Thanks for the suggestion, I do appreciate it!