Processing Manual Receipts

This chapter provides an overview of receipts entry methods, the steps for processing manual receipts, dates and document types, type input codes for standard receipts entry or draft entry, and negative receipts, and discusses how to:

Click to jump to parent topicUnderstanding Receipts Entry Methods

Depending on the type of receipt, you can use either the Standard Receipts Entry (P03B102) or Speed Receipts Entry (P03B0001) program to enter receipts. If you enter unapplied or general ledger receipts you can use either program. To help determine which method you should use, consider the advantages and limitations of standard and speed receipts entry:

Standard Receipts Entry

You can:

You cannot:

Speed Receipts Entry

You can:

You cannot:

Click to jump to top of pageClick to jump to parent topicCommon Fields Used in This Chapter

Amount Unapplied

Displays the difference between the receipt amount entered in receipt header and the total payment amounts entered in the receipt detail. The system creates an unapplied receipt record for the amount that displays in this field.

Bank Account

Enter the bank account to which the receipt is applied. If you leave this field blank, the system uses the account set up for the AAI item RB, based on the company number that you enter.

Chargeback Amount

Enter the unpaid invoice amount for which you want to create a new invoice record to charge the customer.

CB CD (chargeback reason code)

Enter the code that identifies the reason that a chargeback was generated for an invoice during receipt entry. Typical chargeback reason codes are:

DA: Disputed amounts

DD: Unearned (disallowed) discount amount

Note. The system does not accept blank as a value, even if it is defined in the user defined code table.

Company

Enter the company number for which the receipt is applied.

Currency

Enter the currency code of the cash receipt. If you leave this field blank, the system uses the currency code that is assigned to the company.

Customer

Enter the address book number of the party paying the customer invoices, such as the parent company or attorney.

The system does not use the value entered in the Alternate Payor field from the customer record (F03012) as a default value for this field.

If you leave this field blank, the system uses the value from the Payor field.

Deduction Amount

Enter the amount of the deduction represented in the currency of the transaction from which the deduction was generated. For example, if the deduction was generated from Customer Ledger Inquiry, the transaction currency is the currency in which the invoice was entered. If the deduction was generated from a receipt or draft, the transaction currency is the currency in which the receipt or draft was entered.

The currency associated with this amount appears in the Transaction Currency Code field (TCRC).

DD CD (deduction reason code)

Enter the code that identifies the reason a customer did not fully pay an invoice. Typical deduction reason codes include:

DG: Damaged Goods

SS: Short Shipment

UD: Undefined Deduction

Discount Taken

Enter the amount by which an invoice is reduced if paid by a specific date. The discount taken does not have to be the same as the discount available.

If the discount is earned and the invoice is paid in full, the system completes this field with the amount of the discount available.

If the discount is not earned (the G/L date of the payment is after the discount due date), or the invoice is not paid in full, the system does not complete this field.

You can override the field to specify a different discount amount, including zero.

DS CD (discount reason code)

Enter the code that specifies the reason that a discount is given.

Exchange Rate

Displays the exchange rate that is based on the G/L date that you specify.

G/L Date

Enter the date to which the transaction will be posted. The system uses the receipt G/L date to retrieve the exchange rate for multicurrency transactions and to determine if the discount is earned.

G/L Offset

Enter the offset code that the system uses to retrieve the accounts receivable trade account. If you leave this field blank, the system assigns UC, unless you set a processing option to use the G/L class code from the customer record

Payment Amount

Enter the amount of the receipt expressed in the transaction (foreign) currency.

If the payment amount is greater than the open amount of the invoice, the system does not calculate chargeback, write-off, or deduction amounts until you override the payment amount to be less than the open invoice amount.

If you specify a payment amount that is greater than the open amount of the invoice, the system displays the overpayment as a negative open amount on the invoice.

Note. Depending on the processing option settings, the system might automatically write off the difference between the open amount of the invoice and the payment amount that you enter.

Payor

Enter the address book number of the party paying the customer invoices, such as the parent company or attorney.

The system does not use the value entered in the Alternate Payor field from the customer record (F03012) as a default value for this field.

Receipt Amount

Enter the actual amount of the receipt.

When you exit the Receipt Amount field, the system updates the Amount Unapplied field in the lower right-hand corner of the form.

Receipt Date

Enter the date on the check or the date that you enter the receipt into the system. The system copies the value you enter into each line of detail, but you can override the value. The receipt date is used for information and reporting purposes only.

If you leave this field blank, the system uses the G/L date.

Receipt Number

Enter a number to identify a receipt. You can set a processing option to have the system assign the receipt number using the Next Numbers program.

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

Remark

Enter a description of the transaction. The system copies the remark that you enter in the header area to the corresponding field in each line of detail, but you can change it.

T I (type input code)

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

These values can be used in the Standard Receipts Entry program (P03B102):

  • 10: Simple invoice match.

    If you enter 10, when you move the cursor out of this field, the system automatically completes the Payment Amount field with the amount of the invoice. If the invoice has an earned discount, the system also completes the Discount Taken field with the amount in the Discount Available field.

  • 11: Invoice match with auto chargeback for discount.

    If you enter 11, when you move the cursor out of this field, the system completes the Payment Amount field with the amount of the invoice and the Chargeback Amount field with the amount in the Discount Available field.

  • 15: Invoice match with write-off.

    If you enter 15, when you move the cursor out of this field the system automatically completes the Write-Off Amount field with the difference between the payment amount that you enter and the open amount of the invoice.

  • 16: Invoice match with chargeback.

    If you enter 16, when you move the cursor out of this field the system automatically completes the Chargeback Amount field with the difference between the payment amount that you enter and the open amount of the invoice.

  • 17: Invoice match with deduction.

    If you enter 17, when you move the cursor out of this field the system automatically completes the Deduction Amount field with the difference between the payment amount that you enter and the open amount of the invoice.

These values can be used in the Speed Receipts program (P03B0001):

  • 1: Unapplied receipt.

  • 2: Balance forward receipt.

  • 3: Logged receipt.

  • 4: G/L receipt.

Transaction Disc Avail (transaction discount available)

Enter the amount of the invoice pay item that is eligible to be subtracted from the gross amount when the transaction is paid. The system calculates discount amounts based on the payment term entered on the transaction.

Note. If the system calculates the discount, verify that it applies to the pay item specified. Usually, freight, sales tax, and labor charges that are included in the gross amount do not qualify for discounts.

Write-Off Amount

Enter the amount that the system subtracts from the open amount of the invoice and does not require the customer to pay.

WO CD (write-off reason code)

A code that identifies the reason that the write-off occurred. Typical reason codes are:

BD: Bad debt

DC: Damaged goods

MW: Minor amount write-off

TF: Tax or freight dispute

Click to jump to parent topicUnderstanding the Steps for Processing Manual Receipts

You use the standard three-tier processing steps to manage manual receipts:

This graphic illustrates the receipt entry process and the tables that the system updates:

Manual receipts process

Click to jump to parent topicUnderstanding Dates and Document Types

When you enter and process manual receipts, you must be familiar with how the system uses receipt dates and general ledger dates. You must also be familiar with the document types that the system assigns to invoice and receipt records.

Click to jump to top of pageClick to jump to parent topicReceipt Dates and General Ledger Dates

When you enter a receipt, you must enter both a receipt date and a general ledger date.

Receipt Date

The date you enter for the receipt date can be the date you entered the receipt into the system or the date on the customer's check. The system does not use the receipt date for any accounting purposes. The system maintains this date for information only.

General Ledger Date

The system uses the general ledger date for exchange rate calculations, to determine whether a discount is earned, and to update account information when you post the receipt. Because the system uses the general ledger date for so many reasons, you cannot change the general ledger date after you enter the receipt.

Click to jump to top of pageClick to jump to parent topicDocument Types

The system uses document types to identify invoice and receipt transactions. Because document types are part of the key data that the system uses to locate transactions, you should understand how the system assigns and uses document types.

Invoice Document Types

Invoice document types can be user-defined or system-defined (RR, for example). Invoice transactions can exist in the system autonomously-that is, they are not dependent upon the existence of other transactions. The system stores invoices in the Customer Ledger table (F03B11).

The system assigns the document type for all receipt transactions. Receipts cannot exist without a corresponding record in the F03B11 table. The document type that the system assigns to a receipt is the stored in the matching document type field (DCTM), unless the receipt generates an invoice record. Invoice records that are generated from the receipt programs include:

When you display open items for a customer, each pay item consists of an invoice document type. When you apply the receipt to the invoice, the system generates a receipt document for the invoice.

Common invoice document types include:

Document Type

Description

RI (Regular Invoice)

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

RM (Credit Memo)

Unless you modify the processing option in the Invoice Entry MBF Processing Options program (P03B0011), the system assigns RM to credit memos entered manually using Standard Invoice Entry or Speed Invoice Entry.

RR (Recurring Invoice)

The system assigns RR to all recurring invoices entered with frequency and number of payments.

RN (Manual Billing)

The system assigns RN to all invoices generated from manual billings in the JD Edwards EnterpriseOne Real Estate Management system.

RD (Recurring Billing)

The system assigns RD to all invoices generated from the recurring billings in the JD Edwards EnterpriseOne Real Estate Management system.

RH (Expense Participation)

The system assigns RH to all invoices generated from the expense participation billings in the JD Edwards EnterpriseOne Real Estate Management system.

RJ (Sales Overage)

The system assigns RJ to all invoices generated from the sales overage billings in the JD Edwards EnterpriseOne Real Estate Management system.

RL (Escalation)

The system assigns RL to all invoices generated from the escalation billings in the JD Edwards EnterpriseOne Real Estate Management system.

RT (A/R Fee & Interest)

The system assigns RT to all invoices generated from the fee and interest billings in the JD Edwards EnterpriseOne Real Estate Management system.

RB (Chargeback Invoice)

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

R5 (Deduction)

The system assigns R5 to invoice deduction records generated when the receipt is entered. The deduction indicates an unpaid amount that must be resolved.

R1 (Draft)

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

RF (Delinquency Fee)

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

NP (Partial NSF)

The system assigns NP to stand-alone invoice records that are generated for the NSF amount when you enter a partial NSF draft.

Receipt Document Types

When you apply the receipt to an invoice, the system creates these two records:

The system assigns receipt document types to the receipt detail record in table F03B14. Receipt document types include:

Document Type

Description

RC (receipt)

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

RO (void receipt)

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

RS (spread receipt)

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

RV (insufficient funds receipt)

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

RU (unapplied receipt)

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

RL (logged receipt)

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

RR (rounding record)

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

Click to jump to parent topicUnderstanding Type Input Codes for Standard Receipts Entry or Draft Entry

When you apply receipts or drafts to invoices, you use type input (TI) codes to automatically calculate amounts to apply for payments, discounts, write-offs, chargebacks, and deductions.

This table lists the types of input codes for standard receipts entry or draft entry and how you can use them to automatically calculate any necessary amounts.

Type Input Code

Calculations

10 (Simple Invoice Match)

  • Payment amount = current open amount − discount available

  • Discount taken = discount available

  • Write-off = optional

  • Chargeback = optional

  • Deduction = optional

11 (Invoice Match with Automatic Chargeback for Discount Amount)

  • Payment amount = current open amount − discount available

  • Discount taken = optional

  • Write-off = optional

  • Chargeback = discount available

  • Deduction = optional

15 (Invoice Match with Write-Off)

  • Amount applied = current amount − discount available

  • Discount taken = discount available

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

  • Chargeback = optional

  • Deduction = optional

16 (Invoice Match with Chargeback)

  • Amount applied = current open amount − discount available

  • Discount taken = discount available

  • Write-off = optional

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

  • Deduction = optional

17 (Invoice Match with Deduction)

  • Amount applied = current open amount − discount available

  • Discount taken = discount available

  • Write-off = optional

  • Chargeback = optional

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

These examples illustrate how you can use type input codes to enter receipts or drafts. For each example, the outstanding invoice amount is 1000.00, and the payment terms are 1/10, net 30.

Simple Invoice Match (Type Input 10)

You receive 990.00 for invoice 123 within the discount period.

TI Code

Amount Applied

Discount

Write-Off

Chargeback

Gross Amount

Document Number

Document Type

10

990.00

10.00

   

1000.00

123

RI

Using type input 10, the system applies 990.00 and allows the discount of 10.00.

Invoice Match with Automatic Chargeback for Discount Amount (Type Input 11)

You receive 990.00 for invoice 123 after the discount period has expired.

TI Code

Amount Applied

Discount

Write-Off

Chargeback

Gross Amount

Document Number

Document Type

11

990.00

   

10.00

1000.00

123

RI

Using type input 11, the system applies the 990.00 and creates a chargeback for 10.00.

Invoice Match with Write-Off (Type Input 15)

You receive 970.00 for invoice 123 within the discount period. You decide to create a write-off for the 20.00 instead of creating a chargeback invoice.

TI Code

Amount Applied

Discount

Write-Off

Chargeback

Gross Amount

Document Number

Document Type

15

970.00

10.00

20.00

 

1000.00

123

RI

Using type input 15, the system applies the 970.00, allows 10.00 for the discount, and creates a write-off for 20.00.

Invoice Match with Chargeback (Type Input 16)

You receive 600.00 for invoice 123 within the discount period.

TI Code

Amount Applied

Discount

Write-Off

Chargeback

Gross Amount

Document Number

Document Type

16

600.00

10.00

 

390.00

1000.00

123

RI

Using type input 16, the system applies the 600.00, allows 10.00 for the discount, and creates a chargeback for 390.00.

Invoice Match with Deduction (Type Input 17)

You receive 850.00 for invoice 123 within the discount period. You decide to create a deduction for the remaining amount of 140.00, which you will research and resolve at a later time.

TI Code

Amount Applied

Discount

Write-Off

Deduction

Gross Amount

Document Number

Document Type

17

850.00

10.00

 

140.00

1000.00

128

RI

Using type input 17, the system applies the 850.00, allows the discount of 10.00, and creates a deduction for 140.00.

Click to jump to top of pageClick to jump to parent topicUnderstanding Simple Invoice Match (TI Code 10)

You use type input code 10 when the receipt pays all or part of the invoice and you do not want to specify manual write-offs, chargebacks, or deductions. The system automatically takes any discount that is earned (the G/L date is on or before the discount due date). You indicate how much of the invoice the receipt pays in the Payment Amount field. If you leave this field blank, the system pays the entire open amount of the invoice, up to the receipt amount.

After you enter receipts and drafts, you must post them to the general ledger:

Click to jump to top of pageClick to jump to parent topicUnderstanding Invoice Match with Discount (TI Code 10)

When you apply a receipt or draft to an invoice or group of invoices, you can select whether to allow the discount. If the customer pays the invoice in full on or before the discount due date, the discount is earned and the system automatically populates the Discount Taken field with the amount of the discount. If the discount is not earned (the G/L date of the payment is after the discount due date), the system does not automatically populate the Discount Taken field, but you can override it and apply a discount amount manually. If you do not allow the discount, the system leaves the invoice open in the amount of the discount.

You can set processing options to allow the amount of the discount taken to be more than the discount available, or to allow the discount taken to be more than the applied (payment amount). For example, you might issue a credit to a customer in the form of a discount for a disputed item. You can also specify grace days to add to the discount due date.

After you enter receipts and drafts, you must post them.

When you post payments with earned discounts, in addition to the bank account (or drafts receivable account) and A/R trade account, the system updates a discount taken account. The system uses this hierarchy to locate the discount taken account:

  1. The system searches for AAI item RKDxxx, where xxx is the discount reason code that you entered for the company that you entered on the receipt.

  2. If the system does not locate this AAI, it uses RKDxxx for company 00000.

  3. If the system does not locate this AAI, it returns an error.

Click to jump to top of pageClick to jump to parent topicUnderstanding Invoice Match with Chargeback (TI Codes 11 and 16)

When applying a payment to an invoice, you might want to create a chargeback if the amount that you receive is less than the open amount for the invoice. For example, a customer might issue payment for an invoice, less the discount, even though the terms of the discount have expired, or they might refuse to pay freight charges.

You can use these type input codes for generating a chargeback invoice:

TI Code

Usage

11

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

16

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

When you enter a receipt with a chargeback, the system generates the records in these tables:

Table

Record Generated

F03B11

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

The chargeback invoice record has these characteristics:

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

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

  • It is expressed as a debit amount.

  • It has a batch type of either RB (if generated from a receipt application) or DB (if generated from a draft application).

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

The posted codes for the payment records in the F03B13 and F03B14 tables remain blank until the receipt or draft is posted.

F03B13

The payment record.

F03B14

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

Regardless of the type input code you use, if you specify a chargeback amount and reason code, the system creates a chargeback record.

After you enter receipts and drafts, you must post them. When you post payments with chargebacks, in addition to the bank account (or draft receivables account) and A/R trade account, the system might update a different A/R trade account for the chargeback amount, depending on whether you complete the Chargeback G/L Offset field on the payment record.

Click to jump to top of pageClick to jump to parent topicUnderstanding Invoice Match with Write-Off (TI Codes 10 and 15)

If the payment that you receive is not enough to pay the open amount of the invoice, or if you receive a small overpayment, you might want to write off the difference and close the invoice. For example, you might receive a payment from a customer that is slightly less than the invoice amount. To maintain a good relationship with the customer, you might select to write off the minor amount instead of creating a chargeback invoice for the difference or leaving the amount open.

These two options are available for performing write-offs:

Option

Usage

Automatic write-off

(TI Code 10)

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

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

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

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

Manual write-off

(TI Code 15)

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

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

Regardless of the type input code you use, if you specify a write-off amount and reason code, the system generates a write-off.

For the write-off to occur on amounts that exceed the invoice open amount, such as overpayments, you must override the transaction payment amount with the receipt or draft amount. Otherwise, the system generates an unapplied payment record for the amount. For example, if the payment amount is 100.00 and the invoice amount is 95.00, and you wish to write off the 5.00 automatically, you must change the payment amount in the detail area from 95.00 to 100.00. Otherwise, the system generates an unapplied payment record for 5.00.

After you enter receipts and drafts, you must post them. When you post payments with write-offs, in addition to crediting the bank account (or draft receivables account) and debiting the A/R trade account, the system updates a write-off account that you specify for the AAI item RAxx, where xx is the write-off reason code. You must set up an AAI for each write-off reason code that you use.

Click to jump to top of pageClick to jump to parent topicUnderstanding Invoice Match with Deduction (TI Code 17)

Entering receipts and drafts with deductions is a method of postponing a response to a short payment from the customer without delaying payment entry. You can enter the payment immediately while another person researches and resolves the deduction. Some common reasons that a customer might take a deduction are:

You specify that you want the system to calculate deductions by using type input code 17. If the amount applied to the invoice is less than the receipt amount, the system updates the Deduction Amount field for the difference automatically. The system also updates the deduction reason code with the default value that you specify in the processing options.

When you enter a receipt or draft with a deduction, the system generates documents in these tables:

Table

Document

F03B11

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

The deduction invoice record has these characteristics:

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

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

  • It is expressed as a debit amount.

  • It has a batch type of either RB (if generated from a receipt application) or DB (if generated from a draft application).

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

The posted codes for the payment records in the F03B13 and F03B14 tables remain blank until the receipt or draft is posted.

F03B13

The payment record.

F03B14

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

Regardless of the type input code that you use, if you specify a deduction amount and reason code, the system creates a deduction record.

After you enter receipts and drafts, you must post them. When you post payments with deductions, in addition to the bank account (or draft receivables account) and A/R trade account, the system debits the deduction suspense account that is set up for the AAI item RN. The system also creates records in the A/R Deduction Management table (F03B40). The deduction record enables you to research and resolve the reason for the deduction at a later time.

Note. If you need to change the deduction amount or void the payment after it is posted, you must first reverse or void the deduction record (F03B40) using the deduction application. You can, however, revise other non-deduction payment detail records.

See Also

Processing Deductions

Click to jump to top of pageClick to jump to parent topicUnderstanding Invoice Match Using Multiple Type Input Codes

You can enter a receipt or draft and apply it simultaneously to a group of invoices that require individual treatment. For example, if you have three invoices, you might allow the discount on one invoice, charge back the discount amount on another invoice, and create a write-off for the shipping cost on the last invoice.

When you apply a receipt or draft to invoices using multiple type input codes, you can address each invoice individually by using the type input codes in any combination.

Note. The system uses this criteria to determine the payment amount for each receipt detail line:

Receipt or Draft Amount

Open Invoice Amount

Type Input Code

Unapplied Amount

For example, if you neglect to complete the Receipt Amount or Draft Amount field, and you attempt to pay multiple invoices, the system attempts to compensate for the first payment amount you enter by populating the second detail line with a negative payment amount.

Click to jump to parent topicUnderstanding Negative Receipts

Circumstances might occur when you need to enter a negative receipt. For example, you need to record a credit card refund to a customer that is greater than the credit card payment. You can enter a negative receipt for the refund amount and offset it against a credit memo so that the general ledger accurately reflects the credit to the bank account and the debit to the A/R trade account. When you enter a negative receipt, the system generates a receipt detail record (F03B14) and updates the pay status of the credit memo to P to prevent it from being refunded again.

You can also enter negative receipts when you need to:

You use the Standard Receipts Entry program (P03B102) to enter negative receipts. You set a processing option to enable the entry of negative receipts.

Example: Credit Card Refund

A customer purchases goods or services from you with a credit card. An invoice is created for 90.00 for the purchased items. The credit card company deposits funds directly into the bank account for the customer's purchase. Meanwhile, a refund in the amount of 150.00 is issued by the credit card company for returned items previously paid for by the customer. The refund amount is greater than the credit card payment (90.00) from the customer, which results in a negative amount of 60.00. To offset the negative amount, you need to create a receipt for -60.00 and apply it to a credit memo for the refund and to the invoice for which the customer paid.

The credit card company directly deposits and withdraws funds from the bank account.

To complete this scenario:

  1. Create an invoice (RI) for the customer in the amount of 90.00.

  2. Post the invoice to create these G/L entries:

  3. Create a credit memo (RM) for the refund amount of 150.00.

  4. Post the credit memo to create these G/L entries:

  5. Using the Standard Receipts Entry program, create a negative receipt in the amount of 60.00 and apply it against the credit memo (RM) for 150.00.

  6. Apply the remaining 90.00 to the customer's invoice (RI).

    When you complete the receipt, the system closes the credit memo and the open A/R invoice in the F03B11 table.

  7. Post the receipt to create these G/L entries:

Example: Negative G/L Adjustment

You process a customer's payment through a credit card company. The credit card company charges you a 3.5 percent fee to process the transaction. When you receive payment from the credit card company, you want to enter the processing fee directly to the general ledger and apply the full amount that the customer paid to the associated invoices.

For example, a customer paid the credit card company 9,647.05 for these invoices:

In addition to fully applying the customer's payment to the three invoices, you need to create a negative G/L receipt for the 3.5 percent credit card processing fee of 337.65. As a result, the system closes the invoices and creates an entry to the corresponding expense account in the general ledger.

To complete this scenario:

  1. Using the Standard Receipts Entry program, enter the receipt information specifying 9,309.40 as the receipt amount.

  2. Select the three invoices to be paid and apply the invoice amount as the payment amount to each invoice.

    A negative amount of 337.65 remains as unapplied.

  3. Select General Ledger from the Form menu.

  4. Specify the account to which you want to make the adjustment for the processing fee.

  5. Enter the negative amount of 337.65.

  6. Complete the entry.

    The system applies the full amount that the customer paid to the credit card company closing out the three invoices.

  7. Post the receipt to create these G/L entries:

Click to jump to parent topicEntering Standard Receipts

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

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

See Entering Manual Receipts for Argentina.

Click to jump to top of pageClick to jump to parent topicUnderstanding 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).

See Also

Processing Foreign and Alternate Currency Receipts

Reviewing Invoices

Click to jump to top of pageClick to jump to parent topicUnderstanding 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

Click to jump to top of pageClick to jump to parent topicUnderstanding 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).

See Also

Entering Unapplied Receipts (TI Code 1)

Click to jump to top of pageClick to jump to parent topicPrerequisite

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.

Click to jump to top of pageClick to jump to parent topicForms Used to Enter Standard Receipts

Form Name

FormID

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.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Standard Receipts Entry (P03B102)

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

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.

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 to use for receipt detail records. Values are:

Blank: Use the invoice remark.

1: Use the receipt header 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.

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

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 Invoicesis 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.

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.

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.

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.

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.

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.

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.

Click to jump to top of pageClick to jump to parent topicEntering Unapplied Receipts

Access the 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.

Click to jump to parent topicLocating Open Invoices

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

Click to jump to top of pageClick to jump to parent topicUnderstanding 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:

See Also

Applying an Unapplied Receipt to Invoices

Accepting Drafts

Researching and Resolving Deductions

Click to jump to top of pageClick to jump to parent topicPrerequisite

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.

Click to jump to top of pageClick to jump to parent topicForms Used to Locate Open Invoices

Form Name

FormID

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

Select 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.

Click to jump to top of pageClick to jump to parent topicLoading 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. This task is illustrated using the Receipt Entry form only.

Access the Receipt Entry or Draft Entry form.

This example shows the Load Invoices 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 field 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.

Click to jump to top of pageClick to jump to parent topicSelect 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.

Click to jump to top of pageClick to jump to parent topicSelecting 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:

  7. If you need 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.

Click to jump to parent topicApplying 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:

Click to jump to top of pageClick to jump to parent topicUnderstanding 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:

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.

Click to jump to top of pageClick to jump to parent topicUnderstanding 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:

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

See Also

Understanding Receipt Posting

Understanding Draft Approval and Posting

Click to jump to top of pageClick to jump to parent topicPrerequisites

Before you complete the tasks in this section:

Click to jump to top of pageClick to jump to parent topicForms Used to Apply Receipts or Drafts to Invoices Using Type Input Codes

Form Name

FormID

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.

Click to jump to top of pageClick to jump to parent topicApplying 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 need 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.

See Also

Understanding Receipt Posting

Understanding Draft Approval and Posting

Click to jump to top of pageClick to jump to parent topicApplying 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.

Click to jump to top of pageClick to jump to parent topicApplying 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.

Click to jump to parent topicWorking with G/L Receipts

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

See Also

Entering G/L Receipts (TI Code 4)

Click to jump to top of pageClick to jump to parent topicUnderstanding 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.

Click to jump to top of pageClick to jump to parent topicForms Used to Enter G/L Receipts

Form Name

FormID

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.

Click to jump to top of pageClick to jump to parent topicEntering 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 need 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.

Click to jump to top of pageClick to jump to parent topicCreating 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.

Click to jump to parent topicEntering Stand-Alone Records

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

See Also

Applying Receipts or Drafts to Invoices Using Type Input Codes

Processing Deductions

Click to jump to top of pageClick to jump to parent topicUnderstanding 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.

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.

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.

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:

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.

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.

Click to jump to top of pageClick to jump to parent topicPrerequisites

For stand-alone write-offs:

For stand-alone chargebacks:

For stand-alone deductions:

Click to jump to top of pageClick to jump to parent topicForms Used to Enter Stand-Alone Records

Form Name

FormID

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.

Click to jump to top of pageClick to jump to parent topicEntering Stand-Alone Transactions with Invoice Match

The task to create stand-alone write-offs with invoice match is the same regardless of whether you select the Standard Receipts Entry program (P03B102) 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.

To enter stand-alone transactions with invoice match:

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

  2. On Receipt Entry or Draft Entry, 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 appropriate value for each invoice.

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

    The system displays the Create Stand-alone Transaction form.

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

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

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

  8. Click OK.

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

  9. 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.

  10. Click OK.

    Chargeback G/L Offset

    Enter a code to specify the A/R trade account that you want the system to use when you post the chargeback. If you do not use a separate account to track the offset for chargebacks, you can leave this field blank.

Click to jump to top of pageClick to jump to parent topicEntering 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.

Click to jump to parent topicEntering Speed Receipts

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

Click to jump to top of pageClick to jump to parent topicUnderstanding 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:

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.

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.

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).

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.

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.

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.

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.

Click to jump to top of pageClick to jump to parent topicPrerequisite

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

Click to jump to top of pageClick to jump to parent topicForms Used to Enter Speed Receipts

Form Name

FormID

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.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Speed Receipts Entry (P03B0001)

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

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.

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.

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.

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)

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.

Discount

These processing options specify whether to enable all discounts or earned discounts only, as well as 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.

Click to jump to top of pageClick to jump to parent topicEntering 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.

Click to jump to top of pageClick to jump to parent topicEntering 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 need 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.

Click to jump to top of pageClick to jump to parent topicEntering 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.

Click to jump to top of pageClick to jump to parent topicAssigning 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.

Click to jump to top of pageClick to jump to parent topicEntering 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.

Click to jump to parent topicRevising Receipts

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

Click to jump to top of pageClick to jump to parent topicUnderstanding 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.

Unposted Receipts

You can revise these fields on an unposted receipt:

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.

Posted Receipts

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

You do not need to post the receipt again.

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

See Deleting and Voiding Receipt Information.

Logged Receipts

If you need 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.

Click to jump to top of pageClick to jump to parent topicForms Used to Revise Receipts

Form Name

FormID

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.

Click to jump to top of pageClick to jump to parent topicRevising 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.

Click to jump to parent topicApproving 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:

See Also

Posting Foreign and Alternate Currency Receipts

Click to jump to top of pageClick to jump to parent topicUnderstanding 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:

If no errors occur, the system:

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.

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:

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:

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:

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

Otherwise, the system creates detailed journal entries.

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

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:

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.

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.

Click to jump to top of pageClick to jump to parent topicUnderstanding 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

Company 00000

When the system creates automatic entries for receipts, it always assigns company 00000 to the document company field of the journal entry (KCO), regardless of the setting of the offset method in the constants. The system must assign company 00000 because of the one-to-many relationship inherent in the receipt entry process-that is, one receipt can pay many invoices from different companies. If the post did not use company 00000, it would have to create additional journal entries to accommodate each invoice document company.

Click to jump to top of pageClick to jump to parent topicForms Used to Approve and Post Receipts

Form Name

FormID

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.

Click to jump to top of pageClick to jump to parent topicRunning 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.

Click to jump to top of pageClick to jump to parent topicPosting 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.

Click to jump to parent topicDeleting and Voiding Receipt Information

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

Click to jump to top of pageClick to jump to parent topicUnderstanding 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:

Additionally, if you void a receipt, the system:

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.

Click to jump to top of pageClick to jump to parent topicPrerequisite

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

Click to jump to top of pageClick to jump to parent topicForms Used to Delete and Void Receipts

Form Name

FormID

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.

Click to jump to top of pageClick to jump to parent topicDeleting 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.

Click to jump to top of pageClick to jump to parent topicDeleting 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.

Click to jump to parent topicDesignating Receipts as Insufficient Funds

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

Click to jump to top of pageClick to jump to parent topicUnderstanding 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:

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.

Click to jump to top of pageClick to jump to parent topicPrerequisite

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.

Click to jump to top of pageClick to jump to parent topicForms Used to Design Receipts as Insufficient Funds

Form Name

FormID

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.

Click to jump to top of pageClick to jump to parent topicDesignating 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.