(CHL and PER) Reporting Taxes

This chapter discusses how to:

(CHL and PER) Set up the IGV Purchase Ledger.
(PER) Print the value-added tax (VAT) purchasing report.
(CHL) Print the VAT purchasing ledger.
(PER) Print the PDT purchase report.
(PER) Print the PDT sales report
(CHL and PER) Print the sales VAT report.

(CHL and PER) Setting Up the IGV Purchase Ledger Report

This section provides an overview of the columns for the IGV purchase ledger report and discusses how to set up the IGV Purchase Ledger report.

Understanding Columns for the IGV Purchase Ledger Report

You use the Localization Information Tax Areas (P76H020) program and the VAT Purchase Configuration (P76H030) program to set up column numbers for the IGV purchase ledger report. Use the Localization Information Tax Areas program to set up the columns for taxes that have a tax explanation code V or C. Use the VAT Purchase Configuration program to set up the columns for taxes that have a tax explanation code of E or S. Use columns 4–9 for tax explanation codes of E or S.

This table displays the suggested setup for the purchase ledger:

Concept	Column	Application
Taxable	1	P76P030
Taxable	2	P76P030
Taxable	3	P76P030
Non Taxable	4	P76P030
Specific Tax	5	P76H020
General Sales Tax	6	P76H020
General Sales Tax	7	P76H020
General Sales Tax	8	P76H020
Other Taxes	9	P76H020

Forms Used to Set Up the IGV Purchase Ledger

Form Name	FormID	Navigation	Usage
Work With Tax Buckets Columns set up	W76H020B	General Configuration (G76P00), Localization Information Tax Areas.	Review and select existing records.
Tax Buckets set up	W76H020B	Click Add on the Work With Tax Buckets Columns set up form.	Set up tax buckets for the tax area taxes.
Work with taxable non taxable columns set up	W76P030B	Accounts Payable (G76P04), VAT Purchase Configuration.	Review and select existing records.
Add taxable non taxable columns set up	W76P030C	Click Add on the Work with taxable non taxable columns set up form.	Set up the taxable and non-taxable amounts of the tax area.

Setting Up the IGV Purchase Ledger

Access the Tax Buckets set up form.

Tax Rate Bucket Number

Enter the tax area can be composed of a maximum of 5 tax rates.

Tax Rate

Enter a number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area. Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.

Invoice Print Tax Bucket Number

Enter the bucket number from the Invoice, where the tax amount should be accumulated when the document is printed. Valid bucket numbers are 1 through 5.

Invoice Purchasing Column Number

Enter the column number from the purchasing report, where the tax amount should be placed when the batch process is being executed. This tax amount is not the total voucher tax amount. It is the tax amount that is associated to the tax area bucket number. Valid column numbers are: 5 through 9. These are the numbers of the purchasing report where the amounts are placed.

Tax Sales Column Number

Enter the column number from the sales report, where the tax amount should be placed when the batch process is being executed. This tax amount is not the total voucher tax amount. It is the tax amount that is associated to the tax area bucket number. The allowed values are 1, 2 and 3.

Access the Add taxable non taxable columns set up form.

Tax Area

Enter the tax rate area for which you set up the columns.

Taxable Purchasing Column and Non Taxable Purchasing Column

Specify the column from the purchasing report where the voucher taxable amount or the voucher non taxable amount should be placed when the batch process is being executed.

Taxable Sales Column and Non Taxable Sales Column

Specify the column from the sales report where the invoice taxable amount or invoice non taxable amount should be placed when the batch process is being executed.

(PER) Printing the VAT Purchasing Report (R76P4500)

This section provides an overview of the VAT purchasing report for Peru, lists prerequisites, and discusses how to:

Print the VAT Purchasing Report.
Set processing options for VAT Purchasing Report (R76P4500).

Understanding the VAT Purchasing Report

The VAT Purchasing report should be run on a monthly basis. It is a legal requirement in Peru. This report lists all vouchers entered in the JD Edwards EnterpriseOne Accounts Payable system, with or without purchase orders, and with V, VT, E or S tax explanation code in a month period.

Vouchers must meet these conditions:

The vouchers must be posted in the Taxes (F0018) table. This table is updated when the Tax tab from the General Ledger Post (R09801) program has value of 3in the first processing option.
The tax areas are set up as VAT in the localization and they are not fee withholdings.

The report prints supplier and voucher information. The set up of the column heading and the related tax areas is user-defined. The report is ordered by invoice date and by legal company.

This program performs these validations:

There are no vouchers without tax detail in the F0018 table.
Vouchers have an assigned tax area.

Any processing errors are automatically generated in the VAT Purchasing Ledger Errors (R76P4501) report.

Data Selection

You should exclude the document types defined for vouchers generated for IGV withholding and SPOT vouchers, for example, IG and SP document types.

Prerequisites

Before you complete the tasks in this section:

Verify the localized setup of the tax areas for the tax area– tax pocket–report column relationship (P76P030).
Verify that all the vouchers are posted.

Printing the VAT Purchasing Report

Select Accounts Payable (G76P04), VAT Purchasing Report.

Setting Processing Options for VAT Purchasing Report (R76P4500)

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

General

Mode

Enter 1 to print the report in final mode. If you select final mode, only the next page number is updated. In final mode, all printed documents are stored in the F76P411T table.

Legal Company

Specify the Legal Company.

Reprint

Specify whether to print previously printed documents. Values are:

Blank: Print only documents which have not yet been printed .

1: Print only documents that have been printed.

2: Print and non-printed and previously printed documents.

Dates

From Date and Thru Date

Specify the from GL date or the thru GL date.

Document Type	Specify the document type to restore the next number as the page number. The next number is restored and updated only in final mode.
Print Title	Specify whether to print a report title. Values are: Blank: Print a title. 1: Suppress the report title.
Title	Specify the title if selected to print a title in the Print Title processing option.
Print Company	Enter 1 to omit company information in the report heading.

(CHL) Printing the VAT Purchasing Report (R76H4010)

This section provides an overview of the VAT purchasing report for Chile, lists prerequisites, and discusses how to:

Print the VAT Purchasing Report.
Set processing options for VAT Purchasing Report (R76H4010).

Understanding the VAT Purchasing Report

Issuing a monthly purchasing report is a legal requirement in Chile. To meet the requirement, run the VAT Purchasing Report (R76H4010) program monthly. This report lists all vouchers entered in the JD Edwards EnterpriseOne Accounts Payable system that meet these conditions:

The vouchers must be posted in the F0018 table.

This file is updated when the Tax tab from the R09801 posting program has value 3 in the first processing option.
The tax areas are set up as VAT in the localization, for example they are not fees withholdings.

The report is categorized by invoice date and prints these Amount columns:

Gross Amount

The sum of all the voucher lines (except from withholdings).
Non Taxable Amount

All entered vouchers are printed with tax explanation code E.
Taxable Amount.

The sum of the invoice taxable amount.
VAT Amount

The sum of the taxes calculated by the first pocket percentage of the tax areas.
Specific Tax Amount.

The sum of the taxes calculated by the pocket percentage 2 to 5 of the tax areas.

At the bottom part of the report, this additional information is displayed:

Non Reimbursable VAT Total.

The sum of all the vouchers which have non reimbursable tax areas defined in the tax area localized setup.
Number of Vouchers.
Number of Credit Notes.
Number of Exempt Documents.

Printing the VAT Purchasing Report

Select Accounts Payable (G76H04), VAT Purchasing Report.

Setting Processing Options for VAT Purchasing Report (R76H4010)

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

General

Mode

Enter 1 to run the report in final mode. If you select final mode, only the next page number is updated. In final mode, all printed documents are stored in F76P411T.

Legal Company

Specify the Legal Company.

Reprint

Specify whether to print previously printed documents. Values are:

Blank: Print only documents which have not yet been printed .

1: Print only documents that have been printed.

2: Print and non-printed and previously printed documents.

Dates

From Date and Thru Date

Specify the from GL date or the through GL date.

Document Type	Specify the document type to restore the next number as the page number. The next number is restored and updated only in final mode.
Print Title	Specify whether to print a report title. Values are: Blank: Print a title. 1: Suppress the report title.
Title	Specify the title if selected to print a title in the Print Title processing option.
Print Company	Enter 1 to omit company information in the report heading.
Check record existence	Enter 1 if you want to check the record existence in the F0018 table.

(PER) Printing the PDT Purchase Report

This section provides an overview of the PDT purchase report and discusses how to:

Print the Purchasing PDT report.
Set processing options for Purchasing PDT (R76P4200).

Understanding the PDT Purchase Report

This report prints the accumulated amounts of the documents issued by the supplier for a specified fiscal year. The system writes flat file data to the Text Processor Header (F007101) and Text Processor Detail (F007111) tables. You then use the Text File Processor (P00710) program to work with the data written to the F007101 and F007111 tables.

The amount to be reported is the difference between the gross amount of the document and the IGV amount. The IGV amount is the addition of the tax amounts that are defined as 4, 6, 7, and 8 in the columns set up in the Localization Information Tax Areas (P76H020) program.

Printing the Purchase PDT Report

Select Accounts Payable (G76P04), Purchasing PDT.

Setting Processing Options for Purchasing PDT (R76P4200)

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

Data Selection

Legal Company	Specify the number associated to the transaction company in the Company Master.
Year to Process	Specify the fiscal year of the transactions that will be selected to issue the report.

General

Father's Last Name and Mother's Last Name	Specify a UDC (01/W0) value used to search for the Father’s Last Name or the Mother's Last Name of the supplier in the Who's Who File. It is only applicable when individuals are reported.
Vendor First Name and Vendor Second Name	Specify a UDC (01/W0) value used to search for the supplier’s First Name or the suppliers Second Name in the Who's Who File. It is only applicable when individuals are reported.
Mode	Enter 1 to print the report in final mode. In final mode, the documents are reported as processed in the F76P411T file.
Minimal Amount	Specify the amount to be compared with the total amount of the operations for each supplier. Only those exceeding the minimum amount are reported.
Details	Specify whether to print a list of processed documents. Values are: Blank: Print a summary. 1: Print details.
Reprocessing	Enter 1 to record the transactions in the PDT Purchases (F76P420) table that are replaced with new data. If you leave this processing option blank, the system adds the new processed records to the existing ones.

File Generation

The processing option on this tab are no longer used. Instead of writing a text file to the path in these processing options, the system writes flat file data to the F007101 and F007111 tables. You then use the Text File Processor program to work with the flat file.

Delete Records

Enter 1 to delete the records existing in the file.

(PER) Printing the Sales PDT Report

The system writes flat file data to the F007101 and F007111 tables. You then use the Text File Processor program to work with the data written to the F007101 and F007111 tables.

This section discusses how to:

Print the PDT sales report.
Set processing options for Sales PDT (R76P3B70).

Printing the Sales PDT Report

Select Accounts Receivable (G76P03B), Sales PDT.

Setting Processing Options for Sales PDT (R76P3B70)

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

General

Legal Company	Enter a value that you set up in the Legal Company program (P76H010) to identify the company for which you run the report.
Century	Enter the two-digit calendar century associated with the year for which you run the report.
Fiscal Year	Enter the two-digit year for which you run the report.
Minimum Amount	Enter the minimum amount.
Mode	Enter 1 to run the report in final mode. If you leave this processing option blank, the system runs the report in proof mode.
Document Detail	Enter 1 to print details of the records. Leave this processing option blank to print a summary report.

Setup

Father's Name	Enter a value from the Type Code (01/W0) UDC table to specify the code that identifies the supplier's father's name. Complete this processing option only when the supplier is an individual.
Mother's Name	Enter a value from the Type Code (01/W0) UDC table to specify the code that identifies the supplier's mother's name. Complete this processing option only when the supplier is an individual.
Vendor First Name	Enter a value from the Type Code (01/W0) UDC table to specify the code that identifies the vendor's first name. Complete this processing option only when the supplier is an individual.
Vendor Middle Name	Enter a value from the Type Code (01/W0) UDC table to specify the code that identifies the vendor's middle name. Complete this processing option only when the supplier is an individual.

File Generation

Delete Records

Enter 1 to delete the records that currently exist for this report. The system deletes the records before processing the new report. If you leave this processing option blank, the system appends new records to the existing records.

(CHL and PER) Printing the Sales VAT Report

This section provides an overview of the Sales VAT report, lists a prerequisite, and discusses how to:

Print the Sales VAT report.
Set processing options for Sales VAT (R76P03B40 and R76H3B40).

Understanding the VAT Sales Report

When you run the Sales VAT report, the system runs these validations:

There are no legal numbers skips for the selected range date in the processing options.
There are no invoices without tax detail in the F0018 table.
Invoices have a valid tax area.
The first legal number of the month is correlative with the last legal number used in the previous month's execution.
Invoices are printed.

If there are errors while processing this report, the Error Sales VAT Report (R76H3B41) is automatically generated.

Taxing Samples

Sampling, or free merchandising delivery to customers, is taxed with VAT tax. These deliveries involve an invoice issue for the delivered merchandise and must be included in VAT Sales legal book.

This functionality was added in order to facilitate the user the sampling management:

Invoices or tickets issued from the JD Edwards EnterpriseOne Sales Order Management system update the Taxes by Sales Order Line (F76H218) table with the tax detail of the legal document.
In the case of invoices delivered by samples, you must run the Sales Update (R42800) program to suppress an update of the customer’s accounts receivable records. In such case, use these AAI from the JD Edwards EnterpriseOne Sales Order Management system instead of AAIs RCxxxx and RTxxxx:

AAI 4245 Accounts Receivable Trade will be used to replace AAI RCxxxx.

AAI 4250 Tax Liability will be used to replace AAI RTxxxx.

See (CHL and PER) Setting Up Functionality for Chile and Peru.
Tax detail is obtained from the F76H218 table for sampling.

Prerequisite

Verify that all invoices are posted and printed.

Printing the VAT Sales Ledger

For Peru, select Accounts Receivable (G76P03B), Sales VAT.

For Chile, select Accounts Receivable (G76H03B), Sales VAT.

Setting Processing Options for VAT Sales Ledger (R76P3B40) and (R76H03B40)

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

General

Mode	Enter 1 to print the report in final mode. If you select final mode, the system updates the F76H3B10 table.
Legal Company	Specify the Legal Company.
Reprint	Specify whether to print previously printed documents. Values are: Blank: Print only documents which have not yet been printed . 1: Print only documents that have been printed. 2: Print and non-printed and previously printed documents.
Tickets	Enter 1 to print Tickets accumulated by date. Leave this processing option blank to print all details

Dates

From Date	Specify the from GL date.
Thru Date	Specify the thru GL date.
Dates	Enter 1 to select invoices according to the Invoice Date. Leave this processing option blank (default) to select according to the GL Date.

Document Type	Specify the document type to restore the next number as the page number. The next number is restored and updated only in final mode.
Print Title	Enter 1 to suppress printing of a report title.
Title	Specify the title for the report is you selected to print the title.
Print Company	Enter 1 to omit company information in the report heading.
Enter 1 to generate saving on magnetic device	Future use.

Tax Rate Bucket Number	Enter the tax area can be composed of a maximum of 5 tax rates.
Tax Rate	Enter a number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area. Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
Invoice Print Tax Bucket Number	Enter the bucket number from the Invoice, where the tax amount should be accumulated when the document is printed. Valid bucket numbers are 1 through 5.
Invoice Purchasing Column Number	Enter the column number from the purchasing report, where the tax amount should be placed when the batch process is being executed. This tax amount is not the total voucher tax amount. It is the tax amount that is associated to the tax area bucket number. Valid column numbers are: 5 through 9. These are the numbers of the purchasing report where the amounts are placed.
Tax Sales Column Number	Enter the column number from the sales report, where the tax amount should be placed when the batch process is being executed. This tax amount is not the total voucher tax amount. It is the tax amount that is associated to the tax area bucket number. The allowed values are 1, 2 and 3.

Tax Area	Enter the tax rate area for which you set up the columns.
Taxable Purchasing Column and Non Taxable Purchasing Column	Specify the column from the purchasing report where the voucher taxable amount or the voucher non taxable amount should be placed when the batch process is being executed.
Taxable Sales Column and Non Taxable Sales Column	Specify the column from the sales report where the invoice taxable amount or invoice non taxable amount should be placed when the batch process is being executed.