Exceptions Management Application

Application: Front end user interface application with back-end database. Application must work on Microsoft O/S machines. Application must support multiple access from more than one geographic location. Application must request username and password for logon Username be recorded for each new record uploaded. User interface language must be English. Specific function: Export function to Microsoft Excel Search function [search by item #, search by serial #, search by Exception classification, Search by record status (OPEN or CLOSED)] Edit records Log-off CREATING A NEW RECORD SELECT EITHER SERIALIZED OR NON SERIALIZED * SERIALIZED* Data Capture at the User Interface [login to view URL] # (Sequential numeric) 2. Ship to number (7 digit number) 3. Sold to number (7 digit number) 4. Additional Identifying Data (Text field - mix of numbers and characters, MAX 200 characters) 5. SKU # (Text field - mix of numbers and characters, MAX 20 characters) 6. Serial number number (12-15 digit number) [Serial number can have a leading zero] 7. Box or Console serial # (Drop down list - NA / Box / Con) 8. MPP (Drop down list - NA / Yes / No) 9. Exception classification Drop down list - i. -------------------SELECT PROBLEM ------------------- ii. AMAZON Return - No RMA in system iii. BOM Not in ONE CLICK iv. BULK Non serialized items - No RMA v. Duplicate RMA - 2 Retailer RMA's vi. Duplicate RMA - Retailer & Consumer RMA vii. Missing Microsoft adjustment code viii. RMA created with Box serial number ix. Surface tablet missing from box x. Surface SKU Box + contents missing xii. Serial number cannot be received in ONE CLICK xiii. Serial mismatch (A-SKU Box does not match Console) xiv. X-Box Console missing from box xv. X-Box SKU Box + contents missing 10. Notes field (Text field - mix of numbers and characters, MAX 200 characters) 11. Exception bin location (Text field - mix of numbers and characters, MAX 10 characters) 14. RMA Number 15. TAT SLA [48.00 Hrs] SYSTEM DATA FOR EACH RECORD 16. Date case reported [System date & time stamp when record is created] 17. Date case closed [System date & time stamp when record is saved with status CLOSED] 18. Case Username (record creator) 19. Last updated by Username (Record editor + system date & time stamp) 20. TAT Actual [Date case closed [System date & time stamp] - Date case reported [System date & time stamp] * NON SERIALIZED* Data Capture at the User Interface [login to view URL] # (Sequential numeric) 2. Ship to number (7 digit number) 3. Sold to number (7 digit number) 4. Additional Identifying Data (Text field - mix of numbers and characters, MAX 200 characters) 5. SKU # (Text field - mix of numbers and characters, MAX 20 characters) 6. Quantity (Numeric MAX 5 characters) 7. Part number (Text field - mix of numbers and characters, MAX 40 characters) 8. Exception classification Drop down list - i. -------------------SELECT PROBLEM ------------------- ii. AMAZON Return - No RMA in system iii. BOM Not in ONE CLICK iv. Duplicate RMA - 2 Retailer RMA's v. Duplicate RMA - Retailer & Consumer RMA vi. Missing Microsoft adjustment code 9. Notes field (Text field - mix of numbers and characters, MAX 200 characters) 10. Exception bin location (Text field - mix of numbers and characters, MAX 10 characters) 11. RMA Number 12. TAT SLA [48.00 Hrs] SYSTEM DATA FOR EACH RECORD 13. Date case reported [System date & time stamp when record is created] 14. Date case closed [System date & time stamp when record is saved with status CLOSED] 15. Case Username (record creator) 16. Last updated by Username (Record editor + system date & time stamp) 17. TAT Actual [Date case closed [System date & time stamp] - Date case reported [System date & time stamp]