Open SO Record Counts

This ticket comes in every day has the counts for all of Hager's Open SOs. If there is a SO listed under the "Records in P_OPENSO but not in TEMP File" header, the listed SOs have to be removed or added to the P_OPENSO table. 

Below is an example of the ticket and where to find the P_OPENSO records

Verify if order is already fully shipped. To do this, in G2 go to the page C_SOINQS
and then check the estimate window and see if total estimate is equal to total
shipped. If they are equal, then need to delete record from p_openso, and
if OPEN_QTY_LINE_COUNT is not zero, need to update SO_HDR table to zero that
field. If order is not fully shipped, then leave the record in P_OPENSO.

*Note: in the screenshot below, the two values of 152.29 match. In some cases, both columns may just show zero (0). If they both match, the SO can still be removed from the list using P

To delete record, run utility function P_OPENSO and then delete the record
for the sales order. To update OPEN_QTY_LINE_COUNT, do it in toad using the following SQL: 

-- Select statement to view the SO infomation
select * from SO_HDR where so = lpad('2971926',20);

-- Select statement to show only the open qty line count
select OPEN_QTY_LINE_COUNT from SO_HDR where so = lpad('2971926',20);

-- Update statement to update the open qty line count to zero
update SO_HDR set OPEN_QTY_LINE_COUNT = 0 where so = lpad('2971926',20);