This chapter contains the following topics:
Section 9.4, "Creating Cross-References Between Excise Units and Business Units"
Section 9.5, "Uploading AII, CII, and PLA Opening Balances, and Next Numbers"
Section 9.8, "Entering Excise Account Credit Redistribution Setup Details"
This section provides an overview of the excise setup master and discusses how to:
Set processing options for Excise Setup Master Maintenance (P75I301).
Set up excise unit master details.
You use the Excise Setup Master Maintenance program (P75I301) to assign transaction, order, and document types to an excise unit.
The system stores the excise setup master information in the Excise - Setup Master table (F75I301). You use this information to print excise statutory forms and other reports for excise taxes.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work With Excise Unit | W75I301A | Excise System Setup (G75IEXC4), Excise Setup Master Maintenance | Review a list of excise units. |
Work With Excise Unit Setup Details | W75I301B | Select a record and click Select on the Work With Excise Unit form. | Enter excise unit setup details. |
Processing options enable you to specify the default processing for programs and reports.
Specify a user-defined code from UDC table 01/ST that specifies the type of address book record. You must specify the value EXU for the excise unit.
Access the Work With Excise Unit Setup Details form.
Figure 9-1 Work With Excise Unit Setup Details form
Enter a value from UDC table 75I/TT that indicates the code for excise transaction type. Examples are:
EX01: Export under Claim-AR3
EX02: Export under Bond-ARE-1
EX03: Home Consumption
Enter a number that identifies multiple occurrences, such as line numbers on a purchase order or other document type. Generally, the system assigns this number, but in some cases you can override it.
Enter a value from UDC table 00/DT that identifies the order type for the selected transaction type. Examples are:
$A: Eventual Withholdings
$B: Gross Income Withholdings
%: Percentage Journal Entry
JD Edwards EnterpriseOne software reserves several prefixes for various document types, such as, vouchers, invoices, receipts, and time sheets. The reserved document type prefixes for codes are:
P: Accounts Payable documents
R: Accounts Receivable documents
T: Payroll documents
I: Inventory documents
O: Purchase Order Processing documents
J: General Accounting/Joint Interest Billing documents
S: Sales Order Processing documents
Enter a value from UDC table 00/DT that identifies the document type for the selected transaction type. Examples are:
$A: Eventual Withholdings
$B: Gross Income Withholdings
%: Percentage Journal Entry
JD Edwards EnterpriseOne reserves several prefixes for various document types, such as, vouchers, invoices, receipts, and time sheets. The reserved document type prefixes for codes are:
P: Accounts Payable documents
R: Accounts Receivable documents
T: Payroll documents
I: Inventory documents
O: Purchase Order Processing documents
J: General Accounting/Joint Interest Billing documents
S: Sales Order Processing documents
Enter a value to indicate yes or no responses on prompt screens. Values are:
Y: Yes
N: No
This section provides an overview of the excise period master and discusses how to:
Set processing options for the Excise - Period Master Maintenance program (P75I302).
Define a current period for an excise unit.
You use the Excise Period Master Maintenance program (P75I302) to define a period for an excise unit. The system uses this period to build data for the RG-1 and RG23A-1 reports. You should increase this period on a monthly basis. To be able to change the period for an excise unit, enable the Modify processing option.
The system stores the period for an excise unit in the Excise - Period Master table (F75I302).
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Excise - Work With Period Master | W75I302B | Excise System Setup (G75IEXC4), Excise Period Master Maintenance | Review a list of excise units and periods. |
Excise - Period Master Maintenance | W75I302C | On the Excise - Work With Period Master form, click Add. | Define a period for an excise unit. |
Processing options enable you to specify the default processing for programs and reports.
Specify whether the item is currently active in the simulation process for current cost. Values are:
Blank: The item is inactive, and the user is restricted from updating the period in the Current Period (YYYY/MM) field.
1: The item is active, and the user can update the fiscal period and year for an excise unit.
Access the Excise - Period Master Maintenance form.
Figure 9-2 Excise - Period Master Maintenance form
Enter the address number of the excise unit to define a period for the unit. The search type for the excise unit should be EXU.
Enter the current period for an excise unit. You enter the period in terms of year and month.
You use the Excise Account Master Maintenance program (P75I306) to set up accounts for various types of excise duties. The system stores the account information in the Excise Account Master table (F75I306).
The system retrieves information from the F75I306 table to print statutory forms and other reports related to excise taxes.
This section discusses how to:
Set processing options for Excise Account Master Entry (P75I306).
Enter details for excise account master.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work With Excise Account Master | W75I306A | Excise System Setup (G75IEXC4), Excise Account Master Maintenance | Review a list of excise units. |
Excise Account Master Entry | W75I306D | On the Work With Excise Account Master form, select a record and click Select. | Enter details for excise account master. |
Processing options enable you to specify the default processing for programs and reports.
Specify a user-defined code from UDC table 01/ST that specifies the type of address book record. You must specify EXU for excise units.
Access the Excise Account Master Entry form.
Figure 9-3 Excise Account Master Entry form
Enter a user-defined code from UDC table 75I/EA that specifies the type of excise account. Examples are:
All: Account for Inputs
CII: Account for Capital goods
All: Account for Inputs
PLA: Personal Ledger Account
Enter a tax type for a tax regime, such as AED, BED, and CES.
Enter a value that identifies an account in the general ledger. The first character of the account number indicates its format. You define the account format in the General Accounting constants. Formats to enter account numbers are:
Standard account number, business unit.object.subsidiary format
Flex format
You use the Review and Revise Accounts program (P0901) to set up an account in the general ledger
You use the Excise Unit Branch Plant Cross Reference program (P75I304) to create a relationship between an excise unit and a business unit. You can attach more than one business unit to an excise unit, but not at the same time. The system stores the cross-reference between business and excise units in the Excise - Cross Reference File table (F75I304).
This section discusses how to:
Set processing options for Excise Unit Branch Plant Cross Reference (P75I304).
Create a cross-reference between an excise unit and business unit.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work with Cross Reference Information | W75I304A | Excise System Setup (G75IEXC4), Excise Unit Branch Plant Cross Reference | Review a list of excise unit and business unit cross-references. |
Cross Reference Revision | W75I304B | On the Work with Cross Reference Information form, click Add. | Create a cross-reference between an excise unit and a business unit. |
Processing options enable you to specify the default processing for programs and reports.
Specify a user-defined code from UDC table 01/ST that specifies the type of address book record. You must specify EXU to search for excise units.
Access the Cross Reference Revision form.
Figure 9-4 Cross Reference Revision form
Enter an alphanumeric 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 or a branch/plant.
You can assign a business unit to a document, entity, or a person for 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 prevents you from viewing information about business units for which you have no authority.
You must use the Review and Revise Business Units program (P0006) to link a business unit to a company.
This section provides an overview of AII, CII, and personal ledger account (PLA) opening balances, and next number upload, lists prerequisites, and discusses how to:
Set processing options for Upload AII/CII/PLA Open. Balance/Next No. (P75I381).
Enter AII, CII, and PLA opening balances and next numbers.
You use the Upload AII/CII/PLA Open. Balance/Next No. program (P75I381) to enter opening balances for AII, CII, and PLA registers. You also use this program to enter next numbers for documents related to cenvat credit, export, trading items, and local export.
You enter the opening balances for excise duty, education cess, secondary higher education cess, CVD, CVD Cess, CVD HCess, special excise duty, and additional excise duty for each excise unit for the respective month and year. The system automatically calculates the total opening balances for the subsequent months for the excise unit. The system stores the opening balance, closing balance, and next number information in the Excise - MODVAT / PLA Summary table (F75I310Y) for all values, but it stores the balances of CVD Hcess in the F75I310Y - Tag File table (F75I311).
You use this program only once before the India Localization system goes live.
Note: If you leave the opening balance for an account blank, the system considers the opening balance as zero. |
Before you complete the tasks in the following sections, complete these actions:
Create the excise unit.
Set up the excise unit branch plant cross-reference.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work With Excise AII/CII/PLA Opening Balance | W75I381A | Excise System Setup (G75IEXC4), Upload A2/C2/PLA Opening Balance / Next Number | Review opening balances and next numbers. |
Upload AII/CII/PLA Opening Balance | W75I381B | On the Work With Excise AII/CII/PLA Opening Balance form, click Add. | Enter AII, CII, and PLA opening balances and next numbers. |
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 secondary higher education cess.
Specify a user-defined code from UDC table 75I/GT that identifies the tax type for the CVD higher education cess.
Specify the item type for raw material.
Specify the item type for capital goods.
Specify the item type for PLA.
Access the Upload AII/CII/PLA Opening Balance form.
Figure 9-5 Upload AII/CII/PLA Opening Balance form
Enter the opening and closing balances for basic excise duty in the PLA, A II, or C II account.
Enter the opening and closing balances for the education cess in the PLA, A II, or C II account.
Enter the opening and closing balances for the additional excise duty in the PLA, A II, or C II account.
Enter the opening and closing balances for the special excise duty in the PLA, A II, or C II account.
Enter the opening and closing balances for the secondary higher education cess in the PLA, A II, or C II account.
Enter the next number for the PLA account.
Enter the next number for the RG23A II register.
Enter the next number for the RG23C II register.
Enter the next number for the ARE 3 document.
Enter the next number for the ARE 1 bond.
Enter the next number for the RG23D register.
You use the Service Tax Category Codes Mapping program (P75I009) to assign category codes to attributes of an item. You assign one category code to each item attribute and the system stores the item attributes and the associated category codes in the Item Attributes/Category Codes table (F75I009).
This section lists a prerequisite and discusses how to assign a category code to an item attribute.
Before you perform the task in this section, define the attributes for an item.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work with Item Attributes/Category Codes Mapping | W75I009A | System Setup (G75ISVT3), Service Tax Category Codes Mapping
Category Code Constants (G75ICAT), Item Attributes/Cat. Codes |
Review category codes assigned to item attributes. |
Item Attributes/Category Codes Mapping | W75I009B | On the Work with Item Attributes/Category Codes Mapping form, click Add. | Assign a category code to an item attribute. |
Access the Item Attributes/Category Codes Mapping form.
Figure 9-6 Item Attributes/Category Codes Mapping form
Enter a value from UDC table 75I/IA that identifies the attribute of an item. Values are:
CCT: Collection Code For TCS
CNC: Chapter Number Custom
CNE: Chapter Number Excise
FG: Finished Goods
IT: Item Type
ST: Service Type
Enter a category code to assign to the item attribute. You can assign a category code to only one item attribute.
This section provides an overview of chapter number setup, lists a prerequisite, and discusses how to set up chapter number details.
You use the Chapter Number Set Up program (P75I016) to set up the chapter number values and their descriptions. You define the chapter number values for the items that are stored in the F75I009 table.
The chapter number code generation is based on the next number concept. The system generates the chapter number code for a combination of chapter number and chapter number type.
The system stores the chapter number details in the Chapter Number Set Up table (F75I016).
Before you complete the task in this section, assign the category code to the item attribute for which you want to generate the chapter number code.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work With Chapter Number Set Up | W75I016A | Category Code Constants (G75ICAT), Chapter Number Set Up | Review chapter numbers and their descriptions. |
Chapter Number Set Up | W75I016B | On the Work With Chapter Number Set Up form, click Add. | Set up chapter number details. |
Access the Chapter Number Set Up form.
Enter a value from UDC table 75I/CT that identifies a chapter number type. Values are:
CNC: Chapter Number Custom
CNE: Chapter Number Excise
VAT: VAT item
Enter the chapter number for the chapter number type.
Enter a description for the item chapter.
You use the Excise Account Credit Redistribution Entry program (P75I3061) to set up credit accounts for various types of excise duties. The system stores the account information in the Excise Account Master - Credit Redistribution table (F75I3061).
The system retrieves information from the F75I3061 table to write the general ledger account information for the credit accounts in the F0911 table.
This section discusses how to:
Set processing options for Excise Account Credit Redistribution Entry (P75I3061).
Enter details for the excise account credit master.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work With Excise Account Credit Redistribution Entry | W75I3061A | Excise System Setup (G75IEXC4), Excise Account Credit Redistribution Entry | Review a list of excise units. |
Excise Account Credit Redistribution Entry | W75I3061B | On the Work With Excise Account Credit Redistribution Entry form, select a record and click Select. | Enter details for the excise account credit redistribution master. |
Processing options enable you to specify the default processing for programs and reports.
Specify a user-defined code from UDC table 01/ST that specifies the type of address book record. You must specify EXU for excise units.
Access the Excise Account Credit Redistribution Entry form.
Enter a tax type for a tax regime, such as AED, BED, or CES.
Enter a value that identifies an account in the general ledger. The first character of the account number indicates its format. You define the account format in the General Accounting constants. Formats to enter account numbers are:
Standard account number, business unit.object.subsidiary format
Flex format
You use the Review and Revise Accounts program (P0901) to set up an account in the general ledger.