on 09-30-2014 7:07 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
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
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.