Sales order, quote inventory or purchase order part numbers not matching the description

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

Problem

In some instances in the earlier versions of Jiwa 7, the inventory part number of sales order, purchase orders or quotes does not match the InventoryID or description from IN_Main. 

Solution

Download the three attached scripts.  All scripts are set out in two sections - firstly to identify any issues, the second part to correct the data.  Please run on a copy of the database to make sure you get the result you expect.

Advanced SQL skills are required

Note that to install SQL Scripts in your Jiwa database will require advance sql programming and database management skills.