Importing GST Information into the PeopleSoft Billing Tables

PeopleSoft Order Management can pass India GST data to the PeopleSoft Billing application through the Billing interface. PeopleSoft Contracts and other sources (other than PeopleSoft Order Management) can pass India GST required information to the Billing interface by populating the INTFC_BI and INTFC_BI_AEDS tables, which is used by the Billing Interface Process to determine the GST tax information and use that information to populate the other interface tables like INTFC_BI2 and INTFC_BI_EXSD.

Note: PeopleSoft Billing system accepts India GST data on invoices from PeopleSoft Order Management, PeopleSoft Contracts, Assets to Billing Interface, BI Batch, Data from Spreadsheet, PS/IN to PS/BI Interface, and Projects to Billing Interface.

This topic provides an overview of GST data processing in the Billing interface.

The Billing interface staging area supports the online bill data structure and stores one or more rows of data for each line of chargeable activity that is sent to PeopleSoft Billing. The type of data that you store in the Billing interface is characterized by one of seven transaction types.

The Billing Business Unit Tax Indicator

In PeopleSoft Billing, you can apply only a single method for tax calculation to each invoice. The invoice can be subject to standard taxes, including U.S. sales tax and value-added tax (VAT), subject to third-party taxation when the business unit is associated with a third-party tax provider, or associated with India tax processing. These methods are mutually exclusive. For example, if PeopleSoft Billing identifies that an invoice requires PeopleSoft VAT processing, the system assumes that the invoice requires no India tax processing.

You must bill sales order shipments with GST applicability under a Billing business unit that is associated with an organization's tax location.

For example, consider the following PeopleSoft Inventory, Order Management, and Billing business units called IND01, which are all associated with an organization tax location. Imagine also that the following additional Billing business units exist:

  • IND02, which is not associated with an organization tax location.

  • FRA01, which is associated with a VAT entity.

If a sales order shipment is associated with the Inventory business unit IND01, you should not bill the sales order shipment under billing business units IND02 or FRA01, because these business units are not associated with an organization tax location. If you bill this sales order shipment under IND02 or FRA01, PeopleSoft Billing does not display or calculate the India taxes correctly for this shipment. Even if previously calculated excise duty for the shipment exists, PeopleSoft Billing does not display the excise duty if the shipment is billed under a business unit that is not associated with an organization tax location.

The correct procedure is to bill the shipment under the Billing business unit IND01, which is tied to an organization tax location. If the PeopleSoft Inventory or Order Management business units are tied to an organization tax location, you must also associate their respective Billing business units to an organization tax location to ensure that the appropriate tax processing occurs in PeopleSoft Billing.

The Billing Interface process or online bill entry determines the type of tax to which the Billing business unit is subject and populates the billing business unit tax indicator (BI_BU_TAX_IND) field with one the following values:

Term

Definition

0:

The Billing business unit is subject to PeopleSoft standard taxes, including U.S. sales tax and VAT. This value is the default.

1:

The Billing business unit has an associated third-party tax provider.

2:

The Billing business unit has an associated organization tax location. India GST processing may apply.

Bill-By Functionality

PeopleSoft Billing uses the bill-by identifier to define how to group billing activity when it is added to a bill through the Billing Interface. You can define the bill-by identifier at the customer, bill source, bill type, and business unit levels.

Use the following fields as bill-by fields when you require India tax processing to ensure that the invoices have bill lines that share the same associated state tax authority:

  • SHIP_FROM_BU

  • SHIP_TO_CUST_ID

  • BUSINESS_UNIT_OM

The following tables describe how the Billing interface staging tables (INTFC_BI, INTFC_BI2, and INTFC_BI_EXSD) are populated by the Populate Billing process (OMBILL). Because PeopleSoft Order Management performs tax determination for GST, the Populate Billing process populates the related fields that are in the staging table so that the Billing system knows what input parameters are used for the tax determination.

Sources other than Order Management can populate the Billing Interface staging tables (INTFC_BI and INTFC_BI_AEDS). The Process Billing Interface process does the GST tax determination and populates the INTFC_BI2 and INTFC_BI_EXSD staging tables. Only PeopleSoft Order Management does Tax determination for GST and populates the INTFC_BI, INTFC_BI2, INTFC_BI_AEDS, INTFC_BI_EXSD tables.

Note: The Billing interface staging table fields that begin with the EXS prefix represent GST. When the EXS_TAX_TYPE is GST, all EXS fields are populated with GST-related data.

The Billing Interface process expects all GST defaults to be passed by PeopleSoft Order Management, for all sales order transactions except RMAs. The Billing Interface process sets a GST Defaults Applied flag (EXS_DFLTS_APPLIED) to facilitate later processing in PeopleSoft Billing. The interface process sets the value of this flag to one of the following values:

Field or Control

Description

Y (yes)

PeopleSoft Order Management passes the default tax parameters.

The Billing Interface assumes that GST is applicable and that PeopleSoft Order Management provides the GST parameters.

N (no)

PeopleSoft Billing must call the Tax Determination process for the default tax parameters.

PeopleSoft Order Management passes a bill line that has a GST applicability value of Y, but passes no default values for the tax parameters. The Billing Interface assigns this value when billing for sales order activity that is India GST-applicable only.

PeopleSoft Order Management passes a bill line that is for an RMA transaction.

X (not applicable)

GST is not applicable.

To verify data integrity, the Billing Interface process performs edit checks on the data that is presented to the interface staging area. If the Billing Interface process finds an error, it marks the LOAD_STATUS_BI for all related rows as ERR (error). The Billing Interface process also marks the ERROR_STATUS_BI column with a more specific error condition. On the Correct Interface Errors page, review the errors and take the appropriate action to correct the error. The following Billing interface errors table contains information that is specific to India tax error conditions.

Error Condition

Explanation

0112 - Excise Tax is Applicable.

Excise Tax is applicable, but either no excise tax rate code or excise tax detail is provided.

0113 - Missing Tax Rate Code.

GST is applicable, but no tax rate code is provided.

0114 - Invalid India transaction.

Transaction with India taxation did not originate from PeopleSoft Order Management, PeopleSoft Contracts, Projects to Billing, BI Batch, Asset to Billing, Inventory to BI, or Load Data from Spreadsheet. PeopleSoft Billing processes India tax transactions only from these sources.

0116 - GST Applicability not enabled.

Blank GST applicable flag (STX_APPL_FLG) will cause this error.

0119 - Missing Tax Parameters.

Missing tax rate code. For Order Management, the GST Detail record must exist.

0121 - GST not Applicable.

GST tax applicability flag (STX_APPL_FLG) is not set to Y.

5100 - HSN/SAC missing error

When bill line contains no HSN/SAC codes. HSN/SAC code should be entered for a product in Product Tax Applicability.

5105 - Missing product setup in GST

When bill line is missing product setup in GST. GST flag not enabled for the product in Product Tax Applicability.

5106 - Multiple Tax Authorities

When bill line contains multiple tax authorities. Bill lines in an invoice should have only one tax authority.