+1
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
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
+1
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
