To resolve this issue Support will need to run some scripts on the database. Please raise a case.
Internal Solution
select * from goodsin where notenumber = [NoteNumber] select * from gi_item where notenumber = [NoteNumber] select * from GI_Item_History where notenumber = [NoteNumber] and productid = [ProductID] select * from GI_Item_UOM where NoteNumber = [NoteNumber] select * from product where productid = [ProductID] select * from transactions where transactionnumber = [NoteNumber] and productid = [ProductID] select * from stock where OriginatorID = [OriginatorID] begin transaction update stock set Quantity = [Quantity] where OriginatorID = [OriginatorID] update transactions set Quantity = [Quantity] where originatorid =[OriginatorID] update gi_item set Quantity = [Quantity] where GIItemID = [GIItemID] update GI_Item_History set Quantity = [Quantity] where notenumber = [NoteNumber] and productid = [ProductID] update GI_Item_UOM set Multiple = [Quantity] where NoteNumber = [NoteNumber] and LineNum = [LineNum] rollback commit exec sp_Sync_pickface_stock_balanceV5
Alternatively
Same error in the same screen, this time some filed showed 'Null', these needed updating
These fields are OrderTypeID, OrderPriority, I found the correct figures from looking at every other order for that customer.
Select * from goodsin where NoteNumber = [Goodsin Number] Select * from GoodsIn_History where NoteNumber = [Goodsin Number] Begin transaction Update goodsin set OrderTypeID = ####, OrderPriority = ### where NoteNumber = [Goodsin Number] commit
Full Error: frmSlConfirmGoodsInAdv|GetConfirmData|94|Invalid use of Null