Activating a GRN may produce the error "Unable to insert into IN_WarehouseSOH Module:CreateStockLines"

If an inventory item does not have an IN_WarehouseSOH record for a logical warehouse that a GRN is on, then when the GRN is activated the following error will occur:

---------------------------
Error
---------------------------
Error : unable to insert into IN_WarehouseSOH
Module : CreateStockLines
---------------------------
OK
---------------------------

The system does first attempt to UPDATE IN_WarehouseSOH and if the rows affected is 0, it then attempts to INSERT into IN_WarehouseSOH as a defensive action.

However, the logic to perform the INSERT is flawed and it actually just attempts the UPDATE again.

Workaround is to run the usp_Jiwa_IN_WarehouseSOH_ReBuild stored procedure to create the missing IN_WarehouseSOH records and then the error will not occur.