+1Hello,
Can anyone help with the screens within IFS Apps that contain the following financial data:
Alternatively, the table/view names within the database that these data (chart of accounts, company listing and ledger listing) can be extracted from.
Thank you.
Best answer by Furkan Zengin
Hello,
Company list is under Companies window
You can see the list using the code below
SELECT * FROM COMPANY;
Chart of account is under Account window. You can click RMB and change window presentation to multi-company
Use the code below for db query
SELECT * FROM ACCOUNT;
I assume that ledger listing refers to customers and suppliers. For this purpose you can visit Customers and Suppliers window
+21Hello,
Company list is under Companies window
You can see the list using the code below
SELECT * FROM COMPANY;
Chart of account is under Account window. You can click RMB and change window presentation to multi-company
Use the code below for db query
SELECT * FROM ACCOUNT;
I assume that ledger listing refers to customers and suppliers. For this purpose you can visit Customers and Suppliers window
+1Hello,
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:
I’m writing an extraction logic and don’t have access to IFS.
+21Hello,
Please use GL Voucher Rows Analysis window to extract general ledger details. You need to grant access on Users per Authority Class window.
Hope this helps
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.