The Customer Detail form lists inventory specific to our selected customer, this is specified in Access. Items can be selected two ways: scan UPC number or "Select UPC# manually" button.

After selecting an item to add to our invoice, fill out the qty and on hand qty. Here the ordered qty is 1 and current on hand qty is 4. Credits are indicated by a negative qty (as shown in the second screen shot). Select the "Add" button to add the item. The on hand avg is calculated and the on hand qty is adjusted.

Select "Select UPC# manually ..." button when you need to add an item but don't have a UPC number to scan. You are then navigated to the "Manual Select" form. The Manual Select form (shown in the third screen shot) breaks the inventory list into categories that are maintained in Access. Select the "Back" button once a choice has been selected or the "Cancel" button to ignore any choices.

Select the "Avg Data" button to see a four visit history on a specific UPC. This is helpful in determining how many items the customer is needs to order.

Select the "Total Order" button to view all ordered or credited items.

Let's check the past order history of an item by selecting the "Avg Data " button.

Previous     Next