Alpha DevCon 2018
Results 1 to 3 of 3

Thread: Maintaining Running Inventory

  1. #1
    Member
    Real Name
    Donald Raymond
    Join Date
    Jul 2000
    Location
    Long Island, NY
    Posts
    150

    Default Maintaining Running Inventory

    I would like to know what is considered the best way to maintain a running inventory say for products manufactured and then shipped in a factory.

    Is it best to use Post operations to increment/decrement quantity-on-hand, or is it better to use some type of running total either in a calculated field, or one that can only be had through a report? If it is a Post operation, how do we know if Post failed? If it is calculated type of result, what happens to the performance when there are many records?

    Thanks,
    Don

  2. #2
    "Certified" Alphaholic MoGrace's Avatar
    Real Name
    Robin
    Join Date
    Mar 2006
    Location
    Los Angeles
    Posts
    3,468

    Default Re: Maintaining Running Inventory

    Hi Don,
    I have tried using posts and calc fields and had the same questions as you. So instead I use a transaction table in which matching records are created that works similar to a check register with fields for IN & OUT quantities based on the TYPE of transaction and links to the ITEM_ID. Then I can create sets and reports based on those sets to see whatever amounts I need.

    In my case I receive LBS of yarn which is knit into rolls of fabric grouped into lots for shipping. And since each roll of fabric may use more than one yarn item (50/50 Poly Cotton), I need to break out the roll lbs by percentage for each yarn used. When a shipment of yarn is received I have one transaction record for the IN quantity. In my work order, I set the percentages for each of the yarn items that will be used. Then after each roll is produced, weighed and selected for shipping (creating the LOT NO), a transaction record is created for the OUT quantity that calcs the total roll weight by the percentage for each yarn item referencing the lot number (instead of each individual roll no. which would be too many transaction records).
    Robin

    Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

  3. #3
    Member
    Real Name
    Donald Raymond
    Join Date
    Jul 2000
    Location
    Long Island, NY
    Posts
    150

    Default Re: Maintaining Running Inventory

    Robin, thanks for the reply.

    I would want to structure the transaction table so that I can see the quantity on hand in real-time on a form, rather than having to run a report to calculate what is on hand. I intend to have a transaction record created each time a barcode is scanned such as when a unit is produced (IN) and another scan (record) when it is shipped (OUT). Once you have IN & OUT records, how and when are you calculating QOH? What happens when the transaction table becomes large?

    Regards,
    Don

Similar Threads

  1. Maintaining all changes to the data
    By DLATSHAW in forum Database Design
    Replies: 9
    Last Post: 10-26-2015, 01:13 PM
  2. v11 Beta while still maintaining v10.5 application
    By christappan in forum Application Server Version 10 - Web/Browser Applications
    Replies: 5
    Last Post: 09-25-2011, 02:18 PM
  3. Maintaining users in a web app
    By MikeBalemi in forum Application Server Version 9 - Web/Browser Applications
    Replies: 6
    Last Post: 06-08-2010, 03:09 PM
  4. Maintaining optimized applications
    By whanigsberg in forum Alpha Five Version 5
    Replies: 5
    Last Post: 10-02-2005, 09:37 PM
  5. Maintaining an A5 table from Visual Basic.NET
    By Marcel Kollenaar in forum Alpha Five Version 6
    Replies: 5
    Last Post: 12-20-2004, 02:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •