GL Account Determination

[Former Member]

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!

Adele

[Former Member]

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ñ

[Former Member]

It worked, thanks!