Use the Stock tab to see the in-stock balance of an item, its quantities reserved for sale or expected from purchase. Balance information is provided for each warehouse that stores the item.
The Stock tab is a report that pertains to all item types. For items which are subject to inventory management (services, non-inventory items, deferred expenses), the report shows only amounts reserved for sale or purchase but not in-stock balances. Потрібно перевірити.
The report is not available for newly created items as there is no inventory data to be processed by the report yet. Only when certain inventory transactions for a new item take place, the report retrieves and analyzes information from those transactions and render it in the generated table.
To view the in-stock balance of the item, set a date for which you want to see balances (in the Initial balance date field) and select a type of balance you want to display (in the field Type of balances).
For the date indicated, item balances are provided in the Totals section including the fields explained below. Values in the fields forming the Totals section are calculated automatically for informational purposes only. Totals section fields are disabled for editing and cannot be overridden.
Note: Item balances are calculated regardless of the selected type of balance.
|
Field
|
Used for displaying
|
| Total quantity |
The total quantity of the item as on the indicated date. The total quantity includes the in stock quantity, the reserved quantity and the expected quantity.
- Only quantities that are rendered in the report are summarized. If certain filters are applied excluding particular quantities from the reports, those quantities will not be added to form the total quantity.
|
| Total amount |
The total value of the item as on the indicated date. It is The sum of all values of the in stock quantity, the reserved quantity and the expected quantity.
- Only values that are rendered in the report are summarized. If certain filters are applied excluding particular values from the reports, those values will not be added to form the total amount.
|
Types of balance:
If you select the stock balances type, you will get the following information in the created report:
|
Field
|
Used for displaying
|
|
State
|
Indicates whether the item is in-stock, expected or reserved.
|
|
Inventory account
|
Inventory account to which the item was attributed.
|
|
Warehouse
|
Warehouse in which the item is stored.
|
|
Warehouse section
|
A warehouse compartment in which the item is stored if any.
|
|
Quantity
|
The quantity of the item that is either in stock or expected to be received from a particular vendor or reserved by a specific vendor.
- Item quantity is calculated for each warehouse where the item is stored.
- Multiple statuses may be assigned to different quantities of the item. For each item status, the total quantity of the item to which this status was assigned is calculated.
|
|
Price
|
An average price of one item. It is calculated the following way being broken down for individual customers, vendors or warehouses:
Amount / Quantity
|
|
Amount
|
The value of the calculated quantity of the item (in stock/expected/reserved). The worked out value is broken down for individual customers, vendors or warehouses.
|
For the extended stock balances type, all the details present in the stock balances report are displayed as well along with the following information:
|
Field
|
Used for displaying
|
|
Consignment
|
A document that recorded consigned items as inventory (for example, purchase invoices, goods and services receipts and product assembly documents, etc.).
|
|
Vendor
|
Displays a vendor from whom the item has been purchased or ordered.
|
|
Customer
|
Displays a customer who has reserved or purchased the item.
|
|
Delivery/shipment date
|
Date when the item has been or is to be delivered (if the item was purchased) or is to be shipped (if the item was sold).
|