Use this report to verify your manually entered General Ledger tax journals. You run this report to review the journal taxable lines and the tax lines they generated, for posted or unposted journals.
This report calculates a subtotal for each journal entry, and a grand total for all lines with a given tax code.
This report breaks on balancing segment, tax type, and tax code.
When you request this report, General Ledger prompts you to enter the following:
From/To Balancing Segment: the range of balancing segment values on which you want to report. For example, if Company is your balancing segment, you can report on companies number 5 through 20.
Tax Type: choose to report on Input or Output tax types.
Tax Code: choose the tax code on which you want to report. This is the Oracle Receivables tax code or the Oracle Payables tax name.
From/To Effective Date: enter the range of effective dates to include in your report.
Posting Status: you can report on Posted Journals, Unposted Journals, or Error Journals.
Refer to the selected heading descriptions below for additional information.
Tax Accounting Flexfield: the account assigned to the specified tax code.
Journal Name: the name of the journal containing taxable detail lines.
Effective Date: the journal's effective date.
Taxable Accounting Flexfield: the account for the taxable journal line amount.
Dr/Cr: an indicator of whether the ledger currency amounts are debits or credits.
Primary Currency Amounts - Taxable: the journal line amount that is to be taxed, expressed in your ledger currency.
Primary Currency Amounts - Tax: the calculated tax on the journal line amount, expressed in your ledger currency.
Primary Ledger Amounts - Gross: the total of the taxable journal line amount and the calculated tax, expressed in your ledger currency.
Date: the date of the customer or vendor subledger item that contributed to the taxable journal amount.
Identifier: an identifier associated with the subledger item that contributed to the taxable journal amount.
Customer/Vendor Name: the customer or vendor name associated with the subledger item that contributed to the taxable journal amount.
Customer/Vendor Tax Num: the customer or vendor reference associated with the subledger item that contributed to the taxable journal amount.