Skip to main content

Hello,

Can anyone help with the screens within IFS Apps that contain the following financial data:

  • chart of accounts,
  • company listing and
  • ledger listing

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.

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

 

 

 

 


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.


Hello,

 

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


Reply