Skip to Content
0
Former Member
Nov 29, 2011 at 11:25 AM

Approvals on Stock Transfer

127 Views

Hi all,

We have three warehouses and and three Goods In Transfer (GIT) warehouses. Transfers happen in two phases a below:

TRANSFER between whse A and B

Whse A----->GIT whseB -


> WhseB

I have developed queries to trigger approvals for each step as follows:

STEP1

SELECT DISTINCT 'TRUE' FROM WTR1 T0 WHERE $[WTR1.WhsCode]='GIT_whseB'

step2:

SELECT DISTINCT 'TRUE' FROM OWHS T0 WHERE $[OWTR.Filler]='GIT_whseB' AND $[WTR1.whscode]='whseB'

in Step 1,Mr John (whseA) initiates the transfer and Mr Peter (WhseB) approves it hence goods lie in GIT_WhseB. This step works perfectly.

My issue occurs in step 2: Mr. Peter (whseB) initiates the transfer from GIT-whseB to whseB. I want to come up with a better step2 query than the above which will ensure that only Mr. John (the first transfer initiator) gets the approval alert - not any other user from the third warehouse.

I hope you I am clear enough. Thank you.

Rgds,

Henry