| Table of Contents |
|---|
The Grid
The grids are visual alert monitors, that give you a general feel of the projected inventory per product/package/location.
Open a grid
In Picaso, hit this icon: 
. It opens a list of Grids:
...
Each grid's name starts with a number. Find the meaning of these numbers here
You may also create a grid (hit: 
) and/or understand how a grid works by looking at its properties (
)
...
The main screen shows an alert monitor which provides with visual on the projected stock situation:
| Icon / Color | |
|---|---|
| projected inventory negative |
| projected inventory positive, but lower than safety stock |
| projected inventory above safety stock, and below high target (= OK zone) |
| projected inventory above high target (=excess) |
| upper left black triangle shows a spot receipt (inbound stock transfer, or purchase) |
| lower left black triangle shows a spot requirement (outbound stock transfer, or sales order) |
| black solid line shows a continuous receipt (production) |
| red solid line shows a continuous requirement (consumption) |
Sorting
Sort items by:
| Sort name | Sort by |
|---|---|
| Product | Product Name / Location code / Package Code |
| Product Description | Prod Description / Location code / Package code |
| Locaiton | Location Code / Prod Name / Package Code |
| Init | Final inventory (see Stats) |
| Min | Min inventory (see Stats) |
| In | Xfers in (see Stats) |
| Out | Orders (see Stats) |
| Forecast | (see Stats) |
| Production | (see Stats) |
| Consumption | (see Stats) |
Each sort can be either ascending or descending.
...
Stats shows the key metrics that characterize the situation of a product/location over the horizon defined by the grid.
| Init | Starting inventory |
| Xfers In | Total inbound stock transfer volume over the grid's time span |
| Backord In | Total overdue inbound stock transfer volume |
| Orders | Total outbound volume over the grid's time span |
| Backords | Total overdue outbound volume |
| Final | Inventory at the end of the grid's horizon |
| Low | Lowest inventory point over the grid's time span |
The period of analysis can be found on the bottom of the Stats screen:
...
It lets you pick amongst the following configurations:
| Config | What it does |
|---|---|
| Combine Equivalent Products | The grids shows equivalent products as one single product (=aggregates inventory, receipts and requirements over one product) |
| Combine Equivalent Packages | Same with package codes of a product |
| Combine Equivalent Locations | The grids shows merged locations as one (everything on the parent location) |
| Use Only System-Generated Transfers | DRP Records factored in in the Grid, however only outside of the Time Fence (for more on Time Fences, check out the Inventory Targets and Preference section) |
| Ignore All System-Generated Transfers | DRP Records not factored in at all |
| Use All System-Generated Transfers | DRP Records factored in. |
Change your horizon
Change the Grid horizon with a right click anywhere on the screen. Select Grid Properties.
...
Related Grid lets you check out the grid of the product you right click on:
| By Product: all locations for that product |
|
| By Location: all products for that location |
|
Column layout:
RIght click on the column header of the grid; it lets you pick additional columns for display:
...
Tips: the 'SKU Resp' tells you if a product is defined as MTS or MTO (defined in Inventory Targets and Preferences):
Product / Location specific supply / demand data
...
It is determined automatically based on the UD code and the stock status of each lot in SAP:
| UD | Stock status | Usage |
|---|---|---|
| A* | Unrestricted | 1 (available) |
| R* | * | 0 (unavailble) |
| * | Blocked or Restricted | 0 (unavailable) |
| blank (still in QC) | * | 1 (available) |
You may modify the value of that field. A double click on a lot gets you to a window where you can switch the checkbox on or off:
...
If you switch it off, it'll affect the available inventory in Picaso right away. See below:
| Lot is 'Used' | 'Used' checkbox switched off |
|---|---|
|
|
|
|
The 'used' field will be overwritten overnight.
...
For more about these two topics, check out the Demand Management section.
Remaining FC
Monthly forecast, unconsumed by sales orders (open or shipped). Looks at months M0 → M2
Forecast is Ignored the last 7 days of the month
FC v Ord
Compares forecast and order for the current month.
...
More about material equivalent (and merged packages and locations) here
General
ID of the product / location. Also tells you
Follow this link to know more about product class. Follow that link to know more about location class.
...
When you hit the save button (
), it updates ADM.
More about Inventory targeting,
TargetPlot
Historical inventory level, goes back 9 months.
...