Need to fetch the amount( Debit - Credit) from XLA tables
Summary:
Need to fetch the amount( Debit - Credit) from XLA tables
Content (please ensure you mask any confidential information):
We developed the query to fetch the amount( Debit - Credit) group by segments, period name. We are comparing results with "Inquire on Detail Balances" (General Accounting —>General Accounting Dashboard—>Inquiry and Reporting) from the application. The report output is not matching with the "Inquire on Detail Balances" results.
Attached BIP SQl query for your reference and suggest if I miss anything.
Version (include the version you are using, if applicable):
24B
Code Snippet (add any code snippets that support your topic, if applicable):