Can't close a works order NULL value itemdbkey error

Question

Been puzzling over this for a couple of days now. 
 We have a completed works order that cant be closed due to an error that comes up saying: 
 
 Cannot update Field (itemDBKey) with a Null value as it is marked as not accepting 'Null' values. 
 
 I did get this on a different Works Order, but I managed to fix it due to the warehouse information not being there. But this WO seems to be different 
 The only reference to itemDBKey is in the MFGRepTraceabilityEnquiry table, but that doesn't seem to have much listed (unless its linked to another table) 
 Anyone experience this before and can explain what is causing this?

christopher hall · Answer

Hi Derrick 
 I agree with the previous advice given, I would also recommend reaching out to your Sage 200 support provider for assistance in this matter if you haven't already done so. 
 This is not a particularly common error especially in relation to works orders, so I was unable to find any previously suggested solutions in that area. 
 I did find information on the same error with the BOM reverse build function caused by the built stock item's product group having 'Keep Movement History' unticked. However, I have been unable to replicate the problem with the limited testing I have performed in this area. 
 
 Regards 
 Chris

Sage 200 UKI

Can't close a works order NULL value itemdbkey error

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING