Passing GST Information to PeopleSoft Receivables

The PeopleSoft Billing Load AR process (BILDAR01) populates rows in the PeopleSoft Receivable pending item tables PENDING_TAX and PENDING_TAX_DTL, and populates columns in the PENDING_ITEM table to support GST processing.

Regardless of how you define the AR level on the Installation Options - Billing - Integration Options page (either Header is AR Open Item or Bill Line is AR Open Item), if the bill line has a tax applicable value of Yes (STX_APPL_FLG = Y) the Load AR process inserts a tax row in the PENDING_TAX table for each tax line on the BI_LINE table, and inserts a row in the PENDING_TAX_DTL for each GST detail line on the BI_LINE_EXS_DTL table.

Additionally, the process inserts rows into the PENDING_DST table for the ChartField distribution based on the GST detail entries. The Load AR process inserts rows for all bill lines with appropriate tax calculation codes, even if the calculated GST amounts are zero.

When PeopleSoft Billing creates accounting entries, the process populates the PENDING_DST table with ChartField values that it selects from the BI_ACCT_LN_STG table, which is populated by the Billing Preload process (BIPRELD). If neither PeopleSoft Billing or Receivables create accounting entries, the process obtains GST accounting entry ChartField values from the tax component code definition, when tax is applicable.