Error adding line to Warehouse Purchase Order "Could not find an inventory item with inventoryID of 'nnn'.

Problem

Error is reported when adding item to Warehouse Purchase Order. "Could not find an inventory item with inventoryID of 'nnn'.  Trace has shown that Jiwa is trying to locate a record in the IN_LogicalOrder table which doesn't exist for this InventoryID / INLogicalID.  Is there a script to run to populate the table for missing records?

Solution

There is a script in the C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Miscellaneous SQL Scripts\Inventory directory to create any missing records - Create missing order level records.sql.  A copy is attached for convenience.

Open

Related articles