Using Target-Invoice Processing with the Billing Interface

When the Billing Interface process creates new bill headers, it assigns the next available invoice number to each new bill according to the invoice number ID for the bill. To override the automated invoice numbering, use the Billing interface target-invoice functionality.

If data from a source system has an assigned invoice number that you want to retain in PeopleSoft Billing, populate the TARGET_INVOICE field with the preassigned invoice number to pass that number to the Billing interface. You do not need to specify TARGET_INVOICE as a bill-by field in order to take advantage of this functionality. You do not need to modify the Installation Options − Billing - General Options page to mark the autonumbering parameter as user defined.

Ensure that the source system numbering scheme is different from PeopleSoft Billing numbering scheme. Alternately, the source system can populate the BI_IVC_NUM_PRE table to reserve the numbers. The system initiates the Duplicate Invoice Check function during online bill entry to check the BI_IVC_NUM_PRE table for system-reserved invoice numbers.

If the invoice specified in the TARGET_INVOICE field already exists for the same business unit, the Billing Interface process adds the lines that reference this target invoice to the existing bill. Otherwise, the system creates a new target invoice.

When you specify a target invoice, the system uses only the bill-by functionality to assign bill status. The Billing Interface process groups lines that have the same business unit and target invoice onto the same bill. These lines must reference the same bill-to customer and billing transaction currency. If there are multiple transaction lines that reference the same target invoice, the Billing Interface process uses the fields from the line with the minimum INTFC_ID and INTFC_LINE_NUM to populate the header fields.

When using target-invoice functionality, consider the following:

• An existing target invoice cannot have a bill status of INV, CAN, FNL, TMP, or TMR.

• An existing target invoice cannot have an INVOICE_TYPE of ACR.

  These bills cannot be modified.

• If the interface transaction is for a full bill credit or rebill (AHDR), the target invoice specified cannot already exist.

• If one of the target invoice lines is in error, all other transactions associated with that target invoice will error out.

• For consolidations, you may specify a target invoice for the bills to be attached, but not for the consolidated bill header.

• Only Contracts and Project Costing bills should be used as a target invoice for Contracts and Project Costing transactions. Other bills may not contain all the information, such as contract number, required to complete these transactions.