30 Using Additional Reports in India

This chapter contains the following topics:

30.1 Reports for India

In addition to the reports specified as part of a process in other sections of this implementation guide, the reports exist for India for these tax types:

  • Excise

  • Service

  • Value-added tax (VAT)

  • Sales

  • Purchase

  • Tax collected at source (TCS)

  • Tax deducted at source (TDS)

  • Work contract tax (WCT)

30.1.1 India Reports for Excise Tax

These reports exist for India for excise tax:

Report ID and Report Name Description Navigation
Excise Manufacturer - Deferred CENVAT (R75I304) Run this report to print tax-deferred information. This report also enables you to review the deferred tax amount.

This report reads from the Purchase Order Receiver File table (F43121) and the Purchase Order Receiver Tag table (F75I008).

Reports (G75IEXC7), Excise Manufacturer - Deferred CENVAT
Dealer - RG23D Register (R75I307) Run this report to review information about the association between purchase receipts and sales orders. The system prints information for the item based on the branch/plant, location, lot number, and tax type.

This report reads from the Purchase Order Receiver Tag table (F75I008), Purchase Order Receiver File (F43121), and the RG23D Register - Issues (F75I385) tables.

RG23D (G75IEXC5H), Dealer - RG23D Register
Annexure 19 (R75I319) Run this report to print the Annexure- 19 that you must submit to the Central Excise department.

This report reads from the Print ARE -1/ARE -3 Bond register table (F75I344Y).

Reports (G75IEXC7), Annexure 19
Record of Receipts of Inputs under Bond (R75I323) Run this report to print information about the item receipts for 100 percent export-oriented units and ARE 3 receipts.

This report reads from the Purchase Order Receiver File (F43121), Purchase Order Receiver ARE3 Information (F75I323), and Purchase Order Receiver Tag File (F75I008) tables.

Excise daily processing (G75IEXC1H), Record of Receipts of Inputs under Bond
Print ARE1 Exception Report (R75I344) Run this report to print the nonstatutory ARE 1 document.

This report reads from the Print ARE-1/ARE-3 Bond Register table (F75I344Y).

Reports (G75IEXC7), Print ARE1 Exception Report
Print ARE1 Bond/LOU Master (R75I344S) Run this report to review the ARE 1 bond or LOU (letter of understanding) details for an excise unit.

This report reads from the Print ARE-1/ARE-3 Bond Register table (F75I344Y).

Reports (G75IEXC7), Print ARE1 Bond/LOU Master
Print ARE3 Exception Report (R75I345) Run this report to print the nonstatutory ARE 3 document.

This report reads from the Excise - ARE3 Form Header table (F75I345).

Reports (G75IEXC7), Print ARE3 Exception Report
Print ARE3 CT2/CT3/Annexure (R75I345A) Run this report to print a consolidated report for all CT2, CT3, or Annexure transactions for ARE 3.

This report reads from the Certificate Master table (F75I345Y).

Reports (G75IEXC7), Print ARE3 CT2/CT3/Annexure
Print Unclaimed CENVAT Report (R75I351S) Run this report to print a list of purchase order records with unclaimed central value-added tax (CENVAT) for a specific period for the selected business units.

This report reads from the Purchase Order Receiver File (F43121) and Excise - Cross Reference File (F75I304) tables.

Reports (G75IEXC7), print Unclaimed CENVAT Report
Overdue Consignment (R75I352) Run this report to review the consignments that are older than 180 days.

Note: Consignments older than 180 days are considered as a sale and are liable to tax.

This report reads from the Excise - Consignment/Adjustment Detail File - ItemWise table (F75I312).

Reports (G75IEXC7), Overdue Consignment
Print PLA Form (R75I383) Run this report to print the Annexure 8 that you must submit to the Central Excise department. This report is a statutory requirement.

This report reads from the Excise - PLA Chapter Wise Transaction File for Yarn Industry (F75I315Y) and Excise - MODVAT / PLA Summary File YARN SPECIFIC (F75I310Y) tables.

Reports (G75IEXC7), Print PLA Form
Record Uncaptured RG-1 From Item Card (R75I387) Run this report to print the RG1 records in the Item Ledger File table (F4111) that were not included during the RG1 build. This report also prints the reason for the omission of the records.

You must run the RG-1 Build report (R75I380) to upload the RG1 details to the Excise RG1 Transaction table (F75I380) before you run the Record Uncaptured RG-1 From Item Card report (R75I387).

This report reads from the Item Ledger File (F4111), Excise RG1 transaction File (F75I380), and Excise Cross Reference File (F75I304) tables.

Reports (G75IEXC7), Record not captured from RG-1 Item Card
Excise Return Master (R75I390) Use this program to print any of these reports:
  • ER-1 (monthly)

  • ER-3 (quarterly)

  • ER-5 (annual)

  • ER-6 (monthly)

You set processing options to specify the report and the time period for the report.

This report reads from the Tax Registration Details table (F75I210).

Reports (G75IEXC7), Excise Return Master
Annexure 10 (R75I392) Run this report to review the purchase order details for raw materials and capital goods.

This report reads from the Excise - MODVAT / PLA Summary (F75I310Y), Excise - RG23A-II Chapter Wise Transaction (F75I313Y), and Excise - RG23C-II Chapter Wise Transaction File (F75I317Y) tables.

Reports (G75IEXC7), Annexure 10
ER-5 (R75I395) Run this report to print the details of the type and quantity of principal inputs used in the manufacture of the finished goods. This report is printed annually.

You run this report by setting a processing option and running the Excise Master Report program. Use the Batch Versions program to set the processing options for the ER-5 program before you print the report from the Excise Return Master program.

This report reads from the Bill of Material Master File (F3002), Item Cost File (F4105), Work Order Master File (F4801), Work Order Master Tag File (F4801T), Excise - Cross Reference File (F75I304), ER-5 (1) (F75I395A), ER-5 (2) (F75I395B), and ER-5 (temp) (F75I395T) tables.

Reports (G75IEXC7), Excise Return Master
ER-6 (R75I396) Run this report to print the details of the principal inputs used in the manufacture of the finished goods and the quantity of goods manufactured. This report is printed monthly.

You run this report by setting a processing option and running the Excise Return Master program. Use the Batch Versions program to set the processing options for the ER-6 program before you print the report from the Excise Return Master program.

This report reads from the Bill of Material Master File (F3002), Work Order Parts List (F3111), Item Cost File (F4105), Item Ledger File (F4111), Work Order Master File (F4801), Work Order Master Tag File (F4801T), Excise - Cross Reference File (F75I304), ER-6 - List of Finished goods manufactured (F75I396A), ER-6 (F75I396B), and ER-6 Temp (F75I396T) tables.

Reports (G75IEXC7), Excise Return Master
Print 57F(4) Challan (R75I3906) Run this report to print the details of raw materials sent to the supplier for processing.

This report reads the details from the Consignment Header table (F75I357), and reads and updates from the Work With Consignment - Ind - 43 table (F75I3901).

Subcontracting process (G75I57F4), Print 57F(4) Challan
Print 57F4 Register (R75I3907) Run this report to print the material issued to and received from the processor with the consignment number.

This report reads the details from the Work With Consignment - Ind - 43 table (F75I3901).

Subcontracting process (G75I57F4), Print 57F4 Register
Print Sub Contract Challan (R75I3908) Run this report to display the details of raw materials sent to the supplier for processing.

This report reads the details from the Purchase Order Detail File (F4311) and Consignment Header (F75I357) tables, and reads from and updates the Work With Consignment - Ind - 43 table (F75I3901).

Subcontracting process (G75I57F4), Print Sub Contract Challan

30.1.2 India Reports for Service Tax

These reports exist for India for service tax:

Report ID and Report Name Description Navigation
Service Tax Credit Detail (R75I450) Run this report to print detailed information about the tax credits for service taxes.

This report reads from the Account Payable Matching Document table (F0413), Account Payable Matching Document Detail table (F0414), Service Tax A/P File table (F57I741), and Service Tax Payment File table (F57I744).

Periodic Processing (G75ISVT2), Service Tax Credit Detail
Credit Distribution (R75I720) This report prints the distribution transactions that generate the CENVAT credit. You must group the data by the operating unit, tax type, and service tax category before you run this report.

This report reads from the Credit Distribution table (F75I013).

Reports (G75IEXC7), Credit Distribution

30.1.3 India Reports for VAT

These reports exist for India for VAT:

Report ID and Report Name Description Navigation
Stock Transfer Details (R75I213) Run this report to print stock transfer transactions by business unit.

This report reads from the Stock Transfer Details table (F75I403) and the Sales Order History File (F42119).

Sales Tax (G75I2221), Stock Transfer Details
VAT -O2C - Detail/Summary Report (R75I2212) Run this report to print lists of the sales orders for which VAT is applicable for a specific date range.

This report reads from the Sales Order History table (F42119) and Sales Form Information table (F75I401).

Sales Tax (G75I2221), VAT -O2C - Detail/Summary Report
VAT - Setoff Report - Unregistered Customers (R75I2213R) Run this report to print the offset details for VAT for the sales and purchase transactions for all unregistered customers. This report lists information for each business unit by tax type and document number.

Note: You offset the VAT payable on sales with the VAT paid on purchases and, therefore, pay VAT only on the value-added portions.

This report reads from the Setoff Temp table (F75I2213), Sales Form Information table (F75I401), and the Purchase Tax Form Details table (F75I402), and writes to the Setoff Temp table (F75I2213).

Sales Tax (G75I2221), VAT - Setoff Report - Unregistered Customers
Customer / Supplier Registration Number (R75I2217) Run this report to print the registration numbers for customers and suppliers.

This report reads from the Tax Registration Details table (F75I210).

Sales Tax (G75I2221), Customer / Supplier Registration Number
Reversed Sale Orders Detail (R75I2218) Run this report to list sales orders that were created and later reversed.

This report reads from the Sales Form Information table (F75I401).

Sales Tax (G75I2221), Reversed Sale Orders Detail
Exempted Item Details for Sales (R75I2219) Run this report to print the sales and invoice details for items that are exempted from VAT. You run this report for a specific business unit and state.

This report reads from the Sales Order Detail table (F4211) or Sales Order History table (F42119) and the State / Branch Plant Cross Reference table (F75I406).

Sales Tax (G75I2221), Exempted Item Details for Sales
Trading Item Sales (R75I2221) Run this report to print the total sales amount of the trading transactions. These transactions do not involve VAT.

This report reads from the Item Branch File (F4102) and the Sales Order Detail table (F4211).

Sales Tax (G75I2221), Trading Item Sales
Void Voucher Report (R75I2222) Run this report to print voided transactions, including the total voided amounts.

This report reads from the Purchase Tax Form Details table (F75I402).

Purchase tax (G75I2222), Void Voucher Report
VAT -Purchase Tax Summary / Details (R75I2231) Run this report to print purchase orders in summary or detail format for companies and business units for a specific date range.

This report reads from the Purchase Order Receiver table (F43121).

Purchase tax (G75I2222), VAT -Purchase Tax Summary / Details
Reversed Purchase Orders Details (R75I2236) Run this report to list purchase orders for which you have reversed the vouchers. The report shows purchase orders with a Match Type of 3 in the F43121 table.

This report reads from the Purchase Tax Form Details table (F75I402) and Purchase Order Receiver table (F43121).

Purchase tax (G75I2222), Reversed Purchase Orders Details
Exempted Items Details (R75I2237) Run this report to print exempted items and voucher amounts for a specific business unit and state.

This report reads from the Purchase Order Receiver File table (F43121) and the State / Branch Plant Cross Reference table (F75I406).

Purchase tax (G75I2222), Exempted Items Details
Purchase against Trading Items (R75I2240) Run this report to print the purchase details of the trading items.

This report reads from the Purchase Order Receiver table (F43121) and the State / Branch Plant Cross Reference table (F75I406).

Purchase tax (G75I2222), Purchase against Trading Items
Reconciliation Report - VAT/CST Receivables (R75I2242) Run this report to compare the VAT amount in localization tables to the tax amounts written to the general ledger accounts for VAT and Central Sales Tax (CST).

This report reads from the Account Ledger table (F0911), WorkFile for VAT/CST Receivables table (F75I2241), and Sales Form Information table (F75I401).

Sales Tax (G75I2221), Reconciliation Report - VAT/CST Receivables

30.1.4 India Reports for Sales Tax

These reports exist for India for sales tax:

Report ID and Report Name Description Navigation
Sales Tax - Concessional Form Status (With Form Code) (R75I4214) Run this report to print the details of the invoices received with concession forms or received without concession forms, for the selected business unit. You use this report to produce a list of the customers from whom you have not received the concession forms so that you can send a reminder that the form is due.

This report prints only those invoices that contain the sales tax component.

Note: Select a value in the Form Type processing option to print the details of the invoices received with the specified concession forms. If you leave the Form Type processing option blank, the system prints the details of those invoices for which you have not received the concession forms.

This report reads from the Business Unit Master table (F0006) and Sales Form Information table (F75I401).

Sales Tax Reports (G75I421), Sales Tax - Concessional Form Status (With Form Code)
Sales Register (R75I4220) Run this report to print a list of invoices with details of the adjustment types and sales taxes that are applicable to all the business units.

This report reads from the Business Unit Master table (F0006), Price Adjustment Ledger File table (F4074), and the Sales Order History table (F42119).

The navigations for this program are:
  • Sales Tax Reports (G75I421), Sales Register

  • Sales Tax Reports (G75I422), Sales Register

Sales Tax Summary/Detail (R75I4223) Run this report to print the summary or details of the sales taxes that are applicable to the business units.

Note: Set the processing option to select either the summary report or the detail report.

This report reads from the Business Unit Master table (F0006), Sales Order History table (F42119), and the Sales Tax Summary/Detail table (F75I4223).

Sales Tax (G75I2221), Sales Tax Summary/Detail

30.1.5 India Reports for Purchase Tax

These reports exist for India for purchase tax:

Report ID and Report Name Description Navigation
Print Purchase Orders (R43500) Run this report to print a new purchase order. When you run this report for India, the system also runs the Loc. Purchase Order Print - IN report (R75I010) to print the layout with the specific tax registration numbers associated with the company and the corresponding taxes (landed cost components for each purchased item).

This report reads from the Purchase Order Header table (F4301), Purchase Order Detail table (F4311), and P.O. Detail Ledger - Flexible Version table (F43199).

Purchase Order Processing (G43A11), Print Purchase Orders
Loc. Purchase Order Print - IN (R75I010) The system runs this program when you run the Print Purchase Order program for India.

This report reads from the Tax Work table (F40UI00T), PO Print Detail Work table (F43UI50D), and PO Print Header Work table (F43UI50H).

The system runs the Loc. Purchase Order Print - IN program when you run the Print Purchase Order program.
Purchase Tax Exception Report (R75I4232) Run this report to compare the purchase order records in the Purchase Tax Form Details table (F75I402) to the reversed or deleted voucher records in the Purchase Order Receiver File table (F43121). The system identifies records with a status of 3 in the Match Type field in the F43121 table as reversed or deleted voucher records.

Note: Run the report in proof mode to print a list of the purchase order records that exist in the F75I402 table for which the corresponding voucher in the F43121 table is reversed or deleted. Run this report in final mode to delete the purchase order records in the F75I402 table for which the voucher was reversed or deleted.

This report reads from the F75I402 table.

Purchase tax reports (G75I423), Purchase Tax Exception Report
Vouchers for which Form issued (R75I4233) Run this report to print a summary of vouchers for which forms are issued.

This report reads from the Business Unit Master table (F0006) and the Purchase Tax Form Details table (F75I402).

Purchase tax reports (G75I423), Vouchers for which Form issued
Forms outstanding - Detail (R75I4234) Run this report to print a summary of the vouchers with pending forms.

This report reads from the Business Unit Master table (F0006) and the Purchase Tax Form Details table (F75I402).

Purchase tax reports (G75I423), Forms outstanding - Detail

30.1.6 India Reports for TCS

These reports exist for India for TCS:

Report ID and Report Name Description Navigation
Form 27D- Certificate for collection of TCS (R75I627) Run this report to generate the Form 27D after you have paid tax to the tax authority. You can generate this report for one specific record or for a selected set of records for a period. Generate this report for the customers who purchase goods with TCS.

This report reads from the TCS Prepayment to Tax authority (F75I612) and TCS Payment Details (F75I604) tables.

The navigations for this report are:
  • Tax Collected At Source (G75ITCS), Form 27D- Certificate for collection of TCS

  • Periodic Processing (2/G75ITCS), Form 27D- Certificate for collection of TCS

Annual Return of TCS (R75I628) Run this report to print the statutory form (Form 27E) and a flat file in an ASCII format.

The flat file contains all of the information that exists in the report but is in the format prescribed by the government, so that you can run it through the File Validation Utility (FVU) application. This application is owned by the government and validates the e-TCS report submitted by you. Oracle does not provide the FVU application.

Submit Form 27E as the annual return of the tax collected by the seller.

Form 27E displays the details of the TCS collected from the buyer and paid to the tax authority.

This report reads from the TCS Details table (F75I604) and the TCS Prepayment to Tax Authority table (F75I612).

Periodic Processing (2/G75ITCS), Annual Return of TCS
Form 27EQ - Quarterly Return of TCS (R75I629) Run this report to print the statutory form (Form 27EQ) and a flat file in an ASCII format.

The flat file contains all of the information that exists in the report but is in the format prescribed by the government so that you can run it through the File Validation Utility (FVU) application. This application is owned by the government and validates the e-TCS report submitted by you. Oracle does not provide the FVU application.

This form is used to submit the quarterly returns for the tax collected by the seller.

Form 27EQ displays the TCS collected and paid to the tax authority.

This report reads from the TCS Details table (F75I604) and the TCS Prepayment to Tax Authority table (F75I612).

Periodic Processing (2/G75ITCS), Form 27EQ - Quarterly Return of TCS
Form 27B - Summery of Annual eTCS Return (R75I630) Run this report to print the statutory form, Form 27B. Form 27B is a summary of the e-TCS return (Form 27E) that contains the details of the amount paid and the income tax collected at the source. You must submit Form 27B to the tax authorities on an annual basis to report the tax collected by the seller. You must separately submit a Form 27B for each TCS return (Form 27E) that you file.

This report reads from the TCS Details table (F75I604) and the TCS Prepayment to Tax Authority table (F75I612).

Periodic Processing (2/G75ITCS), Form 27B - Summery of Annual eTCS Return

30.1.7 India Reports for TDS

These reports exist for India for TDS:

Report ID and Report Name Description Navigation
TDS Statement (R75I102) Run this report to determine the TDS amount and surcharge amount to be paid to the tax authorities.

This report reads from the TDS Certificate Master Maintenance table (F75I100).

Periodic Processing (G75ITDS2), TDS Statement
Form 26Q - P2P - IND (R75I122EQ) Run this report to print a list of tax challans and deductions for a particular quarter.

This report reads from the TDS Document Company table (F75I20A), Certificate Master Maintenance table (F75I100), and TDS Certificate Master Maintenance Tag File (F75I102).

(The following paragraph pertains to Release 9.1 Update) When you run this report, the system prints a PDF and a text file for Form 26Q.

When you print the text file of the report, the system displays S in the Remarks 1 field of section 194J.

ETDS Quarterly/Yearly Special Closing (G75ITDS23), Form 26Q - P2P - IND
Form 26 & Form 27 (R75I126) Run this report to print PDF and text version reports of:
  • Form 26

  • Form 27

This report reads from TDS Certificate Master Maintenance (F75I100), TDS Document Company (F75I20A), and TDS Certificate Master Maintenance Tag File (F75I102) tables.

Periodic Processing (G75ITDS2), Form 26 & Form 27
Form 27A (R75I127) Run this report to print an annual report of the Form 27A.

This report reads from the TDS Certificate Master Maintenance (F75I100), TDS Document Company (F75I20A), and TDS Certificate Master Maintenance Tag File (F75I102) tables.

Periodic Processing (G75ITDS2), Form 27A
Quarterly Deduction Of Tax (Form No 27Q) (R75I128) Run this report to print Form 27Q to submit the TDS deduction details to the income tax department on a quarterly basis. You run this report for a tax deduction account number (TAN) for a specified quarter.

When you run this report, the system prints a PDF and a text file for Form 27Q.

(The following paragraph pertains to Release 9.1 Update) The system displays sections 194LB and 194LC as 4LB and 4LC respectively in the text file of Form 27Q.

This report reads from the TDS Document Company (F75I20A), Certificate Master Maintenance (F75I100), and TDS Certificate Master Maintenance Tag File (F75I102) tables.

Periodic Processing (G75ITDS2), Quarterly Deduction Of Tax (Form No 27Q)

30.1.8 India Reports for WCT

These reports exist for India for WCT:

Report ID and Report Name Description Navigation
Certificate of tax (R75I119) Run this report after you complete the challan update, certificate number generation, and month end process.

This report reads from and writes to the TDS Certificate Master Maintenance table (F75I100).

Periodic Processing (G75IWCTDS2), Certificate of tax
Register to be maintained (R75I120) Run this report to submit a register to the authorities, under the WCT Act, for the taxes deducted from payments issued to contractors.

This report reads from the TDS Certificate Master Maintenance table (F75I100).

Periodic Processing (G75IWCTDS2), Register to be maintained
Monthly statement of tax (R75I121) Run this report to submit a monthly return to the authorities, under the WCT Act, for the taxes deducted from the payments issued to contractors.

This report reads from the TDS Certificate Master Maintenance table (F75I100).

Periodic Processing (G75IWCTDS2), Monthly statement of tax

30.1.9 R75I010 – Loc. Purchase Order Print - IN

When you run the Print Purchase Orders program (R43500) for Indian transactions, the system runs the Loc. Purchase Order Print - IN report (R75I010) to print the layout in an India-specific format if you set a processing option to do so. The India-specific format includes the specific tax registration numbers associated with the company and the corresponding taxes (landed cost components for each purchased item).

30.1.10 Processing Options for Loc. Purchase Order Print - IN (R75I010)

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

30.1.10.1 Report Display

1. Enter a '1' to print the Exchange Rate.

Enter 1 to print the exchange rate on the purchase order.

2. Enter the Global Print Message to print on each order.

Specify a user-defined code from the UDC table 40/PM to print a message on the purchase order.

3. Enter a '1' to print Purchase Order Note.

Enter 1 to print the purchase order in the India-specific format. If you leave this processing option blank, the system prints the purchase order in the standard format.

4. Enter a '1' to suppress the report title and company name from printing.

Enter 1 to suppress the printing of the report title and company name.

5. Enter a '1' to print the Purchasing Agent on the Purchase Order.

Enter 1 to print the name of the purchasing agent on the purchase order.

6. Enter a '1' to exclude Tax Registration Details and Tax Components from Landed Cost (leave blanks to print them)

Enter 1 to suppress the printing of the tax registration details and the tax components from the landed cost setup.

30.1.11 R75I102 – TDS Statement

Run this report to determine the TDS amount and surcharge amount to be paid to the tax authorities. Run this report before performing the challan detail update process.

(This paragraph pertains to Release 9.1 Update) The TDS Statement displays a flag for penalty if a penalty not equal to zero exists in the F75I104 table. The report also displays non-rounded tax amount by summing the values in TDS, surcharge, CESS, and HCESS and also the difference between the total tax amount and the non-rounded tax amount. For this calculation, the system retrieves total tax amount from the F75I100 table.

30.1.12 Processing Options for TDS Statement (R75I102)

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

30.1.12.1 Defaults

Company and Document Company

Specify a number that identifies a specific organization, fund, or other reporting entity. The company must exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions.


Note:

You can use company 00000 for default values, such as dates and automatic accounting instructions. You cannot use Company 00000 for transaction entries.

TDS Group (Tax Deducted at Source Group)

Enter a value from UDC table 75I/TG (TDS Group) that designates the TDS group. TDS groups are stored in the TDS Rate Maintenance table (F75I10A). Examples are:

B: Brokerage

C: Contractor

D: Dividend

I: Interest

R: Rent

Beginning Date and End Date

Specify a date range for which the tax rate is effective.

30.1.13 R75I119 – Certificate of Tax

Run this report after you complete the challan update, the certificate number generation, and the month-end process. You must submit this report to dealers and contractors to enable them to claim the credit on their income tax returns.

30.1.14 Processing Options for the Certificate of Tax (R75I119)

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

30.1.14.1 Default

Beginning Date and End Date

Specify the date range for which the tax rate is effective.

Company and Document Company

Specify a number that identifies a specific organization, fund, or other reporting entity. The company must exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions.


Note:

You can use company 00000 for default values, such as dates and automatic accounting instructions. You cannot use Company 00000 for transaction entries.

Work Contract Tax Type

Specify a user-defined code from the TDS Type UDC table (75I/TY) that identifies the tax type for the work contract. The law specifies different tax types. Examples are:

1: Include in 1099 Processing

A: Interest Dividends to NRI

B: Advertising Contract

C: Contractor

D: Dividend

Date to be printed at the bottom as a Date of Issue of Certificate. If left blank, System Date will be printed.

Specify the date that the system prints as the issue date at the bottom of the certificate. If you leave this processing option blank, the system uses the current date.

Amount Paid

Specify the code that indicates which amount you pay. Values are:

Blank: Amount on the contractor's bill

1: Challan amount you pay to the government

Print Report Heading

Specify whether to print the heading of the Certificate of Tax report.

Y: Yes

N: No

30.1.15 R75I120 – Register to be Maintained

This report prints a register that you submit to the authorities for the taxes deducted from payments issued to contractors. This report consolidates TDS details from the tax certificates submitted by suppliers. You need to submit this report to the Income Tax Department.

30.1.16 Processing Options for Register to be Maintained (R75I120)

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

30.1.16.1 Defaults

Contract Type

Specify a user-defined code from the TDS Type UDC table (75I/TY) that identifies the tax type for the work contract. The law specifies different tax types. Examples are:

1: Include in 1099 Processing

A: Interest Dividends to NRI

B: Advertising Contract

C: Contractor

D: Dividend

TDS Certificate Issue Date

Specify the date that the TDS certificate was issued by the tax authorities.

Company and Document Company

Specify a number that identifies a specific organization, fund, or other reporting entity. The company must exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions.


Note:

You can use company 00000 for default values, such as dates and automatic accounting instructions. You cannot use Company 00000 for transaction entries.

Print Report Header

Specify whether to print the header of the Register to be Maintained report. Values are:

Y: Yes

N: No

30.1.16.2 Tax Type

Secondary Higher Education Cess

Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the secondary higher education cess component of tax.

30.1.17 R75I121 – Monthly Statement of Tax

Run this report to consolidate the tax deducted for the suppliers every month. Companies must submit this report to the income tax department.

30.1.18 Processing Options for Monthly Statement of Tax (R75I121)

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

30.1.18.1 Defaults

Beginning Date and End Date

Specify the date range for which the tax rate is effective.

Company and Document Company

Specify a number that identifies a specific organization, fund, or other reporting entity. The company must exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions.


Note:

You can use company 00000 for default values, such as dates and automatic accounting instructions. You cannot use Company 00000 for transaction entries.

TDS Type

Specify a user-defined code from the TDS Type UDC table (75I/TY) that identifies the tax type for the work contract. The law specifies different tax types. Examples are:

1: Include in 1099 Processing

A: Interest Dividends to NRI

B: Advertising Contract

C: Contractor

D: Dividend

Print Report Header

Specify whether to print the header of the Monthly Statement of Tax report. Values are:

Y: Yes

N: No

30.1.19 R75I122EQ – Form 26Q - P2P - IND

This report prints a list of tax challans and deductions for a particular quarter. You must run this report every quarter to submit it to the tax authorities.

You must include contact information in the report. At least one of these contact data points must exist:

  • Deductor/collector telephone number with the STD code

  • Responsible person telephone number with the STD code

  • Responsible person mobile number

You set up landline and mobile phone numbers, and the STD code, in the address book records. At least one of the contact data points must exist in the address book record or the data fails the validations. If the data fails the validations, the programs do not generate the electronic file.

(Release 9.1 Update) The system reads the Tax Registration Details table (F75I010), which holds the PAN number, and the F75I215 table, which holds the PAN reference number (also called the deductee reference number), when you run the Form 26Q Quarterly Returns (New Format) program (R75I122EQ). If the PAN number is present in the F75I010 table, then the Form 26Q Quarterly Returns program writes the number to the output file for the Form 26Q quarterly return and leaves the PAN reference number blank in the output file. If the PAN number is not in the F75I010 table, then the Form 26Q Quarterly Returns program writes the PAN reference number from the F75I215 table to the output file and leaves the PAN field in the output file blank.

30.1.20 Processing Options for Form 26Q Quarterly Returns (New Format) (R75I122EQ)

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

30.1.20.1 Default

Company of the Deductor (CO)

Specify company of the deductor responsible for deducting TDS. This is the parent company that has the permanent account number.

Document Company of the Deductor (KCO)

Specify the document company of the person who is responsible for deducting TDS. The document company designates a child company that usually has a separate Tax Deduction and Collection Account Number (TAN) and is associated with a parent company. The system generates the eTDS report for this child company.


Note:

TAN is a 10-digit alphanumeric number obtained by all persons who are responsible for deducting or collecting taxes. You must include the TAN in TDS and TCS returns, TDS and TCS payment challan, and TDS and TCS certificates.

Year for which eTDS Report are printed

Specify the year for which you want to generate an eTDS report. For example, enter 2009 for fiscal year 2008-2009.

Quarter for which eTDs Report are printed

Specify a value that designates the fiscal year quarter. Values are:

1: Display the data from 1st April to 31st June for the fiscal year.

2: Display the data from 1st July to 31st September for the fiscal year.

3: Display the data from 1st October to 31st December for the fiscal year.

4: Display the data from 1st January to 31st March for the fiscal year.

Address Book Number for person responsible for deducting Tax at Source

Specify the address book number of the person who is responsible for deducting taxes at source.

Path for Flat File (TXT File)

Specify the path for the flat file. For example, you might enter C:\TDS\File\. The system saves the flat file to the specified location.

Has any statement been filed earlier for this quarter

Specify whether a statement was filed earlier for this quarter. Values are:

Y: A statement was filed earlier.

N: No statement was filed earlier.

Designation of Person Responsible for deducting tax at source

Specify the designation of the person who is responsible for deducting tax at source, for example, a manager or financial officer.

Name of Return Preparation Utility

Enter the name of the software that you use to prepare the quarterly TDS statement. For example, you can enter JD Edwards EnterpriseOne.

Transactions under minimum (Y/N) Only applied for FORM 26Q Default - N / No Y - Yes (Release 9.1 Update)

Specify whether the system includes transactions under minimum on text file. Values are:

N/Blank: Do not include transactions under minimum

Y: Include transactions under minimum

30.1.20.2 Additional Info

Paid by Book Entry

Specify the status of the Paid by Book entry. Values are:

Y: Paid by Book entry is applicable.

N: Paid by Book entry is not applicable.

When the TDS amount is paid by the government companies to the government, entries are made in journals. Paid by book entries refer to the transfer of records from one journal to the other.

Provisional receipt Number (for Corrected returns)

Specify the provisional receipt number that you want to use if income tax returns need to be corrected.

Deductor Type

Enter a value from the Deductor Type 75I/DE UDC table. Examples of values are:

A: Central Government

S: State government

Address Change Flag for Deductor

Specify if there is a change of address of the tax-deducting authority. Values are:

Y: Address has changed

N: Address has not changed

Address Change Flag for Person Responsible for making deduction

Specify whether the address of the person who is responsible for collecting taxes has changed. Values are:

Y: Address has changed

N: Address has not changed

The person that is responsible for tax collection can be a manager or a financial officer or any individual in charge.

Last Deductor Type

Enter a value from the Deductor Type (75I/DE) UDC table to specify the last statement accepted at the central system for a correction format. Examples of values are:

A: Central Government

K: Company

S: State government

PAO Code (pay and accounts office code)

Enter the PAO code.

PAO Registration No (pay and accounts office registration number)

Enter the PAO registration number.

DDO Code (drawing and disbursing officer code)

Enter the DDO code.

DDO Registration No (drawing and disbursing officer registration number)

Enter the DDO registration number.

Ministry Name

Enter a value from the Ministry Name 75I/MN UDC table to specify the code for the ministry. Examples of values are:

01: Agriculture

02: Atomic Energy

03: Fertilizers

Ministry Name Other

If you entered the code 99 (other) in the Ministry Name processing option, enter the ministry name.

Last Transfer Voucher No

Leave this processing option blank for all transaction types when you process a regular (non-correction) report.

If this is a correction report, enter the transfer voucher number for the previous report for transaction types C2, C3, and C5.

Leave this processing option blank for transaction types C1, C9, and Y.

Transfer Voucher No

Enter the transfer voucher number if:

  • This is a regular (non-correction) report.

  • The value in the Deductor Type field in the header record is A (Central Government) or S (State Government).

  • The NIL Challan Indicator is N (no).

If this is a correction report and the transaction type is C2 and the value in the Deductor Type field in the header records is A (Central Government) or S (State Government), enter the transfer voucher number for this report.

If this is a correction report and the transaction type is C3, the value in the Deductor Type field in the header records is A (Central Government) or S (State Government), and the value in the Challan Updation Indicator processing option is 1, enter the transfer voucher number for this report. If the value in the Challan Updation Indicator processing option is 0, enter the number from the Last Transfer Voucher No processing option.

If this is a correction report and the transaction type is C1, C5, or Y, leave this processing option blank. If this is a correction report and the transaction type is C9, and the value in the Deductor Type field in the header records is A (Central Government) or S (State Government), enter the transfer voucher number for this report, except when a nil challan exists. If a nil challan exists for type C9, leave this processing option blank.

Account Office ID Number of PAO/TO/CDDO (Release 9.1 Update)

Accounts Officer Identification Number (AIN) is a seven-digit unique identification number issued by the Directorate of Income Tax (Systems) Delhi to each Accounts Officer (AO).

If the deductor category is the Central Government or the State Government, the AIN of the following should be reported for every type of deduction or collection, that is, TDS-Salary/TDS Non-Salary/TDS-Non Salary Non-Residents/TCS:

  • Pay and Account Office (PAO)

  • Treasure Office (TO)

  • Cheque Drawing and Disbursing Officer (CDDO)

Minor Head Code (Release 9.1 Update)

Enter a user-defined code from UDC table 75I/MH. Values are:

200: TDS payable by taxpayer

400: TDS regular assessment (Raised by IT Department)

30.1.20.3 Tax Type

Tax Deducted at Source, Surcharge, Education Cess, Secondary Higher Education Cess, Interest, and Others

Specify a user-defined code from UDC table 75I/GT that identifies the tax type or interest type.

30.1.20.4 Correction Format Info

You complete these processing options for correction reports only.

Transaction Type

Enter the code for the type of correction. Leave this processing option blank if this is not a correction report. Values are:

C1: Correction in deductor details (excluding TAN)

C2: Correction in deductor (excluding TAN) or challan details

C3: Correction in deductor (excluding TAN), challan, or deductee details

C5: Correction in PAN of deductees

C9: Correction in challan (addition of challan)

Y: Cancellation of statement

Batch Updation Indicator

Enter 1 if updates exist in the batch header other than the TAN and the transaction type is C2 or C3. Otherwise, enter 0.

Mode

Enter the mode for transaction types C3 and C9. Leave this processing option blank for transaction types C1, C2, and C5. Values are:

A: New deductee record is added for transaction type C3.

D: Existing party detail record is deleted for transaction type C3.

U: Existing party details record is updated (changed) for transaction type C3.

O: Used for transaction type C9.

Original RRR Number

Specify the Provisional Receipt Number (PRN) of the corresponding regular statement.

Previous RRR Number

Specify the Original RRR number (PRN of corresponding regular statement) if no previous correction statement was provided.

Specify the PRN of last correction statement if a previous correction statement was provided.

Last TAN of Deductor/Collector

Enter the same TAN of the collector included in corresponding regular statement accepted by the TIN central system.

Collector's Branch/ Division

For transaction types C1, enter the deductor's branch and division.

For transaction types C2 and C3, enter the deductor's branch and division if you entered 1 in the Batch Updation Indicator processing option. If the value in the Batch Updation Indicator processing option is 0 for transactions types C2 and C3, leave this processing option blank.

For transaction types C5, C9, and Y, leave this processing option blank.

Challan Updation Indicator

For transaction type C3, enter 1 if there are changes in the challan details. Otherwise, enter 0 for transaction type C3. For all other situations, leave this processing option blank.

Last Bank Challan No

For transaction types C2, C3, and C5, enter the Bank Challan Number specified in the corresponding regular or last correction statement. A value is required in this processing option if the book entry flag or the nil challan indicator is N.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Bank Branch Code

For transaction types C2, C3, and C5, enter the bank branch code (BSR code) mentioned in the corresponding regular or last correction statement. A value is required in this processing option if the book entry flag or the nil challan indicator is N.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Date of Bank Challan/Transfer Voucher No

For transaction types C2, C3, and C5, enter the date of the Bank Challan Number or date of the Transfer Voucher Number included in the corresponding regular or last correction statement.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Total of Deposit Amount as per Challan

For transaction types C2, C3, and C5, enter the value from the Total of Deposit Amount as per Challan of the corresponding regular or last correction statement. You must provide this value.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Employee/ Party PAN

For transaction type C3, enter the value from the regular statement or the last correction statement if the mode is D or U.

If the mode for transaction type C3 is A, or if the transaction type is C1, C2, C5, C9, or Y, leave this processing option blank.

Deductee Reference Number

For transaction type C3, enter the deductee reference number. If the mode is D, the value is the same as the value that you enter in Last Collectee / Party PAN Ref. No. processing option.

Leave this processing option blank for transaction types other than C3.


Note:

The deductee reference number is a unique identifier to identify a party where PAN is not available. This number is quoted by the collector.

Last Employee/Party PAN Ref No

For transaction type C3, if mode is D or U, enter the value specified in the regular statement or the last correction statement.

If the mode for transaction type C3 is A, or if the transaction type is C1, C2, C5, C9, or Y, leave this processing option blank.

Last Total Income Tax Deducted at Source

For transaction type C3, if mode is D or U enter the value of the total income tax collected at source (income tax + surcharge + cess) as specified in the corresponding regular statement or the last correction statement.

Leave this processing option blank if the mode is A. For transaction type C5, enter the value of total income tax collected at source (income tax + surcharge + cess) as specified in corresponding regular statement or the last correction statement. Leave this processing option blank if the transaction type is C1, C2, C9, or Y.

Last Total Tax Deposited

For transaction type C3, if mode is D or U enter the value of the total tax deposited as specified in the regular statement or the last correction statement. Leave this processing option blank if the mode is A. For transaction type C5, enter the value of the total tax deposited as specified in the corresponding regular statement or the last correction statement.

Leave this processing option blank if the transaction type is C1, C2, C9, or Y.

Reason for non-deduction/lower deduction

For transaction type C3, if the mode is A, enter A if a lesser deduction amount or no deduction exists due to a certificate under section 197, or enter B if there is no deduction due to a declaration under section 197A.

Leave this processing option blank for all other modes. For transaction type C9, enter A if a lesser deduction amount or no deduction exists due to a certificate under section 197, or enter B if there is no deduction due to a declaration under section 197A. Leave this processing option blank if the transaction type is C1, C2, C5, or Y.

Whether regular statement for Form 26Q has been filed for an earlier period?
Enter ''Y' if regular statement for Form 26Q has been filed for an earlier period.
Else enter value 'N'.

Enter a value depending on the Regular Statement field value, whether filed on an earlier period for Form 26Q. Values are:

Y: If a regular statement for Form 26Q has been filed for an earlier period

N: If a regular statement for Form 26Q has not been filed for an earlier period

30.1.21 R75I126 – Form 26 & Form 27

This report prints a PDF and text version reports of forms 26 and 27. This report must be generated annually to submit to the tax authorities.

30.1.22 Processing Options for Form 26 & Form 27 (R75I126)

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

30.1.22.1 Defaults

Company of the Deductor (CO)

Specify the company of the person who is responsible for deducting TDS. This is the parent company that has the PAN.

Document Company of the Deductor (KCO)

Specify the document company of the person who is responsible for deducting TDS. The document company designates a child company that usually has a separate Tax Deduction and Collection Account Number (TAN) and is associated with a parent company. The system generates the eTDS report for this child company.


Note:

TAN is a 10-digit alphanumeric number obtained by all persons who are responsible for deducting or collecting taxes. You must include the TAN in TDS and TCS returns, TDS and TCS payment challan, and TDS and TCS certificates.

Year for which eTDS Report are printed

Specify the year for which you want to generate an eTDS report. Example, enter 2006 for fiscal year 2005-2006.

Type of Form (Form 26 and Form 27)

Specify a code that designates the type of form. Values are:

1: Form 26

0: Form 27

Address Book Number for person responsible for deducting Tax at Source

Specify the address book number of the person who is responsible for deducting the tax at source.

Path for Flat File (TXT File)

Specify the path for the flat file. For example, you might enter C:\TDS\File\. The system saves the flat file to the specified location.

Address Change Flag

Specify whether the address of the person who is deducting taxes at source has changed. Values are:

Y: The address has changed

N: The address has not changed

Designation of Person Responsible for deducting tax at source

Specify the designation of the person who is responsible for deducting tax at source, for example manager or financial officer or any individual in charge.

30.1.22.2 Additional Info

Paid by Book Entry

Specify the status of the Paid by Book entry. Values are:

Y: Paid by Book entry is applicable.

N: Paid by Book entry is not applicable.

When the TDS amount is paid by the government companies to the government, entries are made in journals. Paid by Book entries refer to the transfer of records from one journal to the other.

Type of Form (R,C)

Specify the code that designates the form type. Values are:

R: Regular

C: Corrected

Provisional receipt Number (for Corrected returns)

Specify the provisional receipt number that you want to use if income tax returns need to be corrected.

Status of deductor

Specify whether the person responsible for deducting taxes is a government representative. Values are:

C: Government deductor

O: Nongovernment deductor

30.1.22.3 Tax Type

Secondary Higher Education Cess

Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the secondary higher education cess component of tax.

30.1.23 R75I127 – Form 27A

This report prints an annual, consolidated report of the Form 27A.

30.1.24 Processing Options for Form 27A (R75I127)

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

30.1.24.1 Defaults

Company of the Deductor (CO)

Specify the company of the person who is responsible for deducting TDS. This is the parent company that has the PAN.

Document Company of the Deductor (KCO)

Specify the document company of the person who is responsible for deducting TDS. The document company designates a child company that usually has a separate TAN and is associated with a parent company. The system generates the eTDS report for this child company.


Note:

TAN is a 10-digit alphanumeric number obtained by all persons who are responsible for deducting or collecting taxes. You must include the TAN in TDS and TCS returns, TDS and TCS payment challan, and TDS and TCS certificates.

Year

Specify the year for which you want to generate an eTDS report. For example, you might enter 2006 for fiscal year 2005-2006.

Type of Form for which Form 27A is Printed

Specify which form you want to print. Values are:

1: Form 26

0: Form 27

Previous receipt Number

Specify the provisional receipt number that you want to use if income tax returns need to be corrected.

Address Book Number for person responsible for deducting Tax at Source

Specify an address book number for the person responsible for deducting tax at source.

Designation of Person Responsible for deducting tax at source

Specify the designation of the person who is responsible for deducting the tax at source, for example, manager or financial officer.

Status of deductor

Specify whether the person responsible for deducting taxes is a government representative. Values are:

C: Government deductor

0: Others

30.1.24.2 Tax Type

Secondary Higher Education Cess

Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the secondary higher education cess component of tax.

30.1.25 R75I128 — Quarterly Deduction of Tax (Form 27Q)

This report prints Form 27Q to submit the TDS deduction details to the income tax department on a quarterly basis. This report shows the deductee's and challan details for the specific quarter.

30.1.26 Processing Options for Quarterly Deduction of Tax (Form 27Q)

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

30.1.26.1 Defaults

Company of the Deductor (CO)

Specify the company of the person responsible for deducting TDS. This is the parent company with a PAN.

Document Company of the Deductor (KCO)

Specify the document company of the person who is responsible for deducting TDS. The document company designates a child company that usually has a separate TAN and is associated with a parent company. The system generates the eTDS report for this child company.


Note:

TAN is a 10-digit alphanumeric number obtained by all persons who are responsible for deducting or collecting taxes. You must include the TAN in TDS and TCS returns, TDS and TCS payment challan, and TDS and TCS certificates.

Year for which eTDS Report are printed

Specify the year for which the eTDS Reports are to be printed. For example, you enter 2006 for fiscal year 2005-2006, or 2009 for fiscal year 2008-2009.

Quarter for which eTDs Report are printed

Specify a value that designates the fiscal year quarter. Values are:

1: Display the data from 1st April to 31st June for the fiscal year.

2: Display the data from 1st July to 31st September for the fiscal year.

3: Display the data from 1st October to 31st December for the fiscal year.

4: Display the data from 1st January to 31st March for the fiscal year.

Address Book Number for person responsible for deducting Tax at Source

Specify the address book number of the person who is responsible for deducting taxes at source.

Path for Flat File (TXT File)

Specify the path for the flat file. For example, you enter C:\TDS\File\. The system saves the flat file to the specified location.

Has any statement been filed earlier for this quarter

Specify whether a statement was filed earlier for this quarter. Values are:

Y: A statement was filed earlier.

N: No statement was filed earlier.

Designation of Person Responsible for deducting tax at source

Specify the designation of the person who is responsible for deducting the tax at source; for example, manager or financial officer.

Name of Return Preparation Utility

Enter the name of the software that you use to prepare the quarterly TDS statement. For example, you enter JD Edwards EnterpriseOne.

Transactions under minimum (Y/N) Only applied for FORM 26Q Default - N / No Y - Yes (Release 9.1 Update)

Specify whether the system includes transactions under minimum on text file. Values are:

N/Blank: Do not include transactions under minimum

Y: Include transactions under minimum

30.1.26.2 Additional Info

Paid by Book Entry

Specify the status of the Paid by Book entry. Values are:

Y: Paid by Book entry is applicable.

N: Paid by Book entry is not applicable.

When the government companies pay the TDS amount to the government, entries are made in journals. Paid by book entries refer to the transfer of records from one journal to the other.

Provisional receipt Number (for Corrected returns)

Specify the provisional receipt number that you want to use if income tax returns need to be corrected.

Deductor Type

Enter a value from the Deductor Type 75I/DE UDC table. Examples of values are:

A: Central government

S: State government

Address Change Flag for Deductor

Specify if there is a change of address of the tax-deducting authority. Values are:

Y: Address has changed

N: Address has not changed

Address Change Flag for Person Responsible for making deduction

Specify whether the address of the person who is responsible for collecting taxes has changed. Values are:

Y: Address has changed

N: Address has not changed

The person that is responsible for tax collection can be a manager or a financial officer or any individual in charge.

Last Deductor Type

Enter a value from the Deductor Type (75I/DE) UDC table to specify the last statement accepted at the central system for a correction format. Examples of values are:

A: Central government

K: Company

S: State government

PAO Code (pay and accounts office code)

Enter the PAO code.

PAO Registration No (pay and accounts office registration number)

Enter the PAO registration number.

DDO Code (drawing and disbursing officer code)

Enter the DDO code.

DDO Registration No (drawing and disbursing officer registration number)

Enter the DDO registration number.

Ministry Name

Enter a value from the Ministry Name 75I/MN UDC table to specify the code for the ministry. Examples of values are:

01: Agriculture

02: Atomic Energy

03: Fertilizers

Ministry Name Other

If you entered the code 99 (other) in the Ministry Name processing option, enter the ministry name.

Last Transfer Voucher No

Leave this processing option blank for all transaction types when you process a regular (non-correction) report.

If this is a correction report, enter the transfer voucher number for the previous report for transaction types C2, C3, and C5.

Leave this processing option blank for transaction types C1, C9, and Y.

Transfer Voucher No

Enter the transfer voucher number if:

  • This is a regular (non-correction) report.

  • The value in the Deductor Type field in the header record is A (Central government) or S (State government).

  • The NIL Challan Indicator is N (no).

If this is a correction report and the transaction type is C2, and the value in the Deductor Type field in the header records is A (Central Government) or S (State Government), enter the transfer voucher number for this report.

If this is a correction report and the transaction type is C3, the value in the Deductor Type field in the header records is A (Central Government) or S (State Government), and the value in the Challan Updation Indicator processing option is 1, enter the transfer voucher number for this report. If the value in the Challan Updation Indicator processing option is 0, enter the number from the Last Transfer Voucher No processing option.

If this is a correction report and the transaction type is C1, C5, or Y, leave this processing option blank. If this is a correction report and the transaction type is C9, and the value in the Deductor Type field in the header records is A (Central Government) or S (State Government), enter the transfer voucher number for this report, except when a nil challan exists. If a nil challan exists for type C9, leave this processing option blank.

Account Office ID Number of PAO/TO/CDDO (Release 9.1 Update)

Accounts Officer Identification Number (AIN) is a seven-digit unique identification number issued by the Directorate of Income Tax (Systems) Delhi to each Accounts Officer (AO).

If the deductor category is the Central Government or the State Government., the AIN of the following should be reported for every type of deduction/collection, that is, TDS-Salary/TDS Non-Salary/TDS-Non Salary Non-Residents/TCS:

  • Pay and Account Office (PAO)

  • Treasure Office (TO)

  • Cheque Drawing and Disbursing Officer (CDDO)

Minor Head Code (Release 9.1 Update)

Enter a user-defined code from UDC table 75I/MH. Values are:

200: TDS payable by taxpayer

400: TDS regular assessment (Raised by IT Department)

30.1.26.3 Tax Type

Tax Deducted at Source, Surcharge, Education Cess, Secondary Higher Education Cess, Interest, and Others

Specify a user-defined code from UDC table 75I/GT that identifies the tax type or interest type.

30.1.26.4 Correction Format Info

You complete these processing options for correction reports only.

Transaction Type

Enter the code for the type of correction. Leave this processing option blank if this is not a correction report. Values are:

C1: Correction in deductor details (excluding TAN)

C2: Correction in deductor (excluding TAN) or challan details

C3: Correction in deductor (excluding TAN), challan, or deductee details

C5: Correction in PAN of deductees

C9: Correction in challan (addition of challan)

Y: Cancellation of statement

Batch Updation Indicator

Enter 1 if updates exist in the batch header other than the TAN and the transaction type is C2 or C3. Otherwise, enter 0.

Mode

Enter the mode for transaction types C3 and C9. Leave this processing option blank for transaction types C1, C2, and C5. Values are:

A: New deductee record is added for transaction type C3.

D: Existing party detail record is deleted for transaction type C3.

U: Existing party details record is updated (changed) for transaction type C3.

O: Used for transaction type C9.

Original RRR Number

Specify the Provisional Receipt Number (PRN) of the corresponding regular statement.

Previous RRR Number

Specify the Original RRR number (PRN of corresponding regular statement) if no previous correction statement was provided.

Specify the PRN of the last correction statement if a previous correction statement was provided.

Last TAN of Deductor/Collector

Enter the same TAN of the collector included in corresponding regular statement accepted by the TIN central system.

Collector's Branch/ Division

For transaction types C1, enter the deductor's branch and division.

For transaction types C2 and C3, enter the deductor's branch and division if you entered 1 in the Batch Updation Indicator processing option. If the value in the Batch Updation Indicator processing option is 0 for transactions types C2 and C3, leave this processing option blank.

For transaction types C5, C9, and Y, leave this processing option blank.

Challan Updation Indicator

For transaction type C3, enter 1 if there are changes in the challan details. Otherwise, enter 0 for transaction type C3. For all other situations, leave this processing option blank.

Last Bank Challan No

For transaction types C2, C3, and C5, enter the Bank Challan Number specified in the corresponding regular or last correction statement. A value is required in this processing option if the book entry flag or the nil challan indicator is N.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Bank Branch Code

For transaction types C2, C3, and C5, enter the bank branch code (BSR code) mentioned in the corresponding regular or last correction statement. A value is required in this processing option if the book entry flag or the nil challan indicator is N.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Date of Bank Challan/Transfer Voucher No

For transaction types C2, C3, and C5, enter the date of the Bank Challan Number or date of the Transfer Voucher Number included in the corresponding regular or last correction statement.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Total of Deposit Amount as per Challan

For transaction types C2, C3, and C5, enter the value from the Total of Deposit Amount as per Challan of the corresponding regular or last correction statement. You must provide this value.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Employee/ Party PAN

For transaction type C3, enter the value from the regular statement or the last correction statement if the mode is D or U.

If the mode for transaction type C3 is A, or if the transaction type is C1, C2, C5, C9, or Y, leave this processing option blank.

PAN Reference Number

For transaction type C3, enter the PAN reference number. If the mode is D, the value is the same as the value that you enter in the Last Collectee / Party PAN Ref. No. processing option.

Leave this processing option blank for transaction types other than C3.


Note:

The PAN Reference Number is a unique identifier to identify a party where the PAN is not available. This number is quoted by the collector.

Last Employee/Party PAN Ref No

For transaction type C3, if the mode is D or U, enter the value specified in the regular statement or the last correction statement.

If the mode for transaction type C3 is A, or if the transaction type is C1, C2, C5, C9, or Y, leave this processing option blank.

Last Total Income Tax Deducted at Source

For transaction type C3, if the mode is D or U, enter the value of the total income tax collected at source (income tax + surcharge + cess) as specified in the corresponding regular statement or the last correction statement.

Leave this processing option blank if the mode is A. For transaction type C5, enter the value of total income tax collected at source (income tax + surcharge + cess) as specified in corresponding regular statement or the last correction statement. Leave this processing option blank if the transaction type is C1, C2, C9, or Y.

Last Total Tax Deposited

For transaction type C3, if the mode is D or U, enter the value of the total tax deposited as specified in the regular statement or the last correction statement. Leave this processing option blank if the mode is A. For transaction type C5, enter the value of the total tax deposited as specified in the corresponding regular statement or the last correction statement.

Leave this processing option blank if the transaction type is C1, C2, C9, or Y.

Reason for non-deduction/lower deduction

For transaction type C3, if the mode is A, enter A if a lesser deduction amount or no deduction exists due to a certificate under section 197, or enter B if there is no deduction due to a declaration under section 197A.

Leave this processing option blank for all other modes. For transaction type C9, enter A if a lesser deduction amount or no deduction exists due to a certificate under section 197, or enter B if there is no deduction due to a declaration under section 197A. Leave this processing option blank if the transaction type is C1, C2, C5, or Y.

Whether regular statement for Form 26Q has been filed for an earlier period?
Enter ''Y' if regular statement for Form 26Q has been filed for an earlier period.
Else enter value 'N'.

Enter a value depending on the Regular Statement field value, whether filed on an earlier period for Form 26Q. Values are:

Y: If a regular statement for Form 26Q has been filed for an earlier period

N: If a regular statement for Form 26Q has not been filed for an earlier period

30.1.27 R75I213 – Stock Transfer Details

This report prints information about the stock transfer transactions for a specific business unit, company, item number, lot number, document number and location for a specific period.

Typically, VAT is not charged on the transfer of goods within an organization when there is no sale involved. However, VAT is charged on the transfer of goods between two divisions of an organization when the divisions are in different states.

30.1.28 Processing Options for Stock Transfer Details (R75I213)

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

30.1.28.1 Display

Month

Specify the number of the month for which you want to run the report. For example, enter 01 for January.

Year

Specify the applicable year.

Business Unit

Specify the number of the business unit for which you want to run the report.

Proof or Final Mode

Specify the processing mode for the program. Values are:

0or blank: proof mode (we don't italicize the value blank)

1: final mode

In proof mode, the report prints the details of the stock transfer transactions and in the final mode it also updates the Consolidated Tax Payment table (F75I404).

30.1.29 R75I304 – Excise Manufacturer - Deferred CENVAT

This report prints the tax-deferred information. This report also enables you to review the deferred tax amount.

30.1.30 Processing Options for Excise Manufacturer - Deferred CENVAT (R75I304)

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

30.1.30.1 General

1 - Date From

Specify the start date from which the deferred CENVAT amount is available.

Date To

Specify the end date through which the deferred CENVAT amount is available.

2 - Excise Unit Blank = All

Specify the address book number of the excise unit.

30.1.31 R75I307 – Dealer - RG23D Register

This report prints information about the purchase receipt and sales order. This report maps the information on the purchase receipt to the sales order by item, branch/plant, location, lot number and tax type. The report retrieves the purchase receipt information from the Purchase Order Receiver Tag File (F75I008) and Purchase Order Receiver File (F43121) tables and the sales order information from the RG23D Register - Issues table (F75I385).

30.1.32 Processing Options for Dealer - RG23D Register (R75I307)

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

30.1.32.1 General

1 - Excise Unit

Specify the address book number of the excise unit.

2 - Date From

Specify the start date for which you want to run the report. If you do not specify a beginning date, the system uses the current date.

Date To

Specify the end date for which you want to run the report. If you do not specify a beginning date, the report uses the current date.

30.1.33 R75I319 – Annexure 19

This report prints the Annexure- 19 form that you must submit to the Central Excise department. The report is used to keep track of all exports for which excise duty is adjusted with the ARE 1 bond. The report shows the export of excisable goods for which the excise duty has not been paid. The report also calculates and shows the total amount of credit that the exporter has taken in the running bond account.

This report consists of these parts:

  • Details of removals for export in the current month.

  • Details of proof of export received for previous quarters.

  • Details of all exports for which the excise duty was adjusted with ARE 1 bond for the exporter who has not received the proof of export by the end of the month. The details are for the exports:

    • Within the statutory time limit

    • For which the statutory period has expired

  • Abstract of the ARE 1 bond only when the bond is furnished.

30.1.34 Processing Options for Annexure 19 (R75I319)

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

30.1.34.1 Defaults

Month

Specify the number of the month for which you want to print the Annexure 19 report. For example, enter 01 for January.

Year

Specify the year for which you want to print the Annexure 19 report. For example, enter 2010.

Excise Unit

Specify the excise unit for which you want to print the Annexure 19 report.

Statutory Time Limit

Specify the number of days in which you must submit the proof of export to the government. The government specifies the statutory time limit. For example, the government can specify a statutory time limit of 180 days.

30.1.35 R75I323 – Record of Receipts of Inputs under Bond

This report enables you to review information by company, date range, and excise unit for the item receipts for export-oriented units. You run this report after you enter the ARE 3 information in the Purchase Order Receiver ARE3 Information program (P75I323).

30.1.36 Processing Options for Record of Receipts under Bond (R75I323)

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

30.1.36.1 General

1 - Enter From Date

Specify a date on which one of these events occur:

  • A component part becomes effective on a bill of material.

  • A routing step becomes effective as a sequence on the routing for an item.

  • A rate schedule is in effect.


Note:

The system uses the current system date as the default date. You can enter future dates to plan for upcoming changes. Items that are no longer effective can still be recorded and recognized in JD Edwards EnterpriseOne Product Costing, JD Edwards EnterpriseOne Shop Floor Management, and JD Edwards EnterpriseOne Capacity Requirements Planning. The JD Edwards EnterpriseOne Material Requirements Planning system determines valid components by effectivity dates, not by the bill of material revision level. Some forms display data based on the effectivity dates that you enter.

2 - Enter To Date

Specify a date on which one of these events occur:

  • A component part is no longer in effect on a bill of material.

  • A routing step is no longer in effect as a sequence on the routing for an item.

  • A rate schedule is no longer active.


Note:

The system uses December 31 of the year defined in the Data Dictionary as the default year. You can enter future effective dates so that the system plans for upcoming changes. Items that are no longer effective in the future can still be recorded and recognized in Product Costing, Shop Floor Management, and Capacity Requirements Planning. The Material Requirements Planning system determines valid components by effectivity dates, not by the bill of material revision level. Some forms display data based on the effectivity dates you enter.

30.1.37 R75I344 – Print ARE1 Exception Report

This report prints the nonstatutory ARE 1 document. You use this report to review details about the ARE 1 exceptions; that is, the entries for which proof of exports have not been received.

You must use the Excise Bond/LOU Master Maintenance program (P75I303) to set up the bond master details for ARE 1 bonds.

30.1.38 Processing Options for Print ARE1 Exception Report (R75I344)

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

30.1.38.1 General

From Date

Specify the date from which you want to print the entries for which you have not received the proof of exports. You must receive the proof of export for the excise duty adjusted against the ARE 1 bond.

To Date

Specify the date to which you want to print the entries for which you have not received the proof of exports. You must receive the proof of export for the excise duty adjusted against the ARE 1 bond.

Number of Days

Specify the number of days prior to the current date for which you want to print details for receipt of the proof of exports. You must receive the proof for the orders on which the excise duty was adjusted against the ARE 1 bonds. For example, if the current date is February 20 and you give the number of days as 4, the system prints the proof of exports records that you received from February 16 to February 20.

If you leave this processing option blank, the report does not print records for which you received the proof of exports.

30.1.39 R75I344S – Print ARE1 Bond/LOU Master

This report enables you to review the expiration period and the bond amount for the specified excise period. If you set the processing option to generate the report for LOU, the system shows the expiration period and the quantity for the LOU for the excise unit.

30.1.40 Processing Options for Print ARE1 Bond/LOU Master (R75I344S)

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

30.1.40.1 Bond Info

Excise Unit

Specify the address number of the excise unit for which you want to print the ARE1 bond or LOU details.

B = With Bond L = LOU

Specify whether to print ARE 1 bond or LOU details for an excise unit. Values are:

B: ARE 1 bond details

L: LOU details

30.1.41 R75I345 – Print ARE3 Exception Report

You use this nonstatutory report to review the status of the ARE 3 exceptions; that is, the entries for which proof of exports have not been received.

You must use the Excise CT2-3/Annexure Master Maintenance program (P75I348) to set up the CT2 and CT3 details for ARE 3 certificates.

30.1.42 Processing Options for Print ARE3 Exception Report (R75I345)

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

30.1.42.1 General

From Date

Specify the date from which you want to print the entries for which you have not received the proof of exports. You must receive the proof of export for the excise duty adjusted against the ARE 3 certificate.

To Date

Specify the date to which you want to print the entries for which you have not received the proof of exports. You must receive the proof of export for the excise duty adjusted against the ARE 3 certificate.

Number of Days

Specify the number of days prior to the current date for which you want to print details for receipt of the proof of exports for the orders on which the excise duty was adjusted against the ARE 3 forms. For example, if the current date is February 20, and you give the number of days as 4, the system will print the records for which you received the proof of exports from February 16 to February 20.

If you leave this processing option blank, the report does not print any records for which you received the proof of exports.

30.1.43 R75I345A – Print ARE3 CT2/CT3/Annexure

This report prints information about all CT2, CT3, or Annexure transactions for ARE 3. You use this report to review the quantity issued and quantity available for each excise unit.

30.1.44 Processing Options for Print ARE3 CT2/CT3/Annexure (R75I345A)

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

30.1.44.1 Defaults

CT2-CT3/Annexure A = Annexure C=CT2–CT3

Specify whether to print details for CT2 or CT3 certificates or Annexures for each excise unit. Values are:

A: Annexure

C: CT2 or CT3

30.1.45 R75I351S – print Unclaimed CENVAT Report

This report prints a list of purchase order records with unclaimed CENVAT for the selected business units for a specific period.

30.1.46 Processing Options for print Unclaimed CENVAT (R75I351S)

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

30.1.46.1 Data Selection

Enter the Excise Unit

Specify the address number of the excise unit for which the system prints the unclaimed central value-added taxes (CENVAT) report.

Business Unit

Specify the business unit of the excise unit for which you print the unclaimed CENVAT report.

Enter the Period From

Specify the beginning of the range of dates from which the system prints the unclaimed CENVAT report.

Enter the Period To

Specify the end of the range of dates from which the system prints the unclaimed CENVAT report.

Allow Negative Excise Amounts

Specify whether to display the negative excise amounts in the unclaimed CENVAT report. Values are:

N: The system does not display negative amounts in the CENVAT report.

Y: The system allows negative amounts in the CENVAT report.

30.1.46.2 Transaction Types

Transaction Type 1

Specify the transaction types for selecting the purchase orders to calculate the CENVAT credit amount.

30.1.47 R75I352 – Overdue Consignment

This report enables you to review the consignments that are older than 180 days. This report displays the consignments for which the excise tax is levied. For a particular excise unit, excise tax is levied on the consignments if they do not return to the factory within 180 days.

30.1.48 Processing Options for Overdue Consignments (R75I352)

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

30.1.48.1 Data Selection

Enter the Excise Unit

Specify the address number of the excise unit.

Enter the Comparison Date

Specify a date which must be compared with the consignment date. The system does not process the consignment if it is overdue.

30.1.49 R75I383 – Print PLA Form

This report prints the Annexure 8 form that you must submit to the Central Excise department. This report shows the credit and debit balances of the personal ledger account (PLA) for all excise duty components. This report also shows the opening PLA balance.

This report reads from these tables:

  • Excise - PLA Chapter Wise Transaction File for Yarn Industry (F75I315Y)

  • Excise - MODVAT / PLA Summary File YARN SPECIFIC (F75I310Y)

  • F75I310Y - Tag File (F75I311)

30.1.50 Processing Options for Print PLA Form (R75I383)

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

30.1.50.1 Defaults

Excise Unit

Specify the excise unit for which to print the Annexure 8 form.

Month

Specify the number of the month for which to print the Annexure 8. For example, enter 01 for January.

Year

Specify the year for which to print the Annexure 8. Enter the year using four digits. For example, enter 2010.

30.1.50.2 Tax Type

Secondary Higher Education Cess

Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the secondary higher education cess component of tax.

30.1.51 R75I387 – Record Uncaptured RG-1 From Item Card

This report prints the RG1 records for the transactions that were included in the Item Ledger File table (F4111), but not included by the Excise RG1 Transaction table (F75I380). This report also prints the reason for the omission of the records.

You must run the RG-1 Build report (R75I380) to upload the RG1 details to the F75I380 table before you run the Record Uncaptured RG-1 From Item Card report.

30.1.52 Processing Options for Record Uncaptured RG-1 From Item Card (R75I387)

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

30.1.52.1 Select

Start Date:

Specify the start date of the period when you entered an order. The system uses this date to determine the effective level for inventory pricing.

End Date:

Specify the end date of the period when you entered an order. The system uses this date to determine the effective level for inventory pricing.

30.1.53 R75I390 – Excise Return Master

This report displays the details of raw materials sent to the supplier for processing. This report prints the details of the excise return for the work orders. You can print ER -1, ER -3, ER -5 and ER -6 reports.

30.1.54 Processing Options for Excise Return Master (R75I390)

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

30.1.54.1 Versions

ER -1 (Monthly Report), ER -3 (Quarterly Report), ER -5 (Annual Report), and ER -6 (Monthly Report)

Specify the version of the report to run.

30.1.54.2 Period

For ER - 1 and ER - 3

Specify the period for which the report is generated. Values are:

M: Monthly

Q: Quarterly

Input Month/Quarter

Specify a numerical value for the month or quarter.

If you entered M in the For ER - 1 and ER - 3 processing option, enter a number that corresponds to the month. For example, enter 1 for January or 3 for March.

If you entered Q in the For ER - 1 and ER - 3 processing option, enter a number that corresponds to the quarter. Values for quarters are:

1: April - June

2: July - September

3: October - December

4: January - March

Year

Specify the year for which you run the ER-1 or ER-3 report.

Date Period Begin

Specify the beginning of the range of dates from which the system prints the report.

If you run the ER-5 report, specify the start date of the year for which you run the report.

If you run the ER-6 report, specify the start date of the month for which you run the report.

Date Period End

Specify the end of the range of dates from which the system prints the report.

If you run the ER-5 report, specify the end date of the year for which you run the report.

If you run the ER-6 report, specify the end date of the month for which you run the report.

30.1.55 R75I392 – Annexure 10

This report enables you to review the purchase order details for raw materials and capital goods. This report prints details of the opening and the closing balances for raw materials and capital goods in addition to the details of the credit claimed and utilized for different tax types.

(For Release 9.1 Update) The Annexure 10 program prints opening balances, closing balances, and credit details of CVD, CVD Cess, and CVD Hcess for input goods and capital goods in these ways:

  • For input goods, the program retrieves CVD, CVD Cess, and CVD Hcess from Counter Veiling Duty, CVD Cess, and Taxable Rounding columns of the F75I313Y table.

  • For capital goods, the program retrieves CVD, CVD Cess, and CVD Hcess from Counter Veiling Duty, CVD Cess, and Taxable Rounding columns of the F75I317Y table.

  • In the ABSTRACT section, the program prints:

    • Opening balances of CVD, CVD Cess, and CVD Hcess for input goods in the OPENING BALANCE column. The Annexure 10 program retrieves CVD and CVD Cess from the AII CVD Opening Balance and AII CVD Cess Opening Balance columns of F75I310Y, and from the corresponding opening balance for CVHC from F75I311.

    • Credit taken of CVD, CVD Cess, and CVD Hcess for input goods in the CREDIT TAKEN DURING THE MONTH column. The Annexure 10 program retrieves these values from the AII CVD Credit and AII CVD Cess Credit columns of F75I310Y, and from the corresponding credit taken for CVHC from F75I311.

    • Credit utilized of CVD, CVD Cess, and CVD Hcess for input goods in the CREDIT UTILIZED DURING THE MONTH column. The Annexure 10 program retrieves these values from the AII CVD Debit and AII CVD Cess Debit columns of F75I310Y, and from the corresponding debit for CVHC from F75I311.

    • Opening Balance of CVD, CVD Cess, and CVD Hcess for Capital goods in the OPENING BALANCE column. The Annexure 10 program retrieves these values from the CII CVD Opening Balance and CII CVD Cess Opening Balance columns of F75I310Y, and from the corresponding opening balance for CVHC from F75I311.

    • Credit taken of CVD, CVD Cess, and CVD Hcess for Capital goods in the CREDIT TAKEN DURING THE MONTH column. The Annexure 10 program retrieves these values from the CII CVD Credit and CII CVD Cess Credit columns of F75I310Y, and from the corresponding Credit taken column for CVHC from F75I311.

    • Credit Utilized of CVD, CVD Cess, and CVD Hcess for Capital goods in the CREDIT TAKEN DURING THE MONTH column. The Annexure 10 program retrieves these values from the CII CVD Debit and CII CVD Cess Debit columns of F75I310Y, and from the corresponding Debit for CVHC from F75I311.

30.1.56 Processing Options for Annexure 10 (R75I392)

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

30.1.56.1 Data Selection

Excise Unit

Specify the address number of the excise unit for which to print the Annexure 10.

Year

Specify the year for which to print the Annexure 10. Enter the year using four digits. For example, enter 2010.

Month

Specify the number of the month for which to print the Annexure 10. For example, enter 01 for January.

To be printed:

Specify the type of report to print. Values are:

1: Original

2: Duplicate

3: Triplicate

4: Quadruplicate

Entry Type

Specify the type of journal entry to print on the report. Values are:

D: Only debit

C: Only credit

B: Both entries

30.1.57 R75I395 – ER-5

This report prints the details of the type and quantity of principal inputs used in the manufacture of the finished goods. Print the report annually.

30.1.58 Processing Options for ER-5 (R75I395)

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

30.1.58.1 Default

Selected Period - From Date

Specify the beginning of the range of dates for work orders from which the system prints the ER - 5 report.

Selected Period - To Date

Specify the end of the range of dates for work orders from which the system prints the ER - 5 report.

Transaction Type for completed Work Orders

Specify a user-defined code from the UDC table 00/DT that identifies the document type assigned to completed work orders.

Partially/Fully Completed Work Order Status

Specify a user-defined code from the UDC table 00/SS that identifies the status of fully or partially completed work orders. Examples are:

50: Partial Completion.

65: Work in Progress.

Stocking Type of Manufactured Item

Specify a user-defined code from the UDC table 41/I that identifies the stocking code of manufactured items. Examples are:

C: Configured items

M: Manufactured Items

Stocking Type of Purchased Item

Specify a user-defined code from the UDC table 41/I that identifies the stocking type of purchased items. Examples are:

N: Non-stock items

M: Purchase raw materials

Stocking Type of phantom item

Specify a user-defined code from the UDC table 41/I that identifies the stocking type of phantom items. Examples are:

0: Phantom items

30.1.58.2 Principle Input Details

Cost Method

Specify a user-defined code from the UDC table 40/CM that specifies the basis for calculating the cost of items in a work order. Values are:

01: Last In

02: Weighted Average

03: Memo

04: Current

05: Future

06: Lot

07: Standard

08: Purchasing-Base Cost No Adds

09: Manufacturing Last Cost

Percentage above which input will be Principle

Specify the percentage of the principle inputs used in the manufacture of finished goods. Enter the decimal number of the value. For example, if the value is 42.5 percent enter 42.5.

30.1.58.3 Category Code for FG

Category Code for Finished Good

Specify the category codes that you set up to identify finished goods.

30.1.59 R75I396 – ER-6

This report prints the details of the principal inputs used in the manufacture of the finished goods and the quantity of goods manufactured. The report is printed monthly.

30.1.60 Processing Options for ER-6 (R75I396)

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

30.1.60.1 Default

Selected Period - From date

Specify the beginning of the range of dates of the credit and collection pattern from which the system prints the ER - 6 report.


Note:

The beginning date and end date should belong to same month.

Selected Period - To date

Specify the end of the range of dates of the credit and collection pattern from which the system prints the ER - 6 report.


Note:

The beginning date and end date should belong to same month.

Status Code W/O (status code for work order)

Specify a user-defined code from the UDC table 00/SS that identifies the status of fully or partially completed work orders. Examples are:

50: Partial Completion.

65: Work in Progress.

Transaction Type of Completed Work Order

Specify a user-defined code from the UDC table 00/DT that identifies the document type assigned to completed work orders.

Stocking Type of Phantom Item

Specify a user-defined code from the UDC table 41/I that identifies the stocking type of phantom items. Example is:

0: Phantom item

Stocking Type of Manufactured Item

Specify a user-defined code from the UDC table 41/I that identifies the stocking code of manufactured items. Examples are:

C: Configured item

M: Manufactured item

Stocking Type of Purchased item

Specify a user-defined code from the UDC table 41/I that identifies the stocking type of purchased items. Examples are:

N: Non-stock item

P: Purchased raw material

30.1.60.2 Category Code of FG

Category Code of finished goods

Specify the category codes that you set up to identify finished goods.

30.1.60.3 Principle Inputs

Percentage above which Input will be Principle Input

Specify the percentage of the principal inputs used in the manufacture of finished goods. Enter the decimal number of the value. For example, if the value is 42.5 percent enter 42.5.

Transaction type 1 for Principle inputs receipt

Specify a user-defined code from the UDC table 00/DT that identifies the document type assigned to receipts for the principal inputs.

Cost Method

Specify a user-defined code from the UDC table 40/CM that specifies the basis for calculating the cost of items in the work order. Values are:

01: Last In

02:Weighted Average

03: Memo

04: Current

05: Future

06: Lot

07: Standard

08: Purchasing-Base Cost No Adds

09: Manufacturing Last Cost

30.1.60.4 Consumed Quantity

Transaction Type for Consumed quantity of Principle Input

Specify a user-defined code from the UDC table 00/DT that identifies the document type assigned to the quantity of principal inputs consumed.

Transaction Type for Component Scrap if used

Specify a user-defined code from the UDC table 00/DT that identifies the document type assigned to scrap components in the principal inputs used for the manufacture of finished goods.

30.1.60.5 Home Consumption

Transaction Type for Home Consumption or Export

Specify a user-defined code from the UDC table 00/DT that identifies the document type assigned to principal inputs that are used internally or for export.

30.1.60.6 Scrap Quantity for Manufactured Items

Transaction Type for Scrap

Specify a user-defined code from the UDC table 00/DT that identifies the document type that is assigned to scrap items in the manufacture of finished goods.

Sub - assemblies Cleared/Destroyed

Specify whether the scrap items from manufactured goods in subassemblies were cleared. The system calculates and displays the value of the scrap items in the report. Values are:

C: Cleared

D: Destroyed

FG Item Cleared/Destroyed

Specify whether the scrap items from finished goods were cleared. The system calculates and displays the value of the scrap items in the report. Values are:

C: Cleared

D: Destroyed

30.1.60.7 Scrap Quantity for Part List

Percent Scrap Cleared/Destroyed

Specify whether the scrap items from the parts list were cleared. The system calculates and displays the value of the scrap items in the report. Values are:

C: Cleared

D: Destroyed

Operational Scrap Percent Cleared/Destroyed

Specify whether the operational scrap items from the parts list were cleared or destroyed. Values are:

C: Cleared

D: Destroyed

30.1.60.8 Quantity for Component Scrap

Transaction Type for Component Scrap

Specify a user-defined code from the UDC table 00/DT that identifies the document type that is assigned to scrap component items.

Component Scrap Cleared/Destroyed

Specify whether the component scrap items were cleared. The system calculates and displays the value of the scrap items in the report. Values are:

C: Cleared

D: Destroyed

30.1.61 R75I450 – Service Tax Credit Detail

This report prints detailed information about the tax credits for service tax, such as payment date, document number, document type, tax type, and service category. You must group the data by address number, tax type, and service category before you run this report.

When you run the Service Tax Credit detail program, this report includes A/P service tax credit for all vouchers whether or not you have made payments for those. If you do not make payments for these vouchers within the specified period and the system reverses the tax credit, this report also displays the reversion records.

30.1.62 Processing Options for Service Tax Credit Detail (R75I450)

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

30.1.62.1 General

Date - From

Specify the date on which a payment or a receipt was entered. In the JD Edwards EnterpriseOne Accounts Payable system, the system uses the manual payment date and the general ledger date to post the payments. The system also uses this date to retrieve the exchange rate for foreign payments from the Currency Exchange Rates table (F0015). In the JD Edwards EnterpriseOne Accounts Receivable system, the system uses the receipt date for information or reporting purposes only.


Note:

Receipt date is the date on the check or the date the you enter the receipt into the system.

Date - Thru

Specify the date on which a payment or a receipt was entered. In the JD Edwards EnterpriseOne Accounts Payable system, the system uses the manual payment date and the general ledger date to post the payments. The system also uses this date to retrieve the exchange rate for foreign payments from the Currency Exchange Rates table (F0015). In the JD Edwards EnterpriseOne Accounts Receivable system, the system uses the receipt date for information or reporting purposes only.


Note:

Receipt date is the date on the check or the date the you enter the receipt into the system.

30.1.63 R75I627 – Form 27D- Certificate for collection of TCS

Run the Form 27D- Certificate for collection of TCS program to print Form 27D, suppliers require to submit to the customers after collecting the tax on various transactions. You can use this program to print the tax collected at source (TCS) certificate in the summary or detailed format. This report displays various sections on the TCS certificate, which are:

  • Summary of Payment: This section displays the amount of payment, nature of payment, and the date the payment is received. However, when you run this report in the Summary format, the system displays only the total amount in this section and lists the payment details categorized by challan numbers in the Annexure section. This report reads from the TCS Prepayment to Tax authority (F75I612) and TCS Payment Details (F75I604) tables. The system categorizes this section on the basis of item collection code.

  • Summary of tax deducted at source in respect of Deductee: This section displays the receipt numbers and amounts of tax deducted and remitted based on each deductee. The system categorizes this section on the basis of receipt number.

  • Details of tax deducted and deposited in the central government account through challan: This section displays the details of the TCS and the bank where the supplier deposits the TCS. The system categorizes this section on the basis of challan number.

Other than these sections, the system displays a Verification section that displays details of the person signing the TCS certificate.

When you run the Form 27D- Certificate for collection of TCS report in Summary mode, it displays the dates of transactions in the Annexure section. The report does not display any date details in the Summary of Payment section.

30.1.64 Processing Options for Form 27D- Certificate for collection of TCS (R75I627)

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

30.1.64.1 Default

Company

Enter the address book number of the company for which you generate the report.

Customer Number

Specify an address book number for a customer.

Annexure (Y/N)Y - Summary of transactions will be printed in the ”summary of receipts section”, detail lines of transactions will be printed in the annexure.N / Else - Detail lines of transactions will be printed in the ”summary of receipts section", annexure will not be printed.

Specify whether you want the details of transactions in the annexure printed at the bottom of the report. Values are:

Y: The system prints the summary of the transactions in the Summary of Payment section of the report, and prints the corresponding details in the Annexure at the bottom of the report.

N: The system prints the details in the Summary of Payment section. The system does not print any annexure.

Nature of receipt

Specify the collection code of the item for TCS for which you want to print the 27D form.

If you leave this option blank, the system prints the 27D form for all items valid for the company for the specified period.

30.1.64.2 Processing

Month/Quarter/Year Processing
M - Month
Q - Quarter
Y - Year

Specify whether to generate the TCS certificate monthly, quarterly, or yearly. Values are:

M: Month

Q: Quarter

Y: Year

Enter Month (If monthly processing)
Range 1 - 12

Specify the numeric value for the month for which you want to run the report. For example, enter 1 for January.

Enter Quarter (Only for Quarterly processing)
Range 1 - 12

Specify the roman value for the quarter for which you want to run the report.

Assessment Year
Enter the year for which the ube should run.
Eg. If Year entered is 2009, Month entered is 1 then data of January 2010 will be processed.

Specify the year for which you want to run the report. This is the assessment year.

For example, if you specify M as the type of processing, the month as 1, and the year as 2011, the report prints details for January 2011. If you enter the month as 5 in the above example, the report prints details for May 2010. However, if you specify Y as the type of processing and specify the year as 2011, then the system runs the report for the period from April 2010 through March 2011.

In all these cases, the system displays the assessment year on the report as 2011-2012.

30.1.64.3 Signing Authority

Address Number of Person Signing

Specify the address number of the person signing the TCS certificate.

Parent Name

Specify the parent name of the person signing the TCS certificate.

Place

Specify the city where the person is signing the TCS certificate.

Designation

Specify the designation of the person signing the TCS certificate.


Note:

The system displays the details specified on the Signing Authority tab in the Verification section of the report.

30.1.65 R75I628 – Annual Return of TCS

This report prints the statutory forms Form 27E and Form 27B. These forms display the TCS collected from the buyer and paid to the tax authority. The Form 27E is a detailed form and Form 27B is a summary form. You must submit these forms to the tax authorities on an annual basis to report the tax collected by the seller. This program prints the Form 27B in a PDF format and produces a flat file in an ASCII format that contains all the information that exists in the Form 27E. You must submit the Form 27B (in a hard-copy format) and the flat file for Form 27E through the File Validation Utility (FVU) application, which is owned by the government. The FVU application also validates the e-TCS report.


Note:

JD Edwards EnterpriseOne software does not provide the FVU application.

30.1.66 Processing Options for Annual Return of TCS (R75I628)

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

30.1.66.1 Default

1. Enter Company (seller) which is responsible for collection of tax.

Specify a value that identifies a specific organization, fund, or other reporting entity. The company code exists in the Company Constants table (F0010).

2. Address Number of the person responsible for collection of tax.

Specify the address book number of the person responsible for the tax collection. The address book number that you enter must exist in the JD Edwards EnterpriseOne Address Book system. Examples include employee, participant, customer, supplier.

3. Designation of person responsible for collection of tax.

Specify the designation of the tax authority officer authenticating the document. For example, enter finance manager.

4. Has address of seller changed since last return.

Specify whether the address of the seller has changed since the submission of the last return to the tax authority. Values are:

Y: Yes

N: No

5. Other Information for Form 27B

Specify any additional information to be printed on Form 27B.

30.1.66.2 Dates

Date of Furnishing Tax Collection Certificate (Form 27D).

Specify the date on which the tax collection certificate (Form 27D) must be submitted to the tax authorities. For example, enter 03/01/2006.

Financial Year Ending Date

Specify the end date of the financial year. For example, enter 03/31/2007.

30.1.66.3 Flat File

1. Enter Flat file path.

Specify the path that identifies the target location of a file set. For example, enter C:\abc.txt.

2. Enter Upload Type

Specify the type of return submitted to the tax authority. Values are:

R: Regular return (default value)

C: Revised return

The regular return is a statutory document that must be submitted to the tax authority on an annual basis. If you make any changes to the regular return, you must submit a revised return to the tax authority as a statutory requirement.

Enter Provisional Receipt number of regular return. (If entered 'C' in the upload type)

Specify the provisional receipt number. You must enter a provisional receipt number if you submit a revised return; that is, if you have entered a C in the Upload Type processing option.

30.1.67 R75I629 – Form 27EQ - Quarterly Return of TCS

This report prints the statutory form (Form 27EQ). You must submit Form 27EQ to the tax authorities on an quarterly basis to report the tax collected by the seller. This report displays the details of the TCS collected and paid to the tax authority for the amount received from the customer. This program generates a report in a PDF format and a flat file in the ASCII format that contains all of the information that exists in the report. You can submit this flat file through version 3.6 of the File Validation Utility (FVU) application, which is owned by the government. The FVU application also validates the e-TCS report.


Note:

JD Edwards EnterpriseOne software does not provide the FVU application.

30.1.68 Processing Options for Form 27EQ - Quarterly Return of TCS (R75I629)

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

30.1.68.1 Default

1. Enter Company (collector) which is responsible for collection of tax.

Specify a value that identifies a specific organization, fund, or other reporting entity. The company code exists in the Company Constants table (F0010).

2. Address Number of the person responsible for collection of tax.

Specify the address book number of the person responsible for the collection of tax. The address book number that you enter must exist in the JD Edwards EnterpriseOne Address Book system. Examples include employee, participant, customer, and supplier.

3. Designation of person responsible for collection of tax.

Specify the designation of the tax authority officer authenticating the document. For example, enter finance manager.

4. Has Address of collector changed since last return.

Specify whether the address of the collector has changed since the submission of the last return to the tax authority. Values are:

Y: Yes

N: No

5. Has Address of Person Responsible for collection of tax changed since last return.

Specify whether the address of the person responsible for the collection of tax has changed since the submission of the last return to the tax authority. Values are:

Y: Yes

N: No

6. Deductor Type

Enter a value from the Deductor Type 75I/DE UDC table. Examples of values are:

A: Central government

S: State government

7. Last Deductor Type

Enter a value from the Deductor Type (75I/DE) UDC table to specify the last statement accepted at the central system for a correction format. Examples of values are:

A: Central government

K: Company

S: State government

8. PAO Code (pay and accounts office code)

Enter the PAO code.

9. DDO Code (drawing and disbursing officer code)

Enter the DDO code.

10. Ministry Name

Enter a value from the Ministry Name 75I/MN UDC table to specify the code for the ministry. Examples of values are:

01: Agriculture

02: Atomic Energy

03: Fertilizers

11. Ministry Name Other

If you entered the code 99 (other) in the Ministry Name field, enter the ministry name.

12. PAO Registration No (pay and accounts office registration number)

Enter the PAO registration number.

13. DDO Registration No (drawing and disbursing officer registration number)

Enter the DDO registration number.

14. Last Transfer Voucher No

Leave this processing option blank for regular reports (non-correction reports.) If this is a correction report, enter the transfer voucher number for the previous report for transaction types C2, C3, and C5.

Leave this processing option blank for transaction types C1, C9, and Y for correction reports.

15. Transfer Voucher No

For regular reports (non-correction reports) that are not nil challen reports, enter the transfer voucher number if the value in the Deductor Type field in the header records is A (Central government) or S (State government).

If this is a correction report and the transaction type is C2 and the value in the Deductor Type field in the header records is A (Central government) or S (State government), enter the transfer voucher number for this report.

If this is a correction report and the transaction type is C3, the value in the Deductor Type field in the header records is A (Central government) or S (State government), and the value in the Challan Updation Indicator processing option is 1, enter the transfer voucher number for this report.

If the value in the Challan Updation Indicator processing option is 0, enter the number from the Last Transfer Voucher No processing option.

If this is a correction report and the transaction type is C1, C5, or Y, leave this processing option blank. If this is a correction report and the transaction type is C9, and the value in the Deductor Type field in the header records is A (Central government) or S (State government), enter the transfer voucher number for this report, except when a nil challan exists. If a nil challen exists for type C9, leave this processing option blank.

16. Account Office ID Number of PAO/TO/CDDO (Release 9.1 Update)

Accounts Officer Identification Number (AIN) is a seven-digit unique identification number issued by the Directorate of Income Tax (Systems) Delhi to each Accounts Officer (AO).

If the deductor category is the Central Government or the State Government, the AIN of the following should be reported for every type of deduction/collection, that is, TDS-Salary/TDS Non-Salary/TDS-Non Salary Non-Residents/TCS:

  • Pay and Account Office (PAO)

  • Treasure Office (TO)

  • Cheque Drawing and Disbursing Officer (CDDO)

17. Section Code (Release 9.1 Update)

Enter a user-defined code from UDC table 75I/TC. Examples are:

A: Alcoholic liquor for human consumption

B: Timber obtained under forest lease

C: Timber obtained under any mode other than forest lease

18. Minor Head Code (Release 9.1 Update)

Enter a user-defined code from UDC table 75I/MH. Values are:

200: TDS payable by taxpayer

400: TDS regular assessment (Raised by IT Department)

30.1.68.2 Dates

Financial Year

Specify the financial year for which you want to run the report. If you enter the financial year as 2006, then the report takes the data from 1st April 2005 to 31st March 2006.

Fiscal Quarter Number

Specify the fiscal year quarter number. Values are:

1: Displays data from 1st April to 31st June for the financial year entered

2: Displays data from 1st July to 31st September for the financial year entered

3: Displays data from 1st October to 31st December for the financial year entered

4: Displays data from 1st January to 31st March for the financial year entered

If you enter the financial year as 2006 and select the quarter number as 1, then the report displays records from 1st April 2005 to 31st June 2005. Similarly, to display records for the last quarter of the fiscal year 2005-2006, you must enter 2006 in the Financial Year processing option and 4 in the Fiscal Quarter Number processing option.

30.1.68.3 Flat File

1. Enter Flat file path.

Specify the path that identifies the target location of a file set. For example, enter C:\abc.txt.

2. Enter Upload Type

Specify the type of return submitted to the tax authority. Values are:

R: Regular return (default value)

C: Revised return

The regular return is a statutory document that must be submitted to the tax authority on an annual basis. If you make any changes to the regular return, you must submit a revised return to the tax authority as a statutory requirement.

Enter Provisional Receipt number of regular return. (If entered 'C' in the upload type)

Specify the provisional receipt number. You must enter a provisional receipt number if you submit a revised return; that is, if you have entered a C in the Upload Type processing option.

4. Name of Return Preparation Utility

Enter the name of the software that you use to prepare the quarterly TDS statement. For example, you can enter JD Edwards EnterpriseOne.

30.1.68.4 Correction Format Info

You complete these processing options for correction reports only.

Transaction Type

Enter the code for the type of correction. Leave this processing option blank if this is not a correction report. Values are:

C1: Correction in deductor details (excluding TAN)

C2: Correction in deductor (excluding TAN) or challan details

C3: Correction in deductor (excluding TAN), challan, or deductee details

C5: Correction in PAN of deductees

C9: Correction in challan (addition of challan)

Y: Cancellation of statement

Batch Updation Indicator

Enter 1 if updates exist in the batch header other than the TAN and the transaction type is C2 or C3. Otherwise, enter 0.

Mode

Enter the mode for transaction types C3 and C9. Leave this processing option blank for transaction types C1, C2, and C5. Values are:

A: New deductee record is added for transaction type C3

D: Existing party detail record is deleted for transaction type C3

U: Existing party details record is updated (changed) for transaction type C3

O: Used for transaction type C9

Original RRR Number

Specify the Provisional Receipt Number (PRN) of the corresponding regular statement.

Previous RRR Number

Specify the Original RRR number (PRN of the corresponding regular statement) if no previous correction statement was provided.

Specify the PRN of the last correction statement if a previous correction statement was provided.

Last TAN of Collector

Enter the same TAN of the collector that is included in the corresponding regular statement accepted by the TIN central system.

Collector's Branch/ Division

For transaction types C1, enter the deductor's branch and division.

For transaction types C2 and C3, enter the deductor's branch and division if you entered 1 in the Batch Updation Indicator processing option. If the value in the Batch Updation Indicator processing option is 0 for transactions types C2 and C3, leave this processing option blank.

For transaction types C5, C9, and Y, leave this processing option blank.

Challan Updation Indicator

For transaction type C3, enter 1 if there are changes in the challan details. Otherwise, enter 0 for transaction type C3. For all other situations, leave this processing option blank.

Last Bank Challan No

For transaction types C2, C3, and C5, enter the Bank Challan Number specified in the corresponding regular or last correction statement. A value is required in this processing option if the book entry flag or the nil challan indicator is N.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Bank Branch Code

For transaction types C2, C3, and C5, enter the bank branch code (BSR code) mentioned in the corresponding regular or last correction statement. A value is required in this processing option if the book entry flag or the nil challan indicator is N.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Bank Challan Date

For transaction types C2, C3, and C5, enter the date of the Bank Challan Number or date of the Transfer Voucher Number included in the corresponding regular or last correction statement.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Total of Deposit Amount

For transaction types C2, C3, and C5, enter the value from the Total of Deposit Amount as per Challan of the corresponding regular or last correction statement. You must provide this value.

Leave this processing option blank for transaction types C1, C9, and Y.

Last Collectee/Party PAN

For transaction type C3, enter the value from the regular statement or the last correction statement if the mode is D or U.

If the mode for transaction type C3 is A, or if the transaction type is C1, C2, C5, C9, or Y, leave this processing option blank.

Deductee Ref. No. / PAN Reference Number

For transaction type C3, enter the PAN reference number. If the mode is D, the value is the same as the value that you enter in Last Collectee / Party PAN Ref. No. processing option.

Leave this processing option blank for transaction types other than C3.


Note:

The PAN Reference Number is a unique identifier to identify a party when the PAN is not available. The collector quotes the PAN reference number.

Last Collectee/Party PAN Ref No

For transaction type C3, if the mode is D or U, enter the value specified in the regular statement or the last correction statement.

If the mode for transaction type C3 is A, or if the transaction type is C1, C2, C5, C9, or Y, leave this processing option blank.

Last Total Income Tax Collected at Source

For transaction type C3, if the mode is D or U, enter the value of the total income tax collected at source (income tax + surcharge + cess) as specified in the corresponding regular statement or the last correction statement. Leave this processing option blank if the mode is A.

For transaction type C5, enter the value of total income tax collected at source (income tax + surcharge + cess) as specified in corresponding regular statement or the last correction statement.

Leave this processing option blank if the transaction type is C1, C2, C9, or Y.

Last Total Tax Deposited

For transaction type C3, if the mode is D or U, enter the value of the total tax deposited as specified in the regular statement or the last correction statement. Leave this processing option blank if the mode is A.

For transaction type C5, enter the value of the total tax deposited as specified in the corresponding regular statement or the last correction statement.

Leave this processing option blank if the transaction type is C1, C2, C9, or Y.

Reason for non-collection

For transaction type C3, if the mode is A, enter A if a lesser deduction amount or no deduction exists due to a certificate under section 197, or enter B if there is no deduction due to a declaration under section 197A. Leave this processing option blank for all other modes.

For transaction type C9, enter A if a lesser deduction amount or no deduction exists due to a certificate under section 197, or enter B if there is no deduction due to a declaration under section 197A.

Leave this processing option blank if the transaction type is C1, C2, C5, or Y.

Certificate Number for Non-Deduction/Lower Deduction (Release 9.1 Update)

Enter the certificate number that is issued by the Assessing Officer under section code 197 for non-deduction/lower deduction.

Whether regular statement for Form27EQ has been filed for an earlier period?
Y - Regular statement has been filed for earlier period.
N - Regular statement has not been filed for earlier period.

Enter a value depending on the Regular Statement field value, whether filed on an earlier period for Form 27EQ. Values are:

Y: If a regular statement has been filed for an earlier period

N: If a regular statement has not been filed for an earlier period

30.1.69 R75I2212 – VAT -O2C - Detail/Summary Report

This report prints a list of the sales orders applicable for VAT. It prints the sales tax for a specific business unit and customer number.

You can run this report in the detail format or the summary format by setting the processing option. The detail report prints the extended price and the tax details for a specific business unit, customer number and item. The summary report prints the total extended price and tax summary of a business unit.

30.1.70 Processing Options for VAT -O2C - Detail/Summary Report (R75I2212)

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

30.1.70.1 Display

Date Period Begin

Specify the start date of the period for which to run the report.

Date Period End

Specify the end date of the period for which to run the report.

Detail/Summary

Specify whether the system prints the report in summary or detail format. Values are:

Blank: Print the report in summary format.

1: Print the report in detail format

30.1.71 R75I2218 – Reversed Sale Orders Detail

This report prints a list of sales orders that have been reversed. The report prints orders for which the document type is either CO or a value that the user defines when creating the credit orders.

30.1.72 Processing Options for Reversed Sale Orders Detail (R75I2218)

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

30.1.72.1 Display

Document Type for Credit Sales Orders

Specify the document type to use for credit sales orders from UDC table 00/DT. The document type identifies the origin and purpose of the transaction. Examples are:

P: Accounts payable

R: Accounts receivable

VAT / CST

Specify whether to print VAT sales orders or CST sales orders. Values are:

0: VAT sales orders

1: CST sales orders

30.1.73 R75I2219 – Exempted Item Details for Sales

This report prints the sales details for items that are exempt from VAT.

Before you run this report, you must use the Item Category Relationship program (P75I2140) to specify the category code for items that are exempted from VAT.

30.1.74 Processing Options for Exempted Item Details for Sales (R75I2219)

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

30.1.74.1 Exempted Item Details

Enter 1 to view Exempted Item Details For Sales from F4211 - IND

Specify whether to process the report for current sales order transactions or for closed sales order transactions. Values are:

0: List the current sales order details from the F4211 table.

1: List the closed sales order details from the F42119 table.

Beginning Invoice Date

Specify the start date of the period for which to print a list of invoices.

Ending Invoice Date

Specify the end date of the period for which to print a list of invoices.

30.1.75 R75I2221 – Trading Item Sales

This report prints the total sales amount of the trading transactions. VAT is not charged on trading items. You must set the VAT category code to T (trading item) in the Item Category Relationship program (P75I2140).

30.1.76 Processing Options for Trading Item Sales (R75I2221)

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

30.1.76.1 Default

Sales Order History Data

Specify whether to print the current sales order transactions or the closed sales order transactions. Values are:

0: Print current sales order transactions from the F4211 table.

1: Print closed sales order transactions from the F42119 table.

Date Period Begin

Specify the start date of the period for which to print a list of invoices.

Date Period End

Specify the end date of the period for which to print a list of invoices.

30.1.77 R75I2222 – Void Voucher Report

This report prints information about voided transactions.

30.1.78 Processing Options for Void Voucher Report (R75I2222)

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

30.1.78.1 Default

Date Period Begin

Specify the start date of the period for which to print the list of vouchers.

Date Period End

Specify the end date of the period for which to print the list of vouchers.

30.1.79 R75I2231 – VAT -Purchase Tax Summary / Details

This report prints a list of the purchase orders for companies and business units for a specific period. The summary report prints the price and the tax amounts based on the VAT percentage. The detail report prints the invoice and tax details for each purchase order for which VAT is applicable.

30.1.80 Processing Options for VAT -Purchase Tax Summary / Details (R75I2231)

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

30.1.80.1 Default

SUMMARY/ DETAIL

Specify whether to print the report in detail or summary format. Values are:

Blank: Print the report in summary format. The system prints the price and the tax amounts based on the VAT percentage.

1: Print the report in detail format. The system prints invoice and tax details for each purchase order that is applicable for VAT.

Date Period Begin

Specify the start date of the period for which to print the list of vouchers.

Date Period End

Specify the end date of the period for which to print the list of vouchers.

30.1.81 R75I2236 – Reversed Purchase Orders Details

This report prints a list of purchase orders with reversed vouchers.

30.1.82 Processing Options for Reversed Purchase Orders Details (R75I2236)

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

30.1.82.1 Display

0=VAT 1=CST

Specify whether to print the reversed purchase orders of either VAT or CST. Values are:

0: Print the reversed purchase orders of VAT.

1: Print the reversed purchase orders of CST.

PO Reversed - From Date

Specify the start date of the period for which to print the reversed purchase orders.

PO Reversed - To Date

Specify the end date of the period for which to print the reversed purchase orders.

30.1.83 R75I2237 – Exempted Items Details

This report prints a list of purchase orders for items that are exempted from VAT. You must set the VAT category code to X (exempted items) in the Item Category Relationship program (P75I2140).

30.1.84 Processing Options for Exempted Items Details (R75I2237)

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

30.1.84.1 Default

From Date

Specify the start date of the period for which to print the purchase orders.

To Date

Specify the end date of the period for which to print the purchase orders.

30.1.85 R75I2240 – Purchase against Trading Items

This report prints a list of purchase orders for items used for trade. The trading items are not liable for tax.

30.1.86 Processing Options for Purchase against Trading Items (R75I2240)

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

30.1.86.1 Default

From Date

Specify the start date of the period to print the list of purchase orders.

To Date

Specify the end date of the period to print the list of purchase orders.

30.1.87 R75I2242 – Reconciliation Report - VAT/CST Receivables

Print this report to compare the VAT details in the WorkFile for VAT/CST Receivables table (F75I2241) and Sales Form Information table (F75I401) with the tax details in the F0911 table.

When a sales order is created and the sales update processed for an item applicable for VAT or CST, the VAT or CST is calculated and updated in the general ledger. The Reconciliation Report - VAT/CST Receivables report displays the tax amount from the general ledger, and the VAT details from the JD Edwards EnterpriseOne Accounts Receivables system.

30.1.88 Processing Options for Reconciliation Report - VAT/CST Receivables (R75I2242)

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

30.1.88.1 Default

Date Period Begin

Specify the start date of the period to run the batch program.

Date Period End

Specify the end date of the period to run the batch program.

VAT/CST

Specify whether to compare the VAT or the CST information. Values are:

0: VAT

1: CST

30.1.89 R75I3906 — Print 57F(4) Challan

This report prints the 57F(4) challan details of a particular business unit, which is a statutory requirement.

30.1.90 Setting Processing Options for Print 57F(4) Challan (R75I3906)

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

30.1.90.1 Select

Challan Number Form 57F (4)

Specify the challan number for form 57F(4).

Business Unit

Specify a code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant.

You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.

Place

Specify the location of the authorized signatory.

Date

Specify the date to print the 57F(4) challan. If you leave this processing option blank, the system prints the challan for the current date.

30.1.91 R75I3907 — Print 57F4 Register

This report prints the details of partially processed goods that are required to be reported on the challan under rule 57F(4) for a particular excise unit.

30.1.92 Setting Processing Options for Print 57F4 Register (R75I3907)

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

30.1.92.1 Select

Excise Unit

Specify the address number of the excise unit.

Business Unit

Specify a code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant.

You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.

From Date and To Date

Specify the date range to print the 57F(4) register. Enter the date in the dd/mm/yy format.

30.1.93 R75I3908 — Print Sub Contract Challan

This report prints the same information as the Print 57F(4) Challan (R75I3906), but prints it in a different format

30.1.94 Setting Processing Options for Print Sub Contract Challan (R75I3908)

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

30.1.94.1 Select

Challan Number Form 57F (4)

Specify the challan number for form 57F(4).

Business Unit

Specify a code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant.

You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.

Place

Specify the location of the authorized signatory.

Date

Specify a date for printing the 57F(4) challan. If you leave this processing option blank, the system prints the challan using the current date.

Order Company (Order Number)-4311

Enter the company number of the order company that generates the purchase order.

30.1.95 R75I4214 – Sales Tax - Concessional Form Status (With Form Code) Report

This report prints the details of invoices received with concession forms and without concession forms, for the selected business unit. You use this report to produce a list of the customers from whom you have not received the concession forms so that you can send a reminder that the form is due.

30.1.96 Processing Options for Sales Tax - Concessional Form Status (With Form Code) Report (R75I4214)

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

30.1.96.1 Default

Form Type

Specify a user-defined code from the UDC table 75I/FS, which identifies the form type for sales tax concession. Examples are:

C: Form C

D: Form D

E I: Form E I

E II: Form E II

F: Form F

H: Form H

From Date

Specify the beginning of the range of dates from which the system prints the invoices received with forms.

To Date

Specify the end of the range of dates from which the system prints the invoices received with forms.

30.1.97 R75I4220 – Sales Register

This report prints a list of invoices with details of the sales tax and adjustment types that are applicable to all the business units.

30.1.98 Processing Options for Sales Register (R75I4220)

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

30.1.98.1 Display

Date Period Begin

Specify the beginning of the range of dates from which the system prints the invoices.

Date Period End

Specify the end of the range of dates from which the system prints the invoices.

Report Title

Specify the title for report heading.

30.1.99 R75I4223 – Sales Tax Summary/Detail

This report prints the details of sales tax for the item and business unit for a specific period.

The summary report prints the total extended price and tax summary and the detailed report prints the total extended price and tax summary, and invoice details.

30.1.100 Processing Options for Sales Tax Summary/Detail (R75I4223)

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

30.1.100.1 Select

Summary/Detail

Specify whether the system prints the report in detail or summary format. Values are:

Blank: Prints in summary format. The system prints the total extended price and tax summary for a business unit.

1: Prints in detail format. The system prints the total extended price, tax details, and invoice details for a business unit.

Report Title

Specify the title for report heading.

Date Period Begin

Specify the beginning of the range of dates from which the system prints the sales tax details.

Date Period End

Specify the end of the range of dates from which the system prints the sales tax details.

Sales Reporting Code that is to be considered as Item Group

Specify a user-defined code from the UDC table 41/CC that indicates the item group. Examples are:

PRP0: Item Pool

PRP1: Commodity Class

PRP2: Commodity Sub Class

PRP3: Supplier Rebate Code

SRP3: Sales Category 3

SRP4: Sales Category 4

30.1.101 R75I4232 – Purchase Tax Exception Report

This report prints purchase orders with reversed vouchers. You run this report to compare the purchase order records in the Purchase Tax Form Details table (F75I402) to the reversed or deleted voucher records in the F43121 table. The system identifies records with a status of 3 in the Match Type field in the F43121 table as reversed or deleted voucher records.

30.1.102 Processing Options for Purchase Tax Exception Report (R75I4232)

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

30.1.102.1 Update

Proof / Final mode

Specify the mode to print the list of purchase orders with reversed vouchers. Values are:

0: Proof mode. The system prints a list of purchase order records that have reversed vouchers in the F43121 table.

1: Final mode. The system prints the report and deletes the purchase order records in the F75I402 table when the corresponding vouchers are reversed in the F43121 table.

30.1.103 R75I4233 – Vouchers for which Form issued

This report prints vouchers received with concession forms.

30.1.104 Processing Options for Vouchers for which Form issued (R75I4233)

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

30.1.104.1 General

Form Type

Specify a user-defined code from the UDC table 75I/FS that identifies the form type for purchase tax concession. Examples are:

C: Form C

D: Form D

E I: Form E I

E II: Form E II

F: Form F

H: Form H

Date Period Begin

Specify the beginning of the range of dates from which the system prints the vouchers received with forms.

Date Period End

Specify the end of the range of dates from which the system prints the vouchers received with forms.

30.1.105 R75I4234 – Forms outstanding - Detail

This report prints vouchers with pending concession forms.

30.1.106 Processing Options for Forms outstanding - Detail (R75I4234)

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

30.1.106.1 General

Form Type

Specify a user-defined code from the UDC table 75I/FS that identifies the form type for purchase tax concession. Examples are:

C: Form C

D: Form D

E I: Form E I

E II: Form E II

F: Form F

H: Form H

Date Period Begin

Specify the beginning of the range of dates from which the system prints the vouchers with pending forms.

Date Period End

Specify the end of the range of dates from which the system prints the vouchers with pending forms.