HI @AkilaR Thanks for your quick response.I don’t have access to IFS database so can’t confirm this myself.Can you help confirm if this query will return the company, voucher_types and their descriptions: SELECT DISTINCT GEN_LED_VOUCHER_ROW_TAB.COMPANY, GEN_LED_VOUCHER_ROW_TAB.VOUCHER_TYPE,ifsapp.VOUCHER_TYPE_API.Get_Description(GEN_LED_VOUCHER_ROW_TAB.voucher_type) AS VOUCHER_DESCFROM ifsapp.GEN_LED_VOUCHER_ROW_TAB GEN_LED_VOUCHER_ROW_TAB
version 10
Hello,Thank you for the response. The first two screenshots helped with the company listings and chart of accounts.The ledger listing I’m referring to is the company ledger to obtain some if not all of the following fields:ledger_name, ledger_number, ledger_description, type, currency_name, currency_number, currency_description, and symbol I’m writing an extraction logic and don’t have access to IFS.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.