Printing the IGV Purchase Ledger (R76P4500)

The IGV Purchase Ledger report layout is in the format prescribed by Peruvian legal reporting requirements. When you run the R76P4500 program, the system generates the IGV Purchase Ledger report in PDF, CSV (R76P4504 report), and text file formats. The system prints two flat files, one each for resident and non-resident.

The following table lists the column names and descriptions for resident and non-resident records when the output type processing option is left blank. This is an example of the PDF report layout.

Column Name	Explanation
Correlative Number	Next number you set up by processing option.
Payment Date	Retrieved from the F0411 table (field DIVJ).
Due Date	Retrieved from the F0411 table (field DDJ).
Type	Retrieved from UDC table 76P/DT.
Serial Number	In the case of domestic vouchers, it is retrieved from F0411 table (serial number from field VINV). In the case of import voucher, the system uses the custom code retrieved from F76P411T (category code defined by PO).
DUA/DSI	DUA/DSI issue year. Defined by processing option.
Number	Vendor invoice number without serial number, retrieved from F0411.
Vendor information	This section includes vendor's document type (from UDC table 76H/DA), document number, and name. Retrieved from F76P101T table.
Op Grav Base Amount	Retrieved from P76P030, column 1.
Op Grav IGV	Retrieved from P76H020, column 6.
Op Grav y no Grav Base Amount	Retrieved from P76P030, column 1.
Op Grav y no Grav IGV	Retrieved from P76H020, column 7.
Op no Grav Base Amount	Retrieved from P76P030, column 1.
Op no Grav IGV	Retrieved from P76H020, column 8.
Value Adq no G	Retrieved from P76H020, column 2.
ISC	Retrieved from P76H020, column 5.
Other	Retrieved from P76H020, column 9.
Total	Retrieved from the F0411 table (AG field).
Payment receipt	Retrieved from the F0411 table (VINV field), only in the case of transactions related with services. You specify this transaction type in UDC table 76P/OT (special handling code 1).
Deduction number	Retrieved from the F76P480 table (P76SPDN field).
Deduction date	Retrieved from the F76P480 table (P76SPDD field).
Exchange Rate	Retrieved from the F0411 table (CRR field).
Date	Original document date, retrieved from F0411 (for credit or debit notes).
Type	Original document type, retrieved from F0411 (for credit or debit notes).
Number	Original document number, retrieved from F0411 (for credit or debit notes).

The following table describes the PDF report layout generated for the resident records when the Output Type processing option is set to 1.

Column Name	Explanation
Document Type	Retrieved from the F0411 table (field DCT).
Document Number	Retrieved from the F0411 table (field DOC).
Period	From Date you set up in the processing option.
CUO Record Key	Unique Key generated using the combination of Document Number and Document Type in Correlative Number.
Type Document	Correlative Number generated using Next number set in processing option or Document Type and Document Number depending up on Processing option.
Invoice Date	Retrieved from the F0411 table (field DIVJ).
Due Date	Retrieved from the F0411 table (field DDJ).
Record Type	Retrieved from UDC table 76P/DT.
DUA Series	In the case of domestic vouchers, it is retrieved from F0411 table (serial number from field VINV). In the case of import voucher, the system uses the custom code retrieved from F76P411T (category code defined by PO).
DUA/DSI Year	DUA/DSI issue year. Defined by processing option.
Payment Number	Vendor invoice number without serial number, retrieved from F0411.
Originator Id	Vendor's document type (from UDC table 76H/DA) retrieved from F76P101T table.
RUC Number	Supplier TaxID retrieved from the F0101 table (field TAX).
Mailing Name	Supplier TaxID retrieved from the F0101 table (field ALPH).
Export Write Amount Basis	Retrieved from P76P030, column 1.
Export Write Tax Basis	Retrieved from P76H020, column 6.
Export Non Write Amount Basis	Retrieved from P76P030, column 1.
Export Non Write Tax Basis	Retrieved from P76H020, column 7.
Export Credit Amount Basis	Retrieved from P76P030, column 1.
Export Credit Tax Amount	Retrieved from P76H020, column 8.
Acquired Amount	Retrieved from P76H020, column 2.
Deducted Amount Basis	Retrieved from P76H020, column 5.
Other Amounts	Retrieved from P76H020, column 9.
Acquired Paid Amount Total	Retrieved from the F0411 table (AG field).

The following table describes the PDF report layout generated for the non-resident records when the Output Type processing option is set to 2.

Column Name	Explanation
Document Type	Retrieved from the F0411 table (field DCT).
Document Number	Retrieved from the F0411 table (field DOC).
Period	From Date you set up in the processing option.
CUO Record Key	Unique Key generated using the combination of Document Number and Document Type in Correlative Number.
Type Document	Correlative Number generated using Next number set in processing option or Document Type and Document Number depending up on Processing option.
Invoice Date	Retrieved from the F0411 table (field DIVJ).
Payment Type	Retrieved from UDC table 76P/DT.
Payment Series	In the case of domestic vouchers, it is retrieved from F0411 table (serial number from field VINV). In the case of import voucher, the system uses the custom code retrieved from F76P411T (category code defined by PO).
Payment Number	Vendor invoice number without serial number, retrieved from F0411.
Acquired Amount	Retrieved from the F0411 table (AG field).
Acquired Amount Total	Retrieved from the F0411 table (AG field).
DUA/DSI Year	DUA/DSI issue year. Defined by processing option.
Currency Code	Retrieved from the F0411 table (field CRCD).
Exchange Rate	Retrieved from the F0411 table (field CRR).
Supplier Country Code	Retrieved from UDC Table 76P/CT.
Supplier Mailing Name	Supplier Name retrieved from the F0101 table (field ALPH).
Supplier ID Number	Supplier TaxID retrieved from the F0101 table (field TAX).
Payor ID Number	Supplier TaxID retrieved from the F0101 table (field TAX).
Alternate Mailing Name	Supplier Name retrieved from the F0101 table (field ALPH).

The following table describes the format of the text file generated by the R76P4500 report for residents:

Number	Length	Description	Type
1	8	Financial period (in the YYYYMM00 format).	Numeric
2	up to 40	Serial number of the month or Single Operation Code (CUO). CUO is the unique key or primary key accounting software that uniquely identifies the key or accounting entry.	Text
3	2 to 10	Correlative number of accounting entries identified in Field 2 when CUO is used. The first character should be A, M, or C.	Alphanumeric
4	10	Date of issue of the payment receipt or document.	DD/MM/YYYY
5	10	Expiration Date or Payment Date.	DD/MM/YYYY
6	2	Type of pay stub or document.	Numeric
7	Up to 20	Series proof of payment or document.	Alphanumeric
8	4	Year of issuance of the DUA or DSI.	Numeric
9	Up to 20	Number of proof of payment or document.	Alphanumeric
10	Up to 20	Blank	Numeric
11	1	This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank.	Alphanumeric
12	Up to 15	Supplier RUC number or identity document number, as appropriate.	Alphanumeric
13	Up to 100	Supplier/vendor name.	Text
14	12 integers and up to 2 decimals, without commas of thousands	Taxable amount of taxable inputs entitling tax credit and/or export credit balance, intended exclusively for taxable transactions and/or export.	Numeric
15	12 integers and up to 2 decimals, without commas of thousands	Amount of General Sales Tax and/or Municipal Promotion Tax.	Numeric
16	12 integers and up to 2 decimals, without commas of thousands	Taxable amount of taxable inputs entitling tax credit and/or export credit balance, aimed at taxable and/or export operations and untaxed operations.	Numeric
17	12 integers and up to 2 decimals, without commas of thousands	Amount of General Sales Tax and/or Municipal Promotion Tax.	Numeric
18	12 integers and up to 2 decimals, without commas of thousands	Taxable amount of taxable inputs that are not entitled to tax credit and/or export credit balance, not to be intended for taxable transactions and/or export.	Numeric
19	12 integers and up to 2 decimals, without commas of thousands	Amount of General Sales Tax and/or Municipal Promotion Tax.	Numeric
20	12 integers and up to 2 decimals, without commas of thousands	Value of acquisitions untaxed.	Numeric
21	12 integers and up to 2 decimals, without commas of thousands	Amount of Excise Tax in cases where the subject can use it as a deduction.	Numeric
22	12 integers and up to 2 decimals, without commas of thousands	Other items, taxes, and charges that are not part of the tax base.	Numeric
23	12 integers and up to 2 decimals, without commas of thousands	Total amount of purchases registered as proof of payment.	Numeric
24	3	This field is not populated in the report.	Alphanumeric
25	1 and 3 decimal integer	Exchange.	Numeric
26	10	Date of issue of the payment receipt.	DD/MM/YYYY
27	2	Proof of payment type.	Numeric
28	Up to 20	Serial number of the payment receipt.	Alphanumeric
29	3	This field is not populated in the report.	Alphanumeric
30	Up to 20	Number of proof of payment.	Alphanumeric
31	10	Date of the Certificate of Deposit Decrease.	DD/MM/YYYY
32	Up to 24	Number of the Certificate of Deposit Decrease.	Alphanumeric
33	1	This field is not populated in the report.	Numeric
34	1	This field is not populated in the report.	Text
35	12	This field is not populated in the report.	Text
36-39	1	These fields are not populated in the report.	Alphanumeric
40	1	Indicator of Payment Receipts Canceled with Payment Methods.	Numeric
41	1	State identifies an opportunity annotation or indication if it corresponds to a setting.	Numeric
42	Up to 200	Free use fields.	Text

The following table describes the format of the text file generated by the R76P4500 report for non-residents:

Number	Length	Description	Type
1	8	Financial period (in the YYYYMM00 format).	Numeric
2	up to 40	Serial number of the month or Single Operation Code (CUO). CUO is the unique key or primary key accounting software that uniquely identifies the key or accounting entry.	Text
3	2 to 10	Correlative number of accounting entries identified in Field 2 when the Single Operation Code (CUO) is used. The first character should be A, M, or C.	Alphanumeric
4	10	Date of issue of the payment receipt or document.	DD/MM/YYYY
5	2	Pay stub or document type.	Alphanumeric
6	Up to 20	This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank.	Alphanumeric
7	Up to 20	Payment voucher number.	Alphanumeric
8	12 integers and up to 2 decimals, without commas of thousands	These fields are not populated in the report if the Select Output Type Processing option under the Report tab is set to blank.	Numeric
9	12 integers and up to 2 decimals, without commas of thousands	These fields are not populated in the report.	Numeric
10	12 integers and up to 2 decimals, without commas of thousands	This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank.	Numeric
11	2	This field is not populated in the report.	Numeric
12	Up to 20	This field is not populated in the report.	Alphanumeric
13	4	This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank.	Numeric
14	Up to 20	This field is not populated in the report.	Alphanumeric
15	12 integers and up to 2 decimals, without commas of thousands	This field is not populated in the report.	Numeric
16	3	Code Currency (Table 4).	Alphanumeric
17	1 and 3-decimal integer	This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank.
18	4	Country of residence of the non-resident subject.	Alphanumeric
19	Up to 100	Supplier/vendor name.	Text
20	Up to 100	This field is not populated in the report.	Text
21	Up to 15	Identification number of the non-resident subject.	Text
22	Up to 15	This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank.	Text
23	Up to 100	This field is not populated in the report if the Select Output Type Processing option under the Report tab is set to blank.	Text
24	4	This field is not populated in the report.	Alphanumeric
25	2	This field is not populated in the report.	Alphanumeric
26-30	12 integers and up to 2 decimals, without commas of thousands	These fields are not populated in the report.	Numeric
31	2	Agreements to avoid double taxation.	Numeric
32	1	This field is not populated in the report.	Numeric
33	2	Type of income.	Numeric
34-35	1	These fields are not populated in the report.	Numeric
36	1	State identifies an opportunity annotation or indication if it corresponds to a setting.	Numeric
37	Up to 200	Free use fields.	Text