PeopleSoft Enterprise Order Management 9.1 PeopleBook

Processing Taxes for India

This chapter discusses how to:

Process Indian taxes for sales orders and quotes.
Populate the Billing Interface with Indian tax information.

Processing Indian Taxes for Sales Orders and Quotes

This section provides an overview of Indian Tax processing and discusses how to:

Access Indian tax information at the header and line level.
Access Indian tax information at the schedule level.

Note. Indian taxes are calculated only during online sales order entry.

Understanding Indian Tax Processing for Sales Orders and Quotes

In order to calculate excise and sales tax, the ship to customer's tax transaction type appears by default on the sales order header from the Customer Tax Applicability page when adding a sales order or quote. It then appears by defaults on the line and schedule. The tax transaction type can be changed at the header, line, or schedule level. If you change the ship to customer or ship to customer location, the tax transaction type is redetermined.

Note. If you change the tax transaction type at the header level after lines are added, it does not update existing lines or schedules. The system only updates new lines.

If the tax transaction type is for an export sale, you are required to select a benefit scheme for the export products on the order schedule to fulfill customs duty obligations. You can enter the benefit scheme on the order line. The benefit scheme is informational only and can help in the reporting of export sales.

Tax information is established for items that are associated to the product on the Item Tax Applicability page. For product kits, the tax information is established on the Product Tax Applicability page. Excise duties and sales taxes are calculated once when a product, quantity, unit of measure, ship from business unit, and ship to customer are entered and the order is priced. When a product kit is entered on a sales order and the entire product kit cannot be shipped, the excise invoices are not created. There can be only one ship ID for each product kit that is ordered on a sales order line.

The Tax Determination process is called to determine the excise tax rate code and sales tax rate code. Then the Tax Calculation process is called to calculate the excise and sales tax amounts. All taxes are calculated at the schedule level and appear on the Excise and Sales Tax page. You are able to change only the tax rate codes from this page. Excise duty and sales tax information can also be viewed on the Order Lines and Order Summary page.

Taxes are calculated in this order:

Excise duties.
Sales taxes.

Note. The Total Order/Load Adjust Option on the Accounting and Billing page for the Order Management Definition, controls how total order and weight, and volume pricing discounts and surcharges are sent to PeopleSoft Billing, and how they appear on invoices. For total order or load-based sales subject to India excise tax, pricing will be sent to PeopleSoft Billing as individual invoice lines so that PeopleSoft Billing will calculate taxes.

Copying Sales Orders and Quotes

Indian tax information is copied in the same manner as sales orders and quotes with this exception: excise duties and sales tax are not re-determined when you are copying lines or schedules, but the taxes will be recalculated.

Note. You can always click the Reprice button on the sales order to recalculate the taxes if you have added new lines/schedules or changed any fields.

Calculating Excise Duty when Multiple Pricing Schedules are in Use

If you have implemented tiered pricing rules in your pricing arbitration plan, the excise duty and sales tax on your shipping excise invoice is calculated based on the net unit price defined on the order schedule in the case where the excise duties should not be calculated based on the assessable value. The Net Unit Price field represents a weighted average price of all of the pricing schedules for a given order schedule.

Note. While the invoice will be correct it is important to note that it will not display the fact that customer paid a certain portion of the order schedule at price A and another portion at price B.

If an order with India Excise Duty has more than one pricing schedule it will be passed to Billing as if the Price Adjustment Detail Option, on the Accounting and Billing page for the Order Management Definition, is set to Netted with Revenue. This means that:

Adjustments are not sent to billing.
Only an invoice line where the list price and the net unit price both equal the net unit price after all adjustments is sent to billing.

Note. It is important to note that the bill reflects the final price after adjustments but the detail of how that price was arrived at is not reflected in the invoice.

Note. It is also important to consider the Excise Duty regulations in force if you decide to implement the Multiple Pricing Schedules.

Note. If you are not using tiered pricing, the system will use the Price Adjustment Detail Option you set on the Accounting and Billing page of the Order Management Definition.

See Establishing Accounting and Billing Options.

Copying Sales Orders and Quotes

Indian tax information is copied in the same manner as sales orders and quotes with this exception: excise duties and sales tax are not redetermined when you are copying lines or schedules, but the taxes are recalculated.

Note. You can always click the Reprice button on the sales order to recalculate the taxes if you add new lines or schedules or change any fields.

Common Elements Used in this Section

Benefit Scheme

Benefit schemes are established on the Customs Duty Benefit Scheme page. The benefit scheme appears on the Order Lines page. A value is required if the transaction is identified as an export sale. These Tax Transaction Types are valid for export sales:

DEB: (direct export with bond).

DEWB: (direct export without bond).

LEB (local export with bond)

LEWB: (local export without bond).

Tax Transaction Type

Tax transaction type that is assigned to the transaction. Values are:

DEB: (direct export with bond).

DEWB: (direct export without bond).

DOM: (domestic).

IUT: (interunit transfer).

LEB: (local export with bond).

LEWB: (local export without bond).

Pages Used to Process Sales Order and Quote Transactions With Indian Taxes

Page Name	Definition Name	Navigation	Usage
Order Entry Form	ORDENT_FORM_LINE	Order Management, Quotes and Orders, Create/Update Order Order Management, Quotes and Orders, Create/Update Quote	Modify the tax transaction type and enter customer and order information pertaining to the entire order. You can also view total excise duty and sales tax amounts for each individual line and for the order.
Line Pricing Data	ORDENT_LINE_PRICE	Click the Pricing Data link on the Order Lines page.	View and modify pricing information for the line. You can also enter manual adjustments.
Shipment Schedules	ORDENT_SCH_ENTRY	Click the Schedules link on the Order Lines page.	Modify the tax transaction type. Define multiple order line shipments or change default information.
Excise and Sales Tax	ORDENT_EXS_TAX_PG	Select Excise and Sales Tax in the ...More field on the Shipment Schedules page.	View excise and sales taxes and modify the tax rate codes.
Schedule Pricing Data	ORDENT_SCH_PRICE	Click the Pricing Data link on the Shipment Schedules page.	View and modify pricing information for the schedule. You can also enter manual adjustments.
Order Summary	ORDENT_SUMMARY	Order Management, Quotes and Orders, Review Order Information, Summary	Quickly view information about an individual sales order. You can view the excise duty and sale tax that is calculated for the order.

Accessing Indian Tax Information at the Header and Line Level

Access the Order Entry Form page (Order Management, Quotes and Orders, Create/Update Order).

Total Excise Duty and Total Sales Tax/VAT

You can view the values for the line from the Taxes tab and for the entire order in the Price Summary area.

Accessing Indian Tax Information at the Schedule Level

Access the Excise and Sales Tax page (select Excise and Sales Tax in the ...More field on the Shipment Schedules page).

Note. If you change any of the values that can be edited (Assess Value, Sales Tax Rate Code, Excise Tax Rate Code, Use Default Rate Codes, Switch Currency Display), the Tax Calculation process uses the new values to determine or recalculate excise duty and sales tax.

Excise UOM (excise unit of measure)	Appears by default from the Item Tax Applicability page, Item Business Unit Tax Applicability page, or the Product Tax Applicability page. The calculated excise duty is multiplied by the conversion rate between the transaction unit of measure and the excise unit of measure to arrive at a final excise duty amount.
Tax Authority Rate	The tax authority rate is derived by using the tax determination process and assigned to the transaction.
Tax Form Code	Define form codes, which are groupings of form names. Form codes are assigned to tax rate codes. When a tax rate code is associated with a transaction, the form code helps determine the applicable forms for the transaction for form tracking purposes. Values are defined on the Sales Tax Form Codes page.
Excise Use Assessable Value	If the flag is selected, the assessable value is used to calculate the tax amounts. If the option is not selected, the Unit Price is used to calculate the tax amounts.
Assess Value	For items and products, this is the assessable value that is defined if you want to calculate duties based on a value other than the basic item or product value. If you edit this field, the Tax Calculation process uses this value to calculate tax amounts.
Excise Item Category Code	Default excise tax category code that is defined for the item.
Sales Item Category Code	Default sales tax category code that is defined for the item.
Customer Excise Tax Category	Appears by default from the Customer Tax Applicability page.
Customer Sales Tax Category	Appears by default from the Customer Tax Applicability page.
Excise Use Assessable Value	If the flag is selected, the assessable value is used to calculate the tax amounts. If the option is not selected, the Unit Price is used to calculate the tax amounts.
Excise Tax Rate Code and Tax Rate Code	Taxes are recalculated if you change either the Excise Tax Rate Code or Tax Rate Code field values.
Use Default Rate Codes	Click the link to call the Tax Determination process to determine the default excise and sales tax rate codes. Then the Tax Calculation process is called to calculate the tax amounts.
Tax Type	Select a tax type with which to associate the tax component code. Defining this information filters tax component codes in the Tax Rate Code table to ensure that tax rate code definitions contain only tax component code lines of the same tax type. Values are Excise (this is the default value) and Sales Tax.
Tax Component Code	You define tax components on the Tax Component Code page. Use to group tax component codes of the same tax type under a common tax rate code.
Calculation Scheme	Assign a default calculation scheme to the tax component code. The value that you assign here appears by default to the Tax Rate Code page, where it can be overridden. Values are: Amount: Ad hoc amount-based tax calculation. Percentage: Percentage-based tax calculation. This is the default value. Quantity: Quantity-based tax calculation.
Tax Rate UOM (tax rate unit of measure)	The unit of measure that is associated with the corresponding rate code. Note. If the transaction unit of measure is different from the tax rate code unit of measure, the system performs the conversion using the PeopleSoft-delivered unit of measure conversion feature.
Tax Rate Percent	If the Calculation Scheme field value is set to Percentage, enter a percentage that is to be applied against the taxable amount.
Basis Amount	Base amount against which taxes are calculated.
Tax Rate Amt (tax rate amount)	If the Calculation Scheme field value is set to Quantity, amount to be applied against the transaction quantity, according to the transaction quantity in the Tax Rate UOM value. Note. If the transaction unit of measure is different from the tax rate code unit of measure, the system performs the conversion by using the PeopleSoft-delivered unit of measure conversion feature. If the Calculation Scheme is set to Amount, this is the calculated tax amount. If the Calculation Scheme is set to Percentage, this field is clear and the tax calculation parameter is the Tax Rate Percent field value.
Tax Amount	Tax amount for the tax rate sequence.
Switch Currency Display	Click to switch between the transaction and base currencies.

See Also

Maintaining Order Schedule Information

Populating the Billing Interface With Indian Tax Information

The process to pass information to PeopleSoft Billing depends on whether the item is a shipped item or a non-shipped item. Shipped items require an excise invoice. If an excise invoice is required, an excise invoice must be generated and in a ready state. This is when the excise duty and sales tax is calculated. The Populate Billing process retrieves the calculated excise duty and sales tax information from the excise invoice and passes it to the Billing Interface.

Note. Excise duty or sales tax is not calculated for direct-ship products.

If the item is not going to be shipped, in the case of a service, the Tax Applicability process must be run. The Tax Applicability process determines sales tax applicability and sales tax defaults for the item so that they can be passed to the Billing Interface. In addition, if an item requires an excise invoice and it is not created, it sets the excise duty applicable flag on the Excise and Sales Tax page to indicate that an excise invoice is needed. PeopleSoft Inventory creates the excise invoice in subsequent runs of the Applicability Check process (OM_EXS_APPL) so it can be passed to the Billing Interface for billing.

PeopleSoft Billing calculates the actual sales tax amounts.

The scenarios describe what is passed to PeopleSoft Billing.

When neither excise duties nor sales taxes are applicable, Populate Billing passes a blank excise invoice number, excise tax applicability as no, sales tax applicability as no, and passes no tax parameters or tax details.
When both excise duties and sales taxes are applicable and the excise invoice is created, the Populate Billing process passes the excise invoice number, excise tax applicability as yes, sales tax applicability as yes, and all tax parameters for excise duties and sales taxes are passed.

If the excise invoice is not yet created, billing activity is not passed. This activity can be passed in a later processing run after the excise invoice is created.
When excise duties are not applicable but sales taxes are applicable, no excise invoice is needed. The Populate Billing process passes a blank excise invoice number, excise tax applicability as no, sales tax applicability as yes, and all tax parameters for sales tax are passed.

The table summarizes how excise duty and sales tax information are passed to the Billing Interface by the Populate Billing process.

Excise Tax Applicability	Sales Tax Applicability	Passed to PeopleSoft Billing Interface
Yes	No	Excise tax components Excise tax amounts
Yes	Yes	Excise tax components Excise tax amounts Sales tax components Sales tax amounts
No	Yes	Sales tax components Sales tax amounts
No	No	None

See Also

Billing Orders

(IND) CreatingShipping Excise Invoices for India

Setting Up the Billing Interface

Pages Used to Populate the Billing Interface with Excise Duty and Sales Tax Information

Page Name	Definition Name	Navigation	Usage
Applicability Check	RUN_OM_EXS_APP_CHK	Inventory, Fulfill Stock Orders, Shipping Excise IND, Tax Applicability	Run the Applicability Check process, which checks each ship line to determine if excise duties and sales taxes are applicable. Specify a business unit or all ship lines for all business units are selected.
Populate Billing	RUN_OM_BILLING1	Order Management, Quotes and Orders, Create OM Billing Entries, Process OM Billing	Run the Populate Billing process (OM_BILL) or run the OM Invoicing multi-process job (OM_INC) to populate the Billing Interface tables with excise duty and sales tax information from the excise invoice. When you select the OM Invoicing process, the Populate Billing, Billing Interface, and Process VAT Defaults processes are run. These processes are also part of the Direct Invoicing multi-process job (DIRCTIV2). See Populating Billing.

Page Name

Definition Name

Navigation

Usage

Applicability Check

RUN_OM_EXS_APP_CHK

Inventory, Fulfill Stock Orders, Shipping Excise IND, Tax Applicability

Run the Applicability Check process, which checks each ship line to determine if excise duties and sales taxes are applicable. Specify a business unit or all ship lines for all business units are selected.

Populate Billing

RUN_OM_BILLING1

Order Management, Quotes and Orders, Create OM Billing Entries, Process OM Billing

Run the Populate Billing process (OM_BILL) or run the OM Invoicing multi-process job (OM_INC) to populate the Billing Interface tables with excise duty and sales tax information from the excise invoice. When you select the OM Invoicing process, the Populate Billing, Billing Interface, and Process VAT Defaults processes are run. These processes are also part of the Direct Invoicing multi-process job (DIRCTIV2).

See Populating Billing.