cancel
Showing results for 
Search instead for 
Did you mean: 

Require validation for Bp Advance limit

former_member188586
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member188586
Active Contributor
0 Kudos

Hi For this

Bellow Thread Give Solution

Thanks&Regards

Andakondaramudu

Answers (1)

Answers (1)

former_member186712
Active Contributor
0 Kudos

Hi,

To create a SP we need to know in witch transaction you want to block?

The below example blocks the Sales Orders.

Try this:


IF @OBJECT_TYPE = '17' AND (@TRANSACTION_TYPE = 'A' or @TRANSACTION_TYPE = 'U')

  BEGIN

   IF EXISTS(SELECT 'True' FROM ORDR T0
  Inner join OCRD T1 on T1.CardCode= T0.CardCode left outer join OVPM T2 on T1.CardCode = T2.CardCode
    where  T0.DocEntry = @list_of_cols_val_tab_del
    Having Sum(T2.NoDocSum) > T1.U_APPRWO/PO)

   BEGIN
    SELECT @ERROR=1,@ERROR_MESSAGE='message you want to send to the user !'
  END
end

Regards,

former_member188586
Active Contributor
0 Kudos

Hi

Augusto Silva

Thanks For your Quick replay

  my  requirement is Bp  has taken Advance earlier 2lakhs ,but Bp total advance is limit is 5lakhs here( Ledger is showing +3lakhs)

now

    we raised one invoice 4LAKHS AGAINST OUTGOING PAYMENT WILL HAVE TO BE RAISED 2LAKHS(BECAUSE EARLIER HE TOOK 2LAKHS ADVANCE HERE WE HAVE DEDUCT ) AFTER COMLETE OP ,NOW BP IS ELIGIBLE TO TAKE 5LAKHS  , HERE USER  WILL GAVE 6LAHS BUT LIMIT IS 5 LAKHS  HERE THERE IS NO VALIDATION FOR THIS SO IT WILL ADD ,NOW I'M GOING TO PUT VALIDATION ..


Thanks&Regrds

  AKR