My client is looking for a way to have an "approval" system for when a supplier's bank details change. We have created 4 UDFs for this (3 for approvers and 1 for an overall approval).
We set the overall approval to Yes when a BP is updated with more than two approvers (Y).
We now want to create a post transaction notification to set all to N for when a change is made to a Supplier's bank details in table OCRB and object 187.
It seems like object 187 and object 2 (BP) fire together, the reason I say this is that when you update the bank nothing happens but when you update OCRD the TXN actually fires for object 187.
We just cannot get it to fire 100%. Started using the AbsKey but as OCRB has four keys SBO concatenates the four fields to be used in the TXN.
The fields are OCRB.COUNTRY, OCRB.BANKCODE, OCRB.ACCOUNT, OCRB.CARDCODE.
The post txn we use is:
SET U_ApproveR1 = N'N'
FROM OCRD INNER JOIN
OCRB ON OCRD.CardCode = OCRB.CardCode
WHERE (OCRD.CardCode = (Select CardCode from OCRB where OCRB.Country+' '+OCRB.BankCode+' '+OCRB.Account+' '+OCRB.CardCode = @list_of_cols_val_tab_del))
Your help will be appreciated as always.