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

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

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

SQL skills are required

Sound SQL skills are required to complete this task

 

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.