+1Hi 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
+21Hi
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
+1Hi Furkan,
Thank you very much indeed.
We are trying to have financial ledger actually. Hence, we can get trial balance.
İlker
+21Hi 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 E-mail address. We'll send you an e-mail with instructions to reset your password.
