Results 1 to 4 of 4

Thread: Inventory

  1. #1
    Join Date
    Jun 2011
    Posts
    3

    Post Unanswered: Inventory

    Please advise the below.
    >
    > Table 1 : opening balances
    > Sl No
    > Product Name
    > Unit
    > Quantity
    > UnitPrice
    > Total
    >
    > Table 2 [Purchase Table]
    > Sl No & Supplier Name in Header
    > Product Name
    > Unit
    > Quantity
    > UnitPrice
    > Total
    >
    > Table 3 [Consumption Table] / Issue Table Form
    > Sl No & Project Name in Header
    > Product Name
    > Unit
    > Quantity
    > UnitPrice
    > Total
    >
    > Its like an inventory system,
    > During Consumption, if there is no stock the item should not be
    > visible Price should be calculated on Weighted Average Cost.
    > Report needed in this format
    > Report for a period : 01.03.2011 to 15.03.2011 Opening Balance as on
    > 01.03.2011, [Qty & Value], Purchases during the period[Qty & Value]
    > [mentioned/criteria], issues during the Period [Qty & Value]
    > [Mentioned criteria] Closing balance [Qty & Value]

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    usually I'd expect to to see something like
    a product table
    a transaction table (identifies stock movements)
    a transaction type table (identifies a stock movement type eg sales, purchase, manufacture, scrap, disposal and so on) the type also determines whether the transaction movement adds or subtracts from the stock. so szales detract, production adds.

    then it depend on your business rules
    I've seen instances where there is a periodic stock count done and thsats added to the transaction table, that gives the baseline from which the current stock position is calculated
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2011
    Posts
    3

    Inventory

    Ist Table is Opening Balances of Products
    2nd tables is Purchases of Products where in Qty, Price & Total is given

    I want to make issued in a 3rd table, which should be in weighted average method.
    and the stock item should show only those items where stock is present and shall take only the available stock.


    once this is suggested i shall continue further in this topic to avoid confusion.

    pls suggest.

    thanks

    shekar

  4. #4
    Join Date
    May 2010
    Posts
    601
    I agree with healdem.

    Quote Originally Posted by shekar_genius View Post
    Ist Table is Opening Balances of Products

    2nd tables is Purchases of Products where in Qty, Price & Total is given
    There should not be an opening balance table. Opening balance in just a type of purchase record. Table 1 and 2 should should all be in the same table.

    Inventory control is one of the most difficult this to program in any language. No just Access.

    See: Inventory Control: Quantity on Hand
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Tags for this Thread

Posting Permissions

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