Page 1 of 2 12 LastLast
Results 1 to 15 of 22
  1. #1
    otis is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Location
    Liberia
    Posts
    21

    Office Supplies to Employee (Inventory)

    Hi
    I need your help. I want to build a stock management inventory for the office. It is not a sale inventory, non-cash transactions. I want to have the total quantity of stock and employee can request stock via requisition slip; and as they request supply, it should be deducted from the total stock and shows the balances. Can someone help me get stable, cuz the database will be on a server
    Example in MS Excel


    Stock Employee
    ITEM TOTAL QTY NAME DEPARTMENT Date QTY REQUESTING BALANCE Qty REMARK
    Sheet 20 Ream Mark Account March 1, 2015 2 Ream 18

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,366
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    otis is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Location
    Liberia
    Posts
    21
    it is not a sale inventory. This is inventory is just for office used. I want employee request supplies via Requisition slip with the name, department and quantity of items they are request, and it should be deducted from my total stock quantity and give the balance. Help me sir with a sample design and how the calculations will be made, cuz over 7 employees will be requesting supplies and this database will be on the server

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,366
    Concept is the same, input transactions for inventory in/out then calculate balance when needed.

    You might look at the MS Desktop Inventory database templates.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    otis is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Location
    Liberia
    Posts
    21
    ok thanks June7, but how can i create a query to subtract "Number of Goods in Stock" from "Quantity Requested" and get a "Qty balance"? See example below in Excel
    Click image for larger version. 

Name:	New Picture (1).jpg 
Views:	29 
Size:	78.3 KB 
ID:	19945

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,730
    Research Inventory and transactions

    There are threads within forum re: use of transactions to manage stock on hand
    Current StockonHand = Starting balance +incoming(Purchases) - outgoing (Sales)

    see
    http://en.allexperts.com/q/Using-MS-...ck-control.htm
    http://en.allexperts.com/q/Using-MS-...ansactions.htm

    The AllenBrowne link from June is a great reference.

  7. #7
    otis is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Location
    Liberia
    Posts
    21
    veteran, you can help me setup a table design base on the post above?

  8. #8
    otis is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Location
    Liberia
    Posts
    21
    thanks Veteran "Orange", but can you help me setup a design, please

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,366
    Look at the MS Desktop Inventory database templates for ideas.

    Perhaps this tutorial will help http://www.rogersaccesslibrary.com/

    Search web for inventory database entity relationship diagram.

    Post your design for analysis.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,730
    otis,

    If it's concepts that are holding you back from looking at the examples that have been suggested, then spend an hour working with this tutorial.
    Then come back and tell us:
    --what exactly you are trying to accomplish and
    --what you are missing and need help with.

  11. #11
    otis is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Location
    Liberia
    Posts
    21
    i just want you to list the table and fields name design so i can create the tables. To admit i appreciate your help wholeheartedly

  12. #12
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,366
    This is a common type db. Examples can be found as described. Attempt design to suit your data and business process and post for analysis.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  13. #13
    otis is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Location
    Liberia
    Posts
    21

    Advise me on this design

    ok, please take a look at this design and relationship Sir. In the tblProduct table, the "Units In Stock" is a fix value as per order. For example if we order 15 reams of sheet. Please advise me sir. This is an office inventory, supplies stocks to employees by quantity request


    Click image for larger version. 

Name:	New Picture.jpg 
Views:	26 
Size:	32.6 KB 
ID:	19957

  14. #14
    otis is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Location
    Liberia
    Posts
    21
    ok, please take a look at this design and relationship Sir. In the tblProduct table, the "Units In Stock" is a fix value as per order. For example if we order 15 reams of sheet. Please advise me sir. This is an office inventory, supplies stocks to employees by quantity request


    Click image for larger version. 

Name:	New Picture.jpg 
Views:	26 
Size:	32.6 KB 
ID:	19957

  15. #15
    otis is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Location
    Liberia
    Posts
    21

    Somebody Help Me

    This is an office inventory, not a sales inventory. We supplies stocks (sheet, staple machine, letter head, etc) to employees by quantity request. We want to know the "Units In Stock' balance as employee request supplies. Example, if we have 10 reams of paper in stock and employee request 2, it should reduce to 8.
    And if we add new supply it should increase. Example if we have 8 ream of paper in stock and we add 10 it should increase to 18. Help!

    Click image for larger version. 

Name:	New Picture.jpg 
Views:	24 
Size:	32.6 KB 
ID:	19958

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 08-19-2014, 12:20 PM
  2. Replies: 1
    Last Post: 04-14-2014, 11:44 AM
  3. Office Supply Inventory
    By swhennen85 in forum Access
    Replies: 3
    Last Post: 02-01-2013, 08:38 PM
  4. Replies: 8
    Last Post: 06-06-2012, 12:28 PM
  5. Upgrading from Office XP to Office 2010
    By Mohamed in forum Access
    Replies: 1
    Last Post: 02-20-2012, 11:32 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums