Skip to Content

Approval for Cash payment above Rs. 20000.

How to incorporate the approval procedure for cash payment above rs 20000.

thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

10 Answers

  • Best Answer
    Posted on Aug 12, 2008 at 08:33 AM

    gangothri,

    Refer to SAP

    Note 1165619 - Cannot add outgoing payments in approval procedures.

    in the below link.

    https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1165619

    This is an application bug.

    This problem is fixed in latest patch.

    Upgrade it to latest patch in 2007B.

    Hope it will solve the issue.

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2008 at 07:32 AM

    1. Create an Approval Stage

    2. Create Approval Stage, by selecting 'Outgoing payment' in the 'Document Tab'

    3. In the Stages Tab, define the 'Approval Stage'

    4. In the Terms Tab, select 'When the Following Applies', select 'Ratio' as 'Greater Than' and in the Value type 20000

    5. Click Add

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 06, 2008 at 10:50 AM

    Open query generator,Click execute,Click Pencil

    button at top left corner,Remove query already there

    by deleting it.

    Paste the below query and save it in a query category.

    SELECT TRUE FROM OVPM T0 WHERE

    T0.[DocType] = 'C' AND T0.[CashSum] > 20000

    Open reqd. approval template

    In approval templates terms tab

    select option when the following applies

    terms based on user queries don't select standard terms,Click update to save changes in approval template.

    Hope it will solve the problem.

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 06, 2008 at 11:09 AM

    Save this modified query

    SELECT TRUE FROM OVPM T0 WHERE

    T0.DocType = 'C' AND T0.DocTotal > 20000

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 07, 2008 at 07:14 AM

    This will work,

    SELECT TRUE FROM [dbo].[OVPM] T0 WHERE

    T0.[CashAcct] = 104002 AND T0.[CashSum] > 20000

    Hard code cash account as defined in COA.

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 07, 2008 at 03:55 PM

    ok...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 08, 2008 at 06:14 AM

    I have tested the query with demo db.

    It's working fine.

    SELECT TRUE FROM OVPM WHERE

    $[$32.0.0]=100409 AND $[$38.0.Number] > 20000

    Replace cash g/l 100409 with your reqd. cash g/l as customized.

    It'll solve problem.

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 08, 2008 at 08:21 AM

    gantori,

    $http://$32.0.0=100409 AND $http://$38.0.Number > 20000

    Replace http:// with [ -open square bracket and close 32.0.0

    with closing square bracket ]

    Also do the same for another condition.

    After doing above changes in query save it once again in

    query manager.

    if problem occurs,post your email id.

    I will send query to email.

    Jeyakanthan.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 08, 2008 at 02:05 PM
    SELECT TRUE FROM OVPM WHERE $[$32.0.0]=100409 AND $[$38.0.Number] > 20000

    Save the query in new name,also update it in approval template.

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Aditya Dalmiya

      Umesh,

      On the Approval template document Tab > Do you have Outgoing Payment as an option that you checked?

      Also the Approval Procedure could work only if the values referred are on the Outgoing Payments window. It seems the $\[$32. is from the Payment means window which might not work

  • Posted on Aug 09, 2008 at 06:05 AM

    What is your SAP B1 version & patch level ?

    I have tested query posted here in demo db,

    approval procedure is triggered for condition mentioned

    in query,no error message appears.

    Is there is any approval procedure active for outgoing payments ?

    Whether you tested approval procedure is trigerred for

    any other transactions ?

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.