Product Balances
Quantities and other details associated with all products that are currently available in the warehouse.
This preloaded action grid shows details about the products (description, location, quantities, etc.) that are currently in stock. Product records may be invoked as a hyperlink (drill-down) from records in some Inbounds/Outbounds action grids. Each product record includes hyperlinks to associated lot, unit, and conveyance information that may be available.
Using standard Action Grid Functionality, the data may be sorted, filtered, and sub-totaled for various types of analysis. The results may be converted to a chart and/or output to external format (PDF, Excel, XML etc.).
Why Multiple Product Balance Records?
When no filtering (or views) have been applied to this action grid, each product balance can consist of of up to four different rows/records. Each of these records represents one of following levels of summary/detail:
- Balance quantity across all warehouses and all holds
- Balance quantity across all warehouses and a specific hold
- Balance quantity for a specific warehouse and all holds
- Balance quantity for a specific warehouse and a specific hold
Record types 1 and 3 will always be listed for each product (since stock is always located in at least one warehouse but holds are optional). VL includes some preset Persistent Views that automatically filter the data to show:
- All warehouses, net holds, and the on-hand balance.
- Specific warehouses, net holds, and the on-hand balance.
Drill-Downs From Product Balances
Some of the data elements for Product Balances act as hyperlinks to other action grids that may contain further details about the record selected.
| Lots | Invokes the Lot Balances action grid which lists lot codes and shows balances of products within each lot. |
| Unit IDs | Invoke the Unit IDs Lists action grid which provides a list of all the available unit IDs (if stock is organized into units, serial numbers, etc.). |
| Conveyances | Invoke the Conveyance Contents action grid which describes the contents associated with each conveyance ID. |
|
|
Exits the current level of a drill-down (if activated). The Back All (double arrow) and the Back (single arrow) buttons are activated (turn red) whenever the current action grid is the result of a drill-down invoked by hyperlinked data elements. If activated, you can use the Back button to exit one level of grid at a time. Use the Back All button to navigate out of all levels and return to the initial action grid. |
.png){kind=small}
Was this article helpful?
Give feedback about this article