Require validation for Bp Advance limit

[former_member188586]

hi

I'm New For to write SP Validation please Assist me

OCRD.CARDCODE,OCRD.U_APPRWO/PO [ HERE WE ASSIGN SOME LIMIT OF  VALUE] THEN  IN OVPM .NODOCSUM [ HERE WE ASSIGN SOME VALUE TO ISSUE FOUND ]

, IF BP ASSIGN LIMIT VALUE AND OUTGOING ADVANCE VALUE IS GROSSED TO BP LIMIT VALUE THEN SYSTEM HAS TO RAISE ONE VALIDATION

Thanks& Regards

AndakondaRamudu

[former_member188586 · Accepted solution]

hi sir

   TV id: 229 458 018 and Pwd:2380

[kothandaraman_nagarajan · Accepted solution]

Hi,

Any update?

Thanks & Regards,

Nagarajan

[former_member188586 · Accepted solution]

hi sir

shall u take now TV ??

[kothandaraman_nagarajan · Accepted solution]

Have you created new UDF?

[former_member188586 · Accepted solution]

no sir, with new UDF we can't do ???

[kothandaraman_nagarajan · Accepted solution]

Hi,

Did you check SAP note for accessing form settings?

[former_member188586 · Accepted solution]

yes sir,

That is fine sir,, what will do for sp sir??i'm not able to understand any thing but i'm thinking only SP...

[kothandaraman_nagarajan · Accepted solution]

Don't worry. We can fix it by today or tomorrow. Now it is not possible to connect TV.

[former_member188586 · Accepted solution]

ok sir ,, Fine when even you feel then connect sir

[kothandaraman_nagarajan · Accepted solution]

Hi,

Solved?

Thanks & Regards,

Nagarajan

[former_member188586 · Accepted solution]

hi sir,

No ,what we ill do tell me sir,

[kothandaraman_nagarajan · Accepted solution]

Ok let me try TN without creating new UDF.

[former_member188586 · Accepted solution]

ok sir

Tv :229 458 018 pwd:7501

[former_member188586]

Finally at last i Got Solution as well as i Lear Tn with The Help of  Nagarajan K sir ;Thank You Very Much Your Almighty Support sir

solution is :

IF (@Object_Type='46') AND (@transaction_type in (N'A', N'U'))

BEGIN

IF EXISTs ( SELECT T0.[DocNum] FROM OVPM T0  INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode  WHERE T1.[U_Bal] <= T0.[NoDocSum]

and T0.DocEntry = @list_of_cols_val_tab_del )

Begin

SET @error = 10

SET @error_message = 'Advance is more'

End

END

Thanks & Regards

AndakondaRamudu

[former_member188586]

hi sir

Tv id:229 458 018 and pwd:2265

[kothandaraman_nagarajan]

Hi,

Sorry. Right now not possible to connect. Sure we will check it by tomorrow.

Thanks & Regards,

Nagarajan

[former_member188586]

hi sir

fine sir.,we will check Tomorrow

Thanks& regards

  AndakondaRamudu

[kothandaraman_nagarajan]

Hi,

Do you want block outgoing payment if payment more than OCRD UDF value?

Thanks & Regards,

Nagarajan

[former_member188586]

hi sir

  Thanks for Your Replay .

  yes sir

[kothandaraman_nagarajan]

Hi,

Why did you consider this field OVPM .NODOCSUM?

Thanks & Regards,

Nagarajan

[former_member188586]

hi  sir

in that filed we mention advance amount and reflected  to total value ...Reffer to attache file

Thanks& regards

  AKR

[kothandaraman_nagarajan]

Hi,

What is your B1 version and PL?

Thanks & Regards,

Nagarajan

[former_member188586]

hi sir,,

sap b1 2007 B PL17

[kothandaraman_nagarajan]

Hi,

I don't have 2007 version to test. Run below query and let me know the result.

SELECT T0.docentry FROM OVPM T0  INNER JOIN VPM2 T1 ON T0.DocEntry = T1.DocNum left join  OCRD T2 on t2.cardcode = T0.[CardCode] WHERE T0.[NoDocSum] > T2.U_APPRWO/PO

Thanks & Regards,

Nagarajan

[former_member188586]

OK SIR ..

I'LL CHECK AND UPDATE YOU

[former_member188586]

hi sir,,

  i'm new to write Sp ,try to provide SP

[kothandaraman_nagarajan]

Hi,

I will give complete SP. But before that, I want to see query result.

Thanks & Regards,

Nagarajan

[former_member188586]

hi sir

after execute query {SELECT T0.docentry FROM OVPM T0  INNER JOIN VPM2 T1 ON T0.DocEntry = T1.DocNum left join  OCRD T2 on t2.cardcode = T0.[CardCode] WHERE T0.[NoDocSum] > T2.[U_ApprWOPO]}

i'm getting  following output

[kothandaraman_nagarajan]

Do you have TV? If yes, send ID and password.

[former_member188586]

hi sir

TV id is:229 458 018 and pwd:5823

[kothandaraman_nagarajan]

Hi,

Did you get SP for your requirement?

Thanks & Regards,

Nagarajan

[former_member188586]

No sir

[kothandaraman_nagarajan]

Hi,

OK. We will check together.

Thanks & Regards,

Nagarajan

[former_member188586]

ok sir

[kothandaraman_nagarajan]

send  TV ID and password now

[former_member188586]

hi sir .. upto sunday  holidays  due to dasara,we ill check monday ...

Thanks & regards

  Andakondaramudu

[kothandaraman_nagarajan]

OK, if I am not wrong Monday also holiday. So we will check it on Tuesday.

[former_member188586]

ok sir

  we will check Tuesday,Happy dasara sir