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:
Enter standard receipts.
Locate open invoices.
Apply receipts or drafts to invoices using input type codes.
Work with G/L receipts.
Enter stand-alone records.
Enter speed receipts.
Revise receipts.
Approve and post receipts.
Delete and void receipt information.
Designate receipts as insufficient funds.
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:
Use either the Load or Select feature to display open items for a customer.
Enter information directly from a customer's remittance slip.
Apply receipts to invoices that include discounts or write-offs.
Create chargebacks for discount amounts or short payments.
Create deductions for short payments.
Create stand-alone chargebacks, write-offs, and deductions.
Apply unapplied amounts to invoices.
Apply receipts that are logged through Speed Receipts Entry.
View the results of receipts entry.
Locate and revise receipts.
Delete unposted receipts and receipt pay items.
Void posted receipts and receipt pay items.
Designate receipts as insufficient funds (NSF).
Apply receipts in an alternate currency.
You cannot:
Enter receipts as quickly as you can using Speed Receipts Entry because you use multiple forms to access open items and enter receipt information.
Enter logged receipts.
Apply receipts using a balance-forward method.
Speed Receipts Entry
You can:
Use one form to enter multiple receipts.
Enter logged receipts.
Enter balance-forward receipts.
Create automatic write-offs.
You cannot:
Create chargebacks, manual write-offs, or deductions.
Preload open items.
Use this program as a stand-alone system.
Locate or revise receipts.
Delete or void receipts.
Designate receipts as NSF.
View the results of receipts application.
Use alternate currencies.
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):
These values can be used in the Speed Receipts program (P03B0001):
|
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 |
You use the standard three-tier processing steps to manage manual receipts:
Enter
Review
Post
This graphic illustrates the receipt entry process and the tables that the system updates:
Manual receipts process
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.
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.
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:
Unapplied receipts (RU)
Chargebacks (RB)
Deductions (R5)
Drafts (R1)
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:
A receipt header record that stores the amount of the receipt, the check number, receipt and general ledger dates, and so on. The system stores receipt header records in the Receipts Header table (F03B13).
A receipt detail record that stores the amount of the receipt that is applied to each invoice. The system stores receipt detail records in the Receipts Detail table (F03B14).
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. |
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) |
|
11 (Invoice Match with Automatic Chargeback for Discount Amount) |
|
15 (Invoice Match with Write-Off) |
|
16 (Invoice Match with Chargeback) |
|
17 (Invoice Match with Deduction) |
|
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.
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:
When you post receipt records, the system debits the bank account for the amount of the receipt and credits the A/R trade account that was used when the invoice was posted.
When you post draft records, the system debits the draft receivables account for the amount of the draft and credits the A/R trade account that was used when the invoice was posted.
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:
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.
If the system does not locate this AAI, it uses RKDxxx for company 00000.
If the system does not locate this AAI, it returns an error.
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:
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.
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.
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:
Damaged or defective merchandise.
Unearned discounts.
Billing errors.
Refusal to pay shipping charges or tax.
Shortages in the shipment of merchandise.
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:
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
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.
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:
Make a negative adjustment directly to the general ledger, such as a cash transfer.
Enter an outgoing wire transfer.
Record an NSF receipt as a general ledger receipt.
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:
Create an invoice (RI) for the customer in the amount of 90.00.
Post the invoice to create these G/L entries:
Debit of 90.00 to A/R trade.
Credit of 90.00 to store sales.
Create a credit memo (RM) for the refund amount of 150.00.
Post the credit memo to create these G/L entries:
Credit of 150.00 to A/R trade.
Debit of 150.00 to store sales.
The A/R trade account reflects a credit amount of 60.00.
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.
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.
Post the receipt to create these G/L entries:
Debit of 60.00 to the A/R trade.
This entry offsets the negative amount created by the credit memo.
Credit of 60.00 to the bank account.
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:
RI 3125 for 1,162.75
RI 3126 for 5,034.30
RI 3127 for 3,000
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:
Using the Standard Receipts Entry program, enter the receipt information specifying 9,309.40 as the receipt amount.
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.
Select General Ledger from the Form menu.
Specify the account to which you want to make the adjustment for the processing fee.
Enter the negative amount of 337.65.
Complete the entry.
The system applies the full amount that the customer paid to the credit card company closing out the three invoices.
Post the receipt to create these G/L entries:
Debit of 337.65 to an expense account for the credit card processing fee.
Debit of 9,309.40 to a bank account.
Credit of 9,647.05 to the A/R trade account reducing the customer's liability.
This section provides an overview of standard receipts, fields updated during receipt or draft entry, and unapplied receipts, and discusses how to:
Set processing options for Standard Receipts Entry (P03B102).
Enter unapplied receipts.
Country-specific functionality exists for entering standard receipts for Argentina.
See Entering Manual Receipts for Argentina.
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
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:
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:
|
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:
|
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:
|
Discount Taken |
Payment with a discount |
10 |
AIDD |
F03B14 |
The system uses this hierarchy, where xx is the discount reason code:
|
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:
|
Write-off |
Stand-alone write-off |
25 |
AIDW |
F03B14 |
The system uses this hierarchy, where xx is the write-off reason code:
|
Deduction Suspense |
Payment with a deduction |
17 |
DAID |
F03B14 |
The system uses this hierarchy:
|
Deduction Suspense |
Stand-alone deduction |
27 |
DAID |
F03B14 |
The system uses this hierarchy:
|
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 |
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:
|
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)
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.
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. |
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:
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:
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:
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:
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. |
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. |
Access the Receipt Entry form
To enter an unapplied receipt:
Complete the fields on the Receipt Entry form.
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.
On Additional Information, complete any other applicable fields and click OK.
Click OK.
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.
This section provides an overview of methods for displaying open invoices and discusses how to:
Load all open invoices for a customer.
Select specific open invoices for a customer.
Select open invoices by remittance.
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:
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:
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:
With the exception of statement number, the system uses the invoice reference to locate invoices from the F03B11 table. The system locates invoices using the statement number from the A/R Notification History Detail table (F03B21). |
Regardless of the method that you select to display open invoices, the system does not retrieve these types of invoices:
RU (Unapplied receipt)
R1 (Drafts)
R5 (Deductions)
NP (Partial NSF)
See Also
Applying an Unapplied Receipt to Invoices
Researching and Resolving Deductions
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.
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. |
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:
Follow the steps to enter an unapplied receipt or an unapplied draft.
On Receipt Entry or Draft Entry, select Load from the Form menu.
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.
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:
Follow the steps to enter an unapplied receipt or an unapplied draft.
On Receipt Entry or Draft Entry, select Select from the Form menu.
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.
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.
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.
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:
Follow the steps to enter an unapplied receipt or an unapplied draft.
On Receipt Entry or Draft Entry, select Remittance from the Form menu.
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.
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.
(Optional) Complete any of the T I and Override Type fields.
Click in the next detail line and review these fields that the system completes:
Items Found
Amount Open
Discount Available
Discount Earnable
Process Type
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.
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. |
This section provides an overview of unapplied receipts applied to invoices and credit memos applied to invoices, and discusses how to:
Apply a receipt or draft to invoices using input type codes.
Apply an unapplied receipt to invoices.
Apply a credit memo to an invoice.
After you enter an unapplied receipt or draft, you can apply it to the appropriate invoice or group of invoices using all of the available type input codes. To match an unapplied payment to invoices, you select the unapplied payment first and then display the open invoice records. You cannot use the Load or Select features to display unapplied payments along with the open invoices.
When you fully apply an unapplied payment to invoices, the system performs these functions for each invoice to which the payment was applied:
Creates a new batch record in the Batch Control Records table (F0011) for batch type RB (for receipts) or DB (for drafts), if the unapplied payment is posted when you apply it against invoices.
Closes the RU invoice document in the F03B11 table by updating the pay status to P.
Closes the RI invoice document in the F03B11 table by updating the pay status to P, if the invoice is fully paid.
Creates RC documents in the F03B14 table.
If you fully apply an unapplied payment to invoices before it is posted, the system deletes the RU record from the F03B11 and F03B14 tables.
Regardless of whether the unapplied payment is posted before you apply it to an invoice, you must post the payment after you apply it to invoices to update the appropriate accounts in the general ledger.
When the customer has outstanding credit memos, you can apply them to outstanding invoices using the Standard Receipts Entry program (P03B102) or one of the draft entry programs (P03B602). Because you do not have a physical payment, you enter zero in the Receipt Amount or Draft Amount field. You can use the Load, Select, or Remittance feature to display the credit memo and invoice, and then you use the appropriate type input code to apply the credit memo to the invoice. If the credit memo does not fully pay the invoice, you can leave the invoice open for the amount that remains, or create a write-off, chargeback, or deduction record for the difference.
When you fully apply a credit memo to an invoice, the system:
Closes the RM credit memo document in the F03B11 table by updating the pay status to P.
Closes the RI invoice document in the F03B11 table by updating the pay status to P, if the invoice is fully paid.
Creates a record in the F03B13 table for a zero amount.
Creates RS receipt documents in the F03B14 table for both the credit memo and the invoice.
After you apply credit memos to invoices, you must post the batch to update the general ledger.
See Also
Understanding Draft Approval and Posting
Before you complete the tasks in this section:
Verify that the appropriate accounts are specified for these AAI items:
RKD for discounts taken.
RCxxxx, where xxxx is the chargeback G/L offset code, for the chargeback A/R trade account.
RAxx, where xx is the write-off reason code.
RN, for the deduction suspense account.
Verify these UDC tables are set up to specify the reason codes:
00/DE for discount reason codes
03B/CB for chargeback reason codes
03B/RC for write-off reason codes
03B/CR for deduction reason codes
Verify the processing options are set up appropriately for discounts, chargebacks, write-offs, and deductions, or for the type input codes that you allow.
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. |
Access the Receipt Entry or Draft Entry form.
To apply a receipt or draft to invoices:
On Receipt Entry or Draft Entry, follow the steps to enter an unapplied receipt or an unapplied draft.
Follow the steps to display the open invoices for the customer.
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
If necessary, override the value in the Payment Amount, Remark, Discount Taken, Write-Off Amount, Chargeback Amount, and Deduction Amount fields.
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.
(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.
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.
Click OK.
See Also
Understanding Draft Approval and Posting
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:
On Receipt Entry, follow the steps to display the open invoices for the customer.
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.
In the detail area, complete the T I field with the appropriate code.
If necessary, override the value in the Payment Amount, Discount Taken, Remark, Write-Off Amount, Chargeback Amount, and Deduction Amount fields.
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.
Click OK.
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:
Follow the steps to enter an unapplied receipt or an unapplied draft, but leave the Receipt Amount or Draft Amount field blank.
On Receipt Entry or Draft Entry, follow the steps to display the open invoices for the customer.
To fully apply a credit memo to an invoice, enter 10 in the T I field next to the credit memo.
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.
Click OK.
This section provides an overview of G/L receipts and discusses how to:
Enter a G/L receipt.
Create an unapplied receipt from a G/L receipt.
See Also
Entering G/L Receipts (TI Code 4)
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.
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. |
Access the Receipt Entry form.
To enter G/L receipts:
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.
Select General Ledger from the Form menu.
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.
Click OK to return to the Receipt Entry form.
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.
On Receipt Entry, click OK.
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.
On Receipt Entry, select General Ledger from the Form menu.
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.
Click OK to return to the Receipt Entry form.
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.
This section provides an overview of stand-alone records and discusses how to:
Enter stand-alone transactions with invoice match.
Enter stand-alone transactions without invoice match.
See Also
Applying Receipts or Drafts to Invoices Using Type Input Codes
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:
5,000 to customer 3004
5,000 to customer 3333
5,000 to customer 3334
Using the stand-alone chargeback feature, you specify the customer and amount that you want to distribute. Enter the payment amount as a credit (negative amount). You repeat the process until the amount is fully distributed among the customers.
The system creates these records:
Table |
Document Type |
Gross Amount |
Customer Number |
Payment ID |
F03B13 |
N/A |
15,000 |
3001 |
521 |
F03B11 |
RB |
-5,000 |
3004 |
521 |
F03B11 |
RB |
-5,000 |
3333 |
521 |
F03B11 |
RB |
-5,000 |
3334 |
521 |
F03B14 |
RC Note. This is the matching document type (DCTM). |
-5,000 |
3004 |
521 |
F03B14 |
RC Note. This is the matching document type (DCTM). |
-5,000 |
3333 |
521 |
F03B14 |
RC Note. This is the matching document type (DCTM). |
-5,000 |
3334 |
521 |
The system uses the payment ID to provide an audit trail from the F03B11 and F03B14 records to the original F03B13 payment record.
Later, you must apply the negative chargeback invoices to invoices that you want to pay.
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.
For stand-alone write-offs:
Ensure that you set the maximum amount in the Manual Write-Off processing option high enough so that the system accepts entry.
Verify that the account that you want to use for the each write-off reason code is set up for the AAI item RAxx, where xx is the write-off reason code.
Verify that the processing option on the Edits tab is set up to allow write-offs.
Verify that the values that you want to use for the write-off reason code are set up in UDC 03B/RC.
For stand-alone chargebacks:
Verify that the chargeback A/R trade account is set up for the AAI item RCxxxx, where xxxx is the chargeback general ledger offset code.
Verify that the processing options on the Chargeback tab are set up.
Verify that the values that you want to use for the chargeback reason code are set up in UDC 03B/CB.
For stand-alone deductions:
Verify that the deduction suspense account is set up for the AAI item RN.
Verify that the values that you want to use for the deduction reason code are set up in UDC 03B/CR.
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. |
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:
Follow the steps to enter an unapplied receipt or an unapplied draft.
On Receipt Entry or Draft Entry, follow the steps to display the open invoices for the customer.
In the detail area, complete the T I field with the appropriate value for each invoice.
From the Form menu, select Stand-alone, and then select Write-Off, Chargeback, or Deduction.
The system displays the Create Stand-alone Transaction form.
For stand-alone write-offs, complete the Write-Off Amount and Write-Off Reason Code fields.
For stand-alone chargebacks, complete the Chargeback G/L Offset, Chargeback Amount, and Chargeback Reason Code fields.
For stand-alone deductions, complete the Deduction Amount and Deduction Reason Code fields.
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.
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.
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. |
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:
On Receipt Entry or Draft Entry, follow the steps to enter an unapplied receipt or an unapplied draft.
From the Form menu, select Stand-alone, and then select Write-Off, Chargeback or Deduction.
On Create Stand-alone Transaction, complete the Customer and Customer Reference fields.
For stand-alone write-offs, complete the Write-Off Amount and Write-Off Reason Code fields.
For stand-alone chargebacks, complete the Chargeback G/L Offset, Chargeback Amount, and Chargeback Reason Code fields.
For stand-alone deductions, complete the Deduction Amount and Deduction Reason Code fields.
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.
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.
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. |
This section provides an overview of speed receipts and discusses how to:
Set processing options for Speed Receipts Entry (P03B0001).
Enter unapplied receipts (TI code 1).
Enter balance forward receipts (TI code 2).
Enter logged receipts (TI code 3).
Assign logged receipts to customers.
Enter G/L receipts (TI code 4).
As an alternative to entering standard receipts, you can use the Speed Receipts Entry program (P03B0001) to quickly enter high-volume, simple receipts. When you use Speed Receipts Entry, you are not required to match receipts to invoices or even apply them to a specific customer's account. You can enter receipts with the minimum amount of information to speed the recognition of cash in the general ledger.
The system creates records in these tables when you enter speed receipts:
F03B13
F03B14
You cannot review or revise receipts using Speed Receipts Entry; you must use Standard Receipts Entry.
After you enter receipts using Speed Receipts Entry, you must post them to the general ledger to update the appropriate bank and A/R trade accounts.
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.
Before you enter logged receipts (TI code 3) set up AAI item RCLC (logged receipts) for the suspense account.
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. |
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:
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:
|
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. |
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:
On Speed Receipts Entry, complete the Company, Bank Account, Type Input, G/L Date, Receipt Date, and Remark (optional) fields in the header area.
Complete the Payor Address, Customer Address, Receipt Number, and Receipt Amount fields in the detail area.
In the detail area, override the value in the G/L Offset field if necessary.
Click OK.
Access the Speed Receipts Entry form.
To enter a balance forward receipt:
On Speed Receipts Entry, complete the Company, Bank Account, Type Input, G/L Date, Receipt Date, and Remark fields in the header area.
Complete the Payor Address, Customer Address, Receipt Number, and Receipt Amount fields in the detail area.
Complete the Bal Fwd Start Date (balance forward start date) field, the Document Number field, or both.
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. |
Access the Speed Receipts Entry form.
To enter a logged receipt:
On Speed Receipts Entry, complete the Company, Bank Account, Type Input, G/L Date, Receipt Date, and Remark fields in the header area.
Complete the Receipt Number and Receipt Amount fields in the detail area and then click OK.
Access the Receipts Entry form by selecting a logged receipt.
To assign a logged receipt to a customer:
On Receipt Entry, complete the Payor and Customer fields.
(Optional) Complete the G/L Date field.
If you know the invoices that you want to pay, you can display the open items and proceed with receipt matching.
Click OK.
Access the Speed Receipts Entry form.
To enter G/L receipts:
On Speed Receipts Entry, complete the Company, Bank Account, Type Input, G/L Date, Receipt Date, and Remark fields.
Complete the Receipt Number, Receipt Amount, and G/L Account Number fields in the detail area.
If you want to distribute the receipt to more than one G/L account, select Split Receipt from the Row menu.
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.
Click OK.
On Speed Receipts Entry, click OK.
This section provides an overview of receipt revisions and discusses how to revise unposted receipts.
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:
Bank Account
Remark
Receipt Amount
If you revise the receipt amount, you must also revise the payment amount information in the detail area.
Payment Instrument
Cleared Date
Unapplied G/L Offset
Receipt Reference
Lease
Building
Unit
Note. The Lease, Building, and Unit fields can be revised only on unapplied receipts, and only when you use the RE Receipts Entry program (P15103).
You can also change the payment amount or type input code, remove invoice pay items, or select other invoices to pay.
Posted Receipts
After you post a receipt, you can change the information in only these fields:
Remark
Payment Instrument
Cleared Date
Receipt Reference
You do not 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.
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.
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. |
Access the Receipt Entry form.
To revise an unposted receipt:
On Receipt Entry, revise the information in the Bank Account, Remark, or Receipt Amount fields.
To revise additional receipt information, select Additional Info from the Form menu.
On Additional Information, revise the information in the Payment Instrument, Cleared Date, Unapplied G/L Offset, Receipt Reference fields and click OK.
On Receipt Entry, revise the payment amount and type input codes of the invoices to pay.
To delete an invoice pay item, select the pay item and click Delete.
To add another invoice pay item, use either the Load or Select feature.
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.
Click OK.
This section provides an overview of receipt posting and the automatic entries created by the receipt post process, and discusses how to:
Run the post program to post receipts.
Post receipts from Receipts Journal Review.
See Also
Posting Foreign and Alternate Currency Receipts
After you enter receipts, you must approve them and then post them to the general ledger to update the appropriate account information. Depending on the organization's policy, management approval might be required before you can post receipt batches. The process to review and approve batches is the same regardless of the batch type.
Because the system creates all of the entries to the Account Ledger table (F0911) when you post receipts, balancing errors occur only when the post program is interrupted. If the post program is aborted before it completes, run the post program again to delete the entries that the system created, and then run the post program a third time to create new entries.
Note. The status of the receipt batch header remains "In Use" until you exit the Work With Customer Receipts Inquiry form.
During the post, the system:
Selects unposted receipt transactions from these tables:
F03B13
F03B14
Validates each transaction.
If no errors occur, the system:
Debits the appropriate bank account for the receipt amount, which creates bank deposit records in the F0911 table.
Creates automatic offsets (credits) to the A/R trade account in the F0911 table.
Creates automatic entries to the discount, write-off, chargeback, or deduction accounts, if applicable.
Updates balances in the Account Balances table (F0902).
Marks the transactions as posted (P) in the F0911 table.
Updates the F03B13 and F03B14 tables with a D in the Posted Code field.
Updates the status of the Batch Control Record table (F0011) to D.
You can also post receipts from the Work With Batches form that you access when you select the Receipts Journal Review or Real Estate Journal Review program (P0011), located on the same menu as the post program.
Note. The system creates unapplied receipt (RU), chargeback (RB), and deduction (R5) invoices with a posted status of D in the F03B11 table. To determine whether these records are posted, you must locate and verify the posted status of the receipt document from which they originated.
Journal Entries Created by the Receipt Post Process
When you post receipts to the general ledger, the system creates the account ledger record (F0911) differently, depending on the setting of the processing option for the journal entry creation method in the receipts entry program.
Regardless of the method that you use to create journal entries, the system updates these fields in the receipt detail record (F03B14) from the journal entry that the system creates:
RZDCTG (Document Type - JE)
RZDOCG (Document Number - JE)
RZKCOG (Document Company - JE)
Detail Method
If you set the processing option to create detailed journal entries, when you enter the receipt, the system updates the A/R Post Status (ISTR) field in the F03B13 table to 1. When you post receipts, the system:
Creates one document in the F0911 table for each receipt in the batch.
Assigns the journal entry for the bank account a document type of RC.
Assigns the document number from Next Numbers for system 09, line 2 (Journal Entry).
The system does not use the receipt number because the field lengths are not the same. The receipt number is a 25-character number, and the journal entry document number is an 8-character number.
Updates the record in the F03B14 table with the document number that is assigned to the journal entry for audit purposes.
Summary Method
If you set the processing option to create summarized journal entries, when you enter the receipt, the system does not update the A/R Post Status (ISTR) field in the F03B13 table. When you post receipts, the system:
Creates one document in the F0911 table for each batch of receipts posted.
Assigns the journal entry a document type of RK to the entry for the bank account.
Assigns the batch number as the document number.
For the system to create summarized journal entries, you must also verify:
The offset method in the Accounts Receivable Constants is set to a value of B (batch mode).
The intercompany settlement option in the general accounting constants is set to a value other than 2 or 3.
Otherwise, the system creates detailed journal entries.
Key to Method Used
This table shows the type of journal entry that the system creates according to the settings in the general accounting and accounts receivable constants.
Intercompany (G/A Constants) |
Offset Method (A/R Constants)* |
Journal Entry Creation Method (Summary or Detail) |
Journal Entry Created (F0911) |
1 (Hub) |
B |
D |
Detail |
1 |
Y |
D |
Detail |
1 |
S |
D |
Detail |
2 (Detail) |
B |
D |
Detail |
2 |
Y |
D |
Detail |
2 |
S |
D |
Detail |
3 (Configured Hub) |
B |
D |
Error (not allowed) |
3 |
Y |
D |
Detail |
3 |
S |
D |
Detail |
1 |
B |
S |
Summary |
1 |
Y |
S |
Detail |
1 |
S |
S |
Detail |
2 |
B |
S |
Summary |
2 |
Y |
S |
Detail |
2 |
S |
S |
Detail |
3 |
B |
S |
Error (not allowed) |
3 |
Y |
S |
Detail |
3 |
S |
S |
Detail |
* Offset Method
Y = One automatic entry offset per document, regardless of the number of line items
S = One automatic entry per pay item
B = One automatic entry per batch
Posting Voided and NSF Receipts
The system also creates different journal entries when you post a receipt that has been voided or designated as insufficient funds (NSF). Regardless of the processing option setting for the journal entry creation method, this occurs:
When you post a voided receipt, the system creates a journal entry with the document type RO.
When you post a receipt that is designated as NSF, the system creates a journal entry with the document type RV.
The system updates the DOCQ, DCTQ, and KCOQ fields in the F03B13 record with the document number and document type that the system assigns to the journal entry.
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.
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.
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. |
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.
Access the Work With Batches form.
Select the batch that you want to post and select Post by Batch from the Row menu.
This section provides an overview of receipt voids and deletions, and discusses how to:
Delete or void a receipt.
Delete or void an invoice pay item from a receipt.
When you cannot revise the information on a receipt, such as the payor or the general ledger date, you must delete or void the receipt. You follow the same steps to delete and void a receipt; if the receipt is unposted, the system removes all the receipt records, if the receipt is posted, the system creates new reversing records.
When you delete or void a receipt, the system:
Restores the open amount of the invoice or group of invoices to which the receipt applied.
Changes the pay status on the invoices from paid (P) to approved (A).
Additionally, if you void a receipt, the system:
Marks the receipt as voided in the F03B13 table.
Creates new records in the Batch Control Records table (F0011) and the F03B14 table.
You must post the new batch to update the general ledger accounts with reversing information. When you post a voided receipt, the system creates a record in the Account Ledger table (F0911) with the document type RO.
Verify that the values that you want to use for the Void/NSF reason codes are set up in UDC 03B/VR.
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 |
|
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. |
Access the Work with Customer Receipts Inquiry form.
To delete or void a receipt:
On Work with Customer Receipts Inquiry, select the receipt that you want to delete or void.
Select Delete from the tool bar or select Void/Delete from the Row menu.
On Confirm Delete, click OK.
If the receipt is not posted, the system removes the records.
If the receipt is posted, on Void/NSF Receipt, complete the G/L Date and Reason Code fields.
Click OK.
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.
On Work With Customer Receipts Inquiry, select the appropriate receipt and click Select.
On Receipts Entry, select the pay item that you want to delete or void.
From the Row menu, select Void/Delete.
On Confirm Delete, click OK.
If the receipt is not posted, the system removes the pay item record.
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.
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.
This section provides an overview of insufficient funds designations, and discusses how to designate receipts as NSF.
When the payor's bank account does not have sufficient funds available to pay the invoices that they have specified, you can designate a receipt as insufficient funds and reopen the invoice or group of invoices. The steps to designate a receipt as insufficient are the same regardless of whether the receipt is posted or unposted. When you designate a receipt as insufficient funds, the system does this:
Indicates the insufficient fund status of the record in the F03B13 table. When you analyze payment trends of customers or tenants, this indication helps you to distinguish insufficient funds receipts from reversals for entry errors and so on.
If the receipt is not posted at the time that it is designated as insufficient funds, the system also marks the posted status of this record as D.
Restores the open amount of the invoice or group of invoices to which the receipt applied.
Changes the pay status of the invoices from paid (P) to approved (A).
Creates a new record in the Batch Control Records table (F0011), if the receipt is posted.
Creates a new record in the F03B14 table with a matching document type RV, if the receipt is posted.
If the receipt is not posted when it is designated as insufficient funds, the system deletes the original record in the F03B14 table.
You must post the new batch to update the general ledger accounts with reversing information. When you post a receipt that is designated as insufficient funds, the system creates in the F0911 table a record with the document type RV.
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.
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. |
Access the Work with Customer Receipts Inquiry form.
To designate receipts as NSF:
On Work with Customer Receipts Inquiry, select the receipt that you want to designate as NSF.
From the Row menu, select NSF.
On Confirm Delete, click OK.
On Void/NSF Receipt, complete the G/L Date and Reason Code fields and click OK.