AnyKey IT Warehouse is a web-based retail & wholesale supplier of computer systems, component, peripherals, consumables and software. It has a computerised system to maintain its customer orders and inventory inventory. Once an order is received an entry is made into an Orders file and a packing slip is automatically generated, which the store person uses to select ordered items. The store person indicates how many items have been included with the order (which may be different to the number ordered). The inventory packed for each order is used from each packing slip to update the Quantity on Hand (QOH) for each stock item. The packing slip is included with its respective order. The inventory update provides an audit trail of stock movement.

Questions

1. What files are needed to store data for this system?
   
   
2. For each file, indicate the contents (fields)
   
   
3. Trace an order through this system by identifying inputs, the file(s) involved and procedures followed.
   
   
4. What extra processing is involved for an order from a new customer?
   
   
5. Identify the process required to enter a new inventory item.

At the end of each day an error report is generated from the processing of packing slips. The error messages indicate an unknown Packing Slip number, an unknown inventory item number, quantity supplied exceeds quantity on hand.

6. How is this report generated? Identify the inputs required and the data file(s) involved.
   
   
7. Who should receive the report & what course of action needs to be taken to resolve the errors?
   
   
8. Once all errors (if any) have been resolved, an Inventory Audit Trail is generated (weekly). What detail should appear on this report?
   
   
9. How would an Inventory Reorder Report be generated & how often?
   
   
10. How can discounts on an individual order item be incorporated?