Skip to Content
0
Former Member
Nov 14, 2012 at 12:01 PM

Approval when Bank Account Changes (TXN)

234 Views

Hi,

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:

UPDATE OCRD

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))

END

Your help will be appreciated as always.

Jacques