Passing VAT Entries to PeopleSoft General Ledger

The Load GL Interface process (BILDGL01) creates accounting entries in the BI_ACCT_ENTRY table. The account entry type is captured in the ACCT_ENTRY_TYPE field. Sales and use tax accounting entries are defined with a code of TX, VAT accounting entries with a code of VT.

VAT amounts have separate entries from sales and use tax entries. VAT amounts also have their own accounting ChartFields. Because PeopleSoft Billing tracks VAT accounting information at a VAT code level, VAT lines have a single set of ChartFields per bill line.

Note: VAT reverse charge will not be passed to PeopleSoft General Ledger.

VAT Changes for Credit Lines and ChartField Source Locations

The Load GL Interface process first checks the VAT_BU_ACCT_TBL table for VAT ChartFields. This table contains the General Ledger business unit as an additional key. If the process finds nothing for the GL business unit, it looks to the VAT_ACCT_TBL table for VAT ChartFields. This table should always be populated with ChartField values.

VAT Distribution Account Type field is used as a key in both the tables. The value of the BI_LINE VAT distribution account type is used in the lookups. If required, ChartField inheritance is applied to the ChartFields that are retrieved for the VAT entries to complete the accounting entries.

Note: The Load GL process picks up only VAT lines with nonzero VAT amounts.