Orders upsert with null salesorderid failing

[Manoj Chaurasia]

Hi All,

 

I'm attempting to use an upsert command in creating an Order, I have the GUID properly defined for existing orders, but when I attempt to pass NULL to it to create a new order, it returns 'Object reference not set to an instance of an object.'. The database itself is storing null as the value for new orders, however, I'm also adding a IF(ISNULLOREMPTY(orderid),NULL,orderid) ... I've tried changing NULL to "" as well, but that failed.