Skip to main content

Hi All,

 

I am looking for table maps that are showing how financial recording is performed and kept in IFS. In other words, how can I find ledger and all financial data?

In a similar way, is there a simple way of reaching to sales data as well.

 

Thank you in advance.

 

İlker

 

 

Hi @ilkertumkaya 

 

Can you elaborate what do you want exactly?

There are dozen of tables and views that stores financial data in IFS Apps. VOUCHER_ROW_TAB, GEN_LED_VOUCHER_ROW_TAB, INVOICE_TAB, LEDGER_ITEM_TAB etc.

 

If you want to create a report from financial transactions then I can suggest using GL_AND_HOLD_VOU_ROW_QRY view where you will have both GL and hold table transactions. I am assuming that you dont use internal ledger functionality for statutory booking.

 

Hope this helps

Furkan

Hi Furkan,

 

Thank you very much indeed.

 

We are trying to have financial ledger actually. Hence, we can get trial balance.

 

İlker

Hi again

If you want to get a trial balance then I can suggest using ACCOUNTING_BALANCE_AUTH view. You can also use GL Balance Analysis window to get a trial balance.

Cheers,

Furkan 

Reply


Terms & ConditionsCookie settings