Datasheet

Release Notes - New Features included in Release 2.4.0
Page 45 of 89
4.2.11 Warehousing and Inventory (INCO)
4.2.11.1 Planned Stock Count option to exclude Locations (SR3767)
A new option has been introduced on the SLAD (Location Details) transaction to identify that a
particular store and location is to be included or excluded from a planned PI (Perpetual Inventory)
stock check.
When a planned PI count is requested, any stock in locations which are excluded are now ignored
from the reports produced and stock check sheets are not generated.
Unplanned counts still allow the items in these locations to be counted.
Existing SLAD details will have the new flag set to ‘Y’ (Include), which matches previous
functionality.
4.2.11.2 Online Stock Reconciliation (SR3781)
The INSM group of transactions provides an alternative stock reconciliation facility allowing the
stock reconciliation procedure to be completed online while the system remains fully available to
other users. (The previous STKRECON facility ran as part of a batch run with online update
transactions prevented for the duration of the run.)
The new facility reconciles stock on an item by item basis so that any discrepancy values can be
identified and explained more easily.
The INSS (Inventory Snapshot Request) transaction is used to request an inventory snapshot for an
entered date and time and submits an INSI (Inventory Item Snapshot) to the background queue.
The INSI (Inventory Item Snapshot) transaction calculates the inventory position for an item and
warehouse at the entered date and time by adjusting the current stock position by the movements
since the entered date and time. The INSI transaction runs in background and submits a further
transaction for the next item to be processed.
The INSQ (Inventory Snapshot Enquiry) provides visibility of existing inventory snapshots
including their status.
The INSD (Delete Inventory Snapshot) transaction removes details of the selected inventory
snapshot from the database.
The INRR (Reconciliation Request) transaction is used to request an inventory reconciliation. A
reconciliation can be requested between two points in time (a From Date and a To Date) for which
inventory snapshot details exist. INRR submits an INSR (Item Reconciliation) transaction to
background in respect of the first inventory item to be processed.
The INSR (Item Reconciliation) transaction reconciles inventory between the two points. The
inventory position at the From Date is adjusted by the movements for the period giving a calculated
end position. This is compared with the position from the To Date snapshot and any difference is
reported as a discrepancy. INSR submits itself to background in respect of the next item.
The INRQ (Reconciliation Enquiry) transaction is used to enquire on the results of the
reconciliation.