Match inventory
Match Inventory processes all pending records in the YFS_INVENTORY_SHIPMENT table. Pending records have a smaller number in POSTED_QUANTITY than in QUANTITY.
Each pending record is matched against the receipt records in YFS_INVENTORY_RECEIPT table by applying the inventory cost determination logic. The unit cost at which the sales and receipt data are matched is also posted in YFS_INVENTORY_MATCH table.
Use this transaction if any of the configured ship nodes maintain inventory cost.
Attributes
The following are the attributes for this time-triggered transaction:
| Attribute | Value |
|---|---|
| Base Transaction ID | INVENTORY_MATCH |
| Base Document Type | General |
| Base Process Type | General |
| Abstract Transaction | No |
| APIs Called | None |
Criteria parameters
The following are the criteria parameters for this transaction:
| Parameter | Description |
|---|---|
| Action | Required. Triggers the transaction. If left blank, it defaults to Get, the only valid value. |
| Number of Records To Buffer | Optional. Number of records to retrieve and process at one time. If left blank or specified as 0 (zero), it defaults to 5000. |
| InventoryOrganizationCode | Optional. Valid inventory owner organization. Organization to process in this run. If not passed, all inventory organizations are processed. |
| CutOffDate | Optional. If passed, records are matched up to this date. Defaults to all unmatched records in Database. |
| ColonyID | Required in a sharded deployment where the YFS_INVENTORY_SHIPMENT, YFS_INVENTORY_RECEIPT, and the YFS_INVENTORY_MATCH tables may exist in multiple schemas. Runs the agent for the colony. |
Statistics tracked
The following statistics are tracked for this transaction:
| Statistic Name | Description |
|---|---|
| NumInventoryShipmentsProcessed | Number of inventory shipments processed. |
| NumInventoryMatchesInserted | Number of inventory matches inserted. |
Pending job count
For this transaction the pending job count is the number of distinct inventory items that exist in the YFS_INVENTORY_SHIPMENT table where the QUANTITY value is not equal to the POSTED_QUANTITY value.
Events raised
None.