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
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.