13 Processing Manual Receipts

This chapter contains the following topics:

13.1 Entering Standard Receipts

This section provides an overview of standard receipts, fields updated during receipt or draft entry, and unapplied receipts, and discusses how to:

  • Set processing options for Standard Receipts Entry (P03B102).

  • Enter unapplied receipts.

Country-specific functionality exists for entering standard receipts for Argentina.

See "Entering Manual Receipts for Argentina" in the JD Edwards EnterpriseOne Applications Localizations for Argentina Implemenation Guide.

13.1.1 Understanding Standard Receipts

Using Standard Receipts Entry, you select the invoices that the receipt pays and select how to apply short payments or unearned discounts to the invoices that are specified on the receipt. This is the most common method of applying receipts and provides the most flexibility for receipt application.

You use type input (TI) codes to specify how you want the system to apply payment amounts. Based on the payment amount that you enter and the type input code that you use, the system can calculate write-off, chargeback, and deduction amounts, as well as determine whether discounts that are available are earned. You can also overpay invoices to generate a credit to the customer's account.

You enter receipts in batches, just as you enter invoices in batches. Depending on the settings of the Accounts Receivable constants, the system might display a batch control form for entering information about the batch, such as the number of transactions and total amount. To make the bank reconciliation process easier, you might want to group the different types of receipts into different batches.

Note:

The system assigns a new batch number only when you exit the Work with Customer Receipts Inquiry form (not the Receipt Entry form) and reenter it. The status of the batch remains In Use until you exit the Work with Customer Receipts Inquiry form. The system assigns the batch type RB to all records that are generated by the receipts applications.

When you apply a receipt to invoices, the system creates one document to represent the receipt, which is stored in the Receipts Header table (F03B13), and one document for each invoice to which you apply the receipt, which is stored in the Receipts Detail table (F03B14).

(Release 9.2 Update) The JD Edwards EnterpriseOne software provides record reservation capability within the Standard Receipts Entry program(P03B102). See Section 2.2, "Understanding Record Reservation (Release 9.2 Update)" for more information.

13.1.2 Understanding Fields Updated During Receipt or Draft Entry

When you enter a receipt, the system updates specific fields with the account ID. The system locates the AAI based on the how the receipt is applied to invoices. The system uses this account ID when you post the receipt to create automatic entries. This table lists the fields that the system updates based on the type of receipt, and the AAI that the system uses to locate the account.

Account Type of Payment Application Type Input Code Field Updated Table Updated AAI Used
Bank Account All N/A GLBA F03B13 The system uses the bank account number entered on the receipt.

If the Bank Account field is blank, the system locates the account based on this hierarchy:

  • RB for the company entered on the receipt

  • RB for company 00000

Note: The system updates the bank account field when you enter a receipt; however, it does not update the bank account field on the draft until you either remit or collect the draft.

A/R Trade Applied payment 10 AID F03B14 The system does not use an AAI.

The system uses the account entered in the AID field of the invoice record in the F03B11 table.

A/R Trade Unapplied payment N/A AID F03B13 The system locates the account using this hierarchy, where xxxx is the value of the Unapplied G/L Offset field:
  • RCxxxx for the company entered on the receipt or draft

  • RCxxxx for company 00000

  • RCUC for the company entered on the receipt or draft

  • RCUC for company 00000

A/R Trade Payment that generates a chargeback 11 and 16 AIDC and AID F03B14 and F03B11 The system locates the account using this hierarchy, where xxxx is the value of the Chargeback G/L Offset field:
  • RCxxxx for the company entered on the invoice

  • RCxxxx for company 00000

  • RC for the company entered on the invoice

  • RC for company 00000

A/R Trade Stand-alone chargeback 26 AIDC F03B14 The system locates the account using this hierarchy, where xxxx is the value of the Chargeback G/L Offset field:
  • RCxxxx for the company entered on the receipt or draft

  • RCxxxx for company 00000

  • RC for the company entered on the receipt or draft

  • RC for company 00000

Discount Taken Payment with a discount 10 AIDD F03B14 The system uses this hierarchy, where xx is the discount reason code:
  • RKDxx for the company entered on the receipt or draft

  • RKDxx for company 00000

  • RKD for the company entered on the receipt or draft

  • RKD for company 00000

Write-off Payment with a write-off 10 and 15 AIDW F03B14 The system uses this hierarchy, where xx is the write-off reason code:
  • RAxx for the company entered on the invoice

  • RAxx for company 00000

Write-off Stand-alone write-off 25 AIDW F03B14 The system uses this hierarchy, where xx is the write-off reason code:
  • RAxx for the company entered on the receipt or draft

  • RAxx for company 00000

Deduction Suspense Payment with a deduction 17 DAID F03B14 The system uses this hierarchy:
  • RN that is set up for the company entered on the invoice

  • RN for company 00000

Deduction Suspense Stand-alone deduction 27 DAID F03B14 The system uses this hierarchy:
  • RN that is set up for the company entered on the receipt or draft

  • RN for company 00000


This table shows how the system updates the AID2 field of the records in the F03B14 table when you accept, remit, or collect a draft. The system creates the records during each draft stage based on the AAI listed, where x is the payment instrument.

Draft Stage AAI
Acceptance RD1x
Remittance RD2x
Remittance for Discount RD3x
Remittance with Contingent Liability RD4x

13.1.3 Understanding Unapplied Receipts

The easiest, quickest method of recognizing cash for the business and crediting the customer's account is to enter unapplied receipts. This type of receipt enables you to immediately enter the money you receive into the system, which helps you determine the current cash position. Entering unapplied receipts enables you to apply a receipt to a customer's account without applying it to a specific invoice or group of invoices. For example, you might want to include the receipt in the daily bank deposit and apply it later to the appropriate invoices.

When you enter an unapplied receipt, the system creates a record in each of these tables:

Table Usage
F03B11 The invoice record for the unapplied receipt. Because a receipt document cannot exist in the system by itself and must be associated to some 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 has these characteristics:

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

  • It is expressed as a credit amount.

  • It has a batch type of RB.

  • It contains a posting status of D (posted). The posted codes for the receipt records in the F03B13 table and the F03B14 table remain blank until the receipt is posted.

F03B13 The receipt record for the transaction.
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.


The unapplied receipt remains open until you apply it to the appropriate invoices.

After you enter unapplied receipts, you must post them. When you post unapplied receipts, the system debits the bank account and credits the A/R trade account associated with the AAI item RCUC, unless you override the Unapplied G/L Offset field on the receipt or specify to use the G/L offset that is set up on the customer master record.

You can also use Speed Receipts Entry program (P03B0001) to enter unapplied receipts. It provides a faster way to enter one or more unapplied receipts. However, you cannot use this program to revise, apply, or delete an unapplied receipt. To apply, revise, or delete an unapplied receipt, you must use the Standard Receipts Entry program (P03102).

13.1.4 Prerequisite

Verify that the appropriate offset account is set up for the AAI RCxxxx, where xxxx is the Unapplied G/L offset (for unapplied drafts) or the Chargeback G/L Offset (for drafts that generate a chargeback). If you enter unapplied drafts, the system uses the default RCUC unless you specify a different Unapplied G/L Offset value or set a processing option to use the value from the customer record.

13.1.5 Forms Used to Enter Standard Receipts

Form Name Form ID Navigation Usage
Receipt Entry W03B102E Manual Receipts Processing (G03B12), Standard Receipts Entry.

Click Add on the Work with Customer Receipts Inquiry form.

Enter standard receipts.
Additional Information W03B102I Select Additional Info from the Form menu on the Receipt Entry form. Assign a G/L offset other than UC to an unapplied receipt.

13.1.6 Setting Processing Options for Standard Receipts Entry (P03B102)

Processing options enable you to specify the default processing for programs and reports.

13.1.6.1 Display

These processing options enable you to retain values that were previously entered on the Receipts Entry form. If you are entering similar types of receipts, completing these processing options can reduce entry time.

1. Company

Specify whether to retain the company number entered on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not retain the company number.

1: Retain the company number.

2. Bank Account

Specify whether to retain the bank account number entered on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not retain the bank account.

1: Retain the bank account.

3. G/L Date

Specify whether to retain the G/L date entered on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not retain the G/L date.

1: Retain the G/L date.

4. Receipt Date

Specify whether to retain the receipt date entered on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not retain the receipt date.

1: Retain the receipt date.

5. Payor Number

Specify whether to retain the payor number entered on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not retain the payor number.

1: Retain the payor number.

6. Customer Number

Specify whether to retain the customer number entered on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not retain the customer number.

1: Retain the customer number.

7. Remark

Specify whether to retain the remark entered on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not retain the remark.

1: Retain the remark.

8. Currency

Use this processing option to retain the currency code entered on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not the retain the currency.

1: Retain the currency.

9. Exchange Rate

Specify whether to retain the exchange rate entered on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not retain the exchange rate.

1: Retain the exchange rate.

10. Payment Instrument

Specify whether to retain the payment instrument on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not retain the payment instrument.

1: Retain the payment instrument.

11. Cleared/Value Date

Specify whether to retain the cleared/value date on the Receipt Entry form after you enter the receipt. Values are:

Blank: Do not retain the cleared/value date.

1: Retain the cleared/value date.

13.1.6.2 Defaults

These processing options enable you to specify default values to use on the Work with Customer Receipts Inquiry, Receipt Entry, Additional Information, Load Invoices, and Select Invoices forms. When you enter the receipt, you can override any of the values that you enter in these processing options.

1. Display Receipt Type

Specify the 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 date type to use with the Date Selection From and Thru fields. Values are:

1: Receipt date

2: G/L date

3. Type Input Code

Specify the default type input code for applying receipts to invoices. 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 that the system uses for receipt detail records. Values are:

Blank: Use the current invoice remark.

1: Use the receipt header remark if the following two conditions are met; the receipt header is not blank and the invoice remark is blank. If one of these conditions is not met, then the system uses the current invoice remark.

5. Receipt Numbering

Specify whether to have Next Numbers assign the receipt number. Values are:

Blank: Do not use Next Numbers.

1: Use Next Numbers.

6. Deduction Reason Code

Specify the default deduction reason code for entering a deduction amount. If you leave this field blank, the deduction reason code must be entered manually in the detail area on the Receipt Entry form. Valid deduction reason codes are defined in UDC 03B/CR.

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 Receipt Entry.

1: Use * for all companies.

8. Default G/L Offset 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 G/L Offset field when you enter unapplied receipts. The system locates the A/R trade account based on the G/L offset that you use. Values are:

Blank: Do not use values from the customer record. The system uses the default value UC.

1: Use the G/L offset from the customer record. If the customer record does not have a G/L offset defined, the system uses the default G/L offset (UC) for unapplied receipts.

13.1.6.3 Edits

These processing options enable you to perform specific functions, such as writing off amounts or designating receipts as having insufficient funds, as well as to specify whether you want the system to notify you of certain conditions, such as using a duplicate receipt number or entering an overpayment.

1. Receipt Number

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

Blank: Do not require receipt number.

1: Require receipt number.

2. Write-Offs

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

Blank: Allow write-offs.

1: Do not allow write-offs.

3. Delete/NSF Unposted Receipts

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

Blank: Allow delete and NSF.

1: Do not allow delete and NSF.

4. Overpayment Edit

Specify the severity of the error message issued when an invoice has been overpaid. Values are:

0: No Edit

1: Warning

2: Error

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

5. Duplicate Receipt Edit

Specify the severity of the message issued when a duplicate receipt number is detected in the system. The system searches for duplicate receipt numbers for all records in the F03B13 table, not for individual customers. Values are:

0: No Edit

1: Warning

2: Error

13.1.6.4 Process

These processing options enable you to control how the system applies receipts to invoices when you use a default type input code. They also control whether the system creates a summarized record in the Account Ledger table (F0911) for each batch of receipts that you enter or a detail record for each receipt.

1. Apply Invoices

Specify how to apply receipts to invoices that appear in the detail area when you specify a default type input code to use. 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) is set to 10.

  • Processing option for Apply Invoices is blank (apply up to the receipt amount).

  • Receipt amount is 100.

  • Invoice amount is 200, due date is June 15, 2008.

  • Credit memo amount is 100, due date is June 30, 2008.

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.

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

  • Processing option for Type Input Code (Defaults tab) is set to 15.

  • Processing option for Apply Invoices is set to 1 (apply all invoices).

  • Processing option for Maximum Write-off Amount is set to 25 (automatic and manual).

  • Receipt amount is 80.

  • Invoice amount is 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 applied to the invoice exceeds the amount of the receipt. For the system to process the write-off, you must override the transaction payment amount to 80.

2. Journal Entry Creation Method

Specify whether the post program creates one summarized journal entry for the batch of receipts entered, 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 (ISTR) in the F03B13 table. 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 A/R Constants is equal to B (batch mode).

  • The batch does not contain any foreign transactions.

Otherwise, the system creates journal entries in detail.

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 F03B14 table with the journal entry information:

  • JE document type (RZDCTG)

  • JE document number (RZDOCG)

  • JE document company (RZKCOG)

Note:

Regardless of the setting of this processing option, the system does not post receipts when the offset method in the A/R constants is set to B and the Intercompany Settlement option in the G/L constants is set to 3.
3. Display Invoices

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

Blank: Display all invoices.

1: Display only approved invoices.

4. Negative Receipts

Specify whether to allow negative receipts in the Standard Receipts Entry program (P03B102). A negative receipt can be either a negative payment amount with a fully applied receipt, or a fully applied receipt with a negative general ledger entry. Values are:

Blank: Do not allow negative receipts.

1: Allow negative receipts.

5. Netting Program Version

Specify the version of the Netting program to use. If you leave this processing option blank, the system uses version ZJDE0002.

13.1.6.5 Currency

These processing options specify whether you want the system to validate whether the exchange rate is effective, and whether to enable alternate currency receipts to be entered.

1. Edit Effective Date

Specify whether the system validates the effective date that it uses to retrieve the exchange rate against the G/L date that you enter on the receipt. Values are:

Blank: Do not validate the effective date.

1: Validate the effective date. The system issues a warning when the effective date of the exchange rate retrieved from the Currency Exchange Rates table (F0015) is not in the same period as the G/L 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 payment in alternate currency.

1: Allow payment in alternate currency.

13.1.6.6 Chargeback

These processing options specify values that you want the system to assign to chargeback records that it creates.

1. Pay Status

Specify the default pay status to assign to chargebacks. If you leave this processing option blank, the system uses the value that is set up in the Data Dictionary for item PST. Valid values are defined in UDC 00/PS (Pay Status).

2. Date Option

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

Blank: Use the receipt G/L date.

1: Use the corresponding dates from the invoice.

3. Reason Code

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

13.1.6.7 Auto Write Off

These processing options activate the automatic write-off feature and enable you to establish write-off limits for both under- and overpayments. You must designate the write-off reason code for the system to use when you activate the automatic write-off feature.

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 specified, the system automatically writes off the remaining amount when you enter the receipt.

2. Underpayment Reason Code

Use this processing option to enable automatic write-off processing and to specify the default reason code to assign when the system 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 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

Use this processing option to enable automatic write-off processing and to 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.

13.1.6.8 Mnl Write Off

These processing options establish write-off limits for both under- and overpayments, and to set up a default for the system to use for the write-off reason code.

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 specified, the system enables 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 specified, the system enables 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 to assign when you enter a write-off amount. 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 each write-off reason code that you specify.

13.1.6.9 Discount

These processing options set up rules for processing discounts.

1. Discount Available

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

Blank: Do not allow discounts taken to be greater than the discount available.

1: Allow discounts taken to be greater than the available discount.

2. Discount Applied

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

Blank: Do not allow the discount taken to be greater than the payment amount.

1: Allow the discount taken to be greater than the payment amount.

3. Grace Period Days

Specify the number of 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 default discount reason code 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.

13.1.6.10 Match Priority

These processing options specify the order that you want the system to use to locate invoices when entering receipts from a remittance.

Invoice Match, Sales Order Match, Customer Reference Match, Statement Match, and Shipment Number Match, and Receipt Matching Reference1

Specify the sequence of search methods that the system uses to select invoices on the Remittance Entry form. Valid search methods are 1, 2, 3, 4, 5, and 6. If you leave a search method processing option blank, the system excludes that search method and uses only the other methods that you specify. If you leave all five fields blank, the system searches using all methods in the order as described in the preceding paragraph.

13.1.7 Entering Unapplied Receipts

Access the Receipt Entry form

Figure 13-1 Receipt Entry form

Description of Figure 13-1 follows
Description of ''Figure 13-1 Receipt Entry form''

To enter an unapplied receipt:

  1. Complete the fields on the Receipt Entry form.

  2. If you want to assign a G/L offset other than UC, select Additional Info from the Form menu and complete the Unapplied G/L Offset field.

    You can also set a processing option for the system to use the default value of the G/L Offset code from the customer record.

  3. On Additional Information, complete any other applicable fields and click OK.

  4. Click OK.

  5. On Receipt Entry, click OK to create an unapplied receipt or follow the steps to apply the receipt to invoices or to enter remittance information.

13.2 Locating Open Invoices

This section provides an overview of methods for displaying open invoices and discusses how to:

  • Load all open invoices for a customer.

  • Select specific open invoices for a customer.

  • Select open invoices by remittance.

13.2.1 Understanding the Methods for Displaying Open Invoices

To specify the invoices that a receipt or draft pays, you must display them on the payment entry form. Regardless of the method that you use to locate open invoices, you specify search criteria on one form, and the system returns the invoices that meet the criteria specified on the receipt or draft entry form.

The system provides these methods for displaying open invoices that you want to pay:

Method Description
Load Invoices The system displays all the open invoices for the specified payor that meet the additional search criteria specified:
  • Company: You can specify one company or enter * for all companies.

  • Currency Code: You can specify one currency code or * for all currency codes.

The system displays the invoices in order by due date.

Select Invoices The system displays all the open invoices that meet the search criteria that you enter:
  • Payor or Customer

  • Company: You can specify one company or enter * for all companies.

  • Currency Code: You can specify one currency code or * for all currency codes.

Additionally, you can use the QBE row to specify additional search criteria, such as the document type or statement number.

The system displays the invoices that meet the criteria that you specified. You then select each invoice pay item that you want to pay. After invoices are selected, you can alter the search criteria and select more invoices. The system returns all the invoices selected in the order that you selected them on the payment entry form.

Select Invoices by Remittance You use this method to enter the remittance information from the bank. You enter information about the invoice, such as the invoice number, in the Invoice Reference field, and the system indicates the number of invoices located that meet the criteria that you specified. You use a separate detail line to specify different search criteria.

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

  • Invoice number (DOC)

  • Sales order number (DOCO)

  • Customer reference number (VR01)

  • Statement number (CTL)

  • Shipment number (SHPN)

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


Regardless of the method that you select to display open invoices, the system does not retrieve these types of invoices:

  • RU (Unapplied receipt)

  • R1 (Drafts)

  • R5 (Deductions)

  • NP (Partial NSF)

13.2.2 Prerequisite

If you select invoices by remittance, verify that the processing options on the Match Priority tab for the RE Receipts Entry program (P15103) are set up appropriately.

13.2.3 Forms Used to Locate Open Invoices

Form Name Form ID Navigation Usage
Receipt Entry W03B102E Manual Receipts Processing (G03B12), Standard Receipts Entry.

Click Add on the Work with Customer Receipts Inquiry form.

Enter unapplied receipts.
Draft Entry W03B602B Draft Daily Operations menu (G03B161), Enter Our Drafts or Enter Customer Drafts.

Click Add on the Work With Drafts form.

Enter unapplied drafts.
Load Invoices W03B102J Select Load from the Form menu on the Receipt Entry or Draft Entry form. Loads all open invoices for a customer and apply them to a receipt.
Select Invoices W03B602E Choose Select from the Form menu on the Receipt Entry or Draft Entry form. Select specific open invoices for a customer and apply them to a receipt.
Remittance Entry W03B602K Select Remittance from the Form menu on the Receipt Entry or Draft Entry form. Select open invoices by remittance and apply them to a receipt.

13.2.4 Loading All Open Invoices for a Customer

The task to select open invoices is the same regardless of whether you select Standard Receipts Entry or one of the draft entry programs.

Access the Receipt Entry or Draft Entry form.

To load all open invoices for a customer:

  1. Follow the steps to enter an unapplied receipt or an unapplied draft.

  2. On Receipt Entry or Draft Entry, select Load from the Form menu.

  3. On Load Invoices, complete either the Company or Payor fields if necessary and click OK.

    The system loads only those invoices for the company that you specify. Enter * to load all invoices for all companies.

    Note:

    In the detail area of the Receipt Entry or Draft Entry form, the system loads all open invoices in order by due date. You can continue to load invoices for other customers, if necessary.

    If you set a processing option to use a default type input code, when the system loads invoices, it populates the TI field with the value that you specified in the processing option.

    The system does not load RU (unapplied receipt), R5 (deduction), or R1 (draft) invoice records.

13.2.5 Select Specific Open Invoices for a Customer

The task to select open invoices is the same regardless of whether you select Standard Receipts Entry or one of the draft entry programs. This task is illustrated using the receipt entry form only.

Access the Receipt Entry or Draft Entry form.

This example shows the Select Invoices form.

To select specific open invoices for a customer:

  1. Follow the steps to enter an unapplied receipt or an unapplied draft.

  2. On Receipt Entry or Draft Entry, select Select from the Form menu.

  3. On Select Invoices, complete the necessary fields in the header area or in the QBE line and then click Find to load the open items that meet the search criteria.

    Note:

    The system does not display RU (unapplied receipt), R5 (deduction), and R1 (draft) invoice records. These records are not available for selection.
  4. Select the invoice or group of invoices and click Select.

    The system marks the invoices that you select. Alternatively, you can select Select/Deselect from the Row menu or double-click the Document Number field to select or deselect the invoices for payment.

    You can select invoices from multiple customers. The system keeps track of the number of invoices that you select and the total amount of the selected invoices.

  5. Click Close to load the selected invoices in the detail area of the Receipt Entry form.

    Note:

    The system displays the invoices in the order in which they were selected.

    If you set a processing option to use a default type input code, when the system loads invoices, it updates the TI field with the value that you specified in the processing option.

13.2.6 Selecting Open Invoices by Remittance

The task to enter remittance information is the same regardless of whether you use the Standard Receipts Entry program (P03B102) or one of the draft entry programs. This task is presented using the Receipt Entry form only.

Access the Receipt Entry or Draft Entry form.

To select open invoices by remittance:

  1. Follow the steps to enter an unapplied receipt or an unapplied draft.

  2. On Receipt Entry or Draft Entry, select Remittance from the Form menu.

  3. On Select Invoices by Remittance, complete the optional fields to narrow the search for the invoices and click Find.

    You can also enter * to specify all values.

    Note:

    If the invoice does not contain the information that you entered in these fields, the system cannot locate it.
  4. In the detail area, complete the Invoice Reference field for each item on the customer's remittance.

    Enter the invoice number, statement number, sales order number, customer reference number, or shipment number. The system searches the F03B11 table for invoices in the order that are specified in the Match Priority processing options, unless you complete the Override Type field.

    Note:

    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) to generate statements for the system to locate invoices by statement number.
  5. (Optional) Complete any of the T I and Override Type fields.

  6. Click in the next detail line and review these fields that the system completes:

    • Items Found

    • Amount Open

    • Discount Available

    • Discount Earnable

    • Process Type

  7. To keep a running total of the remittance amounts, complete the Remittance Amount and Remittance Discount fields to update the totals on the bottom of the form.

    Note:

    The system does not use the remittance amounts entered as the payment and discount amounts on the receipt or draft entry form.

    The system calculates the payment amount for you only if the type input code is provided (either as a default in the processing options or as an override on this form). Otherwise, you must specify the payment amount on the receipt or draft entry form.

  8. Click OK.

    The system displays the invoices on the entry form in the order that you entered them on the remittance form.

    • Override Type

      Enter the number to identify which matching process the system runs to locate invoices. If you leave the 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 entered. For example, if you enter an invoice number in the Invoice Reference field, you can enter 1 in the Override Type field and the system searches for the invoice by invoice number only and ignores the Match Priority processing options.

13.3 Applying Receipts or Drafts to Invoices Using Type Input Codes

This section provides an overview of unapplied receipts applied to invoices and credit memos applied to invoices, and discusses how to:

  • Apply a receipt or draft to invoices using input type codes.

  • Apply an unapplied receipt to invoices.

  • Apply a credit memo to an invoice.

13.3.1 Understanding Unapplied Receipts Applied to Invoices

After you enter an unapplied receipt or draft, you can apply it to the appropriate invoice or group of invoices using all of the available type input codes. To match an unapplied payment to invoices, you select the unapplied payment first and then display the open invoice records. You cannot use the Load or Select features to display unapplied payments along with the open invoices.

When you fully apply an unapplied payment to invoices, the system performs these functions for each invoice to which the payment was applied:

  • Creates a new batch record in the Batch Control Records table (F0011) for batch type RB (for receipts) or DB (for drafts), if the unapplied payment is posted when you apply it against invoices.

  • Closes the RU invoice document in the F03B11 table by updating the pay status to P.

  • Closes the RI invoice document in the F03B11 table by updating the pay status to P, if the invoice is fully paid.

  • Creates RC documents in the F03B14 table.

If you fully apply an unapplied payment to invoices before it is posted, the system deletes the RU record from the F03B11 and F03B14 tables.

Regardless of whether the unapplied payment is posted before you apply it to an invoice, you must post the payment after you apply it to invoices to update the appropriate accounts in the general ledger.

13.3.2 Understanding Credit Memos Applied to Invoices

When the customer has outstanding credit memos, you can apply them to outstanding invoices using the Standard Receipts Entry program (P03B102) or one of the draft entry programs (P03B602). Because you do not have a physical payment, you enter zero in the Receipt Amount or Draft Amount field. You can use the Load, Select, or Remittance feature to display the credit memo and invoice, and then you use the appropriate type input code to apply the credit memo to the invoice. If the credit memo does not fully pay the invoice, you can leave the invoice open for the amount that remains, or create a write-off, chargeback, or deduction record for the difference.

When you fully apply a credit memo to an invoice, the system:

  • Closes the RM credit memo document in the F03B11 table by updating the pay status to P.

  • Closes the RI invoice document in the F03B11 table by updating the pay status to P, if the invoice is fully paid.

  • Creates a record in the F03B13 table for a zero amount.

  • Creates RS receipt documents in the F03B14 table for both the credit memo and the invoice.

After you apply credit memos to invoices, you must post the batch to update the general ledger.

13.3.3 Prerequisites

Before you complete the tasks in this section:

  • Verify that the appropriate accounts are specified for these AAI items:

    • RKD for discounts taken.

    • RCxxxx, where xxxx is the chargeback G/L offset code, for the chargeback A/R trade account.

    • RAxx, where xx is the write-off reason code.

    • RN, for the deduction suspense account.

  • Verify these UDC tables are set up to specify the reason codes:

    • 00/DE for discount reason codes

    • 03B/CB for chargeback reason codes

    • 03B/RC for write-off reason codes

    • 03B/CR for deduction reason codes

  • Verify the processing options are set up appropriately for discounts, chargebacks, write-offs, and deductions, or for the type input codes that you allow.

13.3.4 Forms Used to Apply Receipts or Drafts to Invoices Using Type Input Codes

Form Name Form ID Navigation Usage
Receipt Entry W03B102E Manual Receipts Processing (G03B12), Standard Receipts Entry.

Click Add on the Work with Customer Receipts Inquiry form.

Apply a receipt to invoices using type input codes, apply an unapplied receipt to invoices, or apply a credit memo to an invoice.
Draft Entry W03B602B Draft Daily Operations menu (G03B161), Enter Our Drafts or Enter Customer Drafts.

Click Add on the Work With Drafts form.

Apply a draft to invoices using type input codes, or apply a credit memo to an invoice.

13.3.5 Applying a Receipt or Draft to Invoices Using Type Input Codes

Access the Receipt Entry or Draft Entry form.

To apply a receipt or draft to invoices:

  1. On Receipt Entry or Draft Entry, follow the steps to enter an unapplied receipt or an unapplied draft.

  2. Follow the steps to display the open invoices for the customer.

    See Loading All Open Invoices for a Customer.

  3. In the detail area, complete the T I field with the type input code that corresponds to the application method that you want to use

  4. If necessary, override the value in the Payment Amount, Remark, Discount Taken, Write-Off Amount, Chargeback Amount, and Deduction Amount fields.

  5. Depending on the type input code that you entered, you might have to enter a reason code.

    If the type input code is 11 or 16, complete the CB CD (chargeback reason code) field.

    If the type input code is 15, complete the WO CD (writeoff reason code) field.

    If the type input code is 17, complete the DD CD (deduction reason code) field.

    Note:

    The system does not accept blank as a value, even if it is set up in the user-defined codes. Depending on the setting of processing options, the system might automatically supply the value for the reason code.
  6. (Optional) If the type input code is 11 or 16, complete the Chargeback G/L Offset field to direct the offset for the chargeback to a different A/R trade account.

  7. Verify that the Amount Applied and Amount Unapplied fields on the bottom of the form contain the correct information.

    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.

  8. Click OK.

13.3.6 Applying an Unapplied Receipt to Invoices

Access the Receipt Entry form by selecting an unapplied receipt on the Work with Customer Receipts Inquiry form.

To apply an unapplied receipt to invoices:

  1. On Receipt Entry, follow the steps to display the open invoices for the customer.

    See Loading All Open Invoices for a Customer.

  2. In the header area, complete the G/L Date field.

    Note:

    The G/L date that you assign does not change the G/L date of the unapplied receipt record in the F03B13 table. The system uses the G/L date for the record that it creates in the F03B14 table to pay the invoice.
  3. In the detail area, complete the T I field with the appropriate code.

  4. If necessary, override the value in the Payment Amount, Discount Taken, Remark, Write-Off Amount, Chargeback Amount, and Deduction Amount fields.

  5. Verify that the Amount Applied and Amount Unapplied fields on the bottom of the form contain the correct information.

    The amount pending should equal the receipt amount specified in the receipt header if you have fully applied the receipt to invoices.

  6. Click OK.

13.3.7 Applying a Credit Memo to an Invoice

The task to apply a credit memo to an invoice is the same regardless of whether you select Standard Receipts Entry program or one of the draft entry programs.

Access the Receipt Entry or Draft Entry form.

To apply a credit memo to an invoice:

  1. Follow the steps to enter an unapplied receipt or an unapplied draft, but leave the Receipt Amount or Draft Amount field blank.

  2. On Receipt Entry or Draft Entry, follow the steps to display the open invoices for the customer.

    See Locating Open Invoices.

  3. To fully apply a credit memo to an invoice, enter 10 in the T I field next to the credit memo.

  4. Using the appropriate code, complete the T I field next to the invoice.

    If the credit memo does not fully pay the invoice, you can leave the invoice open for the remaining amount or use a type input code to create a write-off, chargeback, or deduction record for the difference.

  5. Click OK.

13.4 Working with G/L Receipts

This section provides an overview of G/L receipts and discusses how to:

  • Enter a G/L receipt.

  • Create an unapplied receipt from a G/L receipt.

13.4.1 Understanding G/L Receipts

When you receive a check that is not associated with a customer's account, such as a refund check from an insurance company or a rebate, you can enter the check by entering a G/L receipt on either the Standard Receipts Entry program (P03B102) or the Speed Receipts Entry program (P03B0001). A G/L receipt enables you to credit the appropriate general ledger account and include the amount in the bank deposit.

After you enter G/L receipts, you must post them to update the bank and G/L accounts.

13.4.2 Forms Used to Enter G/L Receipts

Form Name Form ID Navigation Usage
Work with Customer Receipts Inquiry W03B102A Manual Receipts Processing (G03B12), Standard Receipts Entry. Locate and select an existing receipt.
Receipt Entry W03B102E Click Add on the Work with Customer Receipts Inquiry form. Enter a standard unapplied receipt.
G/L Receipts Entry W03B0001C Select General Ledger from the Form menu on the Receipt Entry form. Enter a G/L receipt that is not associated with a customer's account.

13.4.3 Entering a G/L Receipt

Access the Receipt Entry form.

To enter G/L receipts:

  1. On Receipt Entry, follow the steps to enter an unapplied receipt.

    Note:

    You do not have to complete the Customer or Payor fields when you enter a G/L receipt.
  2. Select General Ledger from the Form menu.

  3. On G/L Receipts Entry, complete the G/L Account Number and Payment Amount fields for each G/L account.

    You can use multiple grid lines to distribute the receipt to as many G/L accounts as necessary. The total amount that you enter must equal the receipt amount.

  4. Click OK to return to the Receipt Entry form.

  5. Verify that the Amount Applied and Amount Unapplied fields on the bottom of the form contain the correct information.

    If you have fully applied the receipt to invoices, the amount pending should equal the receipt amount in the receipt header. The system creates an unapplied receipt record for the amount in the Amount Unapplied field.

    Note:

    If you have an amount in the Amount Unapplied field, you must to complete the Payor and Customer fields on the form before you click OK or the system returns an error.
  6. On Receipt Entry, click OK.

13.4.4 Creating an Unapplied Receipt from a G/L Receipt

Access the Work with Customer Receipts Inquiry form.

To create an unapplied receipt from a G/L receipt:

Locate and select the general ledger receipt on the Work with Customer Receipts Inquiry form.

  1. On Receipt Entry, select General Ledger from the Form menu.

  2. On G/L Receipts Entry, delete one or more lines of account information for the receipt.

    If the receipt is posted, the system prompts you to complete the Void G/L Date and Void Reason Code fields.

  3. Click OK to return to the Receipt Entry form.

  4. Enter a customer number and a payor number, and then click OK.

    Without the general ledger account information, the receipt reverts to an unapplied receipt, which requires a customer number and a payor number.

13.5 Entering Stand-Alone Records

This section provides an overview of stand-alone records and discusses how to:

  • Enter stand-alone transactions with invoice match.

  • Enter stand-alone transactions without invoice match.

13.5.1 Understanding Stand-Alone Records

Stand-alone records are write-offs, chargebacks, and deductions that are not associated with any known invoice. You create stand-alone records when the customer sends a payment for several invoices, but the payment amount does not equal the total amount of the invoices. You can also use the stand-alone feature when an unapplied payment is applied to several invoices and a small difference between the totals exists. In these scenarios, the system matches the payment to invoices, but the shortage is recorded without specifying a particular invoice.

You can also use the stand-alone feature without performing an invoice match. For example, you can create a deduction or write off a small duplicate payment. Additionally, to distribute an unapplied payment to several customer accounts, you can enter a stand-alone chargeback without invoice matching. When you use the stand-alone feature without invoice matching, you must enter the amount as a credit (negative); otherwise, the system creates an unapplied payment for twice the amount specified.

It is recommended that you use the stand-alone feature in conjunction with invoice match, whenever possible.

You use these type input codes to create stand-alone transactions in the receipt and draft entry programs:

Type Input Code Usage
25 (Stand-alone write-off) Use this code to create a write-off for a disputed amount, such as tax on a freight charge, that is not associated with a specific invoice.
26 (Stand-alone chargeback) Use this code to create a chargeback invoice for an unpaid amount that is not associated with a specific invoice.
27 (Stand-alone deduction) Use this code to create a deduction for an amount that is not associated with a specific invoice.

13.5.1.1 Stand-Alone Write-Offs (TI Code 25)

A stand-alone write-off is a write-off for an amount that is not associated with any specific invoice. For example, when you receive a receipt or draft to pay multiple invoices, and the customer has not indicated which invoice should receive the short payment, you can write off this amount using a stand-alone entry. Additionally, you might use the stand-alone feature for write-offs that are not associated with any invoice. For example, you use a stand-alone write-off when you receive a duplicate payment for a small amount and want to write it off.

When you create a stand-alone write-off (type input code 25), the system reduces the customer's open balance by the amount of the write-off.

13.5.1.2 Stand-Alone Chargebacks (TI Code 26)

When an amount in dispute is not associated with a specific invoice, you can create a stand-alone chargeback for the amount. A stand-alone chargeback enables you to re-invoice the customer for the amount that is in dispute. Typically, you enter stand-alone chargebacks when the payment amount does not total the invoices being paid, and you want to charge back the difference to the customer. In this case, you enter a standalone chargeback with invoice match. The system increases the customer's open balance by the amount of the short-payment.

You enter a stand-alone chargeback without invoice match when you want to distribute an unapplied receipt or draft among multiple customer accounts. When you do this, the system creates a record in the F03B13 table for the payor, and creates associated records in the F03B14 and F03B11 tables for the chargeback amount (as a credit) to each customer. This process simulates the creation of an unapplied payment for each customer.

13.5.1.3 Example: Using Stand-Alone Chargebacks to Distribute an Unapplied Payment Among Multiple Customers

When you receive one payment to be distributed among multiple customers without applying it to invoices, you use the stand-alone chargeback feature.

For example, you receive a receipt for 15,000 from payor 3001 to be applied as follows:

  • 5,000 to customer 3004

  • 5,000 to customer 3333

  • 5,000 to customer 3334

Using the stand-alone chargeback feature, you specify the customer and amount that you want to distribute. Enter the payment amount as a credit (negative amount). You repeat the process until the amount is fully distributed among the customers.

The system creates these records:

Table Document Type Gross Amount Customer Number Payment ID
F03B13 N/A 15,000 3001 521
F03B11 RB -5,000 3004 521
F03B11 RB -5,000 3333 521
F03B11 RB -5,000 3334 521
F03B14 RC

Note: This is the matching document type (DCTM).

-5,000 3004 521
F03B14 RC

Note: This is the matching document type (DCTM).

-5,000 3333 521
F03B14 RC

Note: This is the matching document type (DCTM).

-5,000 3334 521

The system uses the payment ID to provide an audit trail from the F03B11 and F03B14 records to the original F03B13 payment record.

Later, you must apply the negative chargeback invoices to invoices that you want to pay.

13.5.1.4 Stand-Alone Deductions (TI Code 27)

When the amount of the payment does not equal the amount of the invoices that it pays, you can create a stand-alone deduction to postpone the research and resolution of the short-payment until a later date. Additionally, you might use the stand-alone feature for deductions that are not associated with any invoice. For example, you would use this feature if you receive a duplicate payment for a small amount and are unsure about how to process it.

When you create a stand-alone deduction (type input code 27), the system reduces the customer's account by the amount of the short-payment.

When you post the deduction, the system creates a record in the A/R Deduction Management table (F03B40) that you use to resolve the issue.

13.5.2 Prerequisites

For stand-alone write-offs:

  • Ensure that you set the maximum amount in the Manual Write-Off processing option high enough so that the system accepts entry.

  • Verify that the account that you want to use for the each write-off reason code is set up for the AAI item RAxx, where xx is the write-off reason code.

  • Verify that the processing option on the Edits tab is set up to allow write-offs.

  • Verify that the values that you want to use for the write-off reason code are set up in UDC 03B/RC.

For stand-alone chargebacks:

  • Verify that the chargeback A/R trade account is set up for the AAI item RCxxxx, where xxxx is the chargeback general ledger offset code.

  • Verify that the processing options on the Chargeback tab are set up.

  • Verify that the values that you want to use for the chargeback reason code are set up in UDC 03B/CB.

For stand-alone deductions:

  • Verify that the deduction suspense account is set up for the AAI item RN.

  • Verify that the values that you want to use for the deduction reason code are set up in UDC 03B/CR.

13.5.3 Forms Used to Enter Stand-Alone Records

Form Name Form ID Navigation Usage
Receipt Entry W03B102E Manual Receipts Processing (G03B12), Standard Receipts Entry.

Click Add on the Work with Customer Receipts Inquiry form.

Enter unapplied receipts.
Draft Entry W03B602B Draft Daily Operations menu (G03B161), Enter Our Drafts or Enter Customer Drafts.

Click Add on the Work With Drafts form.

Enter unapplied drafts.
Create Standalone Payment W03B602H Select Standalone from the Form menu, and then select Write-Off, Chargeback, or Deduction on the Receipt Entry or Draft Entry form. Enter a stand-alone transaction.

This form contains different fields, depending on whether you selected Write-Off, Chargeback, or Deduction.


13.5.4 Entering Stand-Alone Transactions without Invoice Match

The task to create stand-alone transactions without invoice match is the same regardless of whether you select Standard Receipts Entry or one of the draft entry programs. This task is described using the Receipt Entry form only.

Access the Receipt Entry or Draft Entry form.

To create stand-alone transactions without invoice match:

  1. On Receipt Entry or Draft Entry, follow the steps to enter an unapplied receipt or an unapplied draft.

  2. From the Form menu, select Stand-alone, and then select Write-Off, Chargeback or Deduction.

  3. On Create Stand-alone Transaction, complete the Customer and Customer Reference fields.

  4. For stand-alone write-offs, complete the Write-Off Amount and Write-Off Reason Code fields.

  5. For stand-alone chargebacks, complete the Chargeback G/L Offset, Chargeback Amount, and Chargeback Reason Code fields.

  6. For stand-alone deductions, complete the Deduction Amount and Deduction Reason Code fields.

  7. Click OK.

    On Receipts Entry, the system adds a new detail line, creates a positive payment amount for the stand-alone transaction, and assigns the appropriate type input code.

    Note:

    If you are creating standalone chargebacks to distribute an unapplied receipt among multiple customer accounts, repeat steps 2, 3, and 5 for each customer to whom you want to distribute an amount.
  8. Verify that the Amount Pending and Amount Unapplied fields on the bottom of the form contain the correct information

    If you have fully applied the payment to invoices, the amount pending should equal the receipt amount that appears in the header portion of the entry form.

  9. Click OK.

    • Customer

      If you are creating stand-alone chargebacks so that you can distribute an unapplied receipt among multiple customers, enter the customer number to whom you want to distribute the unapplied receipt. The system creates credit (RB) records in the F03B11 table for the appropriate customers, which you can locate and apply against invoices at a later time.

    • Write-Off Amount

      For stand-alone write-offs without invoice match, you must enter the write-off amount as a credit (negative amount). Otherwise, the system creates an unapplied record for twice the amount that you specified.

    • Write-Off Reason Code

      The system does not accept blank as a value, even if it is set up in the user-defined codes. If you leave this field blank, the system does not use the default write-off reason code from the processing options.

    • Chargeback Amount

      Enter the amount that you want to distribute to the first customer as a credit (negative amount). Otherwise, the system creates an unapplied record for twice the amount specified.

    • Deduction Amount

      For stand-alone deductions without invoice match, you must enter the Deduction Amount as a credit (negative amount).

    • Deduction Reason Code

      The system does not accept blank as a value, even if it is set up in the user-defined codes. If you leave this field blank, the system does not use the default deduction reason code from the processing options.

    • Amount Unapplied

      The system creates an unapplied record for the amount in this field.

13.6 Entering Speed Receipts

This section provides an overview of speed receipts and discusses how to:

  • Set processing options for Speed Receipts Entry (P03B0001).

  • Enter unapplied receipts (TI code 1).

  • Enter balance forward receipts (TI code 2).

  • Enter logged receipts (TI code 3).

  • Assign logged receipts to customers.

  • Enter G/L receipts (TI code 4).

13.6.1 Understanding Speed Receipts

As an alternative to entering standard receipts, you can use the Speed Receipts Entry program (P03B0001) to quickly enter high-volume, simple receipts. When you use Speed Receipts Entry, you are not required to match receipts to invoices or even apply them to a specific customer's account. You can enter receipts with the minimum amount of information to speed the recognition of cash in the general ledger.

The system creates records in these tables when you enter speed receipts:

  • F03B13

  • F03B14

You cannot review or revise receipts using Speed Receipts Entry; you must use Standard Receipts Entry.

After you enter receipts using Speed Receipts Entry, you must post them to the general ledger to update the appropriate bank and A/R trade accounts.

13.6.1.1 TI Code 1 (Applied Receipt)

Use this input code to apply a receipt to a customer's account balance instead of matching it to a specific invoice or group of invoices. This method enables you to update the customer's account and recognize cash immediately, and then match the receipt to invoices at a later time.

13.6.1.2 TI Code 2 (Balance Forward Receipt)

The balance forward method enables you to specify a beginning date from which to begin applying the receipt. The program applies the receipt to invoices in the order of oldest to newest. The system applies the receipt to invoices until the receipt amount is exhausted. If the receipt cannot fully pay an invoice, it applies a partial payment. If the amount of the receipt exceeds the amount of the invoices, the system automatically creates an unapplied receipt for the remaining amount. Later, you can apply the receipt to future invoices that you create for the customer. If the receipt does not fully pay an invoice, the system applies a partial payment to it. Alternatively, you can enter an invoice number to have the system apply the receipt to all the pay items for that invoice.

You can set a processing option to enable the system to take earned discounts when entering a balance forward receipt. The system compares the G/L date that you enter on the receipt to the discount due date to determine whether the discount is earned. The system takes earned discounts only when an invoice is paid in full. The Speed Receipts Entry program (P03B0001) does not allow you to change the discount amount; you must use the Standard Receipts Entry program (P03B102).

13.6.1.3 TI Code 3 (Logged Receipt)

If you receive a payment but cannot locate the customer or payor, you can log the receipt (TI code 3) to recognize the revenue immediately, and then apply the receipt to the customer's account at a later date. Logging receipts enables you to deposit payments, improve cash flow immediately, and apply the receipt to the customer account and their invoices later. This method of entering receipts is useful when the people who enter receipts and make the bank deposits are different than those who match the receipts to a customer or invoices.

When you enter a logged receipt, the system creates a record in both the F03B13 and F03B14 tables.

After you enter a logged receipt, you must post it to update the bank account balance. When you post a logged receipt, the system distributes the total amount of the receipt to a suspense account that you specify in the AAI item RCLC. After you apply the receipt to a customer's account, the system clears the suspense account and updates the appropriate A/R trade account.

Note:

If you do not post the logged receipt before you apply it to the customer's account, the system deletes the logged receipt records from the F03B14 table.

13.6.1.4 TI Code 4 (G/L Receipt)

If you receive a miscellaneous payment, such as a rebate check, that is not associated with a customer's account you can enter it into the system using Speed Receipts (TI code 4). This method enables you to credit the appropriate general ledger account and include the amount in the bank deposit.

When you enter a G/L receipt, you can distribute it to one G/L account or several. When entering a G/L receipt, you can select a receipt and redistribute it among multiple G/L accounts. For example, you might want to distribute the amount of a refund check among different revenue or cash accounts. The amounts that you distribute among various G/L accounts must equal the total amount of the receipt.

After you enter a G/L receipt, you must post it to update the account information.

13.6.1.5 Receipt Deletion

Each line in the detail area represents a separate receipt. You can delete a receipt before you click OK on the Speed Receipts Entry form. To do so, select the receipt and click Delete. This method provides a quick way to delete the entire row of information at one time instead of deleting the information in each column separately.

13.6.1.6 Attached Text or Objects

After you enter a receipt, you can attach text, an OLE object, or an image, such as a scanned receipt. For example, you might attach an internal comment or memo regarding a receipt revision or void. You can add attachments only at the receipt level.

To attach text or objects, select the receipt on the Speed Receipts Entry form. Then, select Attachments from the Row menu.

13.6.2 Prerequisite

Before you enter logged receipts (TI code 3) set up AAI item RCLC (logged receipts) for the suspense account.

13.6.3 Forms Used to Enter Speed Receipts

Form Name Form ID Navigation Usage
Speed Receipts Entry W03B0001A Manual Receipts Processing (G03B12), Speed Receipts Entry Enter high-volume, simple receipts.
Work with Customer Receipts Inquiry W03B102A Manual Receipts Processing (G03B12), Standard Receipts Entry Locate logged receipts.
Receipt Entry W03B102E Select a logged receipt and click Select on the Work with Customer Receipts Inquiry form. Assign a logged receipt to a customer.
G/L Receipts Entry W03B0001C Manual Receipts Processing (G03B12), Speed Receipts Entry

Select Split Receipt from the Row menu on the Speed Receipts Entry form.

Distribute a G/L receipt to more than one G/L account.

13.6.4 Setting Processing Options for Speed Receipts Entry (P03B0001)

Processing options enable you to specify the default processing for programs and reports.

13.6.4.1 Display

These processing options specify whether the system retains the field values when a new receipt is entered.

1. Company

Specify whether to retain the company number entered on the Speed Receipts Entry form after you enter the receipt. Values are:

Blank: Do not retain the company number.

1: Retain the company number.

2. Bank Account

Specify whether to retain the bank account number entered on the Speed Receipts Entry form after you enter the receipt. Values are:

Blank: Do not retain the bank account.

1: Retain the bank account.

3. Receipt Date

Specify whether to retain the receipt date entered on the Speed Receipts Entry form after you enter the receipt. Values are:

Blank: Do not retain the receipt date.

1: Retain the receipt date.

4. Remark

Specify whether to retain the remark entered on the Speed Receipts Entry form after you enter the receipt. Values are:

Blank: Do not retain the remark.

1: Retain the remark.

5. G/L Date

Specify whether to retain the G/L date entered on the Speed Receipts Entry form after you enter the receipt. Values are:

Blank: Do not retain the G/L date.

1: Retain the G/L date.

6. Cleared/Value Date

Specify whether to retain the cleared date entered on the Speed Receipts Entry form after you enter the receipt. Values are:

Blank: Do not retain the cleared date.

1: Retain the cleared date.

7. Currency

Specify whether to retain the currency code entered on the Speed Receipts Entry form after you enter the receipt. Values are:

Blank: Do not retain the currency code.

1: Retain the currency code.

8. Exchange Rate

Specify whether to retain the exchange rate entered on the Speed Receipts Entry form after you enter the receipt. Values are:

Blank: Do not retain the exchange rate.

1: Retain the exchange rate.

9. Currency Mode

Specify whether to retain the value of the currency mode, which is controlled by the Foreign option, entered on the Speed Receipts Entry form after you enter the receipt. Values are:

Blank: Do not retain the value of the currency mode.

1: Retain the value of the currency mode.

13.6.4.2 Defaults

These processing options specify the default values for certain fields.

1. Type Input Code

Specify the default type input code to display on the Speed Receipts Entry form. Values are:

1: Unapplied Receipt

2: Balance Forward Receipt

3: Logged Receipt

4: General Ledger Receipt

2. Default G/L Offset 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 G/L Offset field when you enter unapplied receipts. The system locates the A/R trade account based on the G/L offset that you use. Values are:

Blank: Do not use values from the customer record. The system uses the default value UC.

1: Use the G/L offset from the customer record. If the customer record does not have a G/L offset defined, the system uses the default G/L offset (UC) for unapplied receipts.

13.6.4.3 Edits

These processing options specify whether a receipt number is required.

1. Receipt Number

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

Blank: Do not require receipt number.

1: Require receipt number.

13.6.4.4 Process

These processing options specify whether to enable invoices to be paid when the status is not approved (A) and whether the system creates summarized or detailed Account Ledger records (F0911) when the receipt is posted.

1. Pay Only Approved Invoices

Specify whether to enable receipts to be applied to all invoices or only approved invoices (invoices with a pay status of A). Values are:

Blank: Pay all invoices.

1: Pay only approved invoices.

2. Journal Entry Creation Method

Specify whether the post program creates one summarized journal entry for the batch of receipts entered, 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 (ISTR) in the F03B13 table. 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 A/R Constants is equal to B (batch mode).

  • The batch does not contain any foreign transactions.

Otherwise, the system creates journal entries in detail.

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)

13.6.4.5 Auto Write-Off

These processing options specify limits for under- and over-payments and the associated reason code.

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 specified, the system automatically writes off the remaining amount when the receipt is applied.

2. Underpayment Reason Code

Use this processing option to enable automatic write-off processing and to 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 specified, the system automatically writes off the remaining amount when the receipt is applied.

Enter the value as a negative amount.

4. Overpayment Reason Code

Use this processing option to enable automatic write-off processing and to 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.

13.6.4.6 Discount

These processing options specify whether to enable all discounts or earned discounts only and the default value for the discount reason code.

1. Allow Discounts

Specify whether to take available discounts during receipt application. Values are:

Blank: Do not allow discounts. If discounts are available, the system ignores them during receipt application.

1: Allow discounts. If discounts are available, the system takes the discount during receipt application.

2. Allow Only Earned Discounts

Specify whether to take only earned discounts during receipt application. A discount is earned when the G/L date entered on the Speed Receipts Entry form is on or before the discount due date of the invoice. Values are:

Blank: Allow all discounts. The system takes the discount, if allowed, regardless of whether it is earned.

1: Allow only earned discounts. The system takes only earned discounts.

3. Discount Reason Code

Specify the default discount reason code to use when discounts are taken. 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.

13.6.5 Entering Unapplied Receipts (TI Code 1)

The system creates unapplied receipt records from the Speed Receipts Entry program (P03B0001) exactly as it does when you use the Standard Receipts Entry program (P03B0102).

See Entering Unapplied Receipts.

Access the Speed Receipts Entry form.

To enter an unapplied receipt:

  1. On Speed Receipts Entry, complete the Company, Bank Account, Type Input, G/L Date, Receipt Date, and Remark (optional) fields in the header area.

  2. Complete the Payor Address, Customer Address, Receipt Number, and Receipt Amount fields in the detail area.

  3. In the detail area, override the value in the G/L Offset field if necessary.

  4. Click OK.

13.6.6 Entering Balance Forward Receipts (TI Code 2)

Access the Speed Receipts Entry form.

To enter a balance forward receipt:

  1. On Speed Receipts Entry, complete the Company, Bank Account, Type Input, G/L Date, Receipt Date, and Remark fields in the header area.

  2. Complete the Payor Address, Customer Address, Receipt Number, and Receipt Amount fields in the detail area.

  3. Complete the Bal Fwd Start Date (balance forward start date) field, the Document Number field, or both.

  4. Click OK.

    • Bal Fwd Start Date (balance forward start date)

      Enter the date that the system uses to select invoices for payment using the balance forward method (type input code 2). Invoices that have a due date equal to or greater than the date that you specify, for the customer that you specify, are eligible for payment. If you leave this field blank, the system applies the receipt to the oldest open invoice for the specified customer.

    • Document Number

      Enter the invoice number to which the system applies the receipt. The system applies the receipt to all pay items for the invoice number that you enter.

      If you enter a document number, you do not have to enter a value in the Balance Forward Start Date field. However, you can complete both fields if you want to limit the number of invoice pay items that the system pays by due date.

13.6.7 Entering Logged Receipts (TI Code 3)

Access the Speed Receipts Entry form.

To enter a logged receipt:

  1. On Speed Receipts Entry, complete the Company, Bank Account, Type Input, G/L Date, Receipt Date, and Remark fields in the header area.

  2. Complete the Receipt Number and Receipt Amount fields in the detail area and then click OK.

13.6.8 Assigning Logged Receipts to Customers

Access the Receipts Entry form by selecting a logged receipt.

To assign a logged receipt to a customer:

  1. On Receipt Entry, complete the Payor and Customer fields.

  2. (Optional) Complete the G/L Date field.

  3. If you know the invoices that you want to pay, you can display the open items and proceed with receipt matching.

  4. Click OK.

13.6.9 Entering G/L Receipts (TI Code 4)

Access the Speed Receipts Entry form.

To enter G/L receipts:

  1. On Speed Receipts Entry, complete the Company, Bank Account, Type Input, G/L Date, Receipt Date, and Remark fields.

  2. Complete the Receipt Number, Receipt Amount, and G/L Account Number fields in the detail area.

  3. If you want to distribute the receipt to more than one G/L account, select Split Receipt from the Row menu.

  4. On G/L Receipts Entry, complete the G/L Account Number, Payment Amount, and Remark fields for each additional G/L account.

    Note:

    You must distribute the entire amount of the receipt; otherwise, the system returns an error.
  5. Click OK.

  6. On Speed Receipts Entry, click OK.

13.7 Revising Receipts

This section provides an overview of receipt revisions and discusses how to revise unposted receipts.

13.7.1 Understanding Receipt Revisions

After you enter receipts, you might need to revise them. For example, you might have applied a receipt to the wrong invoice or customer, or used the wrong general ledger date. Depending on the posting status and the data that you need to change, you might have to delete or void the receipt, and then re-enter it.

You can revise unposted receipts that are in the current general ledger period only, unless you select the Allow PBCO Postings option within the General Accounting constants.

Note:

Depending on the setup of the AAI item for the receivables trade account (RC), the system might generate an error when you try to revise the building on an unposted receipt.

When you enter an unapplied receipt, the system uses the default AAI item RCUC to retrieve the A/R trade account unless you enter an unapplied general ledger offset. If you enter an unapplied general ledger offset, the system uses the account set up for AAI item RCxxxx, where xxxx is the value of the general ledger offset. If the AAI does not have a business unit specified, the system uses the building number (MCU2) entered on the unapplied receipt as the business unit for the account. The system updates the AID field of the Receipts Header record (F03B13) based on the account retrieved from the AAI.

If you change the building number on an unapplied receipt, the system does not rewrite the value of AID. Based on AAI setup, if the system determines that a different account should be updated to the AID field, it generates an error. You must delete the unapplied receipt and re-enter it.

13.7.1.1 Unposted Receipts

You can revise these fields on an unposted receipt:

  • Bank Account

  • Remark

  • Receipt Amount

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

  • Payment Instrument

  • Cleared Date

  • Unapplied G/L Offset

  • Receipt Reference

  • Lease

  • Building

  • Unit

Note:

The Lease, Building, and Unit 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.

13.7.1.2 Posted Receipts

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

  • Remark

  • Payment Instrument

  • Cleared Date

  • Receipt Reference

You do not have 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.

See Deleting and Voiding Receipt Information.

13.7.1.3 Logged Receipts

To change the amount of a logged receipt, the system requires that you assign a payor and customer. If you cannot assign this information, you must delete or void the logged receipt, and re-enter the transaction.

13.7.2 Forms Used to Revise Receipts

Form Name Form ID Navigation Usage
Receipt Entry W03B102E Manual Receipts Processing (G03B12), Standard Receipts Entry.

Select the receipt that you want to revise and then click Select on Work with Customer Receipts Inquiry.

Revise an unposted receipt.

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

Additional Information W03B102I Select Additional Info from the Form menu on the Receipt Entry form. Revise additional receipt information.
Work With Batches W0011A Manual Receipts Processing menu (G03B12), Receipts Journal Review Locate receipt batches.
Create/Revise Batch Header W0011D Select a batch and then select Revise from the Row menu on the Work With Batches form. Revise the status of a batch.

13.7.3 Revising Unposted Receipts

Access the Receipt Entry form.

To revise an unposted receipt:

  1. On Receipt Entry, revise the information in the Bank Account, Remark, or Receipt Amount fields.

  2. To revise additional receipt information, select Additional Info from the Form menu.

  3. On Additional Information, revise the information in the Payment Instrument, Cleared Date, Unapplied G/L Offset, Receipt Reference fields and click OK.

  4. On Receipt Entry, revise the payment amount and type input codes of the invoices to pay.

  5. To delete an invoice pay item, select the pay item and click Delete.

  6. To add another invoice pay item, use either the Load or Select feature.

  7. Verify that the Amount Pending and Amount Unapplied fields on the bottom of the form contain the correct information.

    If you have fully applied the receipt to invoices, the amount pending should equal the receipt amount that is specified in the receipt header. The system creates an unapplied receipt record for the amount in the Amount Unapplied field.

    Note:

    The Amount Unapplied cannot be negative or the system returns an error when you click OK.
  8. Click OK.

13.8 Approving and Posting Receipts

This section provides an overview of receipt posting and the automatic entries created by the receipt post process, and discusses how to:

  • Run the post program to post receipts.

  • Post receipts from Receipts Journal Review.

13.8.1 Understanding Receipt Posting

After you enter receipts, you must approve them and then post them to the general ledger to update the appropriate account information. Depending on the organization's policy, management approval might be required before you can post receipt batches. The process to review and approve batches is the same regardless of the batch type.

Because the system creates all of the entries to the Account Ledger table (F0911) when you post receipts, balancing errors occur only when the post program is interrupted. If the post program is aborted before it completes, run the post program again to delete the entries that the system created, and then run the post program a third time to create new entries.

Note:

The status of the receipt batch header remains "In Use" until you exit the Work With Customer Receipts Inquiry form.

During the post, the system:

  • Selects unposted receipt transactions from these tables:

    • F03B13

    • F03B14

  • Validates each transaction.

If no errors occur, the system:

  • Debits the appropriate bank account for the receipt amount, which creates bank deposit records in the F0911 table.

  • Creates automatic offsets (credits) to the A/R trade account in the F0911 table.

  • Creates automatic entries to the discount, write-off, chargeback, or deduction accounts, if applicable.

  • Updates balances in the Account Balances table (F0902).

  • Marks the transactions as posted (P) in the F0911 table.

  • Updates the F03B13 and F03B14 tables with a D in the Posted Code field.

  • Updates the status of the Batch Control Record table (F0011) to D.

You can also post receipts from the Work With Batches form that you access when you select the Receipts Journal Review or Real Estate Journal Review program (P0011), located on the same menu as the post program.

Note:

The system creates unapplied receipt (RU), chargeback (RB), and deduction (R5) invoices with a posted status of D in the F03B11 table. To determine whether these records are posted, you must locate and verify the posted status of the receipt document from which they originated.

13.8.1.1 Journal Entries Created by the Receipt Post Process

When you post receipts to the general ledger, the system creates the account ledger record (F0911) differently, depending on the setting of the processing option for the journal entry creation method in the receipts entry program.

Regardless of the method that you use to create journal entries, the system updates these fields in the receipt detail record (F03B14) from the journal entry that the system creates:

  • RZDCTG (Document Type - JE)

  • RZDOCG (Document Number - JE)

  • RZKCOG (Document Company - JE)

13.8.1.2 Detail Method

If you set the processing option to create detailed journal entries, when you enter the receipt, the system updates the A/R Post Status (ISTR) field in the F03B13 table to 1. When you post receipts, the system:

  • Creates one document in the F0911 table for each receipt in the batch.

  • Assigns the journal entry for the bank account a document type of RC.

  • Assigns the document number from next numbers for system 03B, line 9 (Receipt JE number).

  • Updates the record in the F03B14 table with the document number that is assigned to the journal entry for audit purposes.

13.8.1.3 Summary Method

If you set the processing option to create summarized journal entries, when you enter the receipt, the system does not update the A/R Post Status (ISTR) field in the F03B13 table. When you post receipts, the system:

  • Creates one document in the F0911 table for each batch of receipts posted.

  • Assigns the journal entry a document type of RK to the entry for the bank account.

  • Assigns the batch number as the document number.

For the system to create summarized journal entries, you must also verify:

  • The offset method in the Accounts Receivable Constants is set to a value of B (batch mode).

  • The intercompany settlement option in the general accounting constants is set to a value other than 2 or 3.

Otherwise, the system creates detailed journal entries.

13.8.1.4 Key to Method Used

This table shows the type of journal entry that the system creates according to the settings in the general accounting and accounts receivable constants.

Intercompany (G/A Constants) Offset Method (A/R Constants)* Journal Entry Creation Method (Summary or Detail) Journal Entry Created (F0911)
1 (Hub) B D Detail
1 Y D Detail
1 S D Detail
2 (Detail) B D Detail
2 Y D Detail
2 S D Detail
3 (Configured Hub) B D Error (not allowed)
3 Y D Detail
3 S D Detail
1 B S Summary
1 Y S Detail
1 S S Detail
2 B S Summary
2 Y S Detail
2 S S Detail
3 B S Error (not allowed)
3 Y S Detail
3 S S 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

13.8.1.5 Posting Voided and NSF Receipts

The system also creates different journal entries when you post a receipt that has been voided or designated as insufficient funds (NSF). Regardless of the processing option setting for the journal entry creation method, this occurs:

  • When you post a voided receipt, the system creates a journal entry with the document type RO.

  • When you post a receipt that is designated as NSF, the system creates a journal entry with the document type RV.

The system updates the DOCQ, DCTQ, and KCOQ fields in the F03B13 record with the document number and document type that the system assigns to the journal entry.

13.8.1.6 Posting Zero Amount Receipts

When you fully apply credit memos or unapplied receipts to invoices, the system does not generate journal entries to the bank account because the amount of the receipt is zero.

Additionally, the system creates an automatic entry (document type AE) only when the A/R trade account to which the unapplied receipt or credit memo was posted is different from the A/R trade account to which the invoice was posted. If the trade accounts are the same for the credit memo or unapplied receipt and the invoice, the system does not generate AE entries or produce a posting edit report.

See Understanding Fields Updated During Receipt or Draft Entry.

13.8.2 Understanding Automatic Entries Created by the Receipt Post Process

When you post receipts, the system creates automatic entries (document type AE) in the F0911 table. The system uses the account IDs from fields that the system updated when you entered the receipt. This table lists the fields that the system uses during the post process to locate the account for the AE entry based on the type of receipt.

Account Type of Receipt Field Table
A/R 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

13.8.3 Forms Used to Approve and Post Receipts

Form Name Form ID Navigation Usage
Work With Batches W0011D Manual Receipts Processing menu (G03B12), Receipts Journal Review Locate receipt batches.
Batch Approval W0011C Select a batch and then select Batch Approval from the Row menu on the Work With Batches form. Approve a batch for posting.

13.8.4 Running the Post Program to Post Receipts

Use one of these navigations:

From the Manual Receipts Processing menu (G03B12), select Post Receipts to G/L.

From the Real Estate Receipts menu (G1513), select Post Receipts.

13.8.5 Posting Receipts from Receipts Journal Review

Access the Work With Batches form.

Select the batch that you want to post and select Post by Batch from the Row menu.

13.9 Deleting and Voiding Receipt Information

This section provides an overview of receipt voids and deletions, and discusses how to:

  • Delete or void a receipt.

  • Delete or void an invoice pay item from a receipt.

13.9.1 Understanding Receipt Voids and Deletions

When you cannot revise the information on a receipt, such as the payor or the general ledger date, you must delete or void the receipt. You follow the same steps to delete and void a receipt; if the receipt is unposted, the system removes all the receipt records, if the receipt is posted, the system creates new reversing records.

When you delete or void a receipt, the system:

  • Restores the open amount of the invoice or group of invoices to which the receipt applied.

  • Changes the pay status on the invoices from paid (P) to approved (A).

Additionally, if you void a receipt, the system:

  • Marks the receipt as voided in the F03B13 table.

  • Creates new records in the Batch Control Records table (F0011) and the F03B14 table.

You must post the new batch to update the general ledger accounts with reversing information. When you post a voided receipt, the system creates a record in the Account Ledger table (F0911) with the document type RO.

13.9.2 Prerequisite

Verify that the values that you want to use for the Void/NSF reason codes are set up in UDC 03B/VR.

13.9.3 Forms Used to Delete and Void Receipts

Form Name Form ID Navigation Usage
Work with Customer Receipts Inquiry W03B102A Manual Receipts Processing (G03B12), Standard Receipts Entry Locate a receipt to delete or void.
Receipt Entry W03B102E Select a receipt and then click Select on the Work With Customer Receipts Inquiry form. Void or delete an invoice pay item from a receipt.
Confirm Delete W03B602D Select Delete from the tool bar or select Void/Delete from the Row menu on the Work with Customer Receipts Inquiry form.

Or, select Void/Delete from the Row menu on the Receipts Entry form.

Confirm the deletion or void/deletion of a receipt.
Void/NSF Receipt W03B102C Click OK on the Confirm Delete form. The system displays this form if you void or delete a posted receipt. You use this form to specify the G/L date and the reason for the void.

13.9.4 Deleting or Voiding a Receipt

Access the Work with Customer Receipts Inquiry form.

To delete or void a receipt:

  1. On Work with Customer Receipts Inquiry, select the receipt that you want to delete or void.

  2. Select Delete from the tool bar or select Void/Delete from the Row menu.

  3. On Confirm Delete, click OK.

    If the receipt is not posted, the system removes the records.

  4. If the receipt is posted, on Void/NSF Receipt, complete the G/L Date and Reason Code fields.

  5. Click OK.

13.9.5 Deleting or Voiding an Invoice Pay Item from a Receipt

Access the Work with Customer Receipts Inquiry form.

To delete or void an invoice pay item from a receipt:

From the Manual Receipts Processing menu (G03B12), select Standard Receipts Entry.

  1. On Work With Customer Receipts Inquiry, select the appropriate receipt and click Select.

  2. On Receipts Entry, select the pay item that you want to delete or void.

  3. From the Row menu, select Void/Delete.

  4. On Confirm Delete, click OK.

    If the receipt is not posted, the system removes the pay item record.

  5. If the receipt is posted, on Void/NSF Receipt, complete the Reason Code field and click OK.

    On Receipts Entry, the system marks the voided pay item with X and creates a new pay item for a reversing amount.

  6. On Receipts Entry, select another invoice to distribute the payment amount, or click OK to create an unapplied receipt for the amount of the voided pay item.

13.10 Designating Receipts as Insufficient Funds

This section provides an overview of insufficient funds designations, and discusses how to designate receipts as NSF.

13.10.1 Understanding Insufficient Funds Designations

When the payor's bank account does not have sufficient funds available to pay the invoices that they have specified, you can designate a receipt as insufficient funds and reopen the invoice or group of invoices. The steps to designate a receipt as insufficient are the same regardless of whether the receipt is posted or unposted. When you designate a receipt as insufficient funds, the system does this:

  • Indicates the insufficient fund status of the record in the F03B13 table. When you analyze payment trends of customers or tenants, this indication helps you to distinguish insufficient funds receipts from reversals for entry errors and so on.

    If the receipt is not posted when it is designated as insufficient funds, the system also marks the posted status of this record as D.

  • Restores the open amount of the invoice or group of invoices to which the receipt applied.

  • Changes the pay status of the invoices from paid (P) to approved (A).

  • Creates a new record in the Batch Control Records table (F0011), if the receipt is posted.

  • Creates a new record in the F03B14 table with a matching document type RV, if the receipt is posted.

    If the receipt is not posted when it is designated as insufficient funds, the system deletes the original record in the F03B14 table.

You must post the new batch to update the general ledger accounts with reversing information. When you post a receipt that is designated as insufficient funds, the system creates in the F0911 table a record with the document type RV.

13.10.2 Prerequisite

To include the bank's address and transit account, set up the necessary information in the Address Book system and on the Set Up G/L Bank Account form.

13.10.3 Forms Used to Design Receipts as Insufficient Funds

Form Name Form ID Navigation Usage
Work with Customer Receipts Inquiry W03B102A Manual Receipts Processing (G03B12), Standard Receipts Entry Locate a receipt to delete or void.
Confirm Delete W03B602D Select NSF from the Row menu on the Work with Customer Receipts Entry form. Designate a receipt as NSF.
Void/NSF Receipt W03B102C Click OK on the Confirm Delete form. Specify the G/L date and the reason for the NSF designation.

13.10.4 Designating Receipts as NSF

Access the Work with Customer Receipts Inquiry form.

To designate receipts as NSF:

  1. On Work with Customer Receipts Inquiry, select the receipt that you want to designate as NSF.

  2. From the Row menu, select NSF.

  3. On Confirm Delete, click OK.

  4. On Void/NSF Receipt, complete the G/L Date and Reason Code fields and click OK.