1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Not able to Disable Multi Currency option in Accounts Payable,

Discussion in 'Oracle Financials' started by rmreddyinfo, May 5, 2011.

  1. rmreddyinfo

    rmreddyinfo Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    80
    Hello Everyone,

    in accounts payable not able to disable Multi currency option

    any one help me on this to resolve.




    Thanks in advance,
    Mallikarjuna Reddy
     
  2. yknev

    yknev Active Member

    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    100
    Hi Mallikarjuna,

    Your requirement is not clear. Please provide the path and version.

    Regards,
    Yknev
     
  3. rmreddyinfo

    rmreddyinfo Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    80
    Hi Yknev,

    It is related to Oralcel Financials 11i and Navigation is Setup==>Options==>Payabls in that Currencey Tab



    Thanks in advance,
    Mallikarjuna Reddy
     
  4. yknev

    yknev Active Member

    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    100
    Hi Mallikarjuana,

    Please let me know the following points:-

    1. Did you raise invoice with multi currency in Payables module or Journal Entires in GL module ?
    2. Did you got any error message while disable of USE OF MULIT CURRENCIES option

    Regards,
    Yknev
     
  5. rmreddyinfo

    rmreddyinfo Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    80
    Hi Yknev,

    i have raised invoice with multi currency in payables module after that when we are disable of use of multi currencies optin

    getting error is : APPS - SQLAP - 10366. you cannot set the allow multiple currencies option to No because you currently have
    one or more multi currency bank accounts.

    Pls suggest......


    Thanks & Regards,
    Mallikarjuna Reddy
     
  6. yknev

    yknev Active Member

    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    100
    Hi Mallikarjuna,

    Please run below query:-

    SELECT disintct currency_code
    FROM ap_bank_accounts_all

    It will returns multi currency because you have multi currency bank accounts. Invoice is raised against to mulit currency and same invoice is gone to GL module also due to this reason your unable to update the check box.

    Regards,
    yknev
     
  7. rmreddyinfo

    rmreddyinfo Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    80
    Hi yknev,

    Thanks for your immedite response,

    Could you please provide me the navigation to run above



    Thanks in advance,
    Mallikarjuna Reddy
     
  8. yknev

    yknev Active Member

    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    100
    Hi Mallikarjuna,

    The above statment is sql query. so you can need to be login in database and run the same.

    Regards,
    Yknev
     
  9. rmreddyinfo

    rmreddyinfo Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    80
    Hi Yknew,

    Thanks for your help


    Regards,
    Mallikarjuna Reddy