Skip to Content
author's profile photo Former Member
Former Member

GL Account Determination

Hi All, How can I determine which account is set up as the Cash on Hand account? I need to get it from DI. Go to Administration > Definitions > Financials > G/L Account Determination? I need to know the account number to be able to do an outgoing payment to a customer. Thanks very much!


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 11, 2004 at 12:27 PM

    Hi Adele,

    just using the Display Debug Information option (Under ToolsUser Tools menu), you can see that this data is stored in the OADM table. Cash account is stored in the LinkAct_3 field.

    Although I don´t think this data could be get using standard SBO datatypes, you can use the recordset object and execute a select against this table and then take the field you need. Try creating the SQL using the Query Generator in order to ensure it works.

    Hope helps,

    Ibai Peñ

    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.