Click or drag to resize

Inventory Sync

This option allows the Ultriva Inventory data to be in synch with the ERP Inventory data. The fields marked as bold are required. Required fields must always have non-empty data.

ERP Inventory Flat File Field Definition

The following table defines the fields in ERPInventory Data file. The fields marked as bold are required. Required fields must always have non-empty data.

ERPInventory Data File (inbound to Ultriva)

Field Name

Data Type

Length

Required

Nullable

Description

EBJ_BUSCODE

STRING

32

Y

N

Business Unit Code. This must match with the code in Ultriva.

EBJ_ITEMNO

STRING

32

Y

N

Item Number for which this PO has to be accounted for.

INVENTORYQTY

NUMBER

N/A

Y

N

Current Inventory for this item in ERP

INVENTORYDATE

DATETIME

N/A

Y

N

The time stamp of the inventory

Pre-Processing

This interface uses following fields as uniqueness constraint.

Field Name

Mandatory Field

EBJ_BUSCODE

Yes

EBJ_ITEMNO

Yes

  1. If there are duplicate records for this combination then only one record with latest timestamp is considered (other records for this item will be marked as DUPLICATE).

Validation

Batch Job Processor validates each record with following validation before it starts processing the record.

  1. Given EBJ_ITEMNO must exist in the given Business Unit context.

  2. If negative Inventory Qty is given then Ultriva considers it as 0 units on hand.

  3. The item must be categorized as either VIRTUAL or FORECAST. If an item is categorized as KANBAN then the record is marked as ERROR.

Processing Logic

The Batch Job Processor processes the input in two different ways based on the Item Category. If given item is categorized as VIRTUAL in ULTRIVA then it simulates Kanban Releases using one of these three replenishment options: OpenBox, EmptyBox or Replenishment Percentage. If given item is categorized as FORECAST then the Ultriva inventory is matched with MRP inventory using Goods Issue (in case of Ultriva inventory is more than MRP Inventory) or Add Inventory (in case of Ultriva Inventory is less than MRP inventory).

For Virtual Kanban Items, the Non-Replenishment cards will be given high priority and if there any cards found then those cards will be released first. The cards also taken in FIFO sort order so the first received card will be consumed.