Quantities

This option is designed to give the user an overview of all the quantities related to the selected product.  No information can be added in this tab.

Warehouse: This field allows the user to choose for which warehouse you would like to see the quantity information.  By default, the system is set for All Warehouses.

Period: The user must select from the pull-down list for which period to display the quantity information.  By default, this field is set to the current period.

Statistics

Under the Statistics, the user must check the box if the user wants to include Inventory adjustments/Physical Count (INVEN) in the display of the the quantity information.  By default, it is not included.

The system will display the following information:

Sales:  Current month and year to date Sales for selected product in dollars.

Costs: Current month and year to date Costs for selected product in dollars.

GP%: Current month and year to date Gross Profit for selected product in percentage.

Purchases: Current month and year to date Purchases for selected product in dollars.

Sales: Current month and year to date Sales for selected product in dollars for last year.

Cost: Current month and year to date Costs for selected product in dollars for last year.

GP%: Current month and year to date Gross Profit for selected product in percentage for last year.

Purchases: Current month and year to date Purchases for selected product in dollars for last year.

General

Unit of measure: Product's unit of measure.

Inventory Value: Current Inventory Value in dollars.

Current Gross Margin: Current Gross Margin in percentage.

Average Cost: Current average cost in dollars.

Current Price: Current Price including any applicable special prices for the Cash customer as specified in the system settings.

Last Cost: Last cost of the product in dollars.

Last Sold: Last date date sold.

Last Purchased: Last date purchased.

Purchases

Received: Total quantity found on current receiving slips that have not been updated.

On Order: Total quantity found on current open purchase order.

Bookings: Total quantity found on current open purchase orders based on the required dated of the order.

Promised Back Order: Total quantities promised on customer orders that are on back order.

Production: All quantities tat are in product and not yet updated.

To Come: Total on Order + Booking + Promised BO + Production.

Inventory

Beginning: Shows the beginning inventory of the product at the beginning of the fiscal year.

Purchased: Total year to date quantities purchased

Adjusted: Total year to date quantities adjusted through physical count.

Sold: Total year to date sold quantities.

Transferred: Total year to date transferred quantities.

Production: Total year to date production/Produced quantities.

On Hand: Total of Beginning + Purchased + Adjusted - Sold + Transferred + Production

Sales

On Hand: Current on hand quantity.

Promised Shipped: Promised shipped quantities from customer orders.

Invoiced: Quantities invoiced that have not been updated yet.

Production:  Quantities in production not updated yet.

Available: Total of On Hand - Promised Shipped - Invoiced - Production.  Basically this is the quantity available to sell.