Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Adding Inventory Management

Discussion in 'Information Technology' started by JackCGW, Nov 14, 2005.

  1. JackCGW

    JackCGW
    Expand Collapse
    Guest

    I posted this question afew days ago, but for some reason I never got a
    single response...perhaps it was too vague.

    I have a database that I use to create project details such as Bill of
    sales, bill of materials and project descriptions. I would like to add the
    ability to control inventory. I have looked at the MS Templates and have not
    been able to grasp the concepts used.
    I have a Materials Table and I am guessing I need to add a table that holds
    the purchases and sales to the inventory. What I can't get is the way the
    Units On Hand in the template works. At the end of the day, I would like to
    be able to add a material from stock and see the remainder on hand like the
    "Tea Lady" does.
    Camro69 helped me to get a great form that lets me select a material from a
    list and then add it to a Bill of Materials (see post 10/23/2005, Move field
    entries from form to form using global variables).
    I would not have gotten this far without the help of theis great diecussion
    site...please don't forsake me know.
    Jack
     
  2. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Jack,

    Have you seen Allen Browne's article that covers Inventory?

    Inventory Control: Quantity on Hand
    http://allenbrowne.com/AppInventory.html


    Tom

    http://www.access.qbuilt.com/html/expert_contributors.html
    __________________________________________

    "JackCGW" wrote:

    I posted this question afew days ago, but for some reason I never got a
    single response...perhaps it was too vague.

    I have a database that I use to create project details such as Bill of
    sales, bill of materials and project descriptions. I would like to add the
    ability to control inventory. I have looked at the MS Templates and have not
    been able to grasp the concepts used.

    I have a Materials Table and I am guessing I need to add a table that holds
    the purchases and sales to the inventory. What I can't get is the way the
    Units On Hand in the template works. At the end of the day, I would like to
    be able to add a material from stock and see the remainder on hand like the
    "Tea Lady" does.

    Camaro69 helped me to get a great form that lets me select a material from a
    list and then add it to a Bill of Materials (see post 10/23/2005, Move field
    entries from form to form using global variables). I would not have gotten
    this far without the help of theis great discussion site...please don't
    forsake me now.

    Jack
     
  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    I like to use 2 fields. One for Purchases and one for Sales. Inventory is
    always the difference between them minus spoilage or theft.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "JackCGW" <GCW@discussions.microsoft.com> wrote in message
    news:D979972A-CDA0-404E-9C6A-D65DDF40614A@microsoft.com...
    > I posted this question afew days ago, but for some reason I never got a
    > single response...perhaps it was too vague.
    >
    > I have a database that I use to create project details such as Bill of
    > sales, bill of materials and project descriptions. I would like to add

    the
    > ability to control inventory. I have looked at the MS Templates and have

    not
    > been able to grasp the concepts used.
    > I have a Materials Table and I am guessing I need to add a table that

    holds
    > the purchases and sales to the inventory. What I can't get is the way the
    > Units On Hand in the template works. At the end of the day, I would like

    to
    > be able to add a material from stock and see the remainder on hand like

    the
    > "Tea Lady" does.
    > Camro69 helped me to get a great form that lets me select a material from

    a
    > list and then add it to a Bill of Materials (see post 10/23/2005, Move

    field
    > entries from form to form using global variables).
    > I would not have gotten this far without the help of theis great

    diecussion
    > site...please don't forsake me know.
    > Jack
     

Share This Page