SO Entry: Unable to Retrieve SO

Issue:
User is unable to retrieve particular SO.


Cause:
Column so_created_by under a_so_header table is NULL. Why it became NULL remains a mystery.

Solution:

1. Check if SO is present on the tables (see query below). Also check so_created_by column in a_so_header table if value is NULL.
   declare @so_no as char(8)
   
   set @so_no = 'input so number here'
   
   select *
   from a_so_header
   where so_number = @so_no
   
   select *
   from a_so_detail
   where so_number = @so_no
   
   select *
   from a_so_release
   where so_number = @so_no
2. If value of so_created_by is NULL, perform update statement below. Otherwise, proceed to step 3.
   declare @so_creator as char(10),
   @so_no as char(8)
   set @so_creator = 'input user id here'
   set @so_no = 'input so number here'
   
   update a_so_header
   set so_created_by = @so_creator
   where so_number = @so_no
3. Notify JSI for issue.