All Possible Questions & Answers regarding Receivable Receipts Questions and Answers What are the MetaLink keywords I should use when searching for more information about the receipts workbench? How to unapply a receipt in a date different than the last open period? How can I turn on / activate automatic numbering (auto numbering) for manual receipts? Why can you enter duplicate receipt numbers? How do you write off small receipt balances? How do you apply a receipt to the same transaction twice? How to access the LOV for Category and Reason Code on the Reverse Receipts window? How to resolve '* This receipt is part of an unposted quick cash batch'? How do you apply payments to unrelated customers' invoices? What do you do with invoices that have credit balances? How are count and amount totals are populated in Receipt Batch Window with Reversals? I applied a receipt to the wrong customer account. How to correct this? What is the difference between a reversed receipt and a debit memo reversal? How do you refund an overpaid (on account) receipt? How do you refund a receipt for returned goods? How do you delete receipts and applications from interim tables? How can you prorate a receipt amount between tax and line items? How do you clear a Note Receivable? How do you change a GL bank account for a Remittance Bank Account? How do you create a manual miscellaneous receipt? When a receipt is reversed, where does the reversal of the On Account line go? Why is the field "Includes Tax" at the adjustment receipt level not updateable? How is the ar_payment_schedules.due_date field derived for receipts? What is the maturity date for receipts in Oracle Receivables? What is the difference between on-account and unapplied receipts? What to do when a customer pays less, because they expect a credit? How to apply this negative on-account cash? What to do when the "Receipt Summary" form is incorrectly sorted? Why does LOV in Receipts Workbench show inactive customers? What does message "Do you want to cancel claims on this receipt?" mean? What is receipt API? How to get a debug log file from the receipt API? Where to get an explanation of accounting entries concerning receipts? How to get a FND debug log file for Receipt form error ? How to issue a refund to Customer's credit card? How to perform Receipt to Receipt applications? How to perform Receipt Line Level application? How to process a payment for a credit memo in AR? How can you change the type of the receipt from cash to misc once it is entered and saved? What date does AR use to calculate earned discounts? Why does the receipt summary form not show the transaction numbers? How to confirm automatic receipts at batch level? How to setup an AR responsibility with disabled "Reverse...1" button in the receipts form? Why do on-account receipts have "wrong" count on batch header window? What is the meaning of exchange gain/loss? Why does post quick cash not over apply receipts?
How to change a distribution set in a misc receipt? How to group all of receipts into a API receipt batch? How do you change the GL date default for receipts? Why does payment method LOV not having any values when entering receipt batch? Why does receipt write-off report complete with no data found? Is there a limit to the number of times one can format a remittance batch? How do you reverse receipts in a different period? When creating a receipt, why can I not see a particular bank account in the LOV for payment methods? How come all the other bank accounts can be seen in the LOV when they have not got a Receipt Class/Payment method setup?
Applies to:
Oracle Receivables - Version: 10.7 to 12.0.0 - Release: 10.7 to 12.0 Information in this document applies to any platform. ARXRWMAI - Receipts ARZACAR_RECEIPTS - Automatic Receipts ARZCAR_REMIT - Automatic Remittance *** Checked for relevance on 29-Mar-2011 *** Purpose
This FAQ document identifies the most frequently reported How-To questions relating to the Oracle Receivables Receipts Workbench for Releases 10.7 to 12. Questions and Answers How to unapply a receipt in a date different than the last open period?
When you unapply a receipt application, Oracle Receivables assigns a reversal GL date to each application that you reopen. The reversal GL date defaults to the GL date of the original application if that period is still open. I f the original application's GL date is in a closed period, then the reversal GL date defaults to the current date. If the current date is not open, the default is the last date of the most recent open period. If you want the reversal GL date to be a different date, you can change it as follows: A. Navigate to Receipts>Receipts or Receipts>Batches. B. Query the receipt you want to unapply. C. Select the Applications button. D. Uncheck the 'Apply' box to unapply the receipt application. E. BEFORE YOU SAVE scroll to the right until you see the Reversal GL Date column. F. Change this date to any date in an open period that is on or after the original GL date for the receipt. G. Save your work. (After saving, the Reversal GL Date column becomes blank and it grayed out.) How can I turn on / activate automatic numbering (auto numbering) for manual receipts?
Oracle Receivables does not automatically number manual receipts. However, document sequencing can be activated for manual receipts. Document sequence numbers are unique numbers that can be assigned to receipts created in Receivables. Document sequencing is an optional feature within Receivables that can be activated using a profile option. This will generate the document number for a manual receipt, but the receipt number itself needs to be entered manually as the document sequence is not copied to the receipt number. The exception to this is that if you are using automatic receipts, you must use document sequencing to sequence the automatically generated receipts. References ---See the Oracle Receivables User Guide Release 11i, Chapter 2 - Setting Up, 'Implementing Document Sequences' for more information on this function. See the Oracle Receivables Implementation Guide Release 12, Chapter 2 - General Receivables Setup Tasks, 'Implementing Document Sequences' for more information on this function. Enhancement Request has been logged: bug 217777 YOU SHOULD BE ABLE TO AUTOMATICALLY NUMBER RECEIPTS AS WITH INVOICES
Why can you enter duplicate receipt numbers?
Duplicate receipt numbers is a functionality of Receivables. Many customers use their customer's check number as the receipt number and for this reason, unique receipt numbers are not required. Internally, a unique cash_receipt_id is assigned to each receipt as it is saved. However, a receipt is considered as 'duplicated' - if the receipt number, receipt date, amount, and customer are identical to another receipt. In this case you will receive an informative message to be confirmed when saving the receipt. How do you write off small receipt balances?
In Oracle Receivables version 11i, you can write off unapplied cash receipt balances. Receipt write-off functionality is provided to account for small overpayments that you do not intend to refund or maintain as unapplied amounts or on account balances. With this function, you can choose to write off an unapplied cash receipt amount, within certain limits. The write-off amount is credited to this account, such as a miscellaneous revenue account, and no longer reflects as an unapplied amount on the receipt or on the customer's account. You can write off individual unapplied receipt amounts during receipt application or later, at any time using the Applications window. You can also write off balances of multiple receipts with the 'Automatic Receipts Write-Off' Program. (Navigation: Control > Write-off Receipts)
For Release 11.0.3 please see Note 199769.1 for a possible workaround. References ---See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'Writing Off Unapplied Receipts' for more information on this function. How to setup Receipt Write Off can also be found in Note 203243.1 'Receipt Write-Off White Paper' and Note 184887.1. See the Oracle Receivables User Guide Release Release 12, Chapter 4 - Receipts, 'Writing Off Receipts' for more information on this function. How do you apply a receipt to the same transaction twice?
Oracle Receivables does not allow you to add a second line to a receipt for the same invoice or debit memo via Receipts workbench. However, you can change the original line applied to the invoice and increase the applied amount by the unapplied portion that you want to apply. In Rel 11.5.10,multiple applications to the same invoice are now allowed for lockbox and quickcash receipts for the purpose of managing deductions, integrating Trade management with AR. This functionality was added in lockbox and Quickcash receipts for the deductions project. How to access the LOV for Category and Reason Code on the Reverse Receipts window?
The Reverse Receipts window is a modal window. Oracle Applications 10.7NCA and R11.0 do not support icon toolbar access in modal windows. You can use Ctrl-L to access the LOV for these fields in either of these versions. In version 11i and 12, you can click on the LOV or use Ctrl L to access the LOV. How to resolve '* This receipt is part of an unposted quick cash batch'?
This message appears on the unposted items report and prevent you from closing your period. There are several reasons why this situation may occur, so first we need to determine if the records are duplicates or if they need to be processed. a) To process this Post Quick Cash Batch do the following Navigate to Receipts > Batches Query for Batch Type = Manual-Quick and the Batch Number listed on the Unposted Items Report If Button 'Post QuickCash' is enabled, you can simple post this QuickCash batch to make the receipts available for GL Transfer. b) If this is not the case, please log a service request with Oracle Support to investigate the issue further with the following information: - Unposted Items Report - Run the Receipt Batch Data Test from Note 311204.1 - Run the Receipt Data Test from Note 215969.1 for sample receipt(s) listed. References
---See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'QuickCash' for more information on this process. See the Oracle Receivables User Guide Release 12, Chapter 4 - Receipts, 'QuickCash' for more information on this process. How do you apply payments to unrelated customers' invoices?
The correct way to apply a receipt to more than one customer is to either establish a relationship between the customers or make sure the System Option - Allow Payment of Unrelated Transactions is checked. Once one or both of the conditions above are met, follow these procedures: A. Navigate to Receipts>Receipts or Receipts>Batches to enter a new receipt. B. Enter the receipt number, amount, payment method, and customer number of the first customer you want to apply the invoice too. You must enter a customer number on this screen in order to make the Applications button available. C. Select the Applications button. D. Apply the receipt to the first customer's invoice. E. If you want to apply monies to another, different customer's invoice, then scroll to the right to find the Customer number field and change the number to the other customer's number. NOTE: If you will be processing many payments to related customers' invoices, you can drag the Customer number column and drop it close to the Apply to column, then save these changes in a folder. F. Then scroll back to the Apply To field and select the LOV. You should now see the other customer's open invoices and can make a selection from here. G. Save your changes. References ---See Note 207487.1 - Applying Receipt to Multiple Customers
What do you do with invoices that have credit balances?
Create a zero-dollar receipt and apply it to the invoice. This will give the zero-dollar receipt a positive balance that can be used to pay off other invoices. Example: Invoice A - $100 Receipt B - $120 Apply Receipt B to Invoice A and Invoice A will have a -$20 balance. To resolve, create Receipt C for $0. Apply Receipt C to Invoice A and Invoice
A will be closed. Then Receipt C will have a balance of $20 to be used for other invoices.
How are count and amount totals are populated in Receipt Batch Window with Reversals?
a. Actual Count and Amount will always show THE ACTUAL NUMBER AND AMOUNT of receipts entered, regardless of any reversals. b. Returned Count and Amount show the number and amount of receipts reversed for the reasons "Nonsufficient funds", or "Stop Payment", i.e. the CUSTOMER has backed out of the payment. c. Reversed Count and Amount show the number and amount of receipts reversed for the reason "Reverse Payment", i.e. the ENTRY CLERK has made a mistake and wants to back out the payment. d. Difference Count and Amount show the Control - (Actual - Reversed) totals. I applied a receipt to the wrong customer account. How to correct this?
The receipt can be reversed and a new receipt entered for the correct customer if the original receipt does not have any adjustments or chargebacks that have been posted to the general ledger. Otherwise, a debit memo reversal will have to be created. Or, if you have established a relationship between the customers or activated the System Option - Allow Payment of Unrelated Transactions, then you can unapply the application for the original customer and then apply an amount to the other customer on the existing receipt. References ---See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'Reversing Receipts' for more information on this function. See the Oracle Receivables User Guide Release 12, Chapter 4 - Receipts, 'Reversing Receipts' for more information on this function.
What is the difference between a reversed receipt and a debit memo reversal?
Receivables lets you reverse a receipt when a customer stops payment on a receipt or if a receipt is returned from the bank for insufficient funds. You can also reverse a receipt if you want to re-enter and reapply it in Receivables (although you can just unapply and reapply, rather than reverse if you prefer). You can reverse cash and miscellaneous receipts before or after they are posted to the General Ledger, and before or after they are applied. Receivables lets you create two types of reversals: 1. Standard Reversal With a standard reversal, Receivables creates reversing journal entries for your general ledger and reopens all of the debit and credit items that were closed with the original receipt. You can create a standard reversal for cash and miscellaneous receipts, as well as a transaction related to a chargeback as long as there is no activity against the
chargeback and the chargeback has not been posted to the general ledger. You also cannot process a standard reversal for any receipts that have adjustments or chargebacks that have been posted to the general ledger. For these exceptions, a debit memo reversal must be used. To reverse a receipt: A. Navigate to: Receipts>Receipts or Receipts>Batches (enter batch information, then press the Receipts button). B. Query the receipt to reverse. C. Select the Reverse button. D. Confirm or change the reversal date and reversal GL date. Oracle Receivables assigns the GL date and reversal GL date as the current date. If the current date is not in an open period, then it assigns both dates as the last date of the most recent open period. If the original GL date of the receipt is later than the current date, then Receivables uses the original GL date. You can change the reversal GL date and GL date to any date in an open period that is on or after the original GL date for the receipt. E. Select the Category for this reversal. Valid categories are: Reverse Payment, Non-Sufficient Funds, and Stop Payment. F. Select a Reason for this reversal. G. Type a comment for the reversal, if desired. H. Select the Reverse button. I. Save your work. 2. Debit Memo Reversal Debit memo reversals are typically used when a standard payment reversal cannot be done. Debit memo reversals are required when you want to reverse a receipt that was previously applied to a chargeback and the chargeback has activity against it (such as another receipt, credit memo, or adjustment); or when chargebacks or adjustments have been posted to the General Ledger for the receipt you want to reverse. Receivables does not update any of the activity associated with the original receipt when you create a debit memo reversal. Instead it creates new receivable debit items for the items closed by the original receipt. You cannot process a debit memo reversal for a miscellaneous receipt. To create a debit memo reversal: A. Navigate to: Receipts>Receipts or Receipts>Batches (enter batch information, then press the Receipts button). B. Query the receipt to reverse. C. Select the Reverse button. D. Confirm or change the reversal date and reversal GL date. Oracle Receivables assigns the GL date and reversal GL date as the current date. If the current date is not in an open period, then it assigns both dates as the last date of the most recent open period. If the original GL date of the receipt is later than the current date, then Receivables uses the original GL date. You can change the reversal GL date and GL date to any date in an open period that is on or after the original GL date for the receipt.
E. Select the Category for this reversal. Valid categories are: Reverse Payment, Non-Sufficient Funds, and Stop Payment. F. Select a Reason for this reversal. G. Type a comment for the reversal, if desired. H. Check the Debit Memo Reversal box. I. Select a debit memo Transaction Type for this reversal. J. Select the Reverse button. K. Save your work. How do you refund an overpaid (on account) receipt?
If your customer has overpaid and you want to cut a refund check for the overage from on account, follow these procedures to clear the credit entry from Accounts Receivable and process a refund through Accounts Payable. Up to Rel 11i, you can perform the following. A. You need to get the on account balance applied to an invoice. When the receipt was applied, the following general ledger entries were made: Cash On Account -- ---100 | | 100 B. Create a debit memo for the amount of the on account credit you want to refund. Use a special Debit Memo transaction type that uses a clearing account rather than Revenue. This will cause the following general ledger entries to be made: Receivable Clearing --- 100 | | 100 C. Apply the on account amount to the new debit memo. This will cause the following general ledger entries to be made (leaves you with a Cash debit for $100 and a Clearing account credit for $100): Receivable On Account Cash --- ---- | 100 100 | 100 | 100 D. In Oracle Accounts Payable, process a check crediting $100 to cash and debiting the clearing account for $100 as below. This returns the cash and all other accounts to zero. Cash Clearing | 100 100 | For Rel 12, you can perform the following:
Navigation: Receipts –> Receipts Click Apply In the Application window, set Apply To= Refund Enter the Amount and other details. You can refund only positive amount and amound less than the Receipt balance. The button Refund Attributes will be enabled. Click on this button to view and update your refund attributes. Attribute values are defaulted from payee setup. You are allowed to overwrite the values. Attribute name and meaning: Customer Name : the customer receiving the refund. Default: customer name on the receipt. Customer Number: the customer receiving the refund. Refund Payment Method: refund method defined in Oracle Payments. Customer Address: address to send the refund to. Party Bank Account: bank account to deposit the refund to. Delivery Channel: determine how banks will actually process a payment. Pay Alone: when checkbox is selected, the refund will not be grouped with other refunds. Remittance Message 1,2,3: text fields that a user can enter in information Save it. Once you Save, an Invoice will be generated in the Payables (AP). Navigation: Receipts –> Receipts –> Applications Form : Refund Status button When you click on Refund Status button, you will view the refund status in AP. References -----------Oracle Receivables Users Guide Release 12, Chapter 5, Electronic Payment Processing -Creating Refunds How do you refund a receipt for returned goods?
If your customer is requesting a refund for goods returned, follow these procedures to clear the credit entry from Accounts Receivable and process a refund through Accounts Payable. This is a manual process between AR and AP. Up to Rel 11i, you can perform the following. A. Create a credit memo in AR for the returned goods. Use the same Revenue and Receivable accounts referenced on the original invoice. This will cause the following general ledger entries to be made: Receivable Revenue --- | 100 100 | B. Create a debit memo to offset the credit memo. Use a special Debit Memo transaction type that uses a clearing account rather than Revenue. This will cause the following general ledger entries to be made: Receivable Clearing --- -
100 | | 100 C. In Oracle Accounts Payable, process a check crediting $100 to cash and debiting the clearing account for $100 as below. This returns the cash and all other accounts to zero. Receivable Clearing --- | 100 100 | For Rel 12, you can perform the following: Create an On Account Credit Memo in AR. click Action -> Applications In the Application window, set Apply To= Refund Enter the Amount and other details. The button Refund Attributes will be enabled. Click on this button to view and update your refund attributes. Attribute values are defaulted from payee setup. You are allowed to overwrite the values. Attribute name and meaning: Customer Name : the customer receiving the refund. Default: customer name on the credit memo. Customer Number: the customer receiving the refund. Refund Payment Method: refund method defined in Oracle Payments. Customer Address: address to send the refund to. Party Bank Account: bank account to deposit the refund to. Delivery Channel: determine how banks will actually process a payment. Pay Alone: when checkbox is selected, the refund will not be grouped with other refunds. Remittance Message 1,2,3: text fields that a user can enter in information Save it. Once you Save, an Invoice will be generated in the Payables (AP). How do you delete receipts and applications from interim tables?
If a receipt came in through quickcash and was not purged from the interim table or it was missing from the batch and was entered manually, then you can delete the receipts and their application as follows: NOTE: If you are uncertain, please log a service request with Oracle Support for assistance. SELECT receipt_number, cash_receipt_id, gl_date FROM ar_interim_cash_receipts_all WHERE receipt_number = &receipt_number; Using the cash_receipt_id you can delete the data: DELETE FROM ar_interim_cash_receipts_all WHERE cash_receipt_id = &id;
DELETE FROM ar_interim_cash_rcpt_lines_all WHERE cash_receipt_id = &id; commit; How can you prorate a receipt amount between tax and line items?
Application Rule Sets determine the logic Receivables uses to apply partial payments to your customer's open debit items, as well as how discounts affect the open balance for each type of associated charges. You can set up different application rule sets for each transaction type. You can also assign a default application rule set in the System Options. Receivables provides the following seeded Application Rule Sets: - Line first / tax after - Line first / tax prorate - Prorate all - Over application rule References ---See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'Receivables Application Rule Sets' and Chapter 2 - Setting Up, 'Application Rule Sets' for more information. See the Oracle Receivables User Guide Release 12, Chapter 4 - Receipts, 'Receivables Application Rule Sets' and Oracle Receivables Implementation Guide Release 12, Chapter 6 - Receipts, 'Application Rule Sets' for more information. How do you clear a Note Receivable?
This is done in Oracle Cash Management for Note Receivables when the receipt class is set with a clearance method of "By Matching". To clear automatically, you need to setup your receipt class with a clearance method equal to "By Automatic Clearing".
How do you change a GL bank account for a Remittance Bank Account?
Once the setup is saved, the Remittance Bank Account window will not allow any changes to the GL accounts. You will need to end-date the remittance bank account and end-date the payment method and define a new one with the correct GL accounts. References ---See the Oracle Receivables User Guide Release 11i, Chapter 2 - Setting Up, 'Payment Methods' for more information on this process. See the Oracle Receivables Implementation Guide Release 12, Chapter 6 - Receipts, 'Receipt Methods' for more information on this process.
How do you create a manual miscellaneous receipt?
Navigate to Receipts>Receipts or Receipts>Batches (and enter batch information if applicable). Select Receipt Type = Misc from the dropdown and then enter your receipt information. References ---See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'Entering Miscellaneous Receipts' for more information on this process. See the Oracle Receivables User Guide Release 12, Chapter 4 - Receipts, 'Entering Miscellaneous Receipts' for more information on this process. When a receipt is reversed, where does the reversal of the On Account line go?
If a receipt that has a partial amount placed on account is reversed, the on account portion of the receipt is also reversed. Why is the field "Includes Tax" at the adjustment receipt level not updateable?
Navigation: Receipts>Receipts>(Query receipt)>Applications button>Adjustments button "Includes Tax" defaults in based on how you define your Adjustment Activity. The Tax Code source you specify determines whether Receivables calculates and accounts for tax on adjustments. References ---See the Oracle Receivable User Guide Release 11i, Chapter 2- Setting Up, 'Receivables Activities' for more information. See the Oracle Receivables Implementation Guide Release 12, Chapter 6 - Receipts, 'Receivables Activities' for more information on this process. How is the ar_payment_schedules.due_date field derived for receipts?
The value stored in ar_payment_schedules.due_date for a receipt is the maturity date in the receipts form under the remittance region. It initially defaults to the receipt date. If the receipt date is changed to a later date, you are requested to enter a maturity date that falls after the receipt's date. What is the maturity date for receipts in Oracle Receivables?
The maturity date in Oracle Receivables is a date that determines when funds for an automatic receipt can be transferred from your customer's bank account to your bank account. The maturity date cannot be before the receipt date. What is the difference between on-account and unapplied receipts?
Unapplied Receipt: This receipt is not applied to an existing invoice when it is entered. When the customer does not want to apply the entered receipt they can leave it as unapplied and apply the amount on a later date. On-Account: In case of an On-Account receipt, there is no identified invoice against the receipt. Advance money is received from the customer and the invoice for the same can be raised at a later date. References ---Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts. See the Oracle Receivables Users Guide Release 12, Chapter 4 - Receipts What to do when a customer pays less, because they expect a credit? How to apply this negative onaccount cash?
Applications functionality does not allow creation of negative receipts. However, you can use Trade Management module to create and settle Claims. Receivables can be integrated with Trade Management for short-payments and over-payments. References ---See the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, 'Working with Claims'. See the Oracle Receivables Users Guide Release 12, Chapter 4 - Receipts, 'Working with Claims' What to do when the "Receipt Summary" form is incorrectly sorted?
Use the Folder functionality to sort. A. On the Tool bar click on the Folder Option -> New. This will lead you onto 'Create New Folder' window. Enter a name - Enter a Name for reference purpose. In Autoquery region--- Choose the radio button -- 'Always' Set the checkbox 'Open as Default' to 'Yes' Set the checkbox 'Public' to 'Yes' Click on OK B. Now again click on the Toolbar --> Folder -> Sort Data. This will lead to a popup window - 'Sort Data'. The window will have three columns: Receipt Number Type Receipt Date Checkbox 'Run Query' set to 'Yes' This means that you can have sorting based on these three columns only. Against each column we have an option to specify the type of order by. Please
select the appropriate order by clauses applicable in your case and then again on the toolbar, click on the Folder -> Save. C. Close the form and then Navigate again into window and verify the result. You would see that the data is displayed as per the order set above. The following windows in the Receipts Workbench are Folder windows. You can customize the appearance of these windows by selecting options from the Folder menu: •Applications •Lockbox Transmission Data •QuickCash •Receipt Batches Summary •Receipts Summary •Remittances Summary References ---See Note 183963.1 - How to Use Folders to Change the Layout of Summary Screens in Oracle Applications. Why does LOV in Receipts Workbench show inactive customers?
This behaviour is intended functionality. Inactive customers are displayed in the LOV in the Receipt workbench, because inactive customer may still have outstanding transactions. References ---See Note 211818.1 - How to Prevent a Customer from Displaying in the Receipts LOV.
What does message "Do you want to cancel claims on this receipt?" mean?
Receivables integrates with Oracle Marketing Online Trade Management to let you record, research, and resolve your customer's short payments and over payments on their receipts. These payment discrepancies are called claims. When there is a claim attached to a receipt then you will get this warning message. If you want to cancel the claim you can say ' Yes". If you say 'No', then the claims will not be canceled. If the claims cannot be canceled are not, or not complete, a message will tell you that the receipt may not be reversed until the claims have been completed. References ---Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, Applying Receipts and Working with Claims. Oracle Receivables User Guide release 12, Chapter 4 - Receipts, Applying Receipts and Working with Claims.
What is receipt API?
For information on Receipts API, please review: Note 1361075.1 Oracle Receivables: Receipts API Overview, Setup, Sample Scripts and Troubleshooting Note 1362066.1, Oracle Receivables: Receipts API Known Issues and Patches •
•
How to get a debug log file from the receipt API?
Please review Note 784317.1, How to Troubleshoot Receivables API Issues Where to get an explanation of accounting entries concerning receipts?
Please review the Oracle Receivables User Guide release 11i, Chapter 8 - Accounting for Receivables. Please review the Oracle Receivables User Guide release 12, Chapter 9 - Accounting for Receivables.
How to get a FND debug log file for Receipt form error ?
For 11.5.10 to Rel 12.x Please review << Note 433199.1>> - How to enable and retrieve debug log messages. For lower than 11.5.10, Please review Note 152164.1 - How To Create A Debug Log File In An AR Form
How to issue a refund to Customer's credit card?
Credit Card refund functionality exists only in 11i and Rel 12. Not prior to that. You can issue a refund to customer's credit card using Receivables only if the original receipt applied to the invoice is a Credit Card receipt. To issue a refund to Customer's Card, perform the following: Nav=>Receipts=>Receipts Query the receipt that needs to be refunded. Click Apply. In applications window, first unapply the receipt from the original invoice. Then, on a new line, set Apply To = Credit Card Refund Pick the refund activity. Save it. This will create a negative MISC receipt in Confirmed status automatically. When this MISC receipt is remitted using Automatic Remittance program, funds are issued back to Customer's Credit Card. References -----------Please see Oracle Receivables Users Guide Release 12, Chapter 5 - Electronic Payment Processing,
Credit Card Refunds Also review Note 1357967.1 Credit Card Payments, Refunds and Chargebacks: Overview and Setup for Oracle Receivables Release 12 - for additional information. How to perform Receipt to Receipt applications?
This feature is available in Rel 11i and Rel 12 only. To Manually Create Receipt To Receipt Applications. Nav=>Receipts=>Receipts Enter or query a receipt Click Apply Once in the Applications form, go to Tools and check the ‘Include Open Receipts’ checkbox Go to ‘Apply TO’ list of values: Open Receipts in the same currency of the original receipt should appear in the ‘Apply To’ List of Values Pick the receipt. Save. References ---------Oracle Receivables Users Guide Release 12, Chapter 4 - Receipts, Receipt-to-Receipt Applications Also, review Note 266290.1-How To Set Up Receipt To Receipt Applications
How to perform Receipt Line Level application?
This is a new feature available in Release 12 only. To perform Receipt line level application. Nav=>Receipts=>Receipts Enter or query the receipt you want to apply. Click Apply. In Applications window, select the invoice from the Apply-To Lov. Click 'Apply in Detail' This shows Detailed Applications window. Select the application level for the receipt: • Transaction Select this option to apply cash at a summary level. You can enter amounts by line type: Line, Tax, Freight, or Charges. If you enter a Line or Tax amount, then Receivables prorates the application across all transaction lines. • All Lines Select this option to apply cash to specific lines. You can select one or more transaction lines. Receivables enters the Amount Applied for this receipt and updates the Balance Due for this transaction, but you can change the amount applied. • Freight and Charges
Select this option to apply cash to freight and charges at the invoice level only. You can apply cash to freight and charges either before or after you apply cash to transaction lines. When you select this option, Receivables displays freight and charges on separate lines, if they exist. Group level application only if group attributes were imported into Receivables from a feeder system, such as Oracle Service Contracts. References: -----------Oracle Receivables Users Guide Release 12, Chapter 4 - Receipts, Applying Receipts in Detail. How to process a payment for a credit memo in AR?
Payments need to be processed through Accounts Payable. See also question 'How do you refund a receipt for returned goods'? How can you change the type of the receipt from cash to misc once it is entered and saved?
This is not possible as the field Type is not updatable once it is entered and saved. Cash type receipts store data in different tables than miscellaneous type receipts. That is why the 'Type' field on the Receipts form is protected as soon as the receipt is saved for the first time. What date does AR use to calculate earned discounts?
When determining the discount percent for earned discounts, Receivables uses the invoice date, discount grace days, and the apply date of the receipt to determine the discount percent for this payment term. References ---See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, Discounts. See the Oracle Receivables User Guide Release 12, Chapter 4 - Receipts, Discounts. Why does the receipt summary form not show the transaction numbers?
Functionally a receipt can be applied to one or more transactions. Hence the summary form cannot show transaction numbers.
How to confirm automatic receipts at batch level?
1. Go to Receipts Summary Form. 2. Query the receipt batch. 3. Use Edit, Select all to mark all records. 4. Push button confirm. References ----
See Note 185309.1.
How to setup an AR responsibility with disabled "Reverse...1" button in the receipts form?
You need to do the following to disable the reverse...1 button in the receipts form. Navigate to System administrator responsibility. Navigate to Security>Responsibility>define Then query on : Responsibility name: your responsibility name Application: Oracle Receivables In the menu exclusion tabbed region select the following function: Receipt Reversal : Standard Receipt Reversal: Debit Memo Then save your work. By doing the above , your receipt reversal button would be disabled in the receipts form. Why do on-account receipts have "wrong" count on batch header window?
When a part of one receipt is applied and part unapplied it is treated as one receipt with the count going to 'Applied' count. References ---See Note 207766.1 11i-AR-On-Account Receipts Are Showing Wrong Count On Batch Header Screens. What is the meaning of exchange gain/loss?
A realized gain or loss occurs when the exchange rate changes between the invoice date and the r eceipt date. References ---Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, Applying Cross Currency Receipts, Calculating the Foreign Currency Exchange Gain or Loss. Oracle Receivables User Guide release 12, Chapter 4 - Receipts, Applying Cross Currency Receipts, Why does post quick cash not overapply receipts?
You cannot overapply a receipt to an open debit item using AutoCash rules. However you can overapply receipt to an invoice (if the Allow overapplication option on the invoice transaction type is set to Yes and profile option AR: Allow Overapplication In Lockbox is set to Yes) if you are not using AutoCash rules. References ---Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, How AutoLockbox Applies Receipts, Overapplying Invoices.
Please check the Oracle Receivables User Guide release 12, Chapter 4 - Receipts, How AutoLockbox Applies Receipts, Overapplying Invoices. How to change a distribution set in a misc receipt?
When entering a Misc Receipt and selecting the receivable activity you are not able to select a specific distribution set. This is a non-updateable field. The values that you see are the ones that were setup in the setup>receipts>receivable activity. References ---Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, Entering Miscellaneous Receipts. Please check the Oracle Receivables User Guide release 12, Chapter 4 - Receipts, Entering Miscellaneous Receipts How to group all of receipts into a API receipt batch?
Since this API creates only one receipt at a time, there is currently no functionality to pass in the Receipt Batch Source value. Please see Enhancement Request Bug 3026454 Also, you can review how to use the various Receipt API scripts in Note 1361075.1, Oracle Receivables: Receipts API Overview, Setup, Sample Scripts and Troubleshooting
How do you change the GL date default for receipts?
Oracle Receivables defaults the current date for the receipt GL date as long as the date is in an open period. Otherwise, it will default to the last day of the most recent open period. There are no profile options available to stop the receipt's GL date from defaulting. However, the profile option 'AR: Application GL Date Default' will control the GL date default when you apply receipts. References ---See the Oracle Receivables User Guide Release 11i, Appendix B for more information on this profile option. See the Oracle Receivables Implementaion Guide Release 12, Appendix B f or more information on this profile option.
Why does payment method LOV not having any values when entering receipt batch?
Payment method associated with this batch source is probably end-dated.
Why does receipt write-off report complete with no data found?
Please check Note 176785.1 Receipt Write-Off Report Completes With No Data Found. Is there a limit to the number of times one can format a remittance batch?
There is no limit to the number of times you can format a remittance batch. References ---Oracle Receivables User Guide for Release 11i Chapter 6 - Receipts - Formatting Remittance Batches Oracle Receivables User Guide for Release 12 Chapter 4 - Receipts - Formatting Remittance Batches
How do you reverse receipts in a different period?
When you reverse a receipt, Oracle Receivables assigns the GL date and reversal GL date as the current date. If the current date is not in an open period, then it assigns both dates as the last date of the most recent open period. If the original GL date of the receipt is later than the current date, then uses the original GL date. You can change the reversal GL date and GL date to any date in an open period that is on or after the original GL date for the receipt. NOTE: If you want a transaction to be posted in a prior period, the period must be open. If the period is already closed and you do not want to open it, you will not be able to do this. Please be aware that reopening a period can lead to further unposted items. If you choose to go this route, please ensure that your data entry personnel do not enter any transactions into this period. References ---See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'Reversing Receipts' for more information on this function. See the Oracle Receivables User Guide Release 12, Chapter 4 - Receipts, 'Reversing Receipts' for more information on this function. When creating a receipt, why can I not see a particular bank account in the LOV for payment methods?
The Payment Method could have an End Date associated to the Bank Account. How come all the other bank accounts can be seen in the LOV when they have not got a Receipt Class/Payment method setup?
When you query back the receipt Class this only shows the first Payment Method assigned to the Receipt Class. You have to place your cursor on the Payment Method and arrow down to see all the other associated payment methods that will be listed in the LOV
