cancel
Showing results for 
Search instead for 
Did you mean: 

Approval Procedure for a Change in Document Discount

Former Member
0 Kudos

Hello Experts!

My client wants to have an approval procedure when the document discount is changed in the Sales Order based on BP discount in the BP Master Data.

How will I setup the approval procedure especially in the Terms tab?

Your prompt response is highly appreciated.

Jen

Accepted Solutions (1)

Accepted Solutions (1)

former_member187989
Active Contributor
0 Kudos

It applicable for all documents in approval template.

Jeyakanthan

Former Member
0 Kudos

Ok. I will try to test it first.

I appreciate your quick response.

Regards,

Jen

former_member204969
Active Contributor
0 Kudos

Try this code:

If (SELECT  T1.Discount  From OCRD T1 Where T1.CardCode=$[ORDR.CardCode])
    ! =  $[ORDR.DiscPrcnt]
 Select 'TRUE'
else 
 Select 'False'

Former Member
0 Kudos

Thanks Istvan!

It works. You solved my problem.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

Is this requirement works for you ?

Lets say Sales Order is 10% ,but when they change in delivery ,you need to trigger the approval procedure .

If that's the case ,I think forum has provided solution .Please search on forum .

If you couldn't then ,i will try to find it for you

Thank you

Bishal

former_member187989
Active Contributor
0 Kudos

hi,

Approval procedure won't work on updations,it may be missing functionality.

Check this links

SAP Business one Product Development colloboration forum.

Jeyakanthan

Former Member
0 Kudos

Hi!

So you mean to say that this will not work in a Sales Order document? How about the delivery document or the AR Invoice?

Regards,

Jen

former_member187989
Active Contributor
0 Kudos

Try this

SELECT DISTINCT 'TRUE' FROM OPOR T0  INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T0.DiscPrcnt ! =  T1.Discount

Jeyakanthan

Former Member
0 Kudos

Hi!

Thanks for the reply but I tried it and it doesn't work. What happened was that it always prompts for an approval procedure eventhough I did not change the document discount in the sales order.

Jen