Below are tips and tricks for working through the Validation subitems on the Monday board during the Validation phase of your project. These tips are also present throughout the subitems' comments on the Monday board as well and should correlate with each section accordingly.
Item Attributes
Component Of… is correct count (Parent Items and Spoke Relationships):
1. Right click on a record
2. Select the Inventory Snapshot
3. Navigate to the BoM tab
Open Sales Orders
Demand Date is correct (will bucket monthly demand):
Directly ties to Actuals data points in Forecast Manager
Ex. If Demand Date = 5/14/2022 then you will see the SalesOrder Record in the March 2022 data point in Forecast Manager
Required Date Correct (optional): When the customer requires the order, when they want it in-hand.
Requested Ship Date Correct (optional): Date requested for the inventory to ship, if any
Open Supply Orders
ReleaseQuantity = How many were originally released on this order.
RemainingReleaseQuantity = How many units, in terms of stocking UoM, that are left un-received.
QuantityShipped = Quantity from this PO that has been shipped. Allows StockIQ to calculate in transit quantity by comparing ReleaseQuantity to RemainingReleaseQuantity and QuantityShipped.
OrderCreationDate = The date this order was created in the ERP system.
ExpectedShipDate = When it is currently expected the order will ship, based on expected shipping LT.
ExpectedDockDate = When the order is expected to arrive on the dock, from expected LT. (StockIQ May add PlanningPad and PutawayLT to this).
Transfer Orders - come from a sending warehouse within your supply chain network. When still in progress, the Transfer Order can be either Open, indicating it has not yet been pulled from the sending warehouse, or Released, indicating it has been pulled out of inventory and is en route.
When a transfer is still in "Open" status, StockIQ will automatically create the pending demand record out of the sending warehouse, so that available inventory is reduced appropriately.
Work Orders - Sometimes known as Manufacturing Orders, these are orders to build product in one of your Manufacturing facilities. Like transfers, they can show as Open or Released, and in fact can be partially released if a SupplyOrderBoM data feed is provided, if you do partial issuing of quantities on your work orders.
Also like transfers, when you have open, unissued components on the work order, StockIQ automatically creates the pending demands on the components of the finished good to correctly reduce available inventory for those components.
InTransit = QuantityShipped - QuantityReceived
QuantityReceived = ReleaseQuantity - RemainingReleaseQuantity
Forecast Manager
Forecast Hierarchy Correct (optional):
- Can be set using your ItemSiteCategories or CustomerShipToCategories
- Used to apply manual forecasts/overrides at a level typically above the ItemSite level
Example:
Month totals appear correct for 5+ items and months:
- Double click a data point
- Verify all orders are pulling through correctly on a few different months for a few different kinds of items to spot check a variety of ItemSite records.
- Can also go to Open Sales Orders and 'include closed orders' to filter Demand History in a macro view.
Seasonality & Stat Forecast appears correct on seasonal items:
- Seasonality should be picked up in StockIQ provided about 3 years of Sales History
- Main objective here is to verify that seasonality exists and if the forecast calculated against it makes sense to you
Dependent Demand flowing from assemblies and spokes properly with correct Qty Per:
Statistical Inventory
Safety Stock, Target Stock, Max Stock Validated for recurring items:
- Safety Stock is the driving factor in calculations
- Target Stock and Max Stock are not used in calculations and these values are just to show you what StockIQ thinks they should be.
- The default is to use StockIQ calculated Safety Stock but can be pulled in from your ERP as well.
Place Orders
Warehouses show correct Warehouse Supplier Type:
Manufacturing facilities show correct Manufacturer Supplier Type:
Individual Supplier Order Recommendations Validated (Quantities, Dates):
Transfer Order Recommendations Validated (Quantities, Dates):
All sources of supply for parts are shown (and no extras):
You may have an Item where there is a Primary Supplier but there's an additional secondary, or even tertiary supplier that needs to be associated as well. If everything is mapped properly, you should be able to see those additional sources of supply in the Place Orders screen on the Substitutes tab highlighted below.
(and no extras) just means that there's no suppliers associated with an item that shouldn't be.
Purchase UoM and Stocking ---> Purchasing UoM Conversion Correct:
Max Order Quantity correct for Manufacturing:
'Max Order Qty' as a column should be automatically populated when looking at a Manufacturer type record.