Spice House Receive Items Narrative
When Spice House receives the inventory items from the vendor, an employee verifies the items listed on the packing slip with the items listed on the purchase order. Then another employee records the items received and database tables are updated. Spice House generates a receiving report and an exception report listing items on the purchase order that have not been received. The reports are sent to the account (receiving report)and the vendor (exception report).
Spice House database tables: Item, Customer, Sales Order, Sales Order Line, Vendor, Purchase Order, Purchase Order Line, Employees, Employee Type, Time, Cash Receipts, Cash Account, and General Ledger
-Create an EAD table for the Spice House Receive Items narrative.

Question

Quizplus · Accepted Answer

The Answer of Spice House Receive Items Narrative
When Spice House receives the inventory items from the vendor, an employee verifies the items listed on the packing slip with the items listed on the purchase order. Then another employee records the items received and database tables are updated. Spice House generates a receiving report and an exception report listing items on the purchase order that have not been received. The reports are sent to the account (receiving report)and the vendor (exception report).
Spice House database tables: Item, Customer, Sales Order, Sales Order Line, Vendor, Purchase Order, Purchase Order Line, Employees, Employee Type, Time, Cash Receipts, Cash Account, and General Ledger
-Create an EAD table for the Spice House Receive Items narrative.