Integrating with PeopleSoft Receivables, General Ledger, and Accounts Payable

This chapter provides an overview of PeopleSoft Receivables, General Ledger, and Accounts Payable integration and discusses how to:

• Run the Currency Conversion process (BICURCNV).

• Run the Pre-Load process (BIPRELD).

• Correct combination edit process errors.

• Run the Load AR Pending Items process (BILDAR01).

• Run the Load GL Accounting Entries process (BILDGL01).

• Run the Generate AP Voucher process (BIGNAP01).

Understanding PeopleSoft Receivables, General Ledger, and Accounts Payable Integration

The following processes prepare and transfer billing information to the Receivables, General Ledger, and Accounts Payable accounting applications:

• Currency Conversion (BICURCNV)

• Pre-Load (BIPRELD)

• Load AR Pending Items (BILDAR01)

• Load GL Accounting Entries (BILDGL01)

• Generate AP Voucher (BIGNAP01)

The processes can be run independently, or included in a multiprocess job, such as the Single Action invoice job (BIJOB03). When running these processes individually, you must run the Currency Conversion and Pre-Load processes before loading to AR (Accounts Receivable) or GL (General Ledger). The Load AR and Load GL processes require that the base currency amounts be calculated by the Currency Conversion process and that accounting entries be staged by the Pre-Load process. You do not need to run the Currency Conversion or Pre-Load process before running the Generate AP Vouchers process (BIGNAP01).

Note. Individual processes should not be run concurrently. For example, the BICURCNV process should not be initiated for two different business units at the same time.

Open Item Processing

You can set up open item accounts in the General Ledger application and charge bill lines to open items within these accounts. When you run the Load GL process, Billing passes the open item charges to General Ledger and Receivables where those applications can reconcile the account balances using the value in the Open Item Key field of the bill line's accounting distribution.

To process open item charges from Billing, you must set the Open Item Key field of the accounting entry definition for Billing to OPEN_ITEM_KEY. In addition, you must set the summarization options for the Billing Journal Generator template to Retain Detail.

See Setting Up for Journal Generator.

The BIIF0001 process does not validate the open item keys for Billing Interface transactions for interunit and intraunit transfers. In addition, the system does not validate open item keys for the balancing entries created by the Inter/Intraunit Processor during the preload process.

See Also

Post-Invoicing Processing Steps

Running Single-Action Jobs for Regular and Consolidated Invoices

PeopleSoft Receivables PeopleBook

PeopleSoft General Ledger PeopleBook

PeopleSoft Payables PeopleBook

Common Elements Used in This Chapter

Running the Currency Conversion Process (BICURCNV)

This section provides an overview of the Currency Conversion process and discusses how to run the Currency Conversion process.

Understanding the Currency Conversion Process (BICURCNV)

Currency conversion process calculates base currency and euro currency amount values and stores them in the PeopleSoft Billing tables with the amounts in the bill transaction currency. The process can perform calculations on bills that are not yet finalized by storing the converted amounts as estimated values and on finalized bills to calculate final converted values, which are needed by subsequent processes such as the Load AR and Load GL processes.

If you process bills using a cycle billing approach rather than a single action approach, invoicing and printing your bills throughout each day but loading to Accounts Receivable and General Ledger less frequently (perhaps weekly or monthly), you can schedule periodic currency conversion runs (perhaps daily at the end of the day) to finalize currency conversions for any newly invoiced bills. Doing so enables you to defer currency conversion to an after-hours schedule, but still have it performed well in advance of scheduled runs that Load to AR or Load to GL.

Note. You must run the Billing Currency Conversion process prior to running the Billing Pre-Load Process, the Load AR Pending Items process, or the Load GL Interface process even if you are not using multiple currencies.

The Billing Currency Conversion process (BICURCNV) is normally included in several jobs, including Currency Conversion & Load AR (BIJOB05), Currency Conversion & Load GL (BIJOB06), Single Action Invoice (BIJOB03), and Single Action Invoice Consolidation (BIJOB04). However, you can also run it independently, using the process as a separate utility to estimate the converted currency values for uninvoiced activity prior to building new accumulation balances or for timing reasons.

Warning! The Currency Conversion process is not designed for concurrent processing. Conflict may occur when two Currency Conversion processes attempt to access the same data.

If you use the euro or base currency amounts of accumulation balances in your processing, and you want to include uninvoiced amounts in the accumulation balances, run the Currency Conversion process to estimate the converted currency values for uninvoiced activity prior to building new accumulation balances. Select the Estimate option on either the Currency Conversion page or the Currency Conversion (Consol) page, and run the Currency Conversion process after you run the finalization process.

Avoiding and Resolving Data Conflict

The Currency Conversion process is not designed for concurrent processing; however, you can avoid conflict by following these guidelines:

• Review the database structure:

  • Implement the database indexes that are recommended for the Currency Conversion process in the posted informational document Performance Recommendations for PeopleSoft Billing for the current release. For assistance to obtain the latest version, contact your PeopleSoft representative.

  • Partition the Billing transaction tables by business unit.

  Note. The database structure should be reviewed and optimized by your PeopleSoft database administrator.

• When running the Currency Conversion process (or a job containing the process), always define the business units to be processed in the run control parameters.

• Always allow one Currency Conversion process to finish before starting another Currency Conversion process that operates on the same or an overlapping set of business units.

  Note. You can start a second Currency Conversion process if it operates on a different set of business units (and you have partitioned the transaction tables as recommended). Allow a brief interval (about 30 seconds) before starting the second process or job.

If a data conflict occurs, have your PeopleSoft database administrator release the database table locks. Restart the Currency Conversion process, allowing the first failed process to finish before restarting any subsequent processes.

Error Codes Used by the Currency Conversion Process

Edit checks that are included in the currency conversion process identify conditions under which the process could not successfully complete currency conversion. If the edit check finds an error, it flags an error condition using one of the following error codes:

Currency Precision Rounding

In a multicurrency environment that is defined by PSOPTIONS.MULTICURRENCY = Y, the application engine function %ROUND is applied to database amount values after they are initially calculated. %ROUND is used in the following sections:

When not in a multicurrency environment, amounts are calculated to two-decimal precision.

Pages Used to Run the Currency Conversion Process (BICURCNV)

Running the Currency Conversion Process (BICURCNV) for Regular and Consolidated Invoices

To run the Currency Conversion process for regular invoices, access the Currency Conversion page (Billing, Generate Invoices, Non-Consolidated, Convert Currency Amounts, Currency Conversion). To run the Currency Conversion process for consolidated invoices, access the Currency Conversion (Consol) page (Billing, Generate Invoices, Consolidated, Convert Currency Amounts, Currency Conversion).

After you define run controls and access the Process Scheduler page, select the Billing Currency Conversion job and click OK.

Warning! Do not start the Currency Conversion process if another Currency Conversion process is already running.

See Understanding the Currency Conversion Process (BICURCNV).

Running the Pre-Load Process (BIPRELD)

This section provides an overview of the Pre-Load process and discusses how to run the Pre-Load process.

Understanding the Pre-Load Process (BIPRELD)

Run the Pre-Load process (BIPRELD) after the Currency Conversion process and before the Load AR process (BILDAR01) and the Load GL process (BILDGL01).

Note. You are not required to run the Pre-Load process prior to the Load AR process for bills with a GL level (at the system, business unit, or bill type level) that you set to AR Creates GL Accounting Entries or No GL Accounting Entries on the Installation Options, Billing - GL/AR page.

Components of the Pre-Load process include:

• Preparation of accounting information for bills that are not subject to ChartField inheritance or Inter/IntraUnit processing.

• ChartField inheritance processing.

• Centralized Inter/IntraUnit processing (including ChartField balancing).

• ChartField combination edit processing for entries that are not edited against the combo edit rules online or where batch combo edit is set on the Installation Option, Billing - GL/AR page.

Important! You should regularly purge the temporary staging entries created by the Pre-Load process by running the Billing Delete Data process (BIDELDATA). The Billing Delete Data process removes entries that have already been loaded to AR and GL. Entries pending the load processes and entries with errors are not deleted.

See Also

Using Interunit and Intraunit Accounting and ChartField Inheritance

Deleting Temporary Data

Pages Used to Run the Pre-Load Process

Preparing Accounting Information

The Pre-Load process performs the following tasks to prepare preliminary accounting information for bills with GL levels that are defined when billing creates GL accounting entries:

1. Determines whether a bill should be processed by the Pre-Load process by checking the PRELOAD_IND field on the BI_HDR table.

2. Determines whether a bill should be processed by the ChartField inheritance processing, centralized Inter/IntraUnit processing, and ChartField combination edit processing components of the Pre-Load process by checking the CF_ACTION_FLG field on BI_HDR table.

   The system populates the CF_ACTION_FLG field on the BI_HDR table if you set up ChartField inheritance options on the Inheritance Options page (CF_INHERIT_TBL) or if you select ChartField balance options on the Detail Ledger Group - InterUnit page.

   Note. If ChartField inheritance is activated and an inherited ChartField differs across bill lines, the Pre-Load process (BIPRELD) summarizes AR offset entries when you define AR_LVL = H and AR_DST_OPT = H. If ChartField inheritance and ChartField balancing are activated, the balancing ChartField must be inherited because additional balancing entries are not created for the summary entries.

3. Updates PeopleSoft Billing tables with the latest distribution ID value.

4. Inserts revenue and InterUnit expense accounting entries into BI_ACCT_LN_STG.

   The Load GL process (BILDGL01) uses this data to calculate recognizable revenue in the process-deferred logic. For nondeferred bills, the Load GL process uses this data when moving entries from BI_ACCT_LN_STG to BI_ACCT_ENTRY.

5. Inserts into BI_ACCT_LN_STG all remaining accounting entries, including AR, DS, UAR, and STAT entries, for bills for which no further ChartField related processing is required.

6. Generates value-added tax (VAT) and tax accounting entries.

7. Calls the ChartField Inheritance, Inter/IntraUnit Processor, and ComboEdit processes for bills for which further processing is necessary.

ChartField Inheritance Processing

The Pre-Load process calls the ChartField Inheritance process when:

• You define the GL level on the Installation Options - Billing - GL/AR page as BI Creates GL Acct Entries (PeopleSoft Billing creates general ledger accounting entries).

• You select ChartField inheritance for the corresponding setID for the business unit.

The ChartField Inheritance process generates entries for the accounting entry types AR, UAR, DR (including that for DSC/SURC), RR (for discount and surcharge only), TX, and VAT, based on ChartField values from the source line revenue, for all bills that:

• Are selected for the run control selection parameters.

• Have ChartField inheritance options enabled.

Note. In PeopleSoft Billing, accounting entries generally inherit balancing ChartField values from revenue entries when inheritance options are defined as Always Inherit or Inherit within Unit on the ChartField Inheritance page. For InterUnit bills for which Billing generates entries for both the bill-from and bill-to GL business units, InterUnit payable entries inherit ChartField values from InterUnit expense entries. When a bill originates from PeopleSoft Contracts or Project Costing and Billing does not manage revenue, accounting entries inherit ChartField values from unbilled revenue entries, because in this scenario the bill has no revenue entries.

See Also

Using Interunit and Intraunit Accounting and ChartField Inheritance

Defining Additional Billing Installation Options

Interacting with the Centralized Inter/IntraUnit Processor

The Pre-Load process interacts with the Centralized Inter/IntraUnit Processor after completing the ChartField inheritance steps.

The PeopleSoft Central Inter/IntraUnit Processor:

• Selects transaction line rows from application tables according to the record names and selection criteria that are supplied.

• Inserts any required InterUnit and IntraUnit lines that are due to or due from into the BI_ACCT_LN_STG table to ensure balanced entries for the transaction.

See Also

Using Interunit and Intraunit Accounting and ChartField Inheritance

Interacting with the Combo Edit Process

The Pre-Load process calls the PeopleSoft General Ledger Combination Edit process to validate ChartField combinations for all generated accounting entries.

You can view and correct accounting information with ChartField combination edit errors using the Correct Staged Accounting Errors component.

See Also

Correcting Accounting Entries That Fail Budget Checking

Understanding General Ledger Background Processes

Correcting Combination Edit Process Errors

This section gives an overview of when to rerun the Pre-Load process and lists the pages that you use to correct the Combination Edit process errors.

Using the Correct Staged Acctg Errors component, you can correct accounting information with combination edit errors that occur during the Pre-Load process.

Note. Correct Staged Acctg Errors component enforces ChartField Security. The component registry entries are delivered with only a subset of detail records enabled for ChartField Security. You can enable or disable the detail records from ChartField Security depending on the business requirements. Keep in mind that each detail record that is enabled adds overhead to open the component.

Understanding When to Rerun the Pre-Load Process

You must run the Pre-Load process after staged accounting entry correction.

Note. You cannot change the accounting entries that are in error if those entries are generated by the system through the Pre-Load process. In this scenario, you can correct the source accounting information, change the ChartField inheritance rules, or change the combination edit rules to enable the invoice to complete the Pre-Load process without error.

Note. If you select the Customer Vendor Affiliate option (BUS_UNIT_TBL_GL.CUST_VNDR_AFFILIATE = Y) on the General Ledger Definition - Definition page, the Affiliate field that is in the Correct Staged Acctg Errors component is not available for entry. The system supplies the Affiliate field values automatically.

Pages Used to Correct Combination Edit Process Errors

Running the Load AR Pending Items Process (BILDAR01)

If you want the receivables system to read the accounts receivable information from the PeopleSoft Billing system—regardless of whether you use PeopleSoft Receivables or a third-party receivables system—you must load the accounts receivable pending items into a pending items table. The Load AR Pending Items process (BILDAR01) populates the pending items table for both regular and consolidated bills so that you can post invoicing information to your customers' accounts.

This section provides an overview of the Load AR Pending Items process (BILDAR01) and discusses how to:

• Run the Load AR Pending Items process for regular and consolidated invoices.

• Regenerate AR pending item reports.

Understanding the Load AR Pending Items Process (BILDAR01)

The Load AR process groups invoices by each distinct bill currency within the business unit that it is processing and inserts rows in the pending item tables. The process inserts group control information with the control counts and amounts. For VAT processing, the Load AR process inserts additional information into the pending VAT table and updates the bill header to indicate that an AR entry or entries are created for the bill.

The Load AR process performs the following steps:

1. Checks credit card authorization.

2. Builds a ChartField array to support dynamic ChartFields.

3. Inserts invoices to be processed into the Load AR temporary table.

4. Processes invoices with a GL level that is defined as AR creates GL accounting entries, grouping by currency code.

5. For all invoices with a GL level that is defined as AR creates GL accounting entries, if the AR level is defined as Header is AR open item:

   1. Formats invoice amounts as entry amounts.

   2. Applies default entry type and entry reason if none exists on the bill header; otherwise, validates the entry type and entry reason on the bill header.

   3. Formats subcustomer qualifier fields from the bill header.

   4. Formats various fields from the bill header.

   5. Inserts pending item.

   6. If the VAT declaration point is not blank, inserts to PENDING_VAT.

6. For all invoices with a GL level that is defined as AR creates GL accounting entries, if the AR level is defined as Bill line is AR open item:

   1. Formats net extended amount as entry amount.

   2. Applies default entry type and entry reason if none exists on the bill line; otherwise, validates the entry type and entry reason on the bill line.

   3. Formats subcustomer qualifier fields from bill line.

   4. Formats various fields from the bill line.

   5. Inserts pending item for each line.

   6. If the VAT declaration point is not blank, inserts to PENDING_VAT.

7. Processes invoices with a GL level that is defined as BI creates GL accounting entries or No GL accounting entries, grouping by currency code.

8. For all invoices with a GL level that is defined as BI creates GL accounting entries or No GL accounting entries, if the AR level is defined as Header is AR open item:

   Note. For all invoices with a GL level defined as Billing creates GL accounting entries, if the AR distribution option is defined as Use Header for Distribution, the system does not force the AR_LVL from H to L when multiple AR offsets exist; the process creates one item containing the summarized AR offsets generated by the preload process.

   1. Formats invoice amount as entry amount.

   2. Applies default entry type and entry reason if none exists on the bill header; otherwise, validates the entry type and entry reason that is on the bill header.

   3. Formats subcustomer qualifier fields from the bill header.

   4. Formats various fields from the bill header.

   5. If the GL level is defined as Billing creates GL accounting entries, looks at BI_ACCT_LN_STG to determine whether pending items are created at the bill line level based on a summarized set of balanced ChartFields of accounting entry type AR and:

      Inserts a pending item into the Pending table.

      Inserts receivables distribution into PENDING_DST, retrieving ChartFields from the BI_ACCT_LN_STG table.

      If the VAT declaration point is not blank, inserts VAT information to PENDING_VAT. Additionally, inserts to PENDING_DST, retrieving ChartFields from the BI_ACCT_LN_STG table.

   6. If the AR level is defined as Header is AR Open Item and the AR distribution option is defined as Use Header for Distribution, you have enabled ChartField inheritance, and if an inherited ChartField differs across bill lines, then the process creates one item with the summarized AR offsets generated by the BIPRELD process.

   7. If the AR level is defined as Header is AR Open Item and the AR distribution option is defined as Use Line for Distribution, you have enabled ChartField inheritance, and if an inherited ChartField differs across bill lines, then the process creates only one item with an AR offset for each line.

   8. If the GL level is defined as No GL accounting entries:

      Inserts pending item based on AR level of Header is AR open item.

      Inserts receivables distribution by retrieving ChartFields from BI_LINE_DST_AR.

      If the VAT declaration point is not blank, inserts VAT information to PENDING_VAT. Additionally, inserts to PENDING_DST, retrieving ChartFields from the VAT tables.

9. For all invoices with a GL level that is defined as BI creates GL accounting entries or No GL accounting entries, if the AR level is defined as Bill line is AR open item:

   1. Applies default entry type and entry reason if none exists on the bill line; otherwise, validates the entry type and entry reason that is on the bill line.

   2. Formats subcustomer qualifier fields from the bill line.

   3. Formats various fields from the bill line.

   4. Inserts a pending item into the Pending Items table for each bill line

   5. If the GL level is defined as Billing creates GL accounting entries:

      Inserts receivables distribution into PENDING_DST retrieving ChartFields from the BI_ACCT_LN_STG table.

      If the VAT declaration point is not blank, inserts VAT information to PENDING_VAT. Additionally, inserts to PENDING_DST, retrieving ChartFields from the BI_ACCT_LN_STG table.

   6. If the GL level is defined as No GL accounting entries:

      Inserts receivables distribution retrieving ChartFields from BI_LINE_DST_AR.

10. Checks group balance.

11. Inserts a record into the GROUP_CONTROL table.

12. Updates the BI_HDR table.

13. Prints summary report.

Entry Type and Entry Reason Defaults

The system uses entry types and reasons to categorize pending items when passing PeopleSoft Billing information to the PeopleSoft Receivables system. You can define these default entry types and reasons for debit and credit activity at the business unit, bill type, and bill source levels, and override these defaults during bill entry at the bill header and bill line levels.

Before passing the appropriate entry types and reasons to PeopleSoft Receivables, the Load AR Pending Items process must do the following tasks.

If you define the AR level on the Installation Options, Billing - GL/AR page with the field value Header is AR Open Item:

1. The Load AR Pending Items process determines whether the Entry Type and Entry Reason fields on the Bill Header table are populated.

   1. If the fields are populated, the process ensures that the entry type and entry reason fields are appropriate for the sign of the invoice amount (after taxes are applied at invoicing, the amount can change from positive to negative).

   2. If the invoice amount is positive, the process looks for a debit entry type and reason. If the invoice amount is negative, the process looks for a credit entry type and reason.

   3. If the fields are not populated, the process retrieves the appropriate default entry type and entry reason from bill source, bill type, or business unit, according to the default hierarchy.

2. If you define the AR level value on the Installation Options, Billing - GL/AR page as Bill LINE is AR Open Item:

   1. The Load AR Pending Items process determines whether Entry Type and Entry Reason fields that are on the bill line table are populated.

   2. If the fields are populated, the process passes these values to PeopleSoft Receivables.

   3. If the net extended amount is positive, the process looks for a debit entry type and reason. If the net extended amount is negative, the process looks for a credit entry type and reason.

   4. If the fields are not populated, the process retrieves the appropriate default entry type and entry reason from bill source, bill type, or business unit, according to the default hierarchy.

Example of Default Hierarchy

The following example illustrates the default hierarchy:

The Load AR Pending Items process is processing an invoice with two lines. The AR level is defined with the value Bill Line is Open Item. The first line is a positive amount with a blank entry type and reason.

To supply the entry type and reason on this first line, the Load AR Pending Items process looks first to the bill source for a debit entry type and reason. However, no debit entry type or reason is defined there. The process then looks to the bill type, which does have a debit entry type and reason. The process retrieves the debit entry type and reason codes from the bill type for this line open item and passes them to PeopleSoft Receivables.

The second line on the invoice is a negative amount with the entry type and reason omitted.

To supply the entry type and reason on the second line, the Load AR Pending Items process looks first to the bill source for a credit entry type and reason. No entry type or reason is defined there, so the process looks to bill type. A credit entry type and reason is not defined at the bill type either. Therefore, the process looks to the business unit, where it retrieves the default credit entry type and reason codes for this invoice and passes them to PeopleSoft Receivables. An entry type and reason always exists at the business unit level because they are mandatory.

Affiliate ChartField Defaults

PeopleSoft Billing passes the Affiliate ChartField value to PeopleSoft Receivables if PeopleSoft Billing is creating the accounting entries. When PeopleSoft Receivables is creating accounting entries, PeopleSoft Receivables assigns the affiliate value.

Load AR Process Error Codes

The following error codes are specific to the Load AR process:

Pages Used to Run the Load AR Pending Items Process (BILDAR01)

Running the Load AR Pending Items Process for Regular and Consolidated Invoices

Loading PeopleSoft Billing items into PeopleSoft Receivables is a two-step process:

1. In PeopleSoft Billing, load the invoiced data into an interface for pending items.

   To run the Load AR Pending Items process for regular and consolidated invoices, access the Load AR Pending Items page or the Load AR for Consolidated Bills page, as applicable.

   If you do not specify a billing business unit, the system processes all invoices within the specified entry date range for all billing business units.

   After you define the run controls and access the Process Scheduler page, select the Currency Conversion & Load AR job, which runs several processes at once. If you run the processes individually, you must run them one at a time and run Currency Conversion first.

2. In PeopleSoft Receivables, post those pending items as PeopleSoft Receivables items.

   Setting the posting action on the Load AR Pending Items page or the Load AR for Consolidated Bills page loads the pending items with the proper action option so that the Receivable Update process can determine how to post the items.

Regenerating AR Pending Item Reports

You can regenerate an AR Pending Items report listing all pending items that are processed in a specified AR entry date range. For example, you may want to regenerate lost reports that were created from previous Load AR processes.

To regenerate an AR Pending Item Report for regular or consolidated invoices, access the AR Pending Item Report page (Billing, Generate Invoices, Reproduce Reports, AR Pending Item Report) or the Consolidated AR Pending Item Report page (Billing, Generate Invoices, Reproduce Reports, Consol AR Pending Item Report, Consolidated AR Pending Item Report), as applicable.

Running the Load GL Accounting Entries Process (BILDGL01)

Run the Load GL processes to create accounting entries for billing activities and unbilled revenue accruals. Two different processes are available that insert accounting entries to the PeopleSoft Billing Accounting Entries table (BI_ACCT_ENTRY): the Load GL Accounting Entries process (BILDGL01) and the Load GL Unbilled Revenue Accrual process (BIACCRUE).

This section provides overviews of the Load GL Accounting Entries process and accounting entries, and discusses how to:

• Run the Load GL Accounting Entries process (BILDGL01) for regular and consolidated invoices.

• Regenerate Load GL Accounting Entries reports.

• Restart the Load GL process.

• Inquire about GL accounting entries.

Note. You must set up ChartField reporting options before running the Load GL Accounting Entries process (BILDGL01). Without the ChartField reporting option information, the system cannot determine which ChartFields to include on the report.

See Also

Using Unbilled Revenue Accrual

Understanding the Load GL Accounting Entries Process (BILDGL01)

The Load GL process performs the following tasks:

1. Checks credit card authorization for all invoices.

2. Inserts into the Load GL temporary table all invoices that are to be processed (those invoices that are processed by the Pre-Load process).

3. Determines which bill lines are subject to deferred revenue processing.

4. Inserts accounting entries into the BI_ACCT_ENTRY table, retrieving rows from BI_ACCT_HDR_STG and BI_ACCT_LN_STG for bill lines that are not subject to deferred revenue.

   1. Inserts AR accounting and revenue accounting entries.

   2. Inserts revenue accounting entries for Inter/IntraUnit invoices.

   3. Inserts revenue accounting entries for discounts and surcharges.

   4. Inserts Inter/IntraUnit expense accounting entries for Inter/IntraUnit invoices.

   5. Inserts Inter/IntraUnit payable accounting entries for Inter/IntraUnit invoices.

   6. Inserts tax accounting entries into the BI_ACCT_ENTRY table.

   7. Inserts VAT tax accounting entries into the BI_ACCT_ENTRY table for invoices that are subject to VAT.

   8. Inserts statistical accounting entries into the BI_ACCT_ENTRY table.

   9. Inserts unbilled AR accounting entries into the BI_ACCT_ENTRY table.

5. Inserts deferred revenue accounting entries into BI_ACCT_ENTRY (retrieving data from BI_ACCT_LN_STG), and applies processing rules as defined by the deferred revenue proration method.

6. Handles adjusted invoice or invoice lines by creating reversal entries for the current accounting period and deleting undistributed future period entries.

7. Creates reversal entries for entries that are generated by the Load GL - Unbilled Accrual process and subsequently invoiced and billed to customers in the same accounting period.

8. Prints a summary report.

The following process flow illustrates how the Load GL Accounting Entry process fits into the overall journal entries generating process.

Overall journal entries generating process and the role of the Load GL Accounting Entry process in the entire procedure

Understanding Accounting Entries

You must populate the PeopleSoft Billing Accounting Entry table (BI_ACCT_ENTRY) with accounting entries before you can create PeopleSoft General Ledger accounting entries.

The Load GL Accounting Entries process (BILDGL01) populates the Billing Accounting Entry table with accounting entries that the Journal Generator eventually picks up. The process selects for processing all bills in the specified range selection that have a status of INV and that have finished the Billing Currency Conversion process and the Pre-Load process.

The following table lists values for accounting entry types:

Note. To ensure that you have set up PeopleSoft Billing to generate GL accounting entries for the system, refer to the Installation Options, Billing - GL/AR Options page.

Pages Used to Run the Load GL Accounting Entries Process (BILDGL01)

Running the Load GL Accounting Entries Process (BILDGL01) for Regular and Consolidated Invoices

To run the Load GL Accounting Entries process for regular invoices, access the Load GL Accounting Entries page (Billing, Generate Invoices, Non-Consolidated, Create Accounting Entries, Load GL Acctng Entries, Load GL Accounting Entries); for consolidated invoices, access the Load GL for Consolidated Bills page (Billing, Generate Invoices, Consolidated, Create Accounting Entries, Consolidated Load GL, Load GL for Consolidated Bills).

After you define the run controls and access the Process Scheduler page, select the Curr Con Preload & Load GL job, which runs several processes at once. If you run the processes individually, you must run them one at a time and run Currency Conversion first, followed by the Pre-Load process.

Regenerating Load GL Accounting Entries Reports

Access the GL Accounting Entries Report page (Billing, Generate Invoices, Reproduce Reports, GL Accounting Entries, GL Accounting Entries Report) or the Consol GL Accounting Entries page (Billing, Generate Invoices, Reproduce Reports, Consol GL Accounting Entries) to regenerate a GL Accounting Entries report listing all accounting entries that are processed in a specified accounting date range. For example, you may want to regenerate lost reports that are created from previous Load GL processes.

See Also

Entering Bill Header Information

Restarting the Load GL Process

The PeopleSoft Billing Load GL process (BILDGL01) contains restart logic to enable you to restart the process from the point preceding a termination of the process, should one occur. Additionally, the Load GL process tags invoices that are selected for a Load GL process request with the process instance of the corresponding request to prevent duplicate accounting entries. If the Load GL process terminates after the system marks invoices with the process instance but before the accounting entries are created, the system does not generate accounting entries for these invoices without restart logic.

Note. To prevent duplicate accounting entries, the system does not process concurrent Load GL process requests that include invoices that are previously tagged with a process instance.

The Load GL Process table (BI_LOADGL_PROC) facilitates the restarting process. It retains the process instance and status of the Load GL process request. The system displays the information in this table on the Load GL Accounting Entries and Load GL for Consolidated Bills pages when a Load GL request has terminated and needs to be restarted.

Updating the Load GL Process Table

Before the system carries out each SQL Commit command of the Load GL process, it updates the Load GL Process table with the process instance and the status of the corresponding request. The system updates the process status with a number that indicates the current stage of the Load GL process. The process status numbers and the corresponding stages are:

Displaying Load GL Requests that Process Successfully

The system updates the status on the Load GL Process table to indicate that processing is complete before it carries out the last SQL Commit command for the corresponding request. After all requests for a run control are processed, the system deletes all records in the Load GL Process table for the corresponding run control. When multiple requests are all processed successfully, the Load GL Accounting Entries and Load GL for Consolidated Bills pages are displayed.

In this scenario, the system does not display the BI Load GL Status and Restart Process Instance fields. If the system processes successfully all requests within a run control, the parameters for the request are available to edit.

Displaying Load GL Requests That Terminate

The run control may contain a Load GL request that does not process successfully. On the Load GL Accounting Entries or the Load GL for Consolidated Bills page, the BI Load GL status indicates that the process is Complete for those requests that process successfully. The parameters for requests that process successfully are not available for edit when succeeding requests within the run control terminate.

If a request terminates after a SQL Commit command, the Load GL process saves the process instance and process status number on the Load GL Process table. The Load GL Accounting Entries or the Load GL for Consolidated Bills page displays the BI Load GL status of the aborted request and the Restart Process Instance number. All other request parameters are unavailable for entry.

All requests not processed, those that follow a terminated request, can be modified. You cannot delete a Load GL process request that must be restarted.

Restarting a Terminated Request

Although the system does not perform validation edits to ensure that you do not include in a second Load GL process request those invoices from a terminated request, you must use the original run control to restart the process. The system marks invoices that are included in an aborted process with the process instance of the aborted request. Although the system allows you to create a new run control to create general ledger entries for the same invoices, initiating this new run control does not produce any general ledger entries.

The system uses the process status number in the Load GL Process table to determine where to restart the request. It restarts a terminated process from the appropriate process status S01 through S99. If the system restarts a request from status S99, you get duplicate copies of the report if the process terminates after the report is printed.

You can check the Message Log to verify the stage from which a request is restarted.

Note. You cannot add a new Load GL process request to a run control ID that requires a restart. The Load GL process does not include any new invoices that become eligible between the request abort and the request restart, even if these invoices meet the existing run control selection criteria.

Inquiring About GL Accounting Entries

After you run the Load GL process or the Unbilled Revenue Accrual process, you can inquire on the accounting entries that are created by using the Accounting Entries By Invoice page.

You can also review the accounting entries after they go through the Journal Generator process and are posted to the general ledger on the Accounting Entries By Journal - Accounting Entry page. You can navigate to the corresponding line details by using the following page elements:

See Also

Determining the Status of Journals

Running the Generate AP Vouchers Process (BIGNAP01)

This section provides an overview of the Generate AP Vouchers process (BIGNAP01) and discusses how to:

• Generate regular and consolidated AP vouchers.

• Regenerate AP voucher entries reports.

Understanding the Generate AP Voucher Process (BIGNAP01)

The Generate AP Voucher process initiates the creation of AP vouchers for InterUnit bills. The process takes InterUnit billing information from the Centralized Inter/IntraUnit Setup table and populates the Payables Voucher Master staging tables. The PeopleSoft Payables Voucher Build process (AP_VCHRBLD) then generates voucher record sets and completes the voucher process.

You need to run the Generate AP Voucher process only if the installation includes PeopleSoft Payables and you have designated that the payables system creates the vouchers.

The Generate AP Voucher process performs the following tasks:

1. Checks credit card authorization.

2. Builds a ChartField array to support dynamic ChartFields.

3. Inserts invoices to be processed, InterUnit bills with GEN_AP_VCHR_FLG = Y, into the BI_GNAP_TMP temporary table.

4. Performs the following steps for invoices for which GEN_AP_VCHR_FLG = Y.

   1. Updates BI_GNAP_TMP with the current Inter/IntraUnit control parameters that are retrieved from the centralized setup table.

   2. Inserts a row into VCHR_HDR_STG for each header for VAT and non VAT bills.

   3. Inserts a row into VCHR_LINE_STG for each line for VAT and non-VAT bills.

   4. Inserts a row into VCHR_DIST_STG, retrieving ChartField values from BI_LINE_IU_EXP.

5. Updates the BI_HDR table.

6. Prints a summary report.

Note. The Generate AP Voucher process creates voucher entries only in the PeopleSoft Payables interface staging tables. The actual vouchers, however, are generated within PeopleSoft Payables.

See Also

Processing Batch Vouchers

Pages Used to Run the Generate the AP Vouchers Process (BIGNAP01)

Generating Regular and Consolidated AP Vouchers

To run the Generate AP Voucher process, access the Generate AP Vouchers page (Billing, Generate Invoices, Non-Consolidated, Load Invoices to AP, Generate AP Vouchers) or the Consolidated Generate AP Vchr page (Billing, Generate Invoices, Consolidated, Load Invoices to AP, Consolidated Generate AP Vchr), as applicable. Select Print Generate AP Report to generate a report listing all AP vouchers that were processed previously by the Generate AP Vouchers process.

After you define the run controls and access the Process Scheduler page, select the Generate AP Vouchers process and click OK.

Regenerating AP Voucher Entries Reports

Access the AP Voucher Entries Report page (Billing, Generate Invoices, Reproduce Reports, AP Voucher Entries, AP Voucher Entries Report) to regenerate an AP Voucher Entries report listing all voucher entries that are processed within a specified range selection. For example, you may want to regenerate lost reports that are created from previous Generate AP Voucher processes.

In the Report Request Parameters group box, select from the following options:

Note. Oracle recommends that you generate the AP Voucher Entries report after running the Generate AP Vouchers process (BIGNAP01) and before running the Voucher Build process to avoid the risk of losing information that cannot be retrieved. The system generates this report by using data that is selected from the AP Voucher Master Header table (VCHR_HDR_STG). The Voucher Build process deletes entries from the VCHR_HDR_STG table. Therefore, the system cannot obtain any data from this table after you run the Voucher Build process.

Note. The AP Voucher Master Header table (VCHR_HDR_STG) does not contain the data that is needed to associate attached invoices with a consolidated header invoice. To generate a report listing the results of the Generate AP Vouchers process for a consolidated header invoice, define the range selection to include the individual corresponding attached invoices.