This chapter contains the following topics:
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)
These reports exist for India for excise tax:
These reports exist for India for service tax:
These reports exist for India for VAT:
These reports exist for India for sales tax:
These reports exist for India for purchase tax:
These reports exist for India for TCS:
These reports exist for India for TDS:
These reports exist for India for WCT:
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).
Processing options enable you to specify default processing for programs and reports.
Enter 1 to print the exchange rate on the purchase order.
Specify a user-defined code from the UDC table 40/PM to print a message on the purchase order.
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.
Enter 1 to suppress the printing of the report title and company name.
Enter 1 to print the name of the purchasing agent on the purchase order.
Enter 1 to suppress the printing of the tax registration details and the tax components from the landed cost setup.
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.
Processing options enable you to specify default processing for programs and reports.
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. |
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
Specify a date range for which the tax rate is effective.
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.
Processing options enable you to specify default processing for programs and reports.
Specify the date range for which the tax rate is effective.
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. |
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
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.
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
Specify whether to print the heading of the Certificate of Tax report.
Y: Yes
N: No
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.
Processing options enable you to specify the default processing for programs and reports.
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
Specify the date that the TDS certificate was issued by the tax authorities.
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. |
Specify whether to print the header of the Register to be Maintained report. Values are:
Y: Yes
N: No
Run this report to consolidate the tax deducted for the suppliers every month. Companies must submit this report to the income tax department.
Processing options enable you to specify default processing for programs and reports.
Specify the date range for which the tax rate is effective.
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. |
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
Specify whether to print the header of the Monthly Statement of Tax report. Values are:
Y: Yes
N: No
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.
Processing options enable you to specify default processing for programs and reports.
Specify company of the deductor responsible for deducting TDS. This is the parent company that has the permanent account number.
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. |
Specify the year for which you want to generate an eTDS report. For example, enter 2009 for fiscal year 2008-2009.
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.
Specify the address book number of the person who is responsible for deducting taxes at source.
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.
Specify whether a statement was filed earlier for this quarter. Values are:
Y: A statement was filed earlier.
N: No statement was filed earlier.
Specify the designation of the person who is responsible for deducting tax at source, for example, a manager or financial officer.
Enter the name of the software that you use to prepare the quarterly TDS statement. For example, you can enter JD Edwards EnterpriseOne.
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
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.
Specify the provisional receipt number that you want to use if income tax returns need to be corrected.
Enter a value from the Deductor Type 75I/DE UDC table. Examples of values are:
A: Central Government
S: State government
Specify if there is a change of address of the tax-deducting authority. Values are:
Y: Address has changed
N: Address has not changed
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.
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
Enter the PAO code.
Enter the PAO registration number.
Enter the DDO code.
Enter the DDO registration number.
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
If you entered the code 99 (other) in the Ministry Name processing option, enter the ministry name.
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.
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.
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)
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)
Specify a user-defined code from UDC table 75I/GT that identifies the tax type or interest type.
You complete these processing options for correction reports only.
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
Enter 1 if updates exist in the batch header other than the TAN and the transaction type is C2 or C3. Otherwise, enter 0.
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.
Specify the Provisional Receipt Number (PRN) of the corresponding regular statement.
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.
Enter the same TAN of the collector included in corresponding regular statement accepted by the TIN central system.
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.
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.
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.
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.
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.
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.
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.
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. |
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.
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.
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.
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.
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
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.
Processing options enable you to specify default processing for programs and reports.
Specify the company of the person who is responsible for deducting TDS. This is the parent company that has the PAN.
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. |
Specify the year for which you want to generate an eTDS report. Example, enter 2006 for fiscal year 2005-2006.
Specify a code that designates the type of form. Values are:
1: Form 26
0: Form 27
Specify the address book number of the person who is responsible for deducting the tax at source.
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.
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
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.
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.
Specify the code that designates the form type. Values are:
R: Regular
C: Corrected
Specify the provisional receipt number that you want to use if income tax returns need to be corrected.
Specify whether the person responsible for deducting taxes is a government representative. Values are:
C: Government deductor
O: Nongovernment deductor
Processing options enable you to specify default processing for programs and reports.
Specify the company of the person who is responsible for deducting TDS. This is the parent company that has the PAN.
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. |
Specify the year for which you want to generate an eTDS report. For example, you might enter 2006 for fiscal year 2005-2006.
Specify which form you want to print. Values are:
1: Form 26
0: Form 27
Specify the provisional receipt number that you want to use if income tax returns need to be corrected.
Specify an address book number for the 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.
Specify whether the person responsible for deducting taxes is a government representative. Values are:
C: Government deductor
0: Others
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.
Processing options enable you to specify default processing for programs and reports.
Specify the company of the person responsible for deducting TDS. This is the parent company with a PAN.
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. |
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.
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.
Specify the address book number of the person who is responsible for deducting taxes at source.
Specify the path for the flat file. For example, you enter C:\TDS\File\. The system saves the flat file to the specified location.
Specify whether a statement was filed earlier for this quarter. Values are:
Y: A statement was filed earlier.
N: No statement was filed earlier.
Specify the designation of the person who is responsible for deducting the tax at source; for example, manager or financial officer.
Enter the name of the software that you use to prepare the quarterly TDS statement. For example, you enter JD Edwards EnterpriseOne.
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
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.
Specify the provisional receipt number that you want to use if income tax returns need to be corrected.
Enter a value from the Deductor Type 75I/DE UDC table. Examples of values are:
A: Central government
S: State government
Specify if there is a change of address of the tax-deducting authority. Values are:
Y: Address has changed
N: Address has not changed
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.
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
Enter the PAO code.
Enter the PAO registration number.
Enter the DDO code.
Enter the DDO registration number.
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
If you entered the code 99 (other) in the Ministry Name processing option, enter the ministry name.
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.
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.
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)
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)
Specify a user-defined code from UDC table 75I/GT that identifies the tax type or interest type.
You complete these processing options for correction reports only.
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
Enter 1 if updates exist in the batch header other than the TAN and the transaction type is C2 or C3. Otherwise, enter 0.
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.
Specify the Provisional Receipt Number (PRN) of the corresponding regular statement.
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.
Enter the same TAN of the collector included in corresponding regular statement accepted by the TIN central system.
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.
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.
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.
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.
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.
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.
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.
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. |
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.
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.
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.
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.
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
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.
Processing options enable you to specify default processing for programs and reports.
Specify the number of the month for which you want to run the report. For example, enter 01 for January.
Specify the applicable year.
Specify the number of the business unit for which you want to run the report.
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).
This report prints the tax-deferred information. This report also enables you to review the deferred tax amount.
Processing options enable you to specify default processing for programs and reports.
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).
Processing options enable you to specify default processing for programs and reports.
Specify the address book number of the excise unit.
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.
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.
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.
Processing options enable you to specify default processing for programs and reports.
Specify the number of the month for which you want to print the Annexure 19 report. For example, enter 01 for January.
Specify the year for which you want to print the Annexure 19 report. For example, enter 2010.
Specify the excise unit for which you want to print the Annexure 19 report.
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.
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).
Processing options enable you to specify default processing for programs and reports.
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. |
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. |
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.
Processing options enable you to specify default processing for programs and reports.
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.
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.
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.
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.
Processing options enable you to specify default processing for programs and reports.
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.
Processing options enable you to specify default processing for programs and reports.
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.
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.
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.
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.
Processing options enable you to specify default processing for programs and reports.
This report prints a list of purchase order records with unclaimed CENVAT for the selected business units for a specific period.
Processing options enable you to specify the default processing for programs and reports.
Specify the address number of the excise unit for which the system prints the unclaimed central value-added taxes (CENVAT) report.
Specify the business unit of the excise unit for which you print the unclaimed CENVAT report.
Specify the beginning of the range of dates from which the system prints the unclaimed CENVAT report.
Specify the end of the range of dates from which the system prints the unclaimed CENVAT report.
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.
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.
Processing options enable you to specify default processing for programs and reports.
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)
Processing options enable you to specify default processing for programs and reports.
Specify the excise unit for which to print the Annexure 8 form.
Specify the number of the month for which to print the Annexure 8. For example, enter 01 for January.
Specify the year for which to print the Annexure 8. Enter the year using four digits. For example, enter 2010.
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.
Processing options enable you to specify default processing for programs and reports.
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.
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.
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.
Processing options enable you to specify default processing for programs and reports.
Specify the version of the report to run.
Specify the period for which the report is generated. Values are:
M: Monthly
Q: Quarterly
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
Specify the year for which you run the ER-1 or ER-3 report.
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.
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.
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.
Processing options enable you to specify default processing for programs and reports.
Specify the address number of the excise unit for which to print the Annexure 10.
Specify the year for which to print the Annexure 10. Enter the year using four digits. For example, enter 2010.
Specify the number of the month for which to print the Annexure 10. For example, enter 01 for January.
Specify the type of report to print. Values are:
1: Original
2: Duplicate
3: Triplicate
4: Quadruplicate
Specify the type of journal entry to print on the report. Values are:
D: Only debit
C: Only credit
B: Both entries
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.
Processing options enable you to specify default processing for programs and reports.
Specify the beginning of the range of dates for work orders from which the system prints the ER - 5 report.
Specify the end of the range of dates for work orders from which the system prints the ER - 5 report.
Specify a user-defined code from the UDC table 00/DT that identifies the document type assigned to completed work orders.
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.
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
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
Specify a user-defined code from the UDC table 41/I that identifies the stocking type of phantom items. Examples are:
0: Phantom items
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
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.
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.
Processing options enable you to specify default processing for programs and reports.
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. |
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. |
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.
Specify a user-defined code from the UDC table 00/DT that identifies the document type assigned to completed work orders.
Specify a user-defined code from the UDC table 41/I that identifies the stocking type of phantom items. Example is:
0: Phantom 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
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
Specify the category codes that you set up to identify finished goods.
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.
Specify a user-defined code from the UDC table 00/DT that identifies the document type assigned to receipts for the principal inputs.
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
Specify a user-defined code from the UDC table 00/DT that identifies the document type assigned to the quantity of principal inputs consumed.
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.
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.
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.
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
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
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
Specify whether the operational scrap items from the parts list were cleared or destroyed. Values are:
C: Cleared
D: Destroyed
Specify a user-defined code from the UDC table 00/DT that identifies the document type that is assigned to scrap component items.
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
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.
Processing options enable you to specify default processing for programs and reports.
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. |
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. |
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.
Processing options enable you to specify default processing for programs and reports.
Enter the address book number of the company for which you generate the report.
Specify an address book number for a customer.
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.
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.
Specify whether to generate the TCS certificate monthly, quarterly, or yearly. Values are:
M: Month
Q: Quarter
Y: Year
Specify the numeric value for the month for which you want to run the report. For example, enter 1 for January.
Specify the roman value for the quarter for which you want to run the report.
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.
Specify the address number of the person signing the TCS certificate.
Specify the parent name of the person signing the TCS certificate.
Specify the city where the person is signing the TCS certificate.
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. |
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. |
Processing options enable you to specify default processing for programs and reports.
Specify a value that identifies a specific organization, fund, or other reporting entity. The company code exists in the Company Constants table (F0010).
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.
Specify the designation of the tax authority officer authenticating the document. For example, enter finance manager.
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
Specify any additional information to be printed on Form 27B.
Specify the date on which the tax collection certificate (Form 27D) must be submitted to the tax authorities. For example, enter 03/01/2006.
Specify the end date of the financial year. For example, enter 03/31/2007.
Specify the path that identifies the target location of a file set. For example, enter C:\abc.txt.
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.
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.
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. |
Processing options enable you to specify default processing for programs and reports.
Specify a value that identifies a specific organization, fund, or other reporting entity. The company code exists in the Company Constants table (F0010).
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.
Specify the designation of the tax authority officer authenticating the document. For example, enter finance manager.
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
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
Enter a value from the Deductor Type 75I/DE UDC table. Examples of values are:
A: Central government
S: State government
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
Enter the PAO code.
Enter the DDO code.
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
If you entered the code 99 (other) in the Ministry Name field, enter the ministry name.
Enter the PAO registration number.
Enter the DDO registration number.
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.
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.
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)
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
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)
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.
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.
Specify the path that identifies the target location of a file set. For example, enter C:\abc.txt.
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.
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.
Enter the name of the software that you use to prepare the quarterly TDS statement. For example, you can enter JD Edwards EnterpriseOne.
You complete these processing options for correction reports only.
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
Enter 1 if updates exist in the batch header other than the TAN and the transaction type is C2 or C3. Otherwise, enter 0.
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
Specify the Provisional Receipt Number (PRN) of the corresponding regular statement.
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.
Enter the same TAN of the collector that is included in the corresponding regular statement accepted by the TIN central system.
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.
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.
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.
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.
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.
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.
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.
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. |
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.
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.
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.
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.
Enter the certificate number that is issued by the Assessing Officer under section code 197 for non-deduction/lower deduction.
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
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.
Processing options enable you to specify default processing for programs and reports.
Specify the start date of the period for which to run the report.
Specify the end date of the period for which to run the report.
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
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.
Processing options enable you to specify default processing for programs and reports.
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
Specify whether to print VAT sales orders or CST sales orders. Values are:
0: VAT sales orders
1: CST sales orders
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.
Processing options enable you to specify default processing for programs and reports.
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.
Specify the start date of the period for which to print a list of invoices.
Specify the end date of the period for which to print a list of invoices.
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).
Processing options enable you to specify default processing for programs and reports.
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.
Specify the start date of the period for which to print a list of invoices.
Specify the end date of the period for which to print a list of invoices.
Processing options enable you to specify default processing for programs and reports.
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.
Processing options enable you to specify default processing for programs and reports.
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.
Specify the start date of the period for which to print the list of vouchers.
Specify the end date of the period for which to print the list of vouchers.
This report prints a list of purchase orders with reversed vouchers.
Processing options enable you to specify default processing for programs and reports.
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.
Specify the start date of the period for which to print the reversed purchase orders.
Specify the end date of the period for which to print the reversed purchase orders.
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).
Processing options enable you to specify default processing for programs and reports.
This report prints a list of purchase orders for items used for trade. The trading items are not liable for tax.
Processing options enable you to specify default processing for programs and reports.
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.
Processing options enable you to specify default processing for programs and reports.
This report prints the 57F(4) challan details of a particular business unit, which is a statutory requirement.
Processing options enable you to specify default processing for programs and reports.
Specify the challan number for form 57F(4).
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.
Specify the location of the authorized signatory.
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.
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.
Processing options enable you to specify default processing for programs and reports.
Specify the address number of the excise 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.
Specify the date range to print the 57F(4) register. Enter the date in the dd/mm/yy format.
This report prints the same information as the Print 57F(4) Challan (R75I3906), but prints it in a different format
Processing options enable you to specify default processing for programs and reports.
Specify the challan number for form 57F(4).
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.
Specify the location of the authorized signatory.
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.
Enter the company number of the order company that generates the purchase order.
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.
Processing options enable you to specify default processing for programs and reports.
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
Specify the beginning of the range of dates from which the system prints the invoices received with forms.
Specify the end of the range of dates from which the system prints the invoices received with forms.
This report prints a list of invoices with details of the sales tax and adjustment types that are applicable to all the business units.
Processing options enable you to specify default processing for programs and reports.
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.
Processing options enable you to specify default processing for programs and reports.
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.
Specify the title for report heading.
Specify the beginning of the range of dates from which the system prints the sales tax details.
Specify the end of the range of dates from which the system prints the sales tax details.
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
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.
Processing options enable you to specify the default processing for programs and reports.
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.
This report prints vouchers received with concession forms.
Processing options enable you to specify the default processing for programs and reports.
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
Specify the beginning of the range of dates from which the system prints the vouchers received with forms.
Specify the end of the range of dates from which the system prints the vouchers received with forms.
This report prints vouchers with pending concession forms.
Processing options enable you to specify the default processing for programs and reports.
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
Specify the beginning of the range of dates from which the system prints the vouchers with pending forms.
Specify the end of the range of dates from which the system prints the vouchers with pending forms.