Re-open Slopchest Sales - script details and stepts

Sometimes it shows that Slopchest Sales are closed, but when checking in Onboard, the month is still open. 

This is happening when Master adds a sale for a crew that has already signed off since previous month.

Sales are still open in June, but in Compas office are showing closed:

How to fix this:

1. Run one of the below scripts in database to find out what is the IDSTATE

Option 1:

Select *

From OBJECT_STATES os

  Inner Join VESSELS v On os.vesselID = v.V_ID

Where v.VESSEL_CODE = 0478 And Year(os.STATE_DATE) = 2024 And

  Month(os.STATE_DATE) = 05 And Upper(os.OBJECT_TYPE) = 'TABLE'

Option 2:

Select *

From SLOPCHEST_ORDERS

Where SLOPCHEST_ORDERS.Order_Vessel = 0478

Before running the script, you need to check vessel ID and if it is the case, to put the month and the date. Please see the text in bold.

2. Ask Ops to run below script to reopen month:

update SLOPCHEST_ORDERS 

set ORDER_CLOSED = NULL,

ORDER_CLOSED_BY = NULL, 

ORDER_CLOSED_DATE = NULL 

where Order_Vessel = 0478 and OS_IDSTATE = 504164 and ORDER_CLOSED = 'Y

You need to put the vessel ID and the IDSTATE.