B JD Edwards EnterpriseOne Tax Processing Reports

This appendix contains the following topics:

B.1 JD Edwards EnterpriseOne Tax Processing Reports: A to Z

This table lists the tax processing reports, sorted alphanumerically by report ID. If more than three reports apply to one country, the reports are listed in a separate table by country.

Report ID and Report Name Description Navigation
R0018P

Tax/Detail Summary

Use this program to list transaction details from the Taxes (F0018) table and provide totals for each tax rate/area for each document type by company.

(Release 9.1 Update) You can also use the BIP solution to run the Tax/Detail Summary Report with alternate tax area functionality.

See Section 9.2, "Generating Generic VAT Reports"

Tax Processing and Reporting (G0021), Tax Detail/Summary.
R0018P1

Tax Summary Report/Use VAT

Use this program to print totals only for each tax area and tax rate for each company.

(Release 9.1 Update) You can also use the BIP solution to run the Tax Summary Report/Use VAT with alternate tax area functionality.

See Section 9.2, "Generating Generic VAT Reports"

Tax Processing and Reporting (G0021), Tax Summary Report/Use VAT.
R0018P2

Sales Tax

Use this program to print the transaction details from the F0018 table and provide totals for each tax rate/area for each document type by company. Tax Processing and Reporting (G0021), Sales Tax.
R0018P7

VAT Exception Report by Tax Area

Use this report to identify the transactions on which the tax amount entered by the user differs from the system-calculated tax amount. The report displays each amount, the amount variance, and the variance percent. Tax Processing and Reporting menu (G0021), VAT Exception Report by Tax Area
R0018P8

GST/PST Tax

Use this program to print GST/PST tax amount for each tax authority. The report lists GST and PST and subdivides PST into seller-assessed PST and self-assessed PST. Tax Processing and Reporting (G0021), GST/PST Tax
R0018R01

Report on Reconciled Taxes by Account ID

Use this program to print each transaction (totaled by document number) by account ID from the F0018R table.

The system does not provide totals on the report.

Global Tax Reconciliation menu (G00217), Report on Reconciled Taxes by Account ID.
R0018R02

Report on Reconciled Taxes by Tax Rate Area

Use this program to print each transaction (totaled by document number) by tax rate/area from the F0018R table.

The system does not provide totals on the report.

Global Tax Reconciliation menu (G00217), Report on Reconciled Taxes by Tax Rate Area.
R00320

VAT Journals

Use this program to print the VAT amounts by revenue and expense account for reconciliation purposes. Tax Processing and Reporting (G0021), VAT Journals.

B.2 JD Edwards EnterpriseOne Tax Processing Reports: Selected Reports

Some reports include a more detailed description, as well as information about processing options. These reports are listed alphanumerically by report ID in this appendix.

B.2.1 R0018P - Tax/Detail Summary Report

The Tax Detail/Summary report (R0018P) lists transaction details from the F0018 table and provides totals for each tax rate/area for each document type by company.

Note:

The system displays an * in the tax override column (TO) to indicate that the value of the tax amount entered differs from the system-calculated tax amount.

B.2.1.1 As If Currency Reporting

This report is enabled for as if currency processing, which enables you to print tax amounts in a currency other than the base currency of the company. As if currency processing for this tax report follows the no inverse method of exchange rate calculation, which is a legal requirement for EMU member currencies. The tax report print amounts as if they were entered in another currency; it does not write or update amounts in a tax table.

B.2.1.2 Intracommunity Reporting

This report includes a column for the value of the intracommunity flag (column heading IC). The system displays a Y in this column to indicate that the transaction has intracommunity taxes. The report also provides a separate total for intracommunity taxes.

B.2.2 Data Selection and Sequencing

Four versions of the report are available that provide different data selection and data sequencing. Although you can change the data selection for any of the versions, you should not change the data sequence. Totals on the report depend on the data sequence that is set up. If you change the data sequence, the results will be unpredictable.

B.2.3 Processing Options for Tax Detail/Summary (R0018P)

Processing options enable you to specify the default processing for programs and reports.

B.2.3.1 Tax Report

1. Detail Records

Enter 1 to flag the detail records as having been read.

B.2.3.2 As-If Currency

1. Currency Code

Enter the currency code for as-if currency reporting. This option enables for amounts to print in a currency other than the currency they are stored in. Amounts will be translated and print in this as-if currency. If you leave this processing option blank, amounts will print in their database currency.

2. Date

Enter the As-Of date for processing the current exchange rate for the as-if currency. If you leave this processing option blank, the system date will be used.

B.2.3.3 Dates

1. From Date and 2. Thru Date

Enter the from date or the through date.

B.2.4 R0018P1 - Tax Summary Report/Use VAT

If you do not want detailed transaction information, you can print the Tax Summary Report/Use VAT report (R0018P1). This report displays totals only for each tax area and tax rate for each company.

B.2.4.1 Intracommunity Reporting

In addition to the columns listed, the Tax Summary Report/Use VAT report also includes these columns for intracommunity reporting:

  • Intra-community taxable amount

  • Intra-community tax

B.2.5 Processing Options for Tax Summary Report/Use VAT (R0018P1)

Processing options enable you to specify the default processing for programs and reports.

B.2.5.1 Tax Report

1. Records

Enter a 1 to flag the detail records as having been read.

B.2.5.2 As-If Currency

1. Currency Code

Enter the currency code for as-if currency reporting. This option allows for amounts to print in a currency other than the currency they are stored in. Amounts will be translated and print in this as-if currency. If left blank, amounts will print in their database currency.

2. Date

Enter the As-Of date for processing the current exchange rate for the as-if currency. If left blank, the system date will be used.

B.2.5.3 Dates

1. From Date and 2. Thru Date

Enter the from date or the through date.

B.2.6 R0018P2 - Sales Tax

The Sales Tax report (R0018P2) displays transaction details from the F0018 table and provides totals for each tax rate/area for each document type by company.

When you select to print the Sales Tax report, the system additionally processes and prints:

  • The Tax Summary Report by Tax Authority (R0018P3)

    This report prints totals only for each tax authority by tax rate for each company.

  • The Tax Detail Report by Tax Authority (R0018P5)

    This report prints each transaction for each tax authority and rate and provides totals by tax authority for each company.

The Tax Summary Report by Tax Authority and Tax Detail Report by Tax Authority reports do not have processing options. If you want to change the data selection for these reports, you must create a new version of the Sales Tax report (R0018P2). In the new version, set up the data selection that you need, check the version in, and run the version locally.

The Sales Tax report provides processing options for you to specify the versions of the R0018P3 and R0018P5 reports that you want to run.

B.2.7 Processing Options for Sales Tax (R0018P2)

Processing options enable you to specify the default processing for programs and reports.

B.2.7.1 Versions

1. Tax Summary Report by Tax Authority Version

Enter an override version number, to override the standard call for Tax Summary Report by Tax Authority (R0018P3). If left blank, ZJDE0001 will default.

2. Tax Detail Report by Tax Authority Version

Enter an override version number, to override the standard call for Tax Detail Report by Tax Authority (R0018P5). If left blank, ZJDE0001 will default.

B.2.8 R0018P7 - VAT Exception Report by Tax Area

You run the VAT Exception Report by Tax Area report (R0018P7) to identify the transactions on which the tax amount entered by the user differs from the system-calculated tax amount. The report displays each amount, the amount variance, and the variance percent.

B.2.8.1 As If Reporting

This report is enabled for "as if" currency processing, which enables you to print tax amounts in a currency other than the base currency of the company. As if currency processing for this tax report follows the no inverse method of exchange rate calculation, which is a legal requirement for EMU member currencies. The tax report print amounts as if they were entered in another currency; it does not write or update amounts in a tax table.

B.2.9 Data Selection

The data selection for this report is set up for tax explanation code V (VAT) only; however, you can change this data selection to run the report for any or all tax explanation codes. The totals that appear on the report depend on the data sequence that is set up. Therefore, do not change the data sequence for this report.

B.2.10 Processing Options for VAT Exception Report by Tax Area (R0018P7)

Processing options enable you to specify the default processing for programs and reports.

B.2.10.1 As-If Currency

1. Currency Code

Enter the currency code for as-if currency reporting. This option allows for amounts to print in a currency other than the currency they are stored in. Amounts will be translated and print in this as-if currency. If left blank, amounts will print as normal.

2. Date

Enter the As Of date for processing the current exchange rate for the as-if currency. If left blank, the system date will be used.

B.2.11 R0018P8 - GST/PST Tax

The GST/ PST Tax report is specifically designed to meet Canadian reporting needs. For each address book number, the report lists GST and PST and subdivides PST into seller-assessed PST and self-assessed PST.

This report lists information by company and tax explanation code. Within each tax explanation code, the report separates taxes into categories such as taxable, nontaxable, GST, seller-assessed PST, and self-assessed PST.

Amounts for these fields are positive for vouchers and negative for invoices:

  • Taxable Amount

  • Non-Taxable

  • Tax

    This is the sum of GST, self-assessed PST, and seller-assessed PST.

  • GST

  • Self-Assessment Tax

    This is the total payable to provincial governments for self-assessed PST. A processing option enables you to display the amount with the sign reversed.

  • Sales Tax

    This is the total payable to provincial governments for seller-assessed PST.

B.2.12 Processing Options for GST/PST Tax (R0018P8)

Processing options enable you to specify the default processing for programs and reports.

B.2.12.1 Update Options

1. Detail Records

Enter a 1 to flag the detail records as having been printed.

B.2.12.2 Display

1. Tax Identification

1. Enter the form of tax identification displayed on the report.

Blank. No ID displayed

1. European Company ID

2. European Individual ID

3. Tax ID

2. Tax Amount

Enter a 1 to reverse the sign on the Self Assessment (Use) Taxes. If left blank, the tax amount will print with the sign in the tax file.

B.2.13 R00320 - VAT Journals

A common business practice throughout Europe is tracking and reconciling VAT by revenue and expense account.

You can track and reconcile VAT by revenue and expense account by classifying each transaction as taxable or nontaxable. You can also give various reasons for the classification of each transaction. The system stores the tax information for transactions in the F0018 table.

Run the VAT Journal program to print a VAT report. The report includes all of the records in the Taxes table that meet the data selections and processing option criteria.

The VAT Journals report (R00320) is a detailed transaction report for which you can specify up to five custom columns to represent up to twelve different tax rates and areas. You can also specify whether a column contains taxable amounts or tax amounts. You set up codes in the user-defined code (UDC) for VAT Journals (00/VJ) to represent the tax rate/areas that you want to print on the report (up to 5) and specify the column number (1 through 5) in the Special Handling field. Processing options enable you to specify the column heading text and to control whether the system prints tax or taxable amounts in the column.

For example, you might want taxable amounts for the New York tax rate/area in the first column, for the Ontario tax rate/area in the second column, for the Quebec tax rate/area in the third column, and so on.

You can print VAT reports to review the taxes on sales or the taxes on purchases. To specify taxes on sales or purchases, include the document type in the data selection. For example, to print a VAT report for purchases, specify Document Type PV.

You can sequence VAT reports by any field in table F0018. The most common report sequence is:

  1. Company

  2. Document Type

  3. Document Number

    Note:

    If you print a VAT report that includes multiple currencies, the system does not print a grand total. To see grand total amounts, print separate VAT reports by company for each currency.

B.2.14 Processing Options for VAT Journals (R00320)

Processing options enable you to specify the default processing for programs and reports.

B.2.14.1 Select

1. Beginning GL Date

Specify to select records from the F0018 table to print. The system selects all records with a GL date that is greater than or equal to the date specified.

2. Ending GL Date

Specify to select records from the F0018 table to print. The system selects all records with a GL date that is less than or equal to the date specified.

B.2.14.2 Print

1. Amount to Distribute

Specify whether the system prints the Taxable or Tax amount into the Tax Rate Area columns that appear on the report. Values are:

Blank: Print the tax amount

1: Print the taxable amount

2. Company for Heading and VAT Registration

Specify the company number for the system to use for the heading information and VAT registration number that prints on the report. The system does not use this information for selection criteria.

3. Summary or Detail

Specify whether to print pay items or line items in summary or detail. Values are:

Blank: Detail. Print each transaction pay item or line item.

1: Summary. Summarize and print the information by document number.

B.2.14.3 Columns

1. Column 1 Upper Heading and 2/ Column 1 Lower Heading

Specify the title for the upper portion or the lower portion of the first column heading. Each column has an upper and lower heading that you can define.

The system retrieves the amount based on the tax rate/area specified in UDC (00/VJ) that has a value in the Special Handling field which corresponds to the column number. For example, if the UDC value ONT has 1 in the Special Handling field, the system prints the amount for ONT in column 1 of the report.

3. Column 2 Upper Heading and 4. Column 2 Lower Heading

Specify the title for the upper portion or the lower portion of the second column heading. Each column has an upper and lower heading that you can define.

The system retrieves the amount based on the tax rate/area specified in UDC (00/VJ) that has a value in the Special Handling field which corresponds to the column number. For example, if the UDC value QUE has 2 in the Special Handling field, the system prints the amount for QUE in column 2 of the report.

5. Column 3 Upper Heading and 6. Column 3 Lower Heading

Specify the title for the upper portion or the lower portion of the third column heading. Each column has an upper and lower heading that you can define.

The system retrieves the amount based on the tax rate/area specified in UDC (00/VJ) that has a value in the Special Handling field which corresponds to the column number. For example, if the UDC value GMY has 3 in the Special Handling field, the system prints the amount for GMY in column 3 of the report.

7. Column 4 Upper Heading and 8. Column 4 Lower Heading

Specify the title for the upper portion or the lower portion of the fourth column heading. Each column has an upper and lower heading that you can define.

The system retrieves the amount based on the tax rate/area specified in UDC (00/VJ) that has a value in the Special Handling field which corresponds to the column number. For example, if the UDC value ITL has 4 in the Special Handling field, the system prints the amount for ITL in column 4 of the report.

9. Column 5 Upper Heading and 10. Column 5 Lower Heading

Specify the title for the upper portion or the lower portion of the fifth column heading. Each column has an upper and lower heading that you can define.

The system retrieves the amount based on the tax rate/area specified in UDC (00/VJ) that has a value in the Special Handling field which corresponds to the column number. For example, if the UDC value SPN has 5 in the Special Handling field, the system prints the amount for SPN in column 5 of the report.

B.2.14.4 Process

1. Calculate Gross Amount

Specify how the system calculates the gross amount that appears on the report, using the definition Gross = Goods + VAT. The system calculates the gross amount differently based on the tax explanation code that you entered for the transaction. For example, if the tax explanation code is VT (for tax only), the gross amount is equal to the tax amount. If the tax explanation code is V, the gross amount might be (taxable + nontaxable + tax), (taxable + tax), or nontaxable only, depending on the values entered. Values are:

Blank

The system calculates the gross amount as either (taxable + tax), or as nontaxable, whichever is applicable.

1

The system calculates the gross amount as (taxable + nontaxable + tax), if applicable.