RI (Regular Invoice)

Unless you modify the processing option in the Invoice Entry MBF Processing Options program (P03B0011), the system assigns RI to all invoice documents that are created by the JD Edwards EnterpriseOne Sales Order Management system, as well as those that you enter manually using Standard Invoice Entry (P03B11) or Speed Invoice Entry (P03B11SI).

RM (Credit Memo)

Unless you modify the processing option in the Invoice Entry MBF Processing Options program (P03B0011), the system assigns RM to credit memos that you enter manually using P03B11 or P03B11SI.

RR (Recurring Invoice)

The system assigns RR to all recurring invoices that you enter with frequency and number of payments.

RN (Manual Billing)

The system assigns RN to all invoices that are generated from manual billings.

RD (Recurring Billing)

The system assigns RD to all invoices that are generated from the recurring billings.

RH (Expense Participation)

The system assigns RH to all invoices that are generated from the expense participation billings.

RJ (Sales Overage)

The system assigns RJ to all invoices that are generated from the sales overage billings.

RL (Escalation)

The system assigns RL to all invoices that are generated from the escalation billings.

RT (AR Fee & Interest)

The system assigns RT to all invoices that are generated from the fee and interest billings.

RB (Chargeback Invoice)

The system assigns RB to invoice chargeback records that are generated when you enter a receipt. The chargeback indicates that you want to pursue payment for an unearned discount or disputed invoice amount.

R5 (Deduction)

The system assigns R5 to invoice deduction records that are generated when you enter a receipt. The deduction indicates an unpaid amount that must be resolved.

R1 (Draft)

The system assigns R1 to draft invoice records. A draft is a promise to pay a debt. This document can be a paper record or an electronic record. A draft includes the amount to be paid, the due date, banking information and, possibly, information about underlying liabilities.

RF (Delinquency Fee)

The system assigns RF to fee invoices. The fee invoice represents the total amount of all fees that are generated for all eligible invoices for the customer for the time period that is specified.

NP (Partial NSF)

The system assigns NP to standalone invoice records that are generated for the insufficient funds (NSF) amount when you enter a partial NSF draft.

RC (receipt)

The system assigns this document type when you enter a receipt.

RO (void receipt)

The system assigns this document type when you void a receipt.

RS (spread receipt)

The system assigns this document type when you apply a credit memo to an invoice on a zero-amount receipt. The system does not assign this document type when you apply an unapplied receipt to an invoice.

RV (insufficient funds receipt)

The system assigns this document type when a customer does not have sufficient funds in the bank to pay the payment.

RU (unapplied receipt)

The system assigns this document type to a receipt that is not applied to a specific invoice. The system applies this receipt to the customer's overall account to reduce the open balance.

RL (logged receipt)

The system assigns this document type to a receipt that is not associated with a customer or payor.

RR (rounding record)

The system assigns this document type when the receipt is either fully applied on the foreign side, but not fully applied on the domestic side, or fully unapplied on the foreign side, but not fully unapplied on the domestic side. This rounding record is at the receipt level and is not associated with any particular invoice pay item.

Customer Ledger (F03B11)

Because a receipt document must be associated with an invoice record, the system generates an invoice record for the unapplied receipt and assigns it a document type RU.

The invoice record for the unapplied receipt:

• Establishes an audit trail to the receipt payment ID.

• Is expressed as a credit amount.

• Has a batch type of RB.

• Contains a posting status of D (posted).

  The posted codes for the receipt records in the Receipts Header table (F03B13) and the Receipts Detail table (F03B14) are omitted until the receipt is posted.

Receipts Header (F03B13)

The receipt record for the transaction.

Receipts Detail (F03B14)

The receipt record that is associated with the invoice that it pays.

Unapplied receipt (RU), chargeback (RB), and deduction (R5) invoice records, which are generated from the receipt application, have a corresponding detail record that is used for posting purposes. The system creates the invoice records (F03B11) with a posting status of D. You must post the receipt records (F03B14) to update the general ledger.

Work With Customer Receipts Inquiry

W15103A

Real Estate Receipts (G1513), RE Receipts Entry

Review and select receipt records.

RE Receipts Entry

W15103C

On the Work With Customer Receipts Inquiry form, click Add.

Enter unapplied receipts.

1. Company, 2. Bank Account, 3. G/L Date, 4. Receipt Date, 5. Payor Number, 6. Customer Number, 7. Remark, 8. Currency, 9. Exchange Rate, 10. Payment Instrument, 11. Cleared/Value Date, and 12. Lease Number

Specify whether to retain the company number, bank account, GL date, receipt date, payor number, customer number, remark, currency, exchange rate, payment instrument, cleared/value date, or lease number that you enter on the RE Receipts Entry form. If you are entering similar types of receipts, retaining these values can reduce data entry. Values are:

Blank: Do not retain.

1: Retain.

1. Display Receipt Type

Specify which type of receipts to display on the Work With Customer Receipts Inquiry form. Values are:

1: All

2: Unapplied

3: Logged

4: General Ledger

2. Date Type

Specify the default date type to use for the Date Selection From and Through fields. Values are:

1: Receipt date

2: GL date

3. Type Input Code

Specify the default type input code for applying receipts to invoices automatically. Use this processing option in conjunction with the Automatic Application processing option. If you set the Automatic Application processing option to 1 (do not allow auto application), the system ignores this processing option. Values are:

Blank: The system does not use a default value.

10: Simple invoice match.

11: Match auto chargeback discount.

15: Match with write-off.

16: Match with chargeback.

17: Match with deduction.

4. Remark

Specify the default remark to assign to receipt detail records. Values are:

Blank: Use the remark from the invoice record.

1: Use the remark from the receipt header.

5. Receipt Numbering

Specify whether the system assigns the receipt number automatically using the Next Numbers program (P0002). Values are:

Blank: Do not automatically assign the receipt number. You must manually enter the receipt number.

1: Automatically assign the receipt number.

6. Deduction Reason Code

Specify a user-defined code (UDC) from UDC table 03B/CR that identifies the default deduction reason for entering a deduction amount. If you leave this processing option blank, you must enter the deduction reason code in the detail area on the RE Receipts Entry form.

7. Override Company Number

Specify the default company number to use on the Load, Select, and Remittance forms. Values are:

Blank: Use the company number from the RE Receipts Entry form.

1: Use * for all companies.

8. Bill Code for Unapplied Receipts

Specify whether to use the value in the G/L Offset field of the customer record (F03012) as the default value for the Unapplied Bill Code field when you enter unapplied receipts. The system locates the AR trade account based on the bill code that you use. Values are:

Blank: Do not use the value from the customer record. The system uses the first bill code that it locates in the Billing Code Extension table (F1512) that has a value of UNC in the Special Processing Code field.

1: Use the GL offset from the customer record. If the customer record does not have a GL offset defined, the system uses the first bill code that it locates in the Billing Code Extension table (F1512) that has a value of UNC in the Special Processing Code field.

1. Receipt Number

Specify whether the system requires a receipt number when you enter a receipt. Values are:

Blank: Do not require.

1: Require.

2. Write-Offs

Specify whether to allow write-offs on receipts. Values are:

Blank: Allow.

1: Do not allow.

3. Delete/NSF Unposted Receipts

Specify whether to allow the delete and NSF operations on unposted receipts. Values are:

Blank: Allow.

1: Do not allow.

4. Overpayment Edit

Specify the severity of the error that the system issues when you overpay an invoice. Values are:

0: No edit

1: Warning

2: Error

Note. When you overpay an invoice, the system displays it as a negative open amount.

5. Duplicate Receipt Edit

Specify the severity of the error that the system issues when a duplicate receipt number is detected. The system searches for duplicate receipt numbers for all records in the Receipts Header table (F03B13), not for individual customers. Values are:

0: No edit

1: Warning

2: Error

1. Apply Invoices

Specify how to apply receipts to invoices that appear in the detail area when you specify a default type input code. If you leave the Type Input Code processing option on the Defaults tab blank, the system ignores this processing option. Values are:

• Blank: Apply invoices up to the receipt amount. The system automatically applies invoices up to the receipt amount. Remaining invoices that appear in the detail area are not considered. If you select both credit memos and invoices, you must select credit memos first so that the system can process them.

  For example:

  Processing option for Type Input Code (Defaults tab) = 10

  Processing option for Apply Invoices = Blank (apply up to the receipt amount)

  Receipt amount = 100

  Invoice amount = 200, due date = June 15, 2007

  Credit memo amount = 100, due date = June 30, 2007

  When you use the Load feature to display open invoices for the customer, the system displays the invoice record before the credit memo because it has an earlier due date. Because you have type input code 10 specified in the processing option, the system applies the receipt amount of 100 to the invoice and leaves the invoice open for 100. The system does not consider the credit memo because the full amount of the receipt is applied to the first invoice.

• 1: Apply all invoices. The system applies the receipt to the invoice open amount, regardless of whether the receipt amount is exceeded. The system considers all invoices and credit memos that appear in the detail area.

  Note. This processing option also affects how the system processes write-offs, chargebacks, and deductions. For example:

  Processing option for Type Input Code (Defaults tab) = 15

  Processing option for Apply Invoices = 1 (apply all invoices)

  Processing option for Maximum Write-off Amount = 25 (automatic and manual)

  Receipt amount = 80

  Invoice amount = 100

  The system displays the type input code as 15 (manual write-off), applies 100 to the invoice, and ignores the write-off. The system returns an error because the amount that is applied to the invoice exceeds the amount of the receipt. For the system to process the write-off, you must change the transaction payment amount to 80.

2. Journal Entry Creation Method

Specify whether the post program creates one summarized journal entry for a batch of receipts, or one journal entry for each receipt. The system assigns the value that you enter in this processing option to the A/R Post field in the Receipts Header record (F03B13). The post program uses this value to create the journal entry records. Values are:

Blank: Summarized journal entries. The system creates one journal entry with the document type RK for each batch of receipts that you post. The system assigns the receipt batch number as the document number of the journal entry. To use this method, you must also ensure that the offset method in the AR Constants is equal to B (batch mode) and the batch does not contain any foreign transactions.

1: Detail journal entries. The system creates one journal entry with the document type RC for each receipt in the batch. The system uses Next Numbers for journal entry documents (system 09) to assign the document number to the receipt journal entry.

To provide an audit trail, the system updates these fields in the Receipts Detail table (F03B14) with the journal entry information:

JE document type (RZDCTG)

JE document number (RZDOCG)

JE document company (RZKCOG)

3. Display Invoices

Specify whether to display all invoices or only invoices with an approved pay status. Values are:

Blank: Display all invoices.

1: Display only approved invoices.

1. Edit Effective Date

Specify whether to validate the effective date that is used to retrieve the exchange rate against the GL date that you enter on the receipt. Values are:

Blank: Do not validate.

1: Validate. The system issues a warning when the effective date of the exchange rate that is retrieved from the Currency Exchange Rates table (F0015) is not in the same period as the GL date of the receipt.

2. Alternate Currency Receipts

Specify whether to allow the payment of an invoice in an alternate currency (a currency other than the base or transaction currency of the invoice). Values are:

Blank: Do not allow.

1: Allow.

1. Pay Status

Specify a code from UDC 00/PS that indicates the default pay status to assign to chargeback invoice records. If you leave this processing option blank, the system uses the value that is set up in the Data Dictionary for item PST.

2. Date Option

Specify the invoice date and net due date to assign to chargeback invoice records. Values are:

Blank: Use the receipt GL date.

1: Use the corresponding dates from the invoice that is used to generate the chargeback.

3. Reason Code

Specify the default reason code from UDC 03B/CB to assign when you enter a chargeback amount. If you leave this processing option blank, you must enter the chargeback reason code manually.

1. Maximum Underpayment Amount

Specify the limit to use to write off underpayments. If the difference between the payment amount and open amount of the invoice is equal to or less than the amount that is specified, the system automatically writes off the remaining amount when you enter the receipt.

2. Underpayment Reason Code

Specify whether to activate the automatic write-off process, and specify the default reason code that you want the system to assign when it automatically writes off an underpayment. Valid write-off reason codes are defined in UDC 03B/RC. You must also set up a corresponding AAI item (RAxx, where xx is the reason code) for the write-off reason code that you specify.

3. Maximum Overpayment Amount

Specify the maximum amount for which the system writes off overpayments. If the difference between the payment amount and the open amount of the invoice is equal to or less than the amount that is specified, the system automatically writes off the remaining amount when you enter the receipt.

Enter the value as a negative amount.

4. Overpayment Reason Code

Specify whether to activate the automatic write-off process, and specify the default reason code for the system to assign when it automatically writes off an overpayment. Valid write-off reason codes are defined in UDC 03B/RC. You must also set up a corresponding AAI item (RAxx, where xx is the reason code) for the write-off reason code that you specify.

1. Maximum Underpayment Amount

Specify the maximum amount for which you can write off an underpayment. If the difference between the payment amount and the open amount of the invoice is equal to or less than the amount that is specified, the system allows you to write off the remaining amount when you enter the receipt.

2. Maximum Overpayment Amount

Specify the maximum amount for which you can write off an overpayment. If the difference between the payment amount and the open amount of the invoice is equal to or less than the amount that is specified, the system allows you to write off the remaining amount when you enter the receipt.

Enter the value as a negative amount.

3. Write-Off Reason Code

Specify the default reason code from UDC 03B/RC that you want the system to assign when you enter a write-off amount. You must also set up a corresponding AAI item (RAxx, where xx is the reason code) for each write-off reason code that you specify.

1. Discount Available

Specify whether to allow the discount taken to be greater than the discount available. Values are:

Blank: Do not allow.

1: Allow.

2. Discount Applied

Specify whether to allow the discount taken to be greater than the payment amount. Values are:

Blank: Do not allow.

1: Allow.

3. Grace Period Days

Specify how many days to add to the discount due date to extend the period during which the discount can be taken. The system uses this processing option only when it calculates the discount taken automatically.

4. Discount Reason Code

Specify the discount reason code that you want the system to use when discounts are taken. You can override this code, if necessary, when you enter the receipt. The discount reason code that you enter must exist in UDC 00/DE. You must also set up a corresponding AAI item (RKDxxx, where xxx is the reason code) for each discount reason code that you specify.

1. Invoice Match, 2. Sales Order Match, 3. Customer Reference Match, 4. Statement Match, and 5. Lease Number Match

Specify values in the fields to identify the sequence of search methods that the system uses to select invoices on the Remittance Entry form.

Values are blank, 1, 2, 3, 4, and 5.

If you leave a search method field blank, the system excludes that search method and uses the other methods that you specify. If you leave all search method fields blank, the system searches using all methods in the order that is listed in this definition.

1. Exclude Type Input Codes

Specify the type input codes in the Input Code 1 throughInput Code 8 fields to disable when you apply receipts to invoices. You can specify up to eight type input codes to disable. The system returns an error if the type input code is used.

2. Automatic Application

Specify whether the system applies the receipt to open invoices automatically; use this processing option in conjunction with the Type Input Code processing option. For example, if the Type Input Code processing option is set to 10, and this processing option is blank (apply receipts automatically), the system automatically copies the type input code that is specified into the corresponding field for all open invoices.

If the Type Input Code processing option is blank, the system ignores this processing option.

Values are:

Blank: Allow auto application.

1: Do not allow auto application.

3. Credit Auto Application

Specify whether to include credit memos (negative invoices) when the system applies receipts automatically; use this processing option in conjunction with the Type Input Code processing option. Values are:

Blank: Apply credit memos automatically. Depending on the setting of the Automatic Application processing option and whether the Priority Code Application check box (using the Load feature) is selected, the system either displays credit memos only or displays and applies them.

If the you leave the Automatic Application processing option blank, the system includes credit memos when the receipt is applied automatically. Additionally, if you select the Priority Code Application check box when invoices are loaded, the system displays and applies only those credit memos that are assigned bill codes that have a priority application code (PRAP) equal to 00.

If you set the Automatic Application processing option to 1, the system displays the credit memos in the detail area of the form, but does not automatically apply them. Additionally, if the Priority Code Application check box is selected when invoices are loaded, the system displays only those credit memos that are assigned bill codes that have a PRAP equal to 00.

1: Do not apply credit memos automatically. The system does not display or apply credit memos regardless of the setting of the Automatic Application processing option or the setting of the Priority Code Application check box.

4. Security Group Display

Specify whether the system displays security group records, which are invoices for bill codes with the value S in the Security Group field (SECG) in the Billing Code Extension table (F1512). Values are:

Blank: Display all invoices.

1: Do not display security group records.

5. Batch Entry

Specify whether the system allows receipts to be entered for multiple companies in the same batch. Values are:

Blank: Allow receipts to be entered in a single batch regardless of the company number.

1: Do not allow receipts to be entered for multiple companies in the same batch; all receipts in the batch must be entered for the same company.

6. Unapplied Receipt Company Validation

Specify whether to validate the company. Values are:

Blank: Do not validate.

1: Validate. The system issues an error if the company that is entered on the unapplied receipt is different from the company that is entered on the lease. If you do not specify a lease number on the unapplied receipt, the system locates the first lease that is entered for the tenant and validates the company number from that lease.

Note. This processing option applies only when you enter an unapplied receipt, not when it is applied to invoices.

1. Tenant Ledger (P15222)

Specify the version of the P15222 program to use.

2. Customer Master (P03013)

Specify the version of the P03013 program to use.

Bank Account

Enter the value that identifies an account in the general ledger. Enter either a standard account number, a third GL number, an account ID number, or a speed code. The first character of the account number indicates its format. You define the account format in the General Accounting constants.

If you leave this field blank, the system uses the bank account that is set up for AAI RB for the company number.

Lease

Enter a lease number. If you enter a tenant but do not enter a lease number, the system uses the first lease, building, and unit for the tenant as the default value.

Payor

Enter the user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book number to the field.

For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an asterisk (*) distinguishes it from other entries (as defined in the Address Book constants), you could enter *TOTAL. and the system would display address book number 4100.

Receipt Date

Enter the date on a payment or the date on which a receipt was entered.

In the JD Edwards EnterpriseOne Accounts Payable system, this is the manual payment date and the general ledger date that the system uses when it posts payments. The system also uses this date to retrieve the exchange rate for foreign payments from the Currency Exchange Rates table (F0015).

In the JD Edwards EnterpriseOne Accounts Receivable system, this is the date on the check or the date that you enter the receipt into the system. The receipt date is used for information and reporting purposes only.

Receipt Number

Enter the alphanumeric code that identifies a check or receipt.

Depending on the setting of the processing option for Duplicate Receipt Edit, the system might display a warning or error if the receipt number has already been entered.

Receipt Amount

Enter the actual amount of the receipt or payment.

Unapplied Bill Code

Enter the bill code. If you leave this field blank, the system uses UC as the default value.

Building

Enter the building. If this lease is for multiple units and you do not enter a building or unit for the lease, you will get a warning indicating that the system will apply cash to the first building and unit on the lease.

Unit

Enter the unit. If this lease is for multiple units and you do not enter a building or unit for the lease, you will get a warning indicating that the system will apply cash to the first building and unit on the lease.

Receipt Reference

Enter the alphanumeric value that you can use as secondary reference on the receipt or draft.

Payment Instrument

Enter a code from UDC 00/PY that specifies the method that the customer uses to make payments. Examples include:

C: Check

D: Draft

T: Electronic funds transfer

Cleared Date

Enter the date on which the payment amount was debited or credited to the bank account. The value date is not the date on which the bank reconciled the payment. The system automatically populates this field with automatic payments. If you are making manual payments and have set a processing option to display the value date, you can manually enter the value date.

Currency

Enter the code that identifies the currency of a transaction.

The system automatically populates this field based on the information from the lease, but you can override all information on this tab except the base currency.

Exchange Rate

Enter the exchange rate. The system automatically populates this field based on the information from the lease, but you can override all information on this tab except the base currency.

Bank Account

All

not applicable

GLBA

Receipts Header (F03B13)

The system uses the bank account number that is entered on the receipt. If you leave the Bank Account field blank, the system locates the account based on this hierarchy:

• RB for the company that is entered on the payment.

• RB for company 00000.

AR Trade

Applied payment

10

AID

Receipts Detail (F03B14)

The system does not use an AAI. Instead, the system uses the account in the AID field of the invoice record in the F03B11 table.

AR Trade

Unapplied payment

not applicable

AID

Receipts Header (F03B13)

The system locates the account using this hierarchy, wherexxxxis the value of the Unapplied Bill Code field:

• RCxxxx for the company that is entered on the receipt.

• RCxxxx for company 00000.

• RCUC for the company that is entered on the receipt.

• RCUC for company 00000.

AR Trade

Payment that generates a chargeback

11 and 16

AIDC and AID

Receipts Detail (F03B14) and Customer Ledger (F03B11)

The system locates the account using this hierarchy, wherexxxxis the value of the Chargeback GL Offset field:

• RCxxxx for the company that is entered on the invoice.

• RCxxxx for company 00000.

• RC for the company that is entered on the invoice.

• RC for company 00000.

AR Trade

Standalone chargeback

26

AIDC

Receipts Detail (F03B14)

The system locates the account using this hierarchy, wherexxxxis the value of the Chargeback GL Offset field:

• RCxxxx for the company that is entered on the receipt.

• RCxxxx for company 00000.

• RC for the company that is entered on the receipt.

• RC for company 00000.

Discount Taken

Payment with a discount

10

AIDD

Receipts Detail (F03B14)

The system uses this hierarchy:

• RKD for the company that is entered on the receipt.

• RKD for company 00000.

Write-off

Payment with a write-off

10 and 15

AIDW

Receipts Detail (F03B14)

The system uses this hierarchy, wherexxis the write-off reason code:

• RA xx for the company that is entered on the invoice.

• RA xx for company 00000.

Write-off

Standalone write-off

25

AIDW

Receipts Detail (F03B14)

The system uses this hierarchy, wherexxis the write-off reason code:

• RA xx for the company that is entered on the receipt.

• RA xx for company 00000.

Deduction Suspense

Payment with a deduction

17

DAID

Receipts Detail (F03B14)

The system uses this hierarchy:

• RN that is set up for the company that is entered on the invoice.

• RN for company 00000.

Deduction Suspense

Standalone deduction

27

DAID

Receipts Detail (F03B14)

The system uses this hierarchy:

• RN that is set up for the company that is entered on the receipt.

• RN for company 00000.

Load open invoices

The system displays all the open invoices for the specified payor that meet the additional search criteria:

• Company

  You can specify one company, or enter * for all companies.

• Currency code

  You can specify one currency code, or enter * for all currency codes.

• Lease

• Priority code application

  The system displays the invoices in order by due date unless you complete this field.

Select open invoices

The system displays all the open invoices that meet the search criteria:

• Payor or Tenant

• Company

  Specify one company, or enter * for all companies.

• Currency code

  Specify one currency code, or enter * for all currency codes.

Additionally, you can use the query by example (QBE) row to specify additional search criteria such as lease number or bill code.

After the system displays the invoices that meet the search criteria, you select each invoice pay item to pay. The system displays a check mark next to each invoice when it is selected. To remove the selection, select the invoice and click Select again.

After you indicate the invoices to pay, you can alter the search criteria and select more invoices. The system tracks the invoices that you select and the total amount of the selected invoices. When you click Close, the system lists all the invoices on the receipt entry form, in the order that you chose them.

Select open invoices by remittance

The system allows you to enter the remittance information from the bank. Enter information about the invoice, such as the invoice number, in the Invoice Reference field, and the system indicates the number of invoices that meet the search criteria. Use a separate detail line to specify different search criteria.

Note. If the invoice does not contain the information that you enter in the header portion of the form, in addition to the detail information about the invoice, the system cannot locate the invoice record.

Processing options enable you to set up a default search order that the system uses to locate the invoices based on the value that is entered in the Invoice Reference field.

The system displays all the open invoices that meet the search criteria:

• Invoice number

• Sales order number

• Customer reference number

• Statement number

• Lease number

With the exception of statement number, the system uses the invoice reference to locate invoices from the Customer Ledger table (F03B11). The system locates invoices using the statement number from the A/R Notification History Detail table (F03B21).

Work With Customer Receipts Inquiry

W15103A

Real Estate Receipts (G1513), RE Receipts Entry

Review and select receipt records.

RE Receipts Entry

W15103C

On the Work With Customer Receipts Inquiry form, click Add or select an unapplied receipt.

Access the menus to display open invoices.

Load Invoices

W15103G

On the RE Receipts Entry form, complete the header portion of the form and select Load from the Form menu.

Load open invoices.

Select Invoices

W15103E

On the RE Receipts Entry form, complete the header portion of the form and choose Select from the Form menu.

Select open invoices.

Select Invoices by Remittance

W15103H

On the RE Receipts Entry form, complete the header portion of the form and select Remittance from the Form menu.

• Select open invoices by remittance.

• Enter invoices from a bank statement (remittance form) and retrieve them for receipt application.

T I (type input)

Enter the code that specifies how the system processes a transaction during receipts entry. The system will not process transactions with a blank or invalid type input.

You can enter a type input code to override the default value that is specified in the processing option. However, the system ignores any value that you enter unless you specify a remittance amount for tracking purposes

Invoice Reference

Enter the identification number that the system uses to locate invoice records for receipt matching. The system can locate invoices by these references:

Invoice number

Statement number

Sales order number

Customer reference number

Shipment number

The system uses the value of this field in conjunction with the processing options on the Match Priority tab to determine which of the five options the value represents, unless you complete the Override Type field.

The system searches the A/R Notification History Detail table (F03B21) to locate the statement number; therefore, you must use the Statement Notification Refresh program (R03B500X) or the Print Statements program (R155001) to generate statements for the system to locate invoices by statement number.

Remittance Amount

Enter the remittance amount. If you need to keep a running total of the remittance amounts, you can complete the Remittance Amount and Remittance Discount fields to update the remittance totals on the bottom of the form; however, the system does not use the amounts that are entered as the payment and discount amounts on the receipts entry form. You must specify the payment amount on the receipts entry form when the system displays the invoices you that specified.

Remittance Discount

Enter the remittance discount. If you need to keep a running total of the remittance amounts, you can complete the Remittance Amount and Remittance Discount fields to update the remittance totals on the bottom of the form; however, the system does not use the amounts that are entered as the payment and discount amounts on the receipts entry form. You must specify the payment amount on the receipts entry form when the system displays the invoices that you specified.

Doc Type (document type)

Enter a code from UDC 00/DT that identifies the origin and purpose of the transaction. The system reserves several prefixes for document types, such as vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are:

P: Accounts payable

R: Accounts receivable

T: Time and Pay

I: Inventory

O: Purchase order

S: Sales order

Doc Co (document company)

Enter the number that, with the document number, document type, and GL date, uniquely identifies an original document, such as an invoice, voucher, or journal entry.

If you use the Next Numbers by Company/Fiscal Year feature, the Automatic Next Numbers program (X0010) uses the document company to retrieve the correct next number for that company.

If two or more original documents have the same document number and document type, you can use the document company to locate the desired document.

Pay Item

Enter the number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has multiple pay items, the numbers are sequential.

Override Type

Enter the number that the system uses to identify which matching process to run to locate invoices. If you leave this field blank, the system uses the matching process that is specified in the processing options for the Standard Receipts Entry program (P03B102). Values are:

1: Invoice Match

2: Sales Order Match

3: Customer Reference Match

4: Statement Number Match

5: Shipment Number Match

To reduce processing time, you can specify the search criteria for the system to use to locate the invoice based on the information that is entered. For example, if you enter an invoice number in the Invoice Reference field, you can enter 1 in this field and the system searches for the invoice by invoice number only and ignores the Match Priority processing options.

Items Found

Displays the number of invoices that the system located based on the information that is provided on the remittance form.

10: Simple Invoice Match

You can use this code to calculate these amounts:

• Payment amount = current open amount − discount available

• Discount taken = discount available

• Write-off = optional

• Chargeback = optional

• Deduction = optional

11: Invoice Match with Automatic Chargeback for Discount Amount

You can use this code to calculate these amounts:

• Payment amount = current open amount − discount available

• Discount taken = optional

• Write-off = optional

• Chargeback = discount available

• Deduction = optional

15: Invoice Match with Write-Off

You can use this code to calculate these amounts:

• Amount applied = current amount − discount available

• Discount taken = discount available

• Write-off = current open amount − amount applied, discount taken, chargeback amount, and deduction amount

• Chargeback = optional

• Deduction = optional

16: Invoice Match with Chargeback

You can use this code to calculate these amounts:

• Amount applied = current open amount − discount available

• Discount taken = discount available

• Write-off = optional

• Chargeback = current open amount − amount applied, discount taken, write-off, and deduction amount

• Deduction = optional

17: Invoice Match with Deduction

You can use this code to calculate these amounts:

• Amount applied = current open amount − discount available

• Discount taken = discount available

• Write-off = optional

• Chargeback = optional

• Deduction = current open amount − amount applied, discount taken, write-off, and chargeback

10

990.00

10.00

NA

NA

1000.00

123

001

RI

11

990.00

NA

NA

10.00

1000.00

123

001

RI

15

970.00

10.00

20.00

NA

1000.00

123

001

RI

16

600.00

10.00

NA

390.00

1000.00

123

001

RI

17

850.00

10.00

NA

140.00

1000.00

128

001

RI

TI Code 11

Use this type input code when you want the system to create a chargeback for an unearned discount. The system automatically completes the Chargeback Amount field with the discount available.

TI Code 16

Use this type input code when you want the system to generate a chargeback for a short payment that is not an unearned discount. The system automatically completes the Chargeback Amount field with the difference between the payment amount that you enter and the open amount of the invoice.

Customer Ledger (F03B11)

The system generates a chargeback invoice record, which takes the place of a specific invoice, for the disputed amount that you want to charge back to the tenant. The system closes the original invoice and marks it as paid, and creates a new chargeback invoice record and assigns it a document type of RB.

The chargeback invoice record:

• Establishes an audit trail to the receipt payment ID.

• Establishes an audit trail to the original invoice if the chargeback was generated for a specific invoice.

• Is expressed as a debit amount.

• Has a batch type of RB.

• Contains a posting status of D (posted).

The posted codes for the payment records in the Receipts Header table (F03B13) and Receipts Detail table (F03B14) remain blank until the receipt is posted.

Receipts Header (F03B13)

The system generates a receipt record.

Receipts Detail (F03B14)

The system generates a detail record that pays the invoice from which the chargeback was generated.

Automatic write-off

(TI Code 10)

The system calculates the difference between the payment amount and the open amount of the invoice. If the difference is within the tolerance limits that are defined in the processing options, the system automatically performs the write-off.

For example, assume that you establish the maximum write-off amount as 10.00 and the invoice open amount is 500.00, and you enter a receipt for 490.00. The system automatically writes off 10.00, provided that you either enter 490.00 in the Payment Amount field or accept the system default. You do not need to calculate or specify a write-off amount.

Automatic write-offs require you to enter a default reason code in the processing options, which the system uses to determine the write-off (adjustment) account. When you enter the receipt, you cannot override the write-off reason code for automatic write-offs.

When you apply the payment to invoices, the system displays a remaining open amount. After you enter the receipt and review it, the system displays the write-off amount and write-off reason code. You can override the write-off reason code at this time.

Manual write-off

(TI Code 15)

You specify that you want the system to perform a write-off by using type input code 15, in which case the system calculates the write-off amount for you. If you exceed the maximum manual write-off amount that is specified in the processing options, the system issues an error when you click OK. You can then manually adjust the write-off amount.

You can set up a default reason code to use for manual write-offs, but this is not required, and you can override it when you enter the receipt.

Customer Ledger (F03B11)

The system generates a deduction invoice document, which takes the place of a specific invoice or group of invoices, for the disputed amount that you want to research and resolve. The system closes the invoice, marks it as paid, creates a new deduction invoice record, and assigns document type R5 to the new record.

The deduction invoice record has these characteristics:

• It establishes an audit trail to the receipt payment ID.

• It establishes an audit trail to the original invoice (if the deduction was generated for a specific invoice).

• It is expressed as a debit amount.

• It has a batch type of RB.

• It contains a posting status of D (posted).

The posted codes for the payment records in the Receipts Header table (F03B13) and Receipts Detail table (F03B14) remain blank until the receipt is posted.

Receipts Header (F03B13)

The system generates a receipt record.

Receipts Detail (F03B14)

The system generates a detail record that pays the invoice from which the deduction was generated.

Work With Customer Receipts Inquiry

W15103A

Real Estate Receipts (G1513), RE Receipts Entry

Review and select receipt records.

RE Receipts Entry

W15103C

On the Work With Customer Receipts Inquiry form, click Add or select an unapplied receipt.

Apply receipts to invoices.

Work With Customer Receipts Inquiry

W15103A

Real Estate Receipts (G1513), RE Receipts Entry

Review and select unapplied receipt records to apply to invoices.

RE Receipts Entry

W15103C

On Work With Customer Receipts Inquiry, click Add or select an unapplied receipt.

• Apply an unapplied receipt to invoices.

• Apply a credit memo to invoices.

• Access the form to enter a general ledger receipt.

G/L Receipts Entry

W03B0001C

On the RE Receipts Entry form, complete the header portion of the form, and select General Ledger from the Form menu.

Enter account information to distribute the receipt.

F03B13

not applicable

15,000

3001

521

F03B11

RB

–5,000

3004

521

F03B11

RB

–5,000

3333

521

F03B11

RB

–5,000

3334

521

F03B14

RC*

–5,000

3004

521

F03B14

RC*

–5,000

3333

521

F03B14

RC*

–5,000

3334

521

Work With Customer Receipts Inquiry

W15103A

Real Estate Receipts (G1513), RE Receipts Entry

Review and select receipt records.

RE Receipts Entry

W15103C

On the Work With Customer Receipts Inquiry form, click Add or select an unapplied receipt.

Access the menus to enter standalone records.

Create Standalone Transaction

W15103D

On the RE Receipts Entry form, complete the header portion and select one of these options from the Form menu: Standalone Write-Off, Standalone Chargeback, or Standalone Deduction.

• Enter standalone write-offs.

• Enter standalone chargebacks.

• Enter standalone deductions.

Type Input

Displays 26 to indicate a standalone chargeback.

Chargeback G/L Offset

Enter the code that indicates the AR trade account that you want the system to use when you post the chargeback. To locate the account, the system concatenates this code to the AAI item RC. Complete this field for standalone chargebacks. If you do not use a separate account to track the offset for chargebacks, you can leave this field blank.

The system uses this hierarchy to locate the AR trade account to use for the chargeback record:

1. If you use multicurrency, the system searches for RCxxx, where xxx is the currency code of the receipt.

2. If the system does not locate the AAI, it uses RCxxxx, where xxxx is the value in the Chargeback G/L Offset field.

3. If the system does not locate the AAI, it uses RCxx, where xx is the chargeback reason code.

4. If the system does not locate the AAI, it uses RC for the company that is specified on the receipt.

5. If the system does not locate the AAI, it uses RC for company 00000.

Chargeback Amount

Enter the unpaid invoice amount for which you want to create a new invoice record so that you can charge the customer. Complete this field for standalone chargebacks.

Chargeback Reason Code

Enter the code that identifies the reason that a chargeback was generated for an invoice during receipt entry. Complete this field for standalone chargebacks. Examples include:

DA: Disputed amounts.

DD: Unearned (disallowed) discount amount.

Note. The system does not accept blank as a value, even if it is defined in the UDC table. If you leave this field blank, the system does not use the default chargeback reason code from the processing options.

Type Input

Displays 27 to indicate a standalone deduction.

Deduction Amount

Enter the domestic amount of the deduction. The currency that is associated with this amount appears in the Base Currency Code field (BCRC). Complete this field for standalone deductions.

Deduction Reason Code

Enter the code that identifies the reason that a customer did not fully pay an invoice. Complete this field for standalone deductions. Examples include:

DG: Damaged goods

SS: Short shipment

UD: Undefined deduction

Note. The system does not accept blank as a value, even if it is defined in the UDC table. If you leave this field blank, the system does not use the default deduction reason code from the processing options.

Amount Pending

Displays the amount pending. If you have fully applied the receipt to invoices, the amount pending should equal the receipt amount that appears in the header portion of the entry form. Verify that the value in this field is correct.

Amount Unapplied

Displays the unapplied record that the system created for the amount. Verify that the value in this field is correct.

1 (Hub)

B

1:Detailed

Detail

1

Y

1:Detailed

Detail

1

S

1:Detailed

Detail

2 (Detail)

B

1:Detailed

Detail

2

Y

1:Detailed

Detail

2

S

1:Detailed

Detail

3 (Configured Hub)

B

1:Detailed

Error (not allowed)

3

Y

1:Detailed

Detail

3

S

1:Detailed

Detail

1

B

Blank: Summary

Summary

1

Y

Blank: Summary

Detail

1

S

Blank: Summary

Detail

2

B

Blank: Summary

Summary

2

Y

Blank: Summary

Detail

2

S

Blank: Summary

Detail

3

B

Blank: Summary

Error (not allowed)

3

Y

Blank: Summary

Detail

3

S

Blank: Summary

Detail

* Offset Method

• Y: One automatic entry offset per document, regardless of the number of line items.

• S: One automatic entry per pay item.

• B: One automatic entry per batch.

not applicable

not applicable

not applicable

AR Trade

Applied Receipt (TI code 10)

AID

F03B14

Unapplied Receipts

AID

F03B13

Chargebacks (TI codes 11, 16, and 26)

AIDC

F03B14

Discount Taken

Discounts (TI code 10)

AIDD

F03B14

Write-off

Write-offs (TI codes 10, 15, and 25)

AIDW

F03B14

Deduction Suspense

Deduction (TI codes 17 and 27)

DAID

F03B14

1. Account Format

Specify the account format that you want to print on the General Ledger Post report. Values are:

Blank: Default account format.

1: Structured account.

2: Short account ID.

3: Unstructured account.

2. Print Error Messages

Specify whether to print errors on the General Ledger Post report. If you leave this processing option blank, the system still prints an error in the work center when an error is detected. Values are:

Blank: Do not print.

1: Print.

1. Detail Currency Restatement Version

Specify the version of the R11411 program that the system uses to create entries. If you leave this processing option blank, the system does not run the R11411 program and does not create detailed currency restatement entries.

2. Fixed Asset Post Version

Specify the version of the R12800 program that the system uses to create fixed asset entries. If you leave this processing option blank, the system does not run the R12800 program and does not create fixed asset entries.

3. 52 Period Post Version

Specify the version of the R098011 program the system uses to update the Account Balances (F0902) and Account Balances - 52 Period Accounting (F0902B) tables. If you leave this processing option blank, the F0902B program does not run and does not update the tables.

4. Create Burdening Transactions Version (R52G11)

Specify the version of the R52G11 program to use to update the Government Burdened Detail Ledger (F52G11) and Government Burdened Summarized Ledger (F52G02) tables. If you leave this processing option blank, the Create Burdening Transactions program does not run and does not update the tables.

1. Update Transaction

Specify whether the system updates Account ID, Company, Fiscal Year, Period Number, Century, and Fiscal Quarter on unposted records in the Account Ledger table (F0911). You might need to update these fields if you have records in the F0911 table that were created by a custom program and may not contain the correct values in these fields.

Values are:

Blank: No editing

1: Update transaction.

The system uses the value in the G/L Account Number field of the unposted record in the F0911 table to update the Account ID and Company fields.

The system calculates the correct values for the Fiscal Year, Period Number, and Century fields using the value in the GL date field of the unposted record in the F0911 table.

The system will update the Fiscal Quarter field on the unposted record in the F0911 table to blank.

1. Update Tax File

Specify whether and how to update the Taxes table (F0018) when you post transactions with tax information to the general ledger. Values are:

Blank: The system does not update the F0018 table.

1: The system updates the F0018 table for these tax explanation codes only: V, VT, V+, U, and UT.

2: The system updates the F0018 table for all tax amounts. The system does not update the Taxes table for transactions with tax explanation code E (exempt).

3: The system updates the F0018 table for all tax explanation codes, including E (exempt).

2. Update VAT Discounts

Specify whether to adjust the tax amount fields, and which fields to adjust, when discounts are taken. The system adjusts the tax amount fields only for transactions with tax explanation code V.

Note. You must select the Tax on Gross Including Discount and Discount on Gross Including Tax options in the tax rules to use this processing option:

Values are:

Blank: Does not adjust tax amounts for discounts taken.

1: Updates only the Tax Amount field (STAM).

2: Updates the Tax (STAM), Taxable (ATXA), and Extended Price (AEXP) Amount fields.

The system uses these algorithms to calculate the adjustment amounts to the tax, taxable, and gross (extended price) amount fields for discounts taken:

Adjustment to the gross amount (extended price) = discount taken

Adjustment to the taxable amount = (taxable amount ÷ gross amount) × discount taken

Adjustment to the tax amount = (tax amount ÷ gross amount) × discount taken. For example:

Tax Rate = 25 percent

Discount Taken = 12.50 USD

Gross Amount (Extended Price) = 1,250.00 USD

Taxable Amount = 1,000.00 USD

Tax Amount = 250.00 USD

Based on the example, using the adjustment algorithms, the system calculates these adjustment amounts:

Adjustment to the Gross Amount = 12.50

Adjustment to the Taxable Amount = 10.00

Adjustment to the Tax Amount = 2.50

To calculate the adjustments, the system subtracts the adjusted amount from the original amount:

Adjusted Gross Amount: 1,250.00 − 12.50 = 1,237.50

Adjusted Taxable Amount: 1,000.00 − 10.00 = 990.00

Adjusted Tax Amount: 250.00 − 2.50 = 247.50

3. Update VAT Receipts and W/O

Specify whether to adjust the tax fields, and which fields to adjust, when the receipt has a write-off. The system adjusts the tax amount fields only for transactions with tax explanation code V. Values are:

Blank: Does not adjust tax amounts for write-offs.

1: Updates only the Tax Amount field (STAM).

2: Updates the Tax (STAM), Taxable (ATXA), and Extended Price (AEXP) amount fields.

The system uses these algorithms to calculate the adjustment amounts to the tax, taxable, and gross (extended price) amount fields for write-off amounts:

Adjustment to the gross amount (extended price) = write-off amount

Adjustment to the taxable amount = (taxable amount ÷ gross amount) × write-off amount

Adjustment to the tax amount = (tax amount ÷ gross amount) × write-off amount. For example:

Tax Rate = 25 percent

Write-off Amount = 12.50 USD

Gross Amount (Extended Price) = 1,250.00 USD

Taxable Amount = 1,000.00 USD

Tax Amount = 250.00 USD

Based on the example, using the adjustment algorithms, the system calculates these adjustment amounts:

Adjustment to the Gross Amount = 12.50

Adjustment to the Taxable Amount = 10.00

Adjustment to the Tax Amount = 2.50

To calculate the adjustments, the system subtracts the adjusted amount from the original amount:

Adjusted Gross Amount: 1,250.00 − 12.50 = 1,237.50

Adjusted Taxable Amount: 1,000.00 − 10.00 = 990.00

Adjusted Tax Amount: 250.00 − 2.50 = 247.50

1. Explode parent item time

Specify whether the system explodes the time entries for a parent asset down to the children of the parent asset. If you enter 1 for this processing option, the General Ledger Post Report program (R09801) creates time entries for the parent asset's children. The system uses the unit of time from the parent asset entries and the rates from the child asset to calculate the appropriate entries. This processing option applies only to batch type T entries. Values are:

Blank: Do not explode.

1: Explode.

1. Units Ledger Type

Specify the units ledger type to assign for cash basis entries. You must enter a valid ledger type from the Ledger Type Master Setup program (P0025). If you leave this processing option blank, the system uses a default ledger type of ZU.

2. Create Cash Basis Entries Version (R11C850)

Specify which version of the Create Cash Basis Entries program (R11C850) to run. If you leave this processing option, the system does not create cash basis entries.

Unposted receipts

You can revise these fields on an unposted receipt:

• Bank Account

• Remark

• Receipt Amount

  Note. If you revise the receipt amount, you must also revise the payment amount information in the detail area.

• Payment Instrument

• Cleared Date

• Unapplied GL Offset

• Receipt Reference

• Lease*

• Building*

• Unit*

* These fields can be revised only on unapplied receipts, and only when you use the RE Receipts Entry program (P15103).

You can also change the payment amount or type input code, remove invoice pay items, or select other invoices to pay.

Posted receipts

After you post a receipt, you can change the information in these fields only:

• Remark

• Payment Instrument

• Cleared Date

• Receipt Reference

You do not need to post the receipt again.

You can also void invoice pay items and specify new invoices to pay. If you revise payment information, you must post the receipt again.

Work With Customer Receipts Inquiry

W15103A

Real Estate Receipts (G1513), RE Receipts Entry

• Review and select receipts to revise, delete, void, or designate as NSF.

• Delete or void a receipt.

RE Receipts Entry

W15103C

On the Work With Customer Receipts Inquiry form, select the receipt record.

Delete or void invoice pay items from receipts.

Void/NSF Receipt

W15103B

On the Work With Customer Receipts Inquiry form, select a receipt, and click Delete.

Enter a GL date and reason code.

Note. The system displays this form only when the receipt is posted.

Chargeback (RB) generated from a receipt.

• Locate the invoice number from which the chargeback originated, using the Original Document field. Then, select the invoice, and select Receipt/Draft Dtls from the Row menu. If the chargeback was generated from a deduction, you must locate the deduction record (R5), which is now paid as a result of creating the chargeback, and then select RE Rec/Draft Dtls from the Row menu.

• Use the payment ID to locate the receipt on the Work With Customer Receipts Inquiry form, which you access when you select RE Receipts Entry.

Deduction (R5) generated from an invoice or receipt.

• Locate the invoice number from which the deduction originated, using the Original Document field. Then select the invoice, and select RE Rec/Draft Dtls from the Row menu.

• Use the payment ID to locate the receipt on the Work With Customer Receipts Inquiry form, which you access when you select RE Receipts Entry.

Chargeback (RB) generated from a deduction.

Locate the payment ID on the chargeback record, and enter it in the QBE row. Verify that the search criteria includes the option All, and then click Find. The system displays the chargeback and deduction records. Select the deduction (R5), and then select RE Rec/Draft Dtls from the Row menu.

Unapplied receipt (RU)

Use the payment ID to locate the receipt on the Work With Customer Receipts Inquiry form, which you access when you select RE Receipts Entry.

Work with Tenant Ledger Inquiry

W15222A

Real Estate Receipts menu (G1513), Tenant Ledger Inquiry

• Review transactions invoices.

• Access receipt detail records.

Receipt Details

W15222E

On the Work with Tenant Ledger Inquiry form, select a paid invoice, and select RE Rec/Draft Dtls from the Row menu.

Review the receipt detail records (F03B14) for paid invoices.

1. Standard Invoice Entry (P03B11)

Specify the version of the P03B11 program to use.

2. Manual Billing Entry (P1511)

Specify the version of the P1511 program to use.

3. Lease Information (P1501)

Specify the version of the P1501 program to use.

4. Recurring Billing (P1502)

Specify the version of the P1502 program to use.

5. RE Receipts Entry (P15103) (real estate receipts entry)

Specify the version of the P15103 program to use.

1. As If Currency Code

Specify the as if currency and whether to display the As If Curr Code field on the Work with Tenant Ledger Inquiry form. The system recalculates domestic amounts based on the as if currency and the date in the Exchange Rate Date processing option, and displays them in the as if columns in the detail area on the form.

If you leave this processing option blank, the system does not display the As If Curr Code field or as if currency columns.

2. Exchange Rate Date

Specify the date to use to retrieve the exchange rate between the as if currency and the domestic currency. If you leave this processing option blank, the system uses the value that you specify in the Thru Date field on the Work with Tenant Ledger Inquiry form. If you leave this processing option blank and do not specify a value in the Thru Date field, the system uses the most recent exchange rate that was entered. If an exchange rate does not exist, the system generates an error.

1. Customer Self-Service in Java/HTML

Specify whether to activate customer self-service functionality in Java/HTML environments. Values are:

Blank: Do not activate.

1: Activate.

Parent

Enter the address book number of the parent company. The system returns tenant records for both the parent and first-level children. The system does not return records for subsequent levels of parent/child relationships.

Include Security Deposit

If you select this check box, the system displays transactions that are related to security deposits. If you do not select this check box, the system excludes security deposit transactions.

All, Paid, Open, and Include Partial

Select one of these options to control the display of invoices:

All: Display all invoices.

Paid: Display only paid invoices.

Open: Display only unpaid invoices.

Include Partial: Include partially paid invoices when displaying paid invoices.

You must select one of these options if you use the As Of Date feature.

Note. The system displays the Include Partial option, which enables you to display or exclude partially paid invoices, only when you select the Paid option.

Date From and Thru

Enter the dates that identify the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern that is assigned to the company to retrieve the appropriate fiscal period number, as well as to perform date validations.

Invoice Date, Due Date,G/L Date, and Statement Date

Select one of these options to indicate the type of date that the system uses when you enter values in the Date From and Thru fields,

As Of Date

Enter the as of date. The system compares the general ledger date of the receipt to the as of date to determine whether the invoice was open or paid on that date.

To use this feature, you must select the All option to include invoices regardless of pay status.

Recurring Invoice

If you select this check box, the system displays only invoices that have recurring information, such as the number of payments and frequency.

Summarize

If you select the check box , the system displays a summary of charges based on bill codes. The system summarizes amounts by similar bill codes.