Can the Daily Rates form be inquiry only?

https://generalledger-gl.blogspot.com/2018/11/can-daily-rates-form-be-inquiry-only.html

Please try to do below steps:

1. Enter a new function for Daily Rates using Sysadmin responsibility

Navigation: Application > Function

2. Query the function: GLXRTDLY with  a User Function Name: Daily Rates

3. Create a new function logically the same as the old one however on the Form tab, indicate QUERY_ONLY="YES" on the Parameters field

4. Attached the newly created function on the Currency Rates Menu

Navigation: Application > Menu

Menu: GL_SU_S_C_RATES

Add the newly created by indicating the function name  on the Function field

5. To apply these inquiry only access on a specific responsibility, query the responsibility

Navigation: Security > Define > Query the responsibility

6. On the menu exclusions indicate the Function name of the old one (Daily Rates original as this is not limited to inquiry only) leaving the newly created one which is for inquiry only

8. Access the form

Hope this helps.

Query to get Account Segment Description

https://generalledger-gl.blogspot.com/2018/11/blog-post.html


SELECT gl_flexfields_pkg.get_description_sql 

 
(

chart_of_accounts_id,--- chart of account id
1,----- Position of segment
segment1 ---- Segment value
) 

 
FROM gl_code_combinations