WRAP UP
THINGS TO KNOW, CONSIDER
Tracking inventory quantities and Locations in the productDetail records now.
There is also a pending field. This is how it works.
1. Customer calls, emails, or faxes order. Enter an Invoice
---productDetail Records
---The Quantity is reduced for each product on the order
---The Pending is increased for each product on the order.
---Invoice Status should be: _______________
2. Your ready to fill the order. Print a Picking Ticket
---Invoice Status should be: _______________
3. You get the Ticket back with notes. Change Invoice or Print Invoice.
---It depends on the notes. No changes? Your ready to Print the Invoice.
4. You need to Change the Invoice. Change Invoice
---You can add new items, change the quantity ...
---If you need to delete an item just change it's Quantity to zero. The program will handle it.
---Quantity and Pending are updated on each productDetail record to keep inventory straight.
5. Ready to print Invoice. Print Invoice
---The Pending amount on each productDetail record is reduced.
---Invoice Status is now Complete.
The Companies Information is now tracked in the nurseryControl table.
I created and imageDir field so that we could change where images were stored.
images is set as the directory. Assume logo.gif for the company logo for now.