Unlock a Submitted Transfer in GP Dynamics Submitted to Accellos WMS via Blue Moon OpsCore

Unlock a Submitted Transfer in GP Dynamics Submitted to Accellos WMS via Blue Moon OpsCore

A few things to note about these two scripts:

– they were written to unlock a submitted transfer to the Accellos WMS via the Blue Moon OpsCore integration tool
– the table RBI13000 that is being updated is located in the GP company DB
– doctype =’8′ identifies the document as a transfer

Variables in this Script:
– XXX, replace the XXX in both scripts with the transfer number
– ZZZ, replace the ZZZ with the dex_row_id listed in the first query as an added safety measure when updating the record (this is optional)

— Script 1
— use this select script to find the locked in-transit transfer that needs to be unlocked

select * from RBI13000 where docnumbr = ‘XXX’

— Script 2
— use this update script to change the release status from a 4 (locked) to a 1 (available)
— added in doctype and dex_row_id as a safety net to make sure the proper record was updated

update RBI13000

set RBI_Release_Status = ‘1’ where docnumbr = ‘XXX’

and doctype = ‘8’ and dex_row_id = ‘ZZZ’