Receipt Wizard Application Double-CheckThe Wizard contains an ‘Override’ column which is used to identify whether the receipt application amount is for the full outstanding balance of the selected transaction (full application) or for an amount less than the outstanding balance of the selected transaction (partial application). This is a useful double-check to ensure the user is applying the correct amounts to the correct transactions.
This column must be set to ‘Yes’ for partial applications. It can be left blank or set to ‘No’ for full applications. An error will be returned to the sheet if the Wizard determines a partial application will be uploaded and the column value is not set to ‘Yes’.
The user can use standard Excel formulas or macros to populate this ‘Override’ column, if desired. The ‘Override’ column can be removed from the worksheet in version 2.8.77 and later. If it does not exist in the worksheet the Wizard assumes there is no need to double-check the application.
When the column does not exist in the worksheet this is the application behavior:
• If the application amount is less than or equal to the transaction balance, then the application will be uploaded to Oracle Receivables.
• If the application amount is greater than the transaction balance and the transaction’s Transaction Type ‘Allow Overapplication’ flag is set to ‘Yes’, then the application will be uploaded to Oracle Receivables and the transaction will be overapplied.
• If the application amount is greater than the transaction balance and the transaction’s Transaction Type ‘Allow Overapplication’ flag is set to ‘No’, then the application will fail and the API error message will be returned to the worksheet.
Refer to section:
|