B1UP Validation Config - help please

[former_member834429]

Hi Experts

I would like to create a validation on Sales Order for when a customer has a particular payment terms of Cash Basic.

In these cases I need users to record the method of payment on a UDF called U_CashBasicType

The UDF has a linked table and 7 options (not including blank) - BA, CA, CC, CH, OK, RP, VO

I would like SAP to throw an error message when the customer is cash basic (GroupNum field 139.47)

I have so far created a B1 Validation Config in Add/Update form mode on event Validate

The SQL condition is:

IF(SELECT GroupNum FROM OCRD WHERE CARDCODE=$[$4.0.0]) =-1 and ordr.U_CashBasicType is NULL)

BEGIN

SELECT 'CASH BASIC' FOR BROWSE

END

the function to execute is a simple status bar error which block the event. 

All looks okay to me but it doesn't see to run when the customer is cash basic and the UDF is blank (null)

Any ideas what I'm doing wrong? 

Fairly new to B1UP and my only training has been through the samples on the Boyum website (not great!) so apologies if this is an obvious fix.

Best Regards

Geoff

[former_member191694]

Hi Geoff,

i thing you want to Stop the Sales Order  let suppose Payment Terms  Is 'Net-30' And UDF is Null  So

IF (ordr.[GroupNum]=-1  and isnull(ordr.U_Fetch,-1)=-1 )

BEGIN

SELECT 'CASH BASIC' FOR BROWSE

END

You can Also do it on the Back end in Transaction Notification SP ...

I Hope this may be Helpful .

Regards,

Mayank Shah