Sales order, quote inventory or purchase order part numbers not matching the description
Sales order, quote inventory or purchase order part numbers not matching the description
- Beth Blok (Unlicensed)
- Mike Sheen
Owned by Beth Blok (Unlicensed)
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.
Related articles
, multiple selections available,
Related content
Part numbers changing on sales orders, quotes, purchase orders, shipments and bookins
Part numbers changing on sales orders, quotes, purchase orders, shipments and bookins
More like this
Exporting inventory with leading zeroes in the part number reads as a number
Exporting inventory with leading zeroes in the part number reads as a number
More like this
Error adding line to Warehouse Purchase Order "Could not find an inventory item with inventoryID of 'nnn'.
Error adding line to Warehouse Purchase Order "Could not find an inventory item with inventoryID of 'nnn'.
More like this
Inventory Import creates new parts when "Update existing Inventory" has been ticked
Inventory Import creates new parts when "Update existing Inventory" has been ticked
More like this
Error when loading sales orders - Key not found. Drill to Source Order'
Error when loading sales orders - Key not found. Drill to Source Order'
More like this
Inventory transaction import errors when importing stock records with a Bin Location
Inventory transaction import errors when importing stock records with a Bin Location
More like this