(CHL and PER) Reporting Taxes

This chapter discusses how to:

(CHL and PER) Set up the IGV Purchase Ledger.
(PER) Print the 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

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

Understanding the IGV Purchase Ledger

Set up column numbers for taxes which will correspond to the Purchase subledger, for example, column 6 (IGV) and column 9 (Specific Tax).

If taxes are entered with a tax area with percentages and tax explanation code V or C, they are set up in P76H020. If taxes are entered with tax explanation code E, they must be set up in P76P030 with values from 4 to 9 in the Non Taxable field. Tax Explanation Code S considers the tax amount as a Non Taxable amount which can be set up for the columns 4 to 9.

Records are stored in F76H020 and F76P030.

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 menu (G76P00), Localization Information Tax Areas.	Set up tax buckets for the tax area taxes.
Work with taxable non taxable columns set up	W76P030B	Accounts Payable menu (G76P04), VAT Purchase Configuration.	Set up the taxable and non-taxable amounts of the tax area.

Setting Up the IGV Purchase Ledger

Access the Tax Buckets Setup 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 Review Taxable/Non Taxable Setup form.

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 by JD Edwards EnterpriseOne Accounts Payable, 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 F0018 table. This table is updated when the Tax tab from the R09801 program has value of 3in the first processing option.
The tax areas are set up as valued-added tax (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 for final mode. Leave blank for proof 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

Values are:

1. Printed documents.

2. Printed and non-printed documents.

Blank: Print documents which have not been printed yet.

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	Enter 1 to not print the report title. Leave blank to print the title.
Title	Specify the title if you left the previous processing option blank.
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. This report lists all vouchers entered by JD Edwards EnterpriseOne Accounts Payable which 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 for final mode. Leave blank for proof 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

Values are:

1. Printed documents.

2. Printed and non-printed documents.

Blank: Print documents which have not been printed yet.

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	Enter 1 to not print the report title. Leave blank to print the title.
Title	Specify the title if you left the previous processing option blank.
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 F0018 file.

(PER) Printing the PDT Purchase Report (R76P4200)

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

Print the PDT Purchase/Sale report.
Set processing options for Purchase PDT.

Understanding the PDT Purchase Report

This report prints the accumulated amounts of the documents issued by the supplier for a certain 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 program (P00710) 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 (P76H020) for the variable Purchase Ledger.

Printing the Purchase PDT Report

Select Accounts Payable (G76P04), Purchasing PDT.

Setting Processing Options for Purchase 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) 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) 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 process in Final Mode. Leave this field blank (default) to run in Proof 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. Enter 1 to display the documents in detail. Leave blank to print a summary.
Reprocessing	Enter 1 to record the transactions in the F76P420 file which are replaced with new data. If this processing option is left blank, the system adds the new processed records to the existing ones.

File Generation

The processing options 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 Text Processor Header (F007101) and Text Processor Detail (F007111) tables. You then use the Text File Processor program (P00710) to work with the flat file.

Delete Records

Enter 1 to delete the records existing in the file.

(PER) Printing the Sales PDT Report (R76P3B70)

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 program (P00710) 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 (R76P03B70).

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 (R76P3B40 and R76H3B40)

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 Ledger Report

The processing of this program 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.

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 JD Edwards EnterpriseOne Sales Order Management update the F76H218 table with the tax detail of the legal document.
In the case of invoices delivered by samples, Sales Update (R42800) must be run in order to not perform an update of customer’s accounts receivable, in such case this ICAS from JD Edwards EnterpriseOne Sales Order Management must be used instead of ICAS RCxxxx and RTxxxx:

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

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

See (CHL and PER) Setting Up Functionality for Chile and Peru.
Tax detail is obtained from F76H218 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 for final mode. Leave blank for proof mode. If you select final mode, the F76H3B10 is updated.
Legal Company	Specify the Legal Company.
Reprint	Values are: 1 or Y: Printed documents. 2: Printed and non-printed documents. Blank: Print documents which have not been printed yet.
Tickets	Enter 1 to print Tickets accumulated by date. Leave 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 not print the report title. Leave blank to print the title.
Title	Specify the title if you left the previous processing option blank.
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.