1. Create a database of generated virtual invoice numbers of not more than (6) Six digits to be generated for the central store.
2. Create another database of 8, 10, and 12 digits of invoice numbers also for the central store.
3. All invoice numbers must have related serial numbers which shall be alpha-numeric of two characters and four digits
4. The serial number and the invoice number of each virtual invoice must be the same as its physical invoice counterpart.
5. Create a database for generating (ie. Setting up) several subsidiary stores
6. Create and interface for transferring the virtual invoice numbers generated at the virtual stores to the subsidiary stores.
7. Create a platform for entering information received on the physical invoices into the database of already generated virtual invoices.
Note:- the invoice number of the physical invoice must match the virtual invoice number in the database. Where the tow invoice (physical and virtual ) match, the computer should confirm by and alert (“MATCHED”). Where they do not match, the computer will raise another alert (“NOT MATCHED”).
8. A. create a database for setting up products that would be recorded on the virtual invoices and also on the physical invoices when sales are made.
b. all products are identified by both name and unique identity numbers.
c. also products can be transferred:
i. from central store to subsidiary store,
ii. from subsidiary store to subsidiary store.
9. A. create a database for setting up managers, sales reps, agents for each subsidiary store
b. create a platform (column) for the name of each manager or sales rep or agent to appear on the virtual invoice and also the physical invoice
10. create a database for setting up banks and bank accounts showing:
a. opening balance on the credit side
b. details of invoice and products sold on the credit side
c. transfer made from the bank account to head office account on the debit side.
11. matching and confirmation state
a. (i) create a platform where physical invoices and their content are matched with virtual invoices in the database
(ii) where the two invoices (physical and virtual) match, the computer should raise an alert (“MATCHED”). Where they do not match, the computer should raise another alert. (“NOT MATCHED”).
b. When invoices are matched, the computer should move the information to another platform known as “matched invoices awaiting bank confirmation