BookIn Activation can sometimes result in an error - "Add failed. Duplicate key value supplied"
BookIn Activation can sometimes result in an error - "Add failed. Duplicate key value supplied"
- Monica Holliday
Owned by Monica Holliday
When the same Suppliers Warehouse is added to the Inventory Suppliers tab for different Unit of Measure, it is set as duplicate default, this can then result in an error on BookIn Activation. This affects version 07.02.01.00 SR18.
This error is due to Inventory Items having more than 1 default supplier warehouses for the same supplier which is an invalid condition.
Run the below script against the database to identify the problem rows and fix the data correctly.
, multiple selections available,
Related content
Cannot insert duplicate key row in object ....
Cannot insert duplicate key row in object ....
More like this
LCINF020 - Inventory Booked in but Not Invoiced with a book in status
LCINF020 - Inventory Booked in but Not Invoiced with a book in status
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
'Creditor warehouse not found' error reported when loading inventory in a newly upgraded 6.5.13 database
'Creditor warehouse not found' error reported when loading inventory in a newly upgraded 6.5.13 database
More like this
Import of inventory transactions errors 'Object reference not set to an instance of an object
Import of inventory transactions errors 'Object reference not set to an instance of an object
More like this
ININF026 - In Stock by Bin was ignoring selected warehouses
ININF026 - In Stock by Bin was ignoring selected warehouses
More like this