1. Add Stock
    1. Receiving
      1. Create a form to prompt user to enter
        1. Part Num (required)
        2. PO Num (required)
        3. Machine Type (required)
          1. dropdown list to choose from
          2. IM
          3. PM
          4. CM
        4. Condition (required)
          1. dropdown list to choose from
          2. HPNew
          3. HPRef
          4. EPRef
        5. Technician (required)
        6. Shelf (required)
        7. Serial Num (optional)
        8. Note (optional)
        9. Auto-fill values in these fields
          1. DateCreated
          2. Now()
          3. StockID
          4. AutoNumber
      2. When all required fields have been entered, user clicks on a button Done
        1. Save this data entry as a new record into tblStockInventory
        2. Automatically print out a label (see Word doc requirement)
          1. Allow user to reprint
        3. Return to Main Screen
  2. Sell Stock
    1. Create a form to allow user to scan the product's barcode value
      1. Once scanned, automatically update this entry in tblStockInventory
        1. Create a form to prompt user to enter
          1. InvNum (required)
          2. Technician (required)
          3. Note (optional)
          4. Auto-fill values in these fields
          5. DateModified
          6. now()
          7. Available
          8. False
        2. Auto print barcode label
          1. 1 x printer
          2. 1 x invoice
        3. Allow user to reprint
  3. Check In Stock
    1. Create a form to allow user to scan the product's barcode value
      1. Form only has a textbox field
        1. Once scanned, prompt user with two buttons
          1. Check In with Parts Pulled
          2. Prompt user for data entry
          3. When all required fields have been entered, user clicks on a button Done
          4. Append a new entry in tblStockWorklog
          5. Fields
          6. WorklogID (AutoNumber)
          7. Lookup the StockID (barcode) from tblStockInventory
          8. Transaction
          9. Auto value=Check In
          10. ChildPartNum (required)
          11. Can only choose from restricted list of available parts in this StockID
          12. We will provide this SQL query
          13. Technician (required)
          14. InvNum (required)
          15. Shelf (required)
          16. Notes (optional)
          17. DateCreated
          18. now()
          19. Update entry in tblStockInventory, using data from tblStockWorklog
          20. StockID (barcode)
          21. Technician
          22. Shelf
          23. Notes
          24. DateModified
          25. now()
          26. Add new entry in tblStockTransaction, using data from tblStockWorklog
          27. StockID (barcode)
          28. Transaction
          29. Sale
          30. ChildPartNum
          31. Available
          32. No
          33. InvNum
          34. DateCreated
          35. Notes
          36. Auto print barcode label
          37. 1 x printer
          38. 1 x invoice
          39. Allow user to reprint
          40. Return to Main Screen
          41. Check In with No Parts Pulled
          42. Prompt user for data entry
          43. When all required fields have been entered, user clicks on a button Done
          44. Append a new entry in tblStockWorklog
          45. Fields
          46. WorklogID (AutoNumber)
          47. Lookup the StockID (barcode) from tblStockInventory
          48. Transaction
          49. Auto value=Check In
          50. Technician (required)
          51. InvNum (optional)
          52. Shelf (required)
          53. Notes (optional)
          54. DateCreated
          55. now()
          56. Auto print barcode label
          57. 1 x printer
          58. Allow user to reprint
          59. Update entry in tblStockInventory, using data from tblStockWorklog
          60. StockID (barcode)
          61. Technician
          62. Shelf
          63. Notes
          64. DateModified
          65. now()
          66. Return to Main Screen
  4. Check Out Stock
    1. Create a form to allow user to scan the product's barcode value
      1. Form should focus cursor on the barcode value so user can directly scan the value
        1. Once scanned, automatically add this new entry into tblStockWorklog
          1. WorklogID (AutoNumber)
          2. StockID
          3. Lookup the StockID (barcode) from tblStockInventory
          4. Transaction
          5. Auto value=Check Out
          6. Technician (required)
          7. InvNum (required)
          8. Notes (optional)
          9. DateCreated
          10. now()
        2. Auto print barcode label
          1. 1 x printer
        3. Allow user to reprint
      2. Form should allow user to type in product's part number
        1. Once entered, look for this part number (PartNumStock) in tblStockInventory
          1. Present all records with different serial #s that has this part#, let user choose one
          2. Log into tblStockWorklog
          3. WorklogID (AutoNumber)
          4. StockID
          5. User picked from list
          6. Transaction
          7. Auto value=Check out
          8. Technician (required)
          9. InvNum (required)
          10. Notes (optional)
          11. DateCreated
          12. now()
          13. Allow user to reprint
          14. 1 x printer
          15. Allow user to reprint
      3. Form should allow user to type in product's serial number
        1. Once entered, look for this serial number (ManufNum) in tblStockInventory
          1. Present all records with matching serial number, let user to choose one
          2. Log into tblStockWorklog
          3. WorklogID (AutoNumber)
          4. StockID
          5. User picked from list
          6. Transaction
          7. Auto value=Check out
          8. Technician (required)
          9. InvNum (required)
          10. Notes (optional)
          11. DateCreated
          12. now()
          13. Auto print barcode label
          14. 1 x printer
          15. Allow user to reprint
      4. Form should allow user to type in product's StockID
        1. Look for this StockID in tblStockInventory
          1. Log into tblStockWorklog
          2. WorklogID (AutoNumber)
          3. StockID
          4. Transaction
          5. Auto value=Check out
          6. Technician (required)
          7. InvNum (required)
          8. Notes (optional)
          9. DateCreated
          10. now()
          11. Auto print barcode label
          12. 1 x printer
          13. Allow user to reprint
      5. Form should also have a button Add Stock, which goes to the frmAddStock