This chapter contains the following topics:
Section 12.1, "Entering Duty Payment Details for Excise Registers"
Section 12.3, "Entering Closing Quantities for Excise Units"
This section provides overviews of entries in the excise registers, balance entries for RG1 register, RG1 table update for excise duty, payment of interest for excise duty, and the PLA credit confirmation. This section also lists prerequisites, and discusses how to:
Set processing options for PLA/AII/CII (Credit/Debit) Entry (P75I311).
Create entries for duty payment registers.
Enter balances for the RG1 register.
Update the RG1 table for excise duty.
Set processing options for Amount of Interest Paid/Month (RG-1) (P75I382).
Enter payment details for interest on excise duty.
Set processing options for Confirm PLA Credit (P75I310).
Confirm a Personal Ledger Account (PLA) credit entry.
Generate the RG-1 report.
You use the PLA/AII/CII (Credit/Debit) Entry program (P75I311) to create a debit or credit entry for all tax types in the excise duty payment registers. These registers are the PLA, Cenvat credit RM, and Cenvat credit CG registers.
You must set processing options to:
Specify the type of register in which you want to create an entry.
Specify the type of entry that you want to create.
You can create an entry in the duty payment register only for the current month for an excise unit. When you create an entry, the system generates a batch number and displays it in a message box. Depending on the type of entry, the system stores the entries for the duty payment register in these tables:
Excise - PLA Chapter Wise Transaction File for Yarn Industry (F75I315Y)
Excise - RG23A - II Chapter Wise Transaction File (F75I313Y)
Excise - RG23C - II Chapter Wise Transaction File (F75I317Y)
Excise - MODVAT / PLA Summary File YARN SPECIFIC (F75I310Y)
(For Release 9.1 Update) The PLA/AII/CII (Credit/Debit) Entry program displays CVD, CVD Cess, and CVD HCess under AII and CII tabs. It retrieves opening balances, debit amounts, credit amounts, and closing balances for CVD and CVD Cess from the F75I310Y table and for CVD HCess from the F75I311 table. The system updates the debit closing and credit closing balances for CVD and CVD Cess in the F75I310Y table. It adds the debit and credit amounts that you enter on AII and CII tabs to the closing balance for debit and credit amounts for the respective tax types in the F75I310Y table. For CVD HCess, the system updates the debit and credit closing balances by adding debit and credit amounts that you enter on AII and CII tabs to the F75I311 table.
You use the RG 1 - Upload Balances program (P75I380) to enter the opening balances for an item in the Excise RG1 Transaction File table (F75I380). You can also use this program to enter the bulk details, such as standard volume and ambient volume, and transportation details for the item. The system stores the RG23A-II, RG23C-II, and PLA debit amounts in the F75I380 table.
Note: The RG–1 Build report (R75I380) uses the opening balances for items from the F75I380 table. Therefore, you must enter the opening balances before you run the RG–1 Build report. |
Run the RG–1 Build report (R75I380) to calculate excise components, such as basic excise duty and additional excise duty for items, and to update the Excise RG1 Transaction table (F75I380) when you move the items from the manufacturer's premise. The system updates the F75I380 table for all the adjustments associated with the particular movement of an item.
The R75I380 report retrieves values from the RG23 – AII, RG23 –CII, PLA tables based on the excise transaction type, and updates the corresponding information in the F75I380 table.
Note: The RG–1 Build report (R75I380) uses the opening balances for items from the F75I380 table. Therefore, you must enter opening balances using the RG 1 - Upload Balances program before you run this report. |
You use the Amount of Interest Paid/Month (RG-1) program (P75I382) to create an entry for the payment of interest on excise duty. You must pay this interest if you exceed the due date for the payment of excise duty for the respective month. You must enter details such as the excise unit, the year and month, and the amount of interest paid to create a voucher number for the payment of interest.
After you create a voucher for the interest payment, you must post the voucher to the general ledger. You cannot update a record that has been posted to the general ledger. However, you can update the records for which the vouchers have been deleted or made obsolete. These records display in a different color on the Work with Amount of Interest paid per Month form.
The system displays the records for which the payments have been made in a different color. You must update the PLA register for these records. When you click PLA Update, the system updates the Excise - PLA Chapter Wise Transaction File for Yarn Industry (F75I315Y) and Excise - MODVAT / PLA Summary File YARN SPECIFIC (F75I310Y) tables. For secondary higher education cess, the system updates the Amount of Interest Paid per month - IND - 00 table (F75I382) and F75I310Y - Tag File table (F75I311).
Note: After you click the PLA update button, the system does not display that record. This restricts you from updating the already updated record. |
You use the Confirm PLA Credit program (P75I310) to confirm the PLA credit balance with the duty amount for each tax type. The duty amount is paid to the government through the TR–6 challan.
The system retrieves the records for which the vouchers have been created from the Account Ledger table (F0911). When you select a record on the Work with Register Entries form, the system retrieves details for the selected record from the Excise - MODVAT/ PLA Summary File YARN SPECIFIC table (F75I310Y) and generates a PLA entry number. After you confirm the PLA entry number, the system updates the Excise - PLA Chapter Wise Transaction File for Yarn Industry table (F75I315Y) and stores the PLA entry number in the F75I310Y or F75I311 table.
Before you perform the tasks in this section, verify that the excise account master has been set up.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work with Register Entries | W75I311A | Advanced and Technical Operations (G75IEXC3H), PLA/AII/CII (Credit/Debit) Entry | Review the opening and closing balances of duty payment for excise registers for the specific month. |
PLA/Cenvat Debit Credit Entry Revisions | W75I311D | On the Work with Register Entries form, select a record and click Select. | Enter the debit or credit amount for an excise register.
Note: After you click OK on this form, the system generates a batch number and displays it in a message box. |
Work With Excise RG1 Upload Balance | W75I380B | Excise System Setup (G75IEXC4), RG 1 - Upload Balances | Review the records uploaded to the RG1 register. |
Upload Balances to RG1 File F75I380 | W75I380A | On the Work With Excise RG1 Upload Balance form, click Add. | Enter balances for the RG1 register. |
Work with Amount of Interest paid per Month | W75I382A | Advanced and Technical Operations (G75IEXC3H), Amount of Interest Paid/Month (RG-1) | Review the amount of interest paid for an excise unit. |
Revise Amount of Interest Paid per Month details | W75I382B | On the Work with Amount of Interest Paid per month form, click Add. | Create a record for payment of interest for an excise unit.
Note: After you create an entry on this form, the system displays a message box with the voucher number. Alternatively, you use this form to enter the voucher in the PLA register after you enter the payment. To perform this task, select a record on the Work with Amount of Interest paid per Month form for which the voucher was paid, and click PLA Update. |
Work With Excise Balance file | W75I310A | Excise periodic Processing (G75IEXC2H), Confirm PLA Credit | Review the vouchers that have been paid to the Government. |
Direct Balance Adjustment | W75I310B | On the Work With Excise Balance file form, select a record and click Select. | Confirm a PLA entry number.
Note: The system displays an error message if the TR–6 challan is not mapped to the Name-remark field in the F0911 table. |
Processing options enable you to specify the default processing for programs and reports.
Specify the address book number of the excise unit.
Specify the type of register to create a debit or credit entry for all tax types. Values are:
1: PLA
2: RG23A-II
3: RG23C-II
Specify the value to indicate a credit entry or debit entry. Values are:
Y: Credit
N: Debit
Specify a user-defined code from UDC table 07/IG to indicate how the payroll journal batches are posted to the General Ledger. Examples are:
A: Automatic
If the batches are in balance and there are no errors, the system posts the batches automatically during the final update step of the payroll cycle. This is the default value.
M: Manual
The batches must be posted manually.
N: None
There is no general ledger interface.
T: Time Accounting
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the additional excise duty component of tax.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the basic excise duty component of tax.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the special excise duty component of tax.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the education cess component of tax.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the higher secondary education cess component of tax.
Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank. (Release 9.1 Update)
Enter a value from the Tax Type UDC table 75I/GT to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank.
Enter a value from the Tax Type (75I/GT) UDC table to specify the code for this tax type. If you do not want to process this tax type for this report, leave this processing option blank. (Release 9.1 Update)
Access the PLA /Cenvat Debit Credit Entry Revisions form.
Figure 12-1 PLA / Cenvat Debit Credit Entry Revisions form
Enter the gate pass number.
Enter the date on which the gate pass is issued.
Enter a code on the container or that you assign to the container in which the items on this purchase order or order line were shipped to you. You can assign container information to an order during receipts entry.
These fields appear under Amount Debit heading on the A-II tab.
Enter the debit amount for the appropriate tax.
Access the Upload Balances to RG1 File F75I380 form.
Figure 12-2 Upload Balances to RG1 File F75I380 form
Enter a numeric value that corresponds to the month in a calendar year. For example, enter 3 for the month of March.
Enter the model year of the appliance in the YYYY format.
Enter the address book number of the excise unit.
Enter the inventory item number. The system provides three separate item numbers. It also provides an extensive cross-reference capability to other item numbers to accommodate substitute item numbers, bar codes, customer numbers, and so on. The item numbers are:
Item Number (short): An eight-digit, computer-assigned item number
2nd Item Number: The 25-digit, free-form, user-defined alphanumeric item number
3rd Item Number: Another 25-digit, free-form, user-defined alphanumeric item number
Enter a value that represents the available quantity. The available quantity can include the on-hand balance minus commitments, reservations, and backorders.
Enter the opening and closing balances for the AED (additional excise duty) component of excise duty in the respective account.
Enter the opening balance for the Education Cess component of excise duty in the respective account.
Enter the opening balances for the BED (basic excise duty) component of excise duty in the respective account.
Enter the opening balances for the special excise duty (SED) component of excise duty in the respective account.
Enter the opening balances for the HCESS component of excise duty in the respective account.
Enter the total cost by item.
Enter the debit amount for the RG23A-II register.
Enter the debit amount for the RG23C-II register.
Enter the debit amount for the PLA register.
Enter a user-defined code from UDC table 00/UM that identifies a unit of measure used when you entered the transaction into the system. Examples are:
AS: Annual Salary (rounded)
AT: Annual Salary (truncated)
BA: Bar Absolute (Pressure)
BC: Bag
BG: Bar Gauge (Pressure)
Enter the chapter number for a specify item.
Enter the total volume by item after it is converted to a standard base. All the conversions must be made in accordance to the standard routines for density, gravity, and temperature.
Enter the ambient quantity of the item. The ambient quantity is the value prior to standard volume conversion that has been converted to the inventory unit of measure.
Enter the weight of the item at standard temperature. The system calculates the weight by multiplying the volume by the density and then applies an air correction, if necessary.
Select Reports (G75IEXC7), RG-1 Build.
Processing options enable you to specify the default processing for programs and reports.
Access the Revise Amount of Interest Paid per Month details form.
Figure 12-3 Revise Amount of Interest Paid per Month details form
Enter the address book number of the excise unit.
Enter the model year of the appliance, in the YYYY format.
Enter a numeric value that corresponds to the month in a calendar year. For example, for the month of March, enter 3.
Enter the address book number of the tax authority. You should have set up supplier or subcontractor as tax authority.
Enter the debit amount for PLA for the appropriate tax type.
Processing options enable you to specify the default processing for programs and reports.
Specify the address book number of the excise unit.
Specify the user-defined code from UDC table 01/ST that indicates the types of address book records you want to search. Examples are:
A: Applicants
B: BANK
C: Customers
EXU: Excise Unit
Specify a code that indicates the posting status of payments in the A/P Matching Document table (F0413). Values are:
Blank: Unposted transactions
P: Transactions processed for payment and require processing again during pre-post
X: Transactions originally with a status P and processed again through pre-post
D: Transactions posted successfully
Specify the user-defined code from UDC table 00/DT that indicates the origin and purpose of the transaction. JD Edwards EnterpriseOne reserves several prefixes for document types, such as vouchers, invoices, receipts, and timesheets. Examples are:
AC: Lease Accrual / Deferral
AF: Adjusting Entries
AR: Asset Revaluation
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the additional excise duty component of tax.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the basic excise duty component of tax.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the special excise duty component of tax.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the education cess component of tax.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the higher secondary education cess component of tax.
This section provides overviews of the ledger balance review and excise payment details, and discusses how to:
Set processing options for Excise Ledger Inquiry (P75I210S).
Review ledger balances for the PLA, RG23A-II, and RG23C-II registers.
You use the Excise Ledger Inquiry program (P75I210S) to review the balances for the personal ledger account (PLA), RG23A-II, and RG23C-II registers. You can review details, such as the opening balances, total credits, total debits, and closing balances for these registers for a specific excise unit and period.
(Release 9.1 Update) You can also use this program to review the opening balances, credit details, debit details, and closing balances for CVD, CVD Cess, and CVD HCess.
The system retrieves the balances from the Excise - MODVAT / PLA Summary (F75I310Y) and F75I310Y - Tag File table (F75I311) tables.
You use the Excise Payment Details program (P75I320S) to review payment information, such as the sales order number, date of payment, entry number, and payment details about the AII, CII, and PLA registers. You can also review payment information for basic excise duty (BED), and education cess.
The system retrieves payment information from the Excise Payment Details Yarn Specific table (F75I320Y).
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Excise Ledger Balance Inquiry (Summary) | W75I210SA | Excise Inquiries (G75IEXC11), Excise Ledger Inquiry | Select a period for the excise unit. |
Excise Ledger Balance Inquiry (Detail) | W75I210SB | On the Excise Ledger Balance Inquiry (Summary) form, select a record and click Select. | Review ledger balances for the excise unit for the selected period. |
Work with Excise Payment Details | W75I320SA | Excise periodic Processing (G75IEXC2H), Excise Payment Details | Review the excise payment details. |
Processing options enable you to specify the default processing for programs and reports.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the higher secondary education cess.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the CVD higher education cess.
Access the Excise Ledger Balance Inquiry form. This is the form that appears after you select a record on the initial summary form.
Figure 12-4 Excise Ledger Balance Inquiry form
Enter the address book number of the excise unit.
This section provides an overview of the closing quantities for excise units and discusses how to enter the closing quantities for an excise unit.
You use the Upload RG23AI program (P75I343) to enter the closing quantities for excise units. This program is used to upload the closing balances for packed items only. The system uses the closing quantity information to calculate the opening stock for the subsequent excise periods. This information is updated in the Excise - Daywise Closing Balance table (F75I343).
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Upload Closing Balances for RG-23A | W75I343A | Excise System Setup (G75IEXC4), Upload RG23AI | Enter the closing quantity for an excise unit. |
Access the Upload Closing Balances for RG-23A form.
Figure 12-5 Upload Closing Balances for RG-23A form
Enter an alphanumeric code that identifies a separate entity within a business for which you want to track costs.
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.
The business unit security might prevent you from viewing information about business units for which you have no authority.
Enter the inventory item number. The system provides three separate item numbers. It also provides an extensive cross-reference capability to other item numbers to accommodate substitute item numbers, bar codes, customer numbers, and so on. The item numbers are:
Item Number (short): An eight-digit, computer-assigned item number
2nd Item Number: The 25-digit, free-form, user-defined alphanumeric item number
3rd Item Number: Another 25-digit, free-form, user-defined alphanumeric item number
Enter a value that represents the available quantity. The available quantity can include the on-hand balance minus commitments, reservations, and back-orders. You enter this value in the Branch/Plant Constants program (P41001).
Enter the unit of measure you used when you entered this transaction into the system.
Enter the number that identifies the batch or interactive program. For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
This section provides overviews of the RG-1 Build program and the RG-1 Print report, lists prerequisites, and discusses how to:
Run the RG-1 Build program.
Set processing options for RG-1 Build (R75I380).
Run the RG-1 Print report.
Set processing options for RG-1 Print report (R75I381).
Run this report to calculate excise tax when you move items. The system updates the Excise RG1 Transaction table (F75I380) for all adjustments associated with a particular movement of an item.
This report uses the opening balance for an item from the F75I380 table. Therefore, you need to run the RG 1 - Upload Balances program (P75I380) before generating this report.
This report reads from the Item Ledger File (F4111), Bulk Product Transaction File (F41511), Excise - Period Master (F75I302), Excise - Cross Reference File (F75I304), and Excise RG1 Transaction (F75I380) tables, and writes to the F75I380 table.
Run the RG-1 Print report to print data about the stock of finished goods for the packed or bulk items based on the selection of the processing option. This report prints the data from the Excise RG1 Transaction table (F75I380) for the excise period that you specify in the data selection. You must run the RG-1 Build report (R75I380) before you run the RG-1 Print report.
Before you perform the tasks in this section, enter ending balances in the RG 1 - Upload Balances program (P75I380).
Select Reports (G75IEXC7), RG-1 Build.
Processing options enable you to specify the default processing for programs and reports.
Specify the month for which you want to run the report. For example, enter 01 for January.
Specify the year for which you want to run the report. For example, enter 2007.
Specify the period for which you need to run the report. Values are:
Y: Build for the complete month
N: Build from RG1 last build date/First day of month to end date of the month
If the build month is the same as the current month, then the system defaults the RG1 End Date to the current date.
Enter a value from the Tax Type (75I/GT) UDC table to specify the code for the tax type. If you do not want to process this tax type for this report, leave this processing option blank.
Select Reports (G75IEXC7), RG-1 Print.
Processing options enable you to specify default processing values.
Specify the beginning date of the range of dates during which the transactions were executed.
Specify the ending date of the range of dates during which the transactions were executed.
Specify the identification for the bulk liquid product. Values are:
Blank or P: Packaged
B: Bulk liquid
Specify whether to print the summary or detailed report. Values are:
Blank: Detailed report
1: Summary report
This section provides an overview of record unlocking and discusses how to unlock a record in the F75IEXC table.
To protect data integrity, the India Localization system locks records to prevent more than one user from updating a table simultaneously. When you use a program that writes records to the PLA, AII, or CII table, the system locks the table so that you cannot use another program that writes records to the same table. The system releases these locked records after the table is updated. If the system does not release the locked records, you can use the Unlock File program (P75I351) to unlock the records in the PLA, AII, or CII table.
The system stores the summary of the locked records in the Excise Balance file lock table (F75IEXC).
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Unlock F75IEXC [Find/Browse] | W75I351A | Excise System Setup (G75IEXC4), Unlock File | Unlock a record in the F75IEXC table. |
Access the Unlock F75IEXC [Find/Browse] form.
Figure 12-6 Unlock F75IEXC [Find/Browse] form
This table lists the tax setup requirements for Excise Registers:
Setup Requirement | Comments |
---|---|
Enter duty payment details for excise registers. | You use the PLA/AII/CII (Credit/Debit) Entry program (P75I311) to create a debit or credit entry for all tax types in the excise duty payment registers. These registers are the PLA, Cenvat credit RM, and Cenvat credit CG registers. |
Enter the balances for the RG1 Register. | You use the RG 1 - Upload Balances program (P75I380) to enter the opening balances for an item in the Excise RG1 Transaction File table (F75I380). You can also use this program to enter the bulk details, such as standard volume and ambient volume, and transportation details for the item.The RG-1 Build report (R75I380) uses the opening balances for items from the F75I380 table. Therefore, you must enter the opening balances before you run the RG-1 Build report. |
Run the RG-1 Build report (R75I380) to calculate excise duty. | You run the RG-1 Build report (R75I380) to calculate excise components, such as basic excise duty and additional excise duty for items and update the Excise RG1 Transaction table (F75I380) when you move the items from the manufacturer's premise. |
Enter the payment details for interest on excise duty. | You use the Amount of Interest Paid/Month (RG-1) program (P75I382) to create an entry for the payment of interest on excise duty. You must pay this interest if you exceed the due date for the payment of excise duty for the respective month. You must update the PLA register for the records for which the payments have been made using the PLA Update program. |
Confirm the PLA credit entry. | You use the Confirm PLA Credit program (P75I310) to confirm the PLA credit balance with the duty amount for each tax type. The duty amount is paid to the Government through the TR-6 challan. |
Enter the closing quantity for an excise unit. | You use the Upload RG23AI program (P75I343) to enter the closing quantities for excise units. |
Unlock a Record in the F75IEXC table. | You can use the Unlock File program (P75I351) to unlock the records in the PLA, AII, or CII table. |