Billing Interface Error Codes

Purpose:  Use this document as a reference for reviewing ctcLink billing interface errors.

Audience:  Billing Specialists

You must have at least one of these local college managed security roles:

  • ZZ Billing Processing
  • ZZ Grant Processing

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Billing Interface Error Codes

The following table explains possible Billing Interface error conditions.

Source: Correcting Billing Interface Errors   

Snapshot date:  September 10, 2018

Billing Interface Error Codes table

Correcting Billing Interface Errors

Error Code

Explanation

0010 - Invalid Transaction Type

Transaction type must be LINE, AE, AHDR, TAX, NOTE, EXSD, DS, or DDS.

0015 - Invalid Entry Event

The provided entry event is invalid.

0020 - Too Many Charge Lines

There is more than one LINE transaction for a unique combination of interface ID (INTFC_ID) and interface line number (INTFC_LINE_NUM).

0030 - No Charge Line for Activity

There exists accounting entries (AE), notes (NOTE), discounts/surcharges (DS), or deferred accounting for discount/surcharge (DDS) transactions, which do not belong to a bill line charge (LINE) transaction.

0040 - Invalid Business Unit

The provided business unit is invalid.

0045 - VAT Information for Non-VAT Business Unit

The Billing Interface encountered unexpected value-added tax (VAT) information for a non-VAT business unit.

Ensure that VAT_APPLICABILITY and TAX_CD_VAT have no values in non-VAT business unit transactions.

0050 - Invalid Bill Type

The provided bill type is invalid.

0060 - Invalid Customer

The provided bill to customer is invalid.

0070 - Invalid Bill To Address

The provided bill to address is invalid.

0080 - Invalid Bill To Contact

The provided bill to contact is invalid.

0090 - Invalid Bill Source

The provided bill source is invalid.

0100 - Invalid Bill Cycle

The provided bill cycle is invalid.

0101 - Invalid Billing Specialist

The provided billing specialist is invalid.

0102 - Invalid Billing Authority

The provided billing authority is invalid.

0103 - Invalid Billing Inquiry Phone

The provided billing inquiry phone number is invalid.

0110 - Invalid Payment Term

The provided payment term is invalid.

0111 - PYCV line contains a tax code

Payment with Corporate Voucher lines cannot reference a tax code.

0112 - Excise Tax is Applicable

Excise tax rate code or excise tax detail record is missing.

0113 - Sales Tax/VAT is Applicable

Tax rate code or sales tax/VAT detail record is missing.

0114 - Invalid India Transaction

Transaction comes from an invalid feeder system (non-Order Management system).

0115 - Invalid Payment Method

The provided payment method is invalid.

0116 - Invalid Applicability Combination

Invalid combinations of excise, sales tax/VAT applicability flags exist.

0117 - Invalid Excise Applicability

Excise applicability may not be N.

0118 - Missing Excise Tax Parameters

Excise tax rate code or excise tax detail record are not provided.

0119 - Missing Sales Tax/VAT Parameters

Sales tax/VAT rate code or sales tax/VAT detail record are not provided.

0120 - Invalid Tax Code

The provided tax code is invalid.

0121 - Sales Tax/VAT is not Applicable

When Tax Type is Sales/VAT or Sales Tax/VAT Rate Code is present, Sales Tax/VAT Applicability flag should be set to Y (yes).

0122 - Missing required Tax Parameters

Either a ship to customer or ship to location, or both, are not provided. These fields are required when third-party tax software is active for the Billing business unit.

0123 - Excise Invoice Number Required

Excise invoice number is missing for inventory order item.

0124 - Excise Tax is not applicable

Unexpected excise tax rate code or excise tax detail record exists.

0125 - Invalid Ship From Country

The provided ship from country is invalid.

0126 - Invalid Ship To Country

The provided ship to country is invalid

0127 - Invalid VAT Tax Code

The provided VAT tax code is invalid.

0128 - Invalid VAT Applicability

The provided VAT applicability is invalid.

0129 - Invalid VAT Transaction Type

The provided VAT transaction type is invalid.

0130 - Invalid Unit of Measure

The provided unit of measure is invalid.

0140 - Invalid Order Accept Location

The specified order-acceptance location is not valid in the Location table.

0150 - Invalid Order Origin Location

The specified order-origin location is not valid in the Location table.

0160 - Invalid Ship From Location

The specified ship from location is not valid in the Location table.

0170 - Invalid Source Reference

Both source reference and source type must be provided. One cannot be blank when the other one is assigned a value.

0200 - Invalid Standard Note Code

The provided standard note code is invalid.

0210 - No Note Text Provided

No note text exists for NOTE transaction type. This arises when either no note code or note text are provided for a NOTE transaction, or when no note text appears by default from the provided note code.

0220 - Missing or invalid line type

Either no line type was provided or an invalid line type was provided. Line type is required.

0230 - Invalid use of SubCustomer

Either the system or the customer is not set up to accept this kind of subcustomer information.

0232 - Invalid Consol Customer ID

The consolidation customer (CONSOL_CUST_ID, CONSOL_SETID) that was passed is not set up as a consolidation customer.

0233 - Missing or Invalid Billing Currency

The billing transaction currency is invalid or missing.

0234 - Invalid Currency Rate Type

The provided currency rate type is invalid.

0235 - Rate Mult/Rate Div

When the rate source is user defined, the Rate Mult and Rate Div fields are required.

0240 - Invalid Target Invoice Status

The specified target invoice cannot have a bill status of INV, CAN, FNL, TMR, or TMP.

0243 - Invalid Target Invoice Type

You cannot add lines to the specified target invoice. A target invoice cannot be a credit or a rebill invoice.

0244 - Different Customer or Currency for Targets

Transactions that reference the same target invoice must also reference the same bill to customer and billing currency.

0245 - Target Invoice Already Exists

You cannot set or change the pay status of existing invoices to Fully Paid.

0246 - Target Invoice Fully Paid

You cannot add lines to an existing fully-paid invoice.

0247 - Invalid Fully Paid Transaction

It is not allowed to send fully paid transactions from any source other than Order Management.

0300 - Disc/Sur Amt & Pct = 0

The discount/surcharge amount and discount/surcharge percentage are both 0. This occurs when either no amount or percentage is provided for a DS transaction or no amount or percentage appears by default from the provided discount/surcharge ID.

0310 - Missing Discount/Surcharge ID

No discount/surcharge ID was provided on the DS or DDS line. A discount/surcharge ID is required on DS or DDS lines.

0350 - Missing tax details

Required tax details are missing.

0351 - Invalid Tax Detail transaction

When all tax details are present, bill header data must also be present.

0355 - Tax details <> Line Tax Amt

The sum of the amounts in the tax detail records does not equal the line tax amount.

0386 - CA/BI Currency Mismatch (Contracts/Billing currency mismatch)

The selected currency code for this bill line does not match the currency code on the selected bill plan ID for PeopleSoft Contracts.

0400 - No Bill By for Line

After defaulting bill by from customer, bill source, bill type, and business unit, no bill by identifier exists for grouping the interface activity into the bill data structure.

0411 - Missing Bill By Field(s) Value

One or more bill by fields in the bill by ID are missing values.

0412 - Missing Required VAT Data

One or more required VAT-related fields are missing values. Ensure that you directly populate these fields (or populate the fields that these fields are derived from) in INTFC_BI:

  • COUNTRY_SHIP_FROM (derived from BUSINESS_UNIT, SHIP_FROMBU).

  • COUNTRY_SHIP_TO (derived from SHIP_TO_CUST_ID, SHIP_TO_ADDR_NUM).

  • COUNTRY_VAT_BILLFR (returned by VAT defaulting function based on Billing business unit location).

  • COUNTRY_VAT_BILLTO (returned by VAT defaulting function based on bill-to customer location).

  • VAT_TREATMENT_GRP (returned by VAT defaulting function).

0413 - PVN Lvl Missing Bill By Field

To process invoices from contracts that require a Public Voucher Number to be generated by the Billing Interface, certain fields must be included in the Bill By.

  • If the PVN generation level is Contract (C), then the PVN_GEN_LVL, CONTRACT_NUM, FROM_DT and TO_DT fields must be in the Bill By.

  • If the PVN generation level is Contract Line (CL), then the PVN_GEN_LVL, CONTRACT_NUM, CONTRACT_LINE_NUM, FROM_DT and TO_DT fields must be in the Bill By.

  • If the PVN generation level is Project (P), then the PVN_GEN_LVL, CONTRACT_NUM, PROJECT_ID, FROM_DT and TO_DT fields must be in the Bill By.

0510 - No Accounting Entries for line

Required accounting entries for a bill line do not exist.

0511 - Invalid Accounting Entries

A charge line may not have a revenue (RR) and an unbilled AR AE unless the bill is an installment bill.

0513 - More than one IP entry for line

More than one interunit payable (IP) type line exists for the bill line. Only one is permitted.

0514 - More than one AR entry for line

There is more than one AR type line for the bill line. Only one is permitted.

0515 - More than one IE entry for line

More than one interunit expense (IE) type line exists for the bill. Only one is permitted.

0516 - No deferred entry for line

The revenue recognition basis specifies that the line is potentially subject to deferred revenue recognition, but no deferred accounting entries exist. This also applies to DS lines with no deferred accounting entries.

0517 - UAR not allowed for non INS

Unbilled accounting entries are not allowed from external, non-PeopleSoft integrations. The features for unbilled accounting entries are used exclusively with installment bills (which you can enter only online) and bills from PeopleSoft Contracts and Project Costing.

0520 - Accounting <> 100% or <> 0% or Gross Ext

The sum of accounting entry amounts for a particular charge line does not equal the gross extended amount for that line, or the sum of the accounting entry percentages for a particular charge line does not equal 100 percent or 0 percent.

0523 - Unbilled <> 100% or <> 0% or Gross Ext

For a charge line with unbilled accounting entries, the sum of accounting entry amounts for a particular charge line does not equal the gross extended amount for that line, or the sum of the accounting entry percentages for a particular charge line does not equal 100 percent or 0 percent.

0525 - Deferred <> 100% or <> 0% or Gross Ext

The sum of deferred revenue accounting entry amounts for a particular charge line does not equal the gross extended amount for that line, or the sum of the accounting entry percentages for a particular charge line does not equal 100 percent or 0 percent.

0526 - Inherited ChartField(s) varies

Inherited ChartField values for a bill line's revenue distribution varies. This option is not supported.

0530 - Invalid Distribution ID

The provided distribution code on an RR type AE or DS transaction is invalid.

0532 - Invalid AR Distribution ID

The provided AR distribution code on a charge line transaction is invalid.

0534 - Invalid Deferred Dist ID

The provided distribution code on a DDS AE is invalid.

0540 - Invalid Account

The account on an AE, DS entry, or DDS entry is invalid.

0542 - Invalid AltAccount

Either the provided alternate account is invalid or the alternate accounting option is not selected.

0544 - No AltAccount

The alternate accounting option is selected, but no alternate account was provided.

0550 - Invalid Department

The department on an AE, DS entry, or DDS entry is invalid.

0557 - Invalid ChartField value

The provided ChartField value is invalid. This is a generic message for fully configurable ChartFields. Check the message log for the Billing Interface process instance to see which ChartField value is invalid.

0560 - Invalid Project ID

The project on an AE, DS entry, or DDS entry is invalid.

0580 - Invalid Statistics Code

The statistics code on an AE, DS entry, or DDS entry (DDS) is invalid.

0584 - Invalid Affiliate

The affiliate value provided on AE, DS, or DDS transactions is invalid.

0590 - No Dst ID or Account

No account exists for an AE or DS.

0591 - No AR Dst ID or Account

No AR distribution code or account exists for a Header AR AE in the INTFC_BI_HDR table.

0595 - No Deferred DST ID or Acct

No deferred account exists for a DDS.

0597 - Invalid Account Entry Type

The account entry type on an AE is invalid.

0599 - Error in INTFC_BI_AEDS row

An error exists in the INTFC_BI_AEDS row.

0610 - Missing Open Item Key from open item account

The line references an open item account, but does not provide the corresponding open item key.

0650 - Invalid InterUnit Pair

The From and To GL business unit pair is not a valid pair for this interunit and intraunit bill line.

0653 - Cus Not Setup for IU Processing

Interunit information was passed, but the customer is not set up as an interunit customer.

0655 - IU Flag=Y but BU To is Null

After applying defaults, the Business Unit To field is blank. This field is required for interunit bills.

0660 - IU IP Sent but Gen Vchr Flg=Y

An AE for interunit payables (IP) cannot be passed when the Generate AP Voucher flag is set on the InterUnit Control Definition table.

0662 - BusUnit To Must Match Adj Bill

The to business unit must be the same as the to business unit on the invoice that is being adjusted.

0700 - Invalid Adjustment Trans Type

The adjustment transaction type is invalid. The type must be CRALL, RBALL, CRLIN, RBLIN, or NTLIN.

0710 - Invalid Invoice to Adjust

The invoice that is to be adjusted must have been invoiced (bill status INV) already and must not be a consolidated invoice.

0720 - Invalid Line Seq to Adjust

The line sequence to be adjusted is invalid. It does not exist.

0730 - Trans Type Must be Line

Line adjustment must have a transaction type of LINE.

0740 - Multiple Adj Not Allowed-CRALL

An invoice cannot be adjusted more than once in the interface batch.

0741 - Multiple Adj Not Allowed-RBALL

An invoice cannot be adjusted more than once in the interface batch.

0742 - Multiple Adj Not Allowed-CRLIN

An invoice cannot be adjusted more than once in the interface batch.

0743 - Multiple Adj Not Allowed-RBLIN

An invoice cannot be adjusted multiple times in the interface batch.

0744 - Multiple Adj Not Allowed-NTLIN

An invoice cannot be adjusted multiple times in the interface batch.

0750 - Must Be Latest Adj in Chain

The invoice or line to be adjusted must not have been adjusted already.

0755 - Prior Adj at Different Level

The invoice or line to be adjusted cannot have prior adjustments that were made at a different level. That is, if prior adjustments were made at the line level, it is not valid to then make them at the header level.

0760 - Invalid Adj Delta Action

The adjustment delta action for the rebill transaction is invalid. Valid values are ADD, DEL, and RPL.

0770 - Currency Must Match Adj Bill

The currency of the adjustment must be the same as the invoice that is being adjusted.

0780 - Trans Type Must be AHDR

Adjustment transactions of type CRALL must have a transaction type of ADHR.

0785 - No Adj Trans Type for AHDR

Transaction types of AHDR must have an adjustment transaction type of CRALL or RBALL.

0790 - No Assoc Cr Header for Rebill

An adjustment transaction type of RBALL must be accompanied by an adjustment transaction type of CRALL for the same invoice.

0791 - No Assoc Cr Line for Rebill

An adjustment transaction type of RBLIN must be accompanied by an adjustment transaction type of CRLIN for the same invoice.

0795 - No Adjust Header for Line

Rebill delta lines must be accompanied by an associated RBALL line.

0799 - Adjustment Err by Association

This adjustment transaction line is associated with another line that contained an error. There may be nothing wrong with this particular line, but when an error is found in one adjustment line, all related adjustment lines are marked with an error.

0800 - Target Invc Err by Association

This target invoice transaction line is associated with another line that contained an error. There may be nothing wrong with this particular line, but when an error is found in one target invoice line, all related target invoice lines are marked with an error.

0801 - Invalid Statistic Account

The statistical account provided is invalid.

0802 - Invalid Account

A statistical account that is provided for nonstatistical accounting entry line.

0803 - No Statistic Code or Amount

For nonstatistical accounting entry line:

A statistic code was provided with no statistic amount.

A statistic amount was provided with no statistic code.

0804 - Invalid Account; not monetary

For statistical accounting entry lines, an account may not be a monetary account.

0805 - No Statistic Amount

No statistic amount was provided.

0810 - No Matching Record found

For each record in the INTFC_BI_HDR table, an associated record in the INTFC_BI table must exist.

0811 - Invalid Transaction Type

The header transaction type that is provided for a record in INTFC_BI_HDR table is invalid.

0813 - No Paid Amount Provided

A paid reference is present, but no paid amount is provided.

0899 - Error in INTFC_BI_HDR row

An error exists in the INTFC_BI_HDR row.

0901 - Acceptgiro IVC Form Invalid

Acceptgiro invoices must use the portrait (P) format.

0902 - Acceptgiro Bank CD Invalid

The bank code must be 007 or 008, which corresponds to the valid Dutch banking institutions that can receive acceptgiro payments.

0903 - Acceptgiro BNK Act Key Invalid

The bank account must use a valid acceptgiro bank code.

0904 - Cons. SetID, CustID not blank

Those invoices that require acceptgiro processing are not allowed to have a consolidation SETID and customer ID.

Value 1

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.