What is balance forward on a bank statement?

Use balance forward billing to consolidate the open transactions belonging to a customer account or customer site into a single bill that you send on a regular basis, instead of sending a separate invoice for each individual transaction.

Considerations for balance forward billing include:

  • Balance Forward Bill Details

  • Balance Forward Billing Cycles

  • Bill Consolidation at Account or Site Level

  • Balance Forward Billing Number

A balance forward bill contains:

  • Beginning balance or the balance carried over from the last billing period.

  • Itemized list of current charges and activities (such as invoices, credit memos, debit memos, adjustments) in either summary or detail format.

  • Payment received during the last billing period.

  • Current total outstanding balance.

Note: You can't update transactions that are included on a balance forward bill, regardless of the setting of the Allow Change to Printed Transactions Receivables system option. Receivables considers inclusion on a balance forward bill to be a transaction activity, and therefore you can't update a transaction once it has activity against it.

Use balance forward billing cycles to generate balance forward bills on a weekly, monthly, bimonthly, quarterly, yearly, or even daily basis.

To create a balance forward billing cycle:

  1. Navigate to the Manage Balance Forward Billing Cycles page.

  2. Click the Plus (+) icon to open the Create Balance Forward Billing Cycle window.

  3. In the Name field, enter a name that identifies this balance forward billing cycle.

  4. In the Start Date field, enter the date to generate the first balance forward bill. All subsequent balance forward bills in this billing cycle are determined by the date you enter here.

  5. In the Frequency field, select Monthly, Weekly, or Daily.

  6. If you select Monthly:

    1. In the Repeat Every field, enter a number to indicate the monthly gap between bills. For example, enter 1 to send a monthly bill; enter 3 to send a quarterly bill; enter 6 to send a biannual bill.

    2. In the Day of Month section, select the day of the month, or Last Day of Month, to send the bill. All applicable transactions with a billing date on or before the selected day of the month are included in the balance forward bill.

    3. Enable the Exclude Saturdays and Sundays option to exclude weekends from balance forward billing.

  7. If you select Weekly:

    1. In the Repeat Every field, enter a number to indicate the weekly gap between bills. For example, enter 1 to send a weekly bill; enter 4 to send a bill every four weeks (which isn't a monthly bill).

    2. In the Day of Week section, select the day of the week to send the weekly bill. All applicable transactions with a billing date on or before the selected day of the week are included in the balance forward bill.

  8. If you select Daily:

    1. In the Repeat Every field, enter a number to indicate the daily gap between bills. For example, enter 1 to send a bill every day; enter 7 to send a bill once a week.

      All applicable transactions with a billing date on or before the selected day are included in the balance forward bill.

    2. Enable the Exclude Saturdays and Sundays option to exclude weekends from balance forward billing.

You can generate bills consolidated at either the customer account or site level:

  • Account-level balance forward billing lets you generate one bill for each business unit of the customer account, addressed to the primary bill-to site of the account.

  • Site-level balance forward billing lets you generate a balance forward bill for each bill-to site of a customer account that has multiple bill-to sites.

    You can exclude a site from a balance forward bill by disabling balance forward billing on the customer profile of the site.

When you print a draft or final balance forward bill, the process generates a unique balance forward billing number and assigns this number to each transaction on the bill. You can use the balance forward billing number to:

  • Query transactions that are included in a balance forward bill.

  • Accept a final balance forward bill.

  • Optionally reprint a draft or final balance forward bill.

  • Apply payment against the transactions in a balance forward bill.

Page 2

Use the Create Balance Forward Bill process to generate balance forward bills. The steps in this topic illustrate how the Create Balance Forward Bill process selects transactions for inclusion on a balance forward bill.

You must select a billing cycle and a currency for a balance forward bill.

If you enter a billing date, the process includes on the bill only those transactions with a billing date on or before the date you enter.

If you change the billing cycle for a customer or group of customers, transactions entered after the change inherit the payment terms attached to the new billing cycle, but existing transactions retain the old payment terms. During the next submission of the Create Balance Forward Bill process, existing transactions with no activity against them inherit the new payment terms, billing date, and due date. Transactions with activity retain their existing payment terms, billing date, and due date.

Caution: If the balance forward bill contains transactions that retain the old payment terms, this may cause an aging discrepancy. This is because the transactions that don't inherit the new payment terms may have due dates different from the other transactions on the bill. If necessary, you can run the process for one set of payment terms only within the selected billing cycle.

The Create Balance Forward Bill process selects transactions for inclusion on a balance forward bill using this sequence:

  1. Determine the payment terms:

    1. Use the balance forward billing payment terms selected, if applicable.

    2. If no payment terms were selected, use all balance forward billing payment terms that match the selected billing cycle.

  2. Determine the customers:

    1. Use the customer or customers selected, if applicable.

    2. If no customers were selected, select all applicable customers. This includes:

      • Customers that have balance forward billing enabled.

      • Customers that have the selected payment terms at the account or site level.

      • Customers with a scheduled billing date earlier than or equal to the submission date.

      The process checks payment terms belonging to the account profile for customers enabled for account-level balance forward billing, and belonging to the site profile (or account profile if no payment terms are specified at a site) for customers enabled for site-level balance forward billing.

      Note: The Create Balance Forward Bill process doesn't select transactions from customers who are related either by customer or account relationships.

  3. Select transactions of the specified customers:

    • Include all transactions that have the selected payment terms.

    • Include all transactions that weren't included on a previous balance forward bill.

    • Exclude all transactions that have the Print Option set to Do Not Print.

  4. Validate transactions:

    • Verify the balance forward payment terms on the transaction.

    • Verify that the transaction billing date is equal to or earlier than the balance forward bill billing date.

      If the transaction has a billing date earlier than that of the balance forward bill, the process includes the transaction if it has no activity.

  5. Determine the opening balance of the balance forward bill:

    • Use the ending balance of the previous billing period as the opening balance of the new bill.

    • If this is the first time balance forward billing runs, the opening balance is zero.

  6. Calculate the ending balance of the balance forward bill. The calculation accounts for the previous balance, new transactions, and any activity that occurred during the billing cycle.

Note: The Create Balance Forward Bill process generates a bill even if no activity takes place within a billing cycle. Such a balance forward bill displays the previous balance, zero current activity, and ending balance.

Page 3

This example demonstrates how to create, update, and deliver a balance forward bill.

This example shows how to create a balance forward bill and then print the bill with a monthly billing cycle in draft mode. After reviewing the draft bill, you remove incorrect transactions and update the customer settings to allow new transactions to be selected, if applicable for the billing cycle.

You create a balance forward bill in draft mode, and print and review the contents of the bill. After reviewing the bill:

  • If the bill is correct and contains all of the intended transactions, you can either confirm the bill or print the bill in final mode.

  • If the bill is missing transactions or contains unintended transactions, reject the bill and update the transactions of the applicable customers.

  1. Run the Create Balance Forward Bill process.

  2. Complete the process parameters as shown in this table:

    Parameter

    Value

    Print Option

    Print draft balance forward bills

    Billing Cycle

    Monthly

    Print Output

    Yes

    Currency

    USD

  3. Review the draft balance forward bill.

  4. If the bill is correct, you can do either of the following:

    • Run the Create Balance Forward Bill process again using the Print Option of Print final balance forward bills.

    • Run the Confirm Balance Forward Bill process using the Confirm Option of Accept draft balance forward bills.

      You can print confirmed balance forward bills at a later time using the Print Balance Forward Bill process.

A draft balance forward bill may contain transactions that don't belong on the bill, or contain transactions that you expect to see on the bill. Along with the parameters you select for a run of the Create Balance Forward Bill process, the settings of the profile assigned to each customer determine which transactions are selected for inclusion on the bill.

These customer profile settings affect the creation of balance forward bills:

  • Bill Level:

    • Account: One balance forward bill is created for all customer sites that have balance forward billing enabled belonging to this customer account.

    • Site: A separate balance forward bill is created for each customer site that has balance forward billing enabled belonging to the customer account.

  • Payment Terms: The payment terms assigned to the customer profile must be balance forward billing payment terms. The balance forward bill includes all transactions assigned these payment terms.

  • Override Terms: This option determines whether transactions belonging to the customer or customer site can use payment terms other than the one assigned to the profile.

  1. Review the draft balance forward bill, and confirm the parameter values that you entered are correct.

  2. If the bill isn't correct, run the Confirm Balance Forward Bill process to reject the draft bill.

  3. Complete the process parameters as shown in this table:

    Parameter

    Value

    Confirm Option

    Reject draft balance forward bills

    Bill Number

    The number of the draft balance forward bill

  4. For each applicable customer account or customer site, confirm the profile settings for balance forward billing.

  5. If the Override Terms option on the customer profile is set to Yes, then you can remove transactions from the bill by assigning these transactions non-balance forward billing payment terms.

    These transactions are excluded from the next run of the balance forward bill. Instead an individual document is printed for each of these transactions.

  6. If you want to include additional transactions on the bill, you can update the customer accounts and sites that are enabled for balance forward billing.

    You must assign the same balance forward billing payments terms to these additional accounts and sites.

  7. After completing your updates, run the Create Balance Forward Bill process.

Page 4

Search and selection ranges and parameters in Receivables use alphanumeric character ordering to determine the order in which to consider names and numbers. The alphanumeric character ordering is: 1 - 9, followed by A - Z, followed by a - z.

When you enter an alphanumeric range, such as in report parameters, Receivables doesn't compare each number as a whole when determining the range of data to display, but instead compares only the first digit in each entered parameter value, and then the second digit, and so on.

For example, if the low and high values in a range are from 99 to 109, then Receivables perceives 99 as higher than 109, and can't successfully determine a range to use. To resolve this issue, submit your searches and print requests in separate batches. For example, if you're using low and high batch name values, then submit the report for batches 1-999, 1000-1999, and so on.

Page 5

Use the Print Receivables Transactions process to schedule print runs of transactions and balance forward bills according to the needs of your enterprise.

When you schedule a print run, this both marks each transaction, or each transaction in a balance forward bill, as printed and generates the printed document according to the template assigned to the transaction.

It isn't recommended to print transactions and balance forward bills directly from BI Publisher, because BI Publisher doesn't mark transactions as printed. If a printed transaction isn't marked as printed, then users can still make changes to the transaction.

You can use the View Print button on the Review Transaction and View Transaction pages to preview the printed version of the transaction. If you haven't printed the transaction, the preview displays the transaction according to the default template in BI Publisher. If you have printed the transaction, the preview displays the transaction using the last template that you used to print the transaction.

Page 6

Use Business Intelligence (BI) Publisher to manage the predefined print templates for printing Receivables transactions and balance forward bills.

There are eight print templates for each transaction class and for balance forward bills:

  • Invoice

  • Invoice Template With SPR (for Structured Payment Reference QR code)

  • Credit Memo

  • Debit Memo

  • Chargeback

  • Bills Receivable

  • Balance Forward Bill Summary

  • Balance Forward Bill Details

You can create your own versions of these print templates using the available editing features in BI Publisher. Recommendations for modifying a print template include:

  • Update the logo on the template to reflect your current organization logo.

  • Add or remove attributes to and from the template according to your requirements.

  • Set your template as the default template in BI Publisher.

There are two predefined data models:

  • Oracle Receivables - Header view and Line view

  • Oracle Receivables Balance Forward - Header view, Summary Billing Lines view, and Detail Billing Lines view

The data models provide the source data displayed on printed transactions. You can't modify the data models.

Page 7

Change the payment terms assigned to the customer profile to another balance forward billing payment terms. Future transactions inherit the new payment terms.

Page 8

Yes, you can generate a draft balance forward bill before the next available billing cycle end date.

When you run the Create Balance Forward Bills process, select the billing cycle and select Print draft future balance forward bills in the Generate Bill parameter. The generated balance forward bills include all transactions for all applicable customer accounts and sites up to the next billing cycle end date, including prior outstanding unbilled and future-dated transactions. The process maintains the due dates on the balance forward billing payment terms assigned to customer accounts and sites.

Use the draft future balance forward bill to review and confirm all transactions you expect to see in the next bill. You can make any necessary changes before sending the final bill to your customers.

Page 9

Create adjustments to increase or decrease the balance due on an invoice, debit memo, or chargeback. For example, after receipt application an invoice has an open balance of two dollars. You can create an adjustment for the remaining amount and close the debit item.

These settings affect the creation and update of adjustments:

  • Adjustment types: The adjustment type determines what part of the invoice is adjusted: Invoice (entire invoice amount); Line; Charges (late charges and penalties); Tax; Freight.

  • Receivables activity: The Receivables activity determines the transaction distribution account to use for the expense or revenue generated by the adjustment.

  • Natural Application and Overapplication rules: The settings for these rules on the transaction type determine whether an adjustment must make the balance due zero, or whether an overapplication is allowed. If the transaction type doesn't allow overapplication, you can't enter an amount that would reverse the sign of the balance of the debit item.

  • Approval limits: If the adjustment amount is within your approval limits for the currency of the item, the adjustment is approved and the customer balance updated. If the adjustment amount is outside your approval limits for the currency of the item, the adjustment is set to the status Pending Approval until someone with the appropriate approval limits either approves or rejects the adjustment.

  • Invoices with Unconfirmed Receipts profile option: You can adjust invoices selected for automatic receipt application if this profile option is set to Adjust or Adjust and Credit.

  • Override Adjustment Activity Account Allowed profile option: If this profile option is set to Yes, you can update the default transaction distribution account determined by the Receivables activity.

  • Adjustment Reason Required profile option: If this profile option is set to Yes, you must enter a reason for the adjustment.

The calculation for each adjustment type is as follows:

  • Invoice: Apply the adjusted amount to the entire invoice, or to the installment you're updating if the transaction has multiple installments.

    You must enter an amount large enough to close the item you're adjusting. If the Allow Overapplication option on the transaction type is set to Yes, you can enter an amount greater than the balance due.

  • Line: Apply the adjusted amount to the invoice lines. The adjusted amount is prorated across all lines. If the adjustment includes tax, the amount is prorated across lines and tax.

  • Charges: Apply the adjusted amount to the charges amount on the invoice. If the adjustment includes tax, the amount is prorated across charges and tax.

  • Tax: Apply the adjusted amount to the tax amount.

  • Freight: Apply the adjusted amount to the freight amount.

Page 10

Use the Create Automatic Billing Adjustments process to automatically adjust the remaining balances of all open invoices, debit memos, credit memos, and chargebacks.

When you run Create Automatic Billing Adjustments, the process:

  • Creates pending and approved adjustments based on your adjustment approval limits.

  • Closes the appropriate items.

You can run the process in preview mode to review the proposed adjustments before updating your open items.

Use the Create Automatic Billing Adjustments process parameters to manage the adjustment of specific sets of transactions, for example, by remaining amount, due date, transaction type, customer name, or customer account number.

If you enter a remaining amount or percentage range that exceeds your adjustment approval limits, the Create Automatic Billing Adjustments process creates these adjustments with a status of Pending Approval. You can refer these adjustments for approval to an approver with the appropriate limits.

If the remaining amount or percentage range is within your adjustment approval limits, the process automatically approves these adjustments.

Page 11

Adjustments to transactions that are pending approval require review and further action by a user with the necessary approval limits.

You can perform these actions on pending adjustments:

  • Approve an adjustment

  • Reject an adjustment

  • Reverse an adjustment

  • Request more information about an adjustment

  • Edit an adjustment

  • Withdraw an adjustment

Use the Approve Adjustments page or the Adjustments section of the Billing work area to review and update pending adjustments.

If an adjustment is in the Pending Approval status, you can approve, reject, or request information. If you approve or reject the adjustment, this updates the customer account balances accordingly. You can only post adjustments that have the status Approved or Rejected.

You can only reject an adjustment with the status Pending Approval.

Note: You can't approve a pending adjustment in either of these cases:

If you need to reverse an approved adjustment, for example, an adjustment approved in error, create a new adjustment with the same information and amount with the opposite sign to the previous adjustment amount.

You can't perform any further action on an adjustment with the status Rejected. If necessary, create a new adjustment to replace the rejected adjustment.

There are two actions that set an adjustment to the status More Research:

  • Use the Request Information action to request information about an adjustment before deciding whether to approve or reject.

  • Use the Withdraw action to withdraw an adjustment in the status Pending Approval that you previously submitted for approval.

You can edit all of the information in an adjustment record with the status More Research. This is the only status that allows edits to all fields.

Note: If you want to reject an adjustment in the More Research status, you must revert the adjustment to the Pending Approval status. Open the adjustment, and enter and submit the requested information. The adjustment reverts to the Pending Approval status and you can then reject the adjustment.

Page 12

If you're crediting a transaction that uses invoicing and revenue scheduling rules, you must select a revenue reversal rule.

The revenue reversal rule determines how to manage the reversal of revenue that was recognized when the credited transaction was created.

There are three revenue reversal rules:

  • LIFO (Last In First Out): This rule reverses revenue starting with the most recent accounting period, and then reverses revenue in all prior periods until the credit memo is finished.

  • Prorate: This rule reverses revenue by crediting an equal percentage to all account assignments for the transaction.

  • Unit: This rule reverses revenue on the number of units that you specify on a transaction line.

    If you select Unit, you must enter a last period to credit, a quantity to credit, and an adjusted unit price on each applicable line. You can't enter a credit quantity that is greater than the quantity on the target transaction line.

Page 13

If you're crediting a transaction that has multiple installments, you must select a split term method.

The split term method determines how to credit a transaction with multiple installments and specifies how the installments are credited.

There are three split term methods:

  • FIFO (First in First Out): This method reduces the remaining balance starting from the first installment.

  • LIFO (Last In First Out): This method reduces the remaining balance starting from the last, or most recent, installment.

  • Prorate: This method credits the installments and prorates them based on the amount remaining for each installment.

    This method uses the formula: Total Credit Amount * (Remaining Line Balance/Total Remaining Balance).

Page 14

Review and update the default sales credits assigned to each credit memo line.

You can review and update the default salespersons and the default sales credits assigned to each salesperson. If AutoAccounting depends on salesperson, you may need to rederive AutoAccounting during your updates.

If you're reviewing a credit memo against a specific invoice, Receivables derives the default sales credits from the sales credit lines of the original invoice. If you're reviewing an on-account credit memo, all sales credits are assigned to the primary salesperson.

You can perform these updates to default sales credits:

  • Update the revenue or non-revenue allocations to existing salespersons by percentage or amount.

  • Split the sales credit with one or more new salespersons. First update the sales credit percentage or amount for the primary salesperson, then add a row for each new salesperson and enter the salesperson name and percentage allocation.

  • Change the primary salesperson.

Caution: If the revenue of the credit memo was previously adjusted using the Manage Revenue Adjustments pages, don't adjust sales credits on the Credit Lines page. You must use the Manage Revenue Adjustments pages to make any sales credit adjustments.

If AutoAccounting depends on salesperson and you change the primary salesperson, Receivables asks if you want to rerun AutoAccounting for this credit memo line.

If you click Yes:

  • Receivables reruns AutoAccounting and updates the revenue accounts for this credit memo line.

  • If you have already posted the credit memo account assignments, the original accounting entries and sales credit record aren't updated. Instead Receivables creates new accounting entries and sales credit records to offset the original sales credit entries and to note the new ones.

  • If AutoAccounting is defined for tax, unbilled, unearned, and AutoInvoice clearing accounts to use sales credits, Receivables updates the classes associated with this credit memo line that are currently based on salesperson.

If you click No, Receivables doesn't run AutoAccounting, but does save your updates to sales credit information.

Page 15

Use the Manual Credit Memo Request Notification (FinArTrxnsCreditMemosCreationPostProcessing) to send email or in-application notifications to each designated approver.

The approver uses the notification window and the Review Credit Memo Request page to review the credit request details, review and update credit request information, and sign off on the review by clicking the Complete button and sending the review to the next approver.

The notification window for the manual credit memo request contains this information:

  • Customer account or site.

  • Request details, including the original transaction, rebill information, adjustments, and receipts.

  • Dispute details, including the dispute amount and dispute reason.

  • Approval history.

  • Link to the Review Credit Memo Request page.

The approver uses the Review Credit Memo Request page, available from the notification window, to review transaction and dispute information, update details of the credit request, and enter comments related to the review.

Use the Review Credit Memo Request page to perform these activities:

  • Review the credit request information.

  • Review the transaction dispute details and amounts, and the disputed transaction lines (if applicable).

  • Use the View Transaction Activities button to review transaction activities for the original transaction under dispute.

  • Use the Rebill Details section to review and update rebill information:

    • Rebill Number field: Enter one or more transaction numbers, separated by commas, to identify the transaction or transactions to rebill the customer in place of the original disputed transaction.

    • Rebill Group field: Select the product under which the rebill takes place.

  • View comments from the customer in the Customer field.

  • Enter approver comments in the Internal Comments field.

Use the Credit Memo Request Manual Entry Notification (FinArTrxnsCreditMemosManualEntryRequestForAction) with Oracle Business Intelligence Publisher to copy the predefined notification template and modify it according to your business requirements and policies.

You can make these modifications to the template:

  • Add new fields from the Manual Credit Memo Request data model.

  • Remove existing fields.

  • Update the look and feel: add images, change colors, change fonts and styling.

  • Update the template text.

The same template is used to generate both the email and in-application notifications for a particular workflow. The modifications you make to the predefined template are reflected in both email and in-application notifications.

Page 16

Review and update information related to transactions under dispute, and review Collections installment and case folder notes on transactions.

Use the Manage Disputes page to enter a customer dispute for all or part of the transaction amount. After you enter the details of the dispute, use the fields in the Dispute Summary section to record customer comments and your own internal comments.

To enter and manage a dispute:

  1. In the Billing work area, open the Manage Transactions page.

  2. Search for and select the transaction you want.

  3. In the Review Transaction page, select Submit a Dispute from the Actions menu to open the Manage Disputes page.

  4. In the Dispute Section field, select the section of the transaction to dispute.

  5. In the Dispute Reason field, select the reason for the dispute.

  6. In the Dispute Type field, optionally select a level to indicate the criticality of the dispute. Red is most critical and Ace is least critical.

    You can use the ORA_IEX_DISPUTE_TYPE_CODE lookup type to define your own codes to describe disputes.

  7. Optionally enable the Reverse applications and credit open balance option to initiate the Credit Memo Rebill process. Use this option to credit the entire amount of the original invoice for rebill purposes.

    The Credit Memo Rebill process reverses any receipts and adjustments against the original invoice and creates a credit memo for the entire invoice amount.

  8. In the Dispute Detail section, enter the values that the customer wants to dispute in the Quantity and Amount fields.

  9. In the Dispute Summary section, enter in the Customer Comments field any information from the customer related to the dispute.

  10. In the Internal Comments field, enter any information from your internal reviews related to the customer or to the dispute.

  11. Click the Submit button to submit the dispute to the credit memo approval process.

    The customer and internal comments are included for review in each node of the approval process. Approvers may add to these comments during the dispute review.

When you submit a dispute, the dispute process creates a note that contains the Credit Memo Request Number (Dispute Number), Dispute Amount, Credit Memo Reason, and your Internal Comments, and attaches this note to the transaction under dispute.

After credit memo approval, the customer comments related to the dispute are available for review in the credit memo created by the dispute.

In addition, during the collections process the Collections agent may enter notes related to transactions under dispute or to collections activity on specific transaction installments.

To review Collections notes on transactions:

  1. In the Billing work area, open the Manage Transactions page.

  2. Search for and select the transaction you want.

  3. In the Review Transaction page, select Review Installments from the Actions menu.

  4. In the Review Installments window, click the Notes icon on the installment you want.

  5. In the Installment tabbed region of the Notes window, review any installment notes in the Note Text column.

  6. Click the Case Folder tab.

  7. In the Case Folder tabbed region of the Notes window, review any case folder notes in the Note Text column.

To review comments related to transactions under dispute:

  1. In the Billing work area, open the Manage Transactions page.

  2. Search for and select the original invoice transaction under dispute.

  3. In the General Information section of the Review Transaction: Invoice page, click the Notes icon.

  4. In the Notes window, click the Transaction tab and review the dispute comments for the original invoice in the Note Text column.

  5. Close the original invoice transaction.

  6. In the Manage Transactions page, search for and select the credit memo created by the dispute for the original transaction.

  7. In the Review Transaction: Credit Memo page, click the Show More link.

  8. Click the Miscellaneous tab.

  9. Review the customer comments in the Comments field.

Page 17

If the credit memo approval process approves a dispute amount greater than the open balance on the invoice, you can set up the applied credit memo to automatically reverse existing receipt applications.

Use this procedure, for example, when an invoice was partially paid but the customer later disputes a portion of the original invoice amount greater than the current open balance.

The credit memo approval process performs these steps:

  1. Unapply one or more full or partial receipt amounts from the invoice to accommodate the approved credit memo amount.

  2. Create and apply the credit memo to close the invoice.

  3. Reapply the receipts and place any remaining receipt amount on-account for the customer.

This process doesn't reverse other activity against an invoice, including adjustments and credit memos. If reversing all available receipts and applying the approved credit memo still leaves a negative invoice balance, then the approval process ends in error.

Note: If the original dispute was created with the Reverse applications and credit open balance option enabled to initiate the Credit Memo Rebill process, then that process takes precedence and the unapplication of receipts process doesn't apply.

To set up credit memo approval to unapply receipts and apply the credit memo:

  1. Create a credit memo transaction source with these settings:

    • Type: Manual

    • Receipt Handling for Credits: On account

    Note: You can also assign these settings to the predefined transaction source Credit Memo.

  2. In the transaction source assigned to the invoice, select the credit memo transaction source you created, or the predefined transaction source Credit Memo, in the Credit Transaction Source field.

  3. In the transaction source assigned to the invoice, select the transaction type to use in the Standard Transaction Type field.

    Note: The transaction type you select must have the Natural Application Only option enabled. You can't use overapplication with credit memo approvals that require the unapplication of receipts.

You can use the receipt history to review a receipt's unapplication and reapplication on the invoice and the credit request details.

Page 18

When you credit a transaction and create a credit memo, this assigns a revenue and tax account to each credit memo line and generates corresponding default distribution amounts.

Use the Distributions window to review and update the account assignments for credit memo and tax lines.

If the transaction you're crediting has associated freight charges, you can also update credit memo freight distributions, unless the credit memo transaction type has Allow Freight set to No or you have specified a standard memo line of type Tax.

You can directly update account assignments that haven't posted. If you update an account assignment that has already posted, Receivables doesn't change the original assignment but instead creates two new account assignments:

  • The first assignment offsets the original posted account assignment.

  • The second assignment records the new amount or account that you have updated.

These settings and documents affect the calculation and display of credit memo distributions:

  • AutoAccounting: Account assignments differ depending on whether AutoAccounting depends on salesperson to determine the segment values.

  • Invoice Accounting Used for Credit Memos profile option: If this profile option is set to Yes, credit memo accounting is derived from the accounting of the invoice being credited.

  • Standard credit memo or on-account credit memo: On-account credit memos depend on AutoAccounting to derive account assignments. Standard credit memos depend on AutoAccounting and the setting of the Invoice Accounting Used for Credit Memos profile option.

  • Credit memo revenue reversal rule: This rule affects account assignments on standard credit memos with revenue scheduling rules.

AutoAccounting assigns a revenue and tax account to each credit memo line. The calculation of the default distribution amount allocated to each account assignment varies depending upon the related documents and settings.

If this is an on-account credit memo, the default amount is the credit memo line amount, where AutoAccounting for the revenue account doesn't depend on salesperson. If AutoAccounting does depend on salesperson, Receivables creates multiple account assignment lines, with one line for each salesperson equal to the amount of the salesperson line.

If this is a standard credit memo against a transaction, then the default amount depends on the setting of the Invoice Accounting Used for Credit Memos profile option:

  • If the Invoice Accounting Used for Credit Memos profile option is set to No, the default amount is calculated using AutoAccounting in the same manner as on-account credit memos.

  • If the Invoice Accounting Used for Credit Memos profile option is set to Yes, and the transaction doesn't use a revenue scheduling rule, the default amount is an amount from the corresponding invoice distribution line using the formula: Amount = (Credit Memo Line Amount/Invoice Line Amount) * Invoice Account Assignment Amount.

  • If the Invoice Accounting Used for Credit Memos profile option is set to Yes, and the transaction uses a revenue scheduling rule, the default amount is calculated according to the setting of the credit memo revenue reversal rule.

    Note: You must run Revenue Recognition before you can review and update distributions on credited transactions with revenue scheduling rules.

Page 19

These examples illustrate the accounting for full and partial credit memos against an invoice that uses the In Advance invoicing rule.

On 1/1/XX invoice 102 is created with these details:

  • Invoice Number = 102

  • Invoice Date = 1/1/XX

  • Invoice Amount = $100

  • Duration = 5 months

  • Invoicing Rule = In Advance

  • Revenue Scheduling Rule = Fixed Amount, with these details:

    • Period 1 = $20

    • Period 2 = $20

    • Period 3 = $10

    • Period 4 = $30

    • Period 5 = $20

This table shows the accounting entries for invoice 102 over the five accounting periods:

Account

Debit

Credit

Accounting Date

Period Status

Accounts Receivable

100.00

None

1/1/XX

Open

Unearned Revenue

20.00

None

1/1/XX

Open

Unearned Revenue

None

100.00

1/1/XX

Open

Revenue

None

20.00

1/1/XX

Open

Unearned Revenue

20.00

None

2/1/XX

Not Open

Revenue

None

20.00

2/1/XX

Not Open

Unearned Revenue

10.00

None

3/1/XX

Not Open

Revenue

None

10.00

3/1/XX

Not Open

Unearned Revenue

30.00

None

4/1/XX

Not Open

Revenue

None

30.00

4/1/XX

Not Open

Unearned Revenue

20.00

None

5/1/XX

Not Open

Revenue

None

20.00

5/1/XX

Not Open

The examples describe four separate scenarios:

  • Scenario 1: A full credit memo entered against the invoice.

  • Scenario 2: A partial credit memo entered against the invoice, with the revenue reversal rule set to Prorate.

  • Scenario 3: A partial credit memo entered against the invoice, with the revenue reversal rule set to LIFO.

  • Scenario 4: A partial credit memo entered against the invoice on 6/1/XX, with the revenue reversal rule set to UNIT.

A full credit memo is entered on 2/15/XX against invoice 102 with these details:

  • Credit memo date = 2/15/XX

  • Credit memo amount = $100

This table shows the reverse accounting entries after the credit memo is applied:

Account

Debit

Credit

Accounting Date

Period Status

Unearned Revenue

100.00

None

2/15/XX

Open

Revenue

20.00

None

2/15/XX

Open

Revenue

20.00

None

2/15/XX

Open

Accounts Receivable

None

100.00

2/15/XX

Open

Unearned Revenue

None

20.00

2/15/XX

Open

Unearned Revenue

None

20.00

2/15/XX

Open

Revenue

10.00

None

3/1/XX

Not Open

Unearned Revenue

None

10.00

3/1/XX

Not Open

Revenue

30.00

None

4/1/XX

Not Open

Unearned Revenue

None

30.00

4/1/XX

Not Open

Revenue

20.00

None

5/1/XX

Not Open

Unearned Revenue

None

20.00

5/1/XX

Not Open

A partial credit memo for $65 is entered on 2/15/XX against invoice 102. The details are:

  • Revenue reversal rule = Prorate

  • Credit memo date = 2/15/XX

  • Credit memo amount = $65

This table shows the partial reverse accounting entries after the credit memo is applied, with the computations used to derive the partial amounts:

Account

Debit

Credit

Accounting Date

Period Status

Unearned Revenue (65/100) * ($100)

65.00

None

2/15/XX

Open

Revenue (65/100) * ($20)

13.00

None

2/15/XX

Open

Revenue (65/100) * ($20)

13.00

None

2/15/XX

Open

Accounts Receivable

None

65.00

2/15/XX

Open

Unearned Revenue

None

13.00

2/15/XX

Open

Unearned Revenue

None

13.00

2/15/XX

Open

Revenue (65/100) * ($10)

6.50

None

3/1/XX

Open

Unearned Revenue

None

6.50

3/1/XX

Open

Revenue (65/100) * ($30)

19.50

None

4/1/XX

Not Open

Unearned Revenue

None

19.40

4/1/XX

Not Open

Revenue (65/100) * ($20)

13.00

None

5/1/XX

Not Open

Unearned Revenue

None

13.00

5/1/XX

Not Open

A partial credit memo for $65 is entered on 2/15/XX against invoice 102. The details are:

  • Revenue reversal rule = LIFO

  • Credit memo amount is fully applied by Period 2

  • Credit memo date = 2/15/XX

  • Credit memo amount = $65

This table shows the partial and full reverse accounting entries after the credit memo is applied:

Account

Debit

Credit

Accounting Date

Period Status

Revenue

5.00

None

2/15/XX

Open

Unearned Revenue

65.00

None

2/15/XX

Open

Unearned Revenue

None

5.00

2/15/XX

Open

Accounts Receivable

None

65.00

2/15/XX

Open

Revenue

10.00

None

2/15/XX

Open

Unearned Revenue

None

10.00

2/15/XX

Open

Revenue

30.00

None

3/1/XX

Not Open

Unearned Revenue

None

30.00

3/1/XX

Not Open

Revenue

20.00

None

4/1/XX

Not Open

Unearned Revenue

None

20.00

4/1/XX

Not Open

A partial credit memo for $65 is entered on 6/1/XX for 8 units against invoice 102, assuming that this invoice consists of 10 units with a value of $10 each for a total of $100. The details are:

  • Revenue reversal rule = UNIT

  • Credit memo date = 6/1/XX

  • Credit memo amount = $65

Receivables derives the Amount to Credit in each period by multiplying the Net Unit Price for each period by the number of units to credit (8 in this example). Receivables derives the Net Unit Price by the following formula:

Net Unit Price = (Invoice Amount in this period - any previous credit memos in this period) / Original invoice quantity

This table shows the Net Unit Price for each period:

Period

Calculation

Net Unit Price

Period 5

($20-$0)/10 units

$2

Period 4

($30-$0)/10 units

$3

Period 3

($10-$0)/10 units

$1

Period 2

($20-$0)/10 units

$2

Period 1

($20-$0)/10 units

$2

This table shows the Amount to Credit (Net Unit Price * Units to Credit) in each period as a result of the calculations of the net unit price in the previous table:

Period

Amount to Credit

Amount Credited (actual)

Period 5

$2 * 8 units

$16

Period 4

$3 * 8 units

$24

Period 3

$1 * 8 units

$8

Period 2

$2 * 8 units

$16

Period 1

$2 * 8 units

$1 (balance of credit memo)

This table shows the partial reverse accounting entries after the credit memo is applied:

Account

Debit

Credit

Accounting Date

Period Status

Unearned Revenue

65.00

None

1/1/XX

Open

Revenue

1.00

None

1/1/XX

Open

Accounts Receivable

None

65.00

1/1/XX

Open

Unearned Revenue

None

1.00

1/1/XX

Open

Revenue

16.00

None

2/1/XX

Open

Unearned Revenue

None

16.00

2/1/XX

Open

Revenue

8.00

None

3/1/XX

Open

Unearned Revenue

None

8.00

3/1/XX

Open

Revenue

24.00

None

4/1/XX

Open

Unearned Revenue

None

24.00

4/1/XX

Open

Revenue

16.00

None

5/1/XX

Open

Unearned Revenue

None

16.00

5/1/XX

Open

Page 20

These examples illustrate the accounting for full and partial credit memos against an invoice that uses the In Arrears invoicing rule.

On 1/1/XX invoice 103 is created with these details:

  • Invoice Number = 103

  • Invoice Date = 1/1/XX

  • Invoice Amount = $100

  • Duration = 5 months

  • Invoicing Rule = In Arrears

  • Revenue Scheduling Rule = Fixed Amount, with these details:

    • Period 1 = $20

    • Period 2 = $20

    • Period 3 = $10

    • Period 4 = $30

    • Period 5 = $20

This table shows the accounting entries for invoice 103 over the five accounting periods:

Account

Debit

Credit

Accounting Date

Period Status

Unbilled Receivable

20.00

None

1/1/XX

Open

Revenue

None

20.00

1/1/XX

Open

Unbilled Receivable

20.00

None

2/1/XX

Not Open

Revenue

None

20.00

2/1/XX

Not Open

Unbilled Receivable

10.00

None

3/1/XX

Not Open

Revenue

None

10.00

3/1/XX

Not Open

Unbilled Receivable

30.00

None

4/1/XX

Not Open

Revenue

None

30.00

4/1/XX

Not Open

Accounts Receivable

100.00

None

5/1/XX

Not Open

Unbilled Receivable

20.00

None

5/1/XX

Not Open

Unbilled Receivable

None

100.00

5/1/XX

Not Open

Revenue

None

20.00

5/1/XX

Not Open

The examples describe four separate scenarios:

  • Scenario 1: A full credit memo entered against the invoice.

  • Scenario 2: A partial credit memo entered against the invoice on 6/1/XX, with the revenue reversal rule set to Prorate.

  • Scenario 3: A partial credit memo entered against the invoice on 6/1/XX, with the revenue reversal rule set to LIFO.

  • Scenario 4: A partial credit memo entered against the invoice on 6/1/XX, with the revenue reversal rule set to UNIT.

A full credit memo is entered on 6/1/XX against invoice 103 with these details:

  • Credit memo date = 6/1/XX

  • Credit memo amount = $100

This table shows the reverse accounting entries after the credit memo is applied:

Account

Debit

Credit

Accounting Date

Period Status

No Entries

None

None

1/1/XX

Closed

No Entries

None

None

2/1/XX

Closed

No Entries

None

None

3/1/XX

Closed

Revenue (reverse Period 1 entry)

20.00

None

4/1/XX

Open

Revenue (reverse Period 2 entry)

20.00

None

4/1/XX

Open

Revenue (reverse Period 3 entry)

10.00

None

4/1/XX

Open

Revenue (reverse Period 4 entry)

30.00

None

4/1/XX

Open

Unbilled Receivable

None

20.00

4/1/XX

Open

Unbilled Receivable

None

20.00

4/1/XX

Open

Unbilled Receivable

None

10.00

4/1/XX

Open

Unbilled Receivable

None

30.00

4/1/XX

Open

Revenue (reverse Period 5 entry)

20.00

None

5/1/XX

Open

Unbilled Receivable

None

20.00

5/1/XX

Open

Unbilled Receivable (reverse original receivable)

100.00

None

6/1/XX

Open

Accounts Receivable

None

100.00

6/1/XX

Open

A partial credit memo for $65 is entered on 6/1/XX against invoice 103. The details are:

  • Revenue reversal rule = Prorate

  • Credit memo date = 6/1/XX

  • Credit memo amount = $65

This table shows the partial reverse accounting entries after the credit memo is applied, with the computations used to derive the partial amounts:

Account

Debit

Credit

Accounting Date

Period Status

No Entries

None

None

1/1/XX

Closed

No Entries

None

None

2/1/XX

Closed

No Entries

None

None

3/1/XX

Closed

Revenue (65/100) * ($20)

13.00

None

4/1/XX

Open

Revenue (65/100) * ($20)

13.00

None

4/1/XX

Open

Revenue (65/100) * ($10)

6.50

None

4/1/XX

Open

Revenue (65/100) * ($30)

19.50

None

4/1/XX

Open

Unbilled Receivable

None

13.00

4/1/XX

Open

Unbilled Receivable

None

13.00

4/1/XX

Open

Unbilled Receivable

None

6.50

4/1/XX

Open

Unbilled Receivable

None

19.50

4/1/XX

Open

Revenue (65/100) * ($20)

13.00

None

5/1/XX

Open

Unbilled Receivable

None

13.00

5/1/XX

Open

Unbilled Receivable

65.00

None

6/1/XX

Open

Accounts Receivable

None

65.00

6/1/XX

Open

A partial credit memo for $65 is entered on 6/1/XX against invoice 103. The details are:

  • Revenue reversal rule = LIFO

  • Credit memo date = 6/1/XX

  • Credit memo amount = $65

This table shows the partial and full reverse accounting entries after the credit memo is applied:

Account

Debit

Credit

Accounting Date

Period Status

No Entries

None

None

1/1/XX

Closed

No Entries

None

None

2/1/XX

Closed

No Entries

None

None

3/1/XX

Closed

Revenue

5.00

None

4/1/XX

Open

Revenue

10.00

None

4/1/XX

Open

Revenue

30.00

None

4/1/XX

Open

Unbilled Receivable

None

5.00

4/1/XX

Open

Unbilled Receivable

None

10.00

4/1/XX

Open

Unbilled Receivable

None

30.00

4/1/XX

Open

Revenue

20.00

None

5/1/XX

Open

Unbilled Receivable

None

20.00

5/1/XX

Open

Unbilled Receivable

30.00

None

6/1/XX

Open

Accounts Receivable

None

30.00

6/1/XX

Open

A partial credit memo for $40 is entered on 6/1/XX for 8 units against invoice 103, assuming that this invoice consists of 10 units with a value of $10 each for a total of $100. The details are:

  • Revenue reversal rule = UNIT

  • Last Period to Credit = last period of the invoice

  • Credit memo date = 6/1/XX

  • Credit memo amount = $40

Receivables derives the Amount to Credit in each period by multiplying the Net Unit Price for each period by the number of units to credit (8 in this example). Receivables derives the Net Unit Price by the following formula:

Net Unit Price = (Invoice Amount in this period - any previous credit memos in this period) / Original invoice quantity

This table shows the Net Unit Price for each period:

Period

Calculation

Net Unit Price

Period 5

($20-$0)/10 units

$2

Period 4

($30-$0)/10 units

$3

Period 3

($10-$0)/10 units

$1

Period 2

($20-$0)/10 units

$2

Period 1

($20-$0)/10 units

$2

This table shows the Amount to Credit (Net Unit Price * Units to Credit) in each period as a result of the calculations of the net unit price in the previous table:

Period

Amount to Credit

Amount Credited (actual)

Period 5

$2 * 8 units

$16

Period 4

$3 * 8 units

$24

This table shows the partial reverse accounting entries after the credit memo is applied:

Account

Debit

Credit

Accounting Date

Period Status

No Entries

None

None

1/1/XX

Closed

No Entries

None

None

2/1/XX

Closed

No Entries

None

None

3/1/XX

Closed

Revenue

24.00

None

4/1/XX

Open

Unbilled Receivable

None

24.00

4/1/XX

Open

Revenue

16.00

None

5/1/XX

Open

Unbilled Receivable

None

16.00

5/1/XX

Open

Unbilled Receivable

40.00

None

6/1/XX

Open

Accounts Receivable

None

40.00

6/1/XX

Open

Page 21

These examples illustrate the accounting for a partial credit memo against an invoice with installments.

On 1/1/XX invoice 104 is created with these details:

  • Invoice Number = 104

  • Invoice Date = 1/1/XX

  • Invoice Amount = $100

  • Payment Terms = 3 Installments, as illustrated in this table:

    Due Date

    Amount

    2/1/XX

    $50

    3/1/XX

    $25

    4/1/XX

    $25

This table shows the payment schedules for these installments:

Due Date

Original Amount Due

Remaining Amount Due

Total Amount Credited

2/1/XX

$50

$50

$0

3/1/XX

$25

$25

$0

4/1/XX

$25

$25

$0

The examples describe three separate scenarios:

  • Scenario 1:

    • A partial credit memo entered against the invoice with the split term method set to Prorate.

    • A partial payment entered against the invoice.

    • Another partial credit memo entered against the invoice.

  • Scenario 2:

    • A partial credit memo entered against the invoice with the split term method set to LIFO.

    • A partial payment entered against the invoice.

    • Another partial credit memo entered against the invoice.

  • Scenario 3:

    • A partial credit memo entered against the invoice with the split term method set to FIFO.

    • A partial payment entered against the invoice.

    • Another partial credit memo entered against the invoice.

There are three transactions against invoice 104:

  • A partial credit memo for $45 with the split term method set to Prorate.

  • A partial payment of $20.

  • Another partial credit memo for $20.

Transaction 1: On 1/1/XX a credit memo for $45 is entered against invoice 104. The details are:

  • Split term method = Prorate

  • Credit memo date = 1/1/XX

  • Credit memo amount = $45

To calculate the amount credited per payment schedule, Receivables uses the following formula:

Amount Credited = (Credit Memo Amount/Total Remaining Amount Due) * Amount Due Remaining on this installment

This table shows the calculations for the amount credited for each installment:

Due Date

Calculation

Amount Credited

2/1/XX

$45/100 * $50

$22.50

3/1/XX

$45/100 * $25

$11.25

4/1/XX

$45/100 * $25

$11.25

This credit memo affects the payment schedules of invoice 104, as shown in this table:

Due Date

Original Amount Due

Remaining Amount Due

Total Amount Credited

2/1/XX

$50

$27.50

$22.50

3/1/XX

$25

$13.75

$11.25

4/1/XX

$25

$13.75

$11.25

Transaction 2: On 1/15/XX a payment is received for $20. This payment affects the payment schedules of invoice 104, as shown in this table:

Due Date

Original Amount Due

Remaining Amount Due

Total Amount Credited

Payment Applied

2/1/XX

$50

$7.50

$22.50

$20

3/1/XX

$25

$13.75

$11.25

$0

4/1/XX

$25

$13.75

$11.25

$0

Transaction 3: On 1/16/XX another credit memo for $20 is entered against invoice 104. The details are:

  • Credit memo date = 1/16/XX

  • Credit memo amount = $20

This credit memo affects the payment schedules of invoice 104, as shown in this table:

Due Date

Original Amount Due

Remaining Amount Due

Total Amount Credited

Payment Applied

2/1/XX

$50

$3.22

$26.78

$20

3/1/XX

$25

$5.89

$19.11

$0

4/1/XX

$25

$5.89

$19.11

$0

Note: The amounts in the Total Amount Credited column are derived from this formula: Total Amount Credited per installment from Transaction 2 + (Credit Memo Amount/Total Remaining Amount Due from Transaction 2 * Remaining Amount Due per installment from Transaction 2) The results are rounded to two decimal places.

There are three transactions against invoice 104:

  • A partial credit memo for $45 with the split term method set to LIFO.

  • A partial payment of $20.

  • Another partial credit memo for $20.

Transaction 1: On 1/1/XX a credit memo for $45 is entered against invoice 104. The details are:

  • Split term method = LIFO

  • Credit memo date = 1/1/XX

  • Credit memo amount = $45

This credit memo affects the payment schedules of invoice 104, as shown in this table:

Due Date

Original Amount Due

Remaining Amount Due

Total Amount Credited

2/1/XX

$50

$50

$0

3/1/XX

$25

$5

$20

4/1/XX

$25

$0

$25

Transaction 2: On 1/15/XX a payment is received for $20. This payment affects the payment schedules of invoice 104, as shown in this table:

Due Date

Original Amount Due

Remaining Amount Due

Total Amount Credited

Payment Applied

2/1/XX

$50

$30

$0

$20

3/1/XX

$25

$5

$20

$0

4/1/XX

$25

$0

$25

$0

Transaction 3: On 1/16/XX another credit memo for $20 is entered against invoice 104. The details are:

  • Credit memo date = 1/16/XX

  • Credit memo amount = $20

This credit memo affects the payment schedules of invoice 104, as shown in this table:

Due Date

Original Amount Due

Remaining Amount Due

Total Amount Credited

Payment Applied

2/1/XX

$50

$15

$15

$20

3/1/XX

$25

$0

$25

$0

4/1/XX

$25

$0

$25

$0

There are three transactions against invoice 104:

  • A partial credit memo for $45 with the split term method set to FIFO.

  • A partial payment of $20.

  • Another partial credit memo for $20.

Transaction 1: On 1/1/XX a credit memo is entered against invoice 104. The details are:

  • Split term method = FIFO

  • Credit memo date = 1/1/XX

  • Credit memo amount = $45

This credit memo affects the payment schedules of invoice 104, as shown in this table:

Due Date

Original Amount Due

Remaining Amount Due

Total Amount Credited

2/1/XX

$50

$5

$45

3/1/XX

$25

$25

$0

4/1/XX

$25

$25

$0

Transaction 2: On 1/15/XX a payment is received for $20. This payment affects the payment schedules of invoice 104, as shown in this table:

Due Date

Original Amount Due

Remaining Amount Due

Total Amount Credited

Payment Applied

2/1/XX

$50

$0

$45

$5

3/1/XX

$25

$10

$0

$15

4/1/XX

$25

$25

$0

$0

Total

$100

$35

$45

$20

Note: When the payment applied on 1/15/XX fully covered the amount due for the first pay period, the remainder of the payment is applied to the amount due for the following period.

Transaction 3: On 1/16/XX another credit memo for $20 is entered against invoice 104. The details are:

  • Credit memo date = 1/16/XX

  • Credit memo amount = $20

This credit memo affects the payment schedules of invoice 104, as shown in this table:

Due Date

Original Amount Due

Remaining Amount Due

Total Amount Credited

Payment Applied

2/1/XX

$50

$0

$45

$5

3/1/XX

$25

$0

$10

$15

4/1/XX

$25

$15

$10

$0

Page 22

This topic contains summary information about the Adjustment Register.

The Adjustment Register provides information about approved adjustments that affect transaction balances.

Review both manual and automatic adjustments by customer, adjustment status, adjustment type, or adjustment reason.

The following table lists frequently asked questions about the Adjustment Register.

FAQ

Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Period Close

Who uses this report?

  • Financial Specialist to review activity for the period.

  • Financial Manager during period close processing.

When do I use this report?

When you need a listing of adjustments against customer transactions or to assist the receivables reconciliation process.

What can I do with this report?

Schedule to run as needed.

What type of report is this?

Oracle Transactional Business Intelligence

This report uses the Receivables - Adjustments Real Time subject area.

Page 23

Use the Adjustment Register to review both manual and automatic approved adjustments that affect transaction balances for the selected period.

This is a standalone report that you can use instead of the drill-down report associated with the Receivables to General Ledger Reconciliation Report. You can optionally use this report to review unapproved and rejected adjustments, or adjustments that require additional research.

Use the available report parameters to display adjustments by customer, adjustment status, adjustment type, or adjustment reason.

The report output displays adjustment information by business unit and adjustment type for a specified period. Totals are displayed in the ledger currency.

This table shows the main column headings in the output of the Adjustment Register.

Column Heading

Description

Customer Name and Account Number

The name and account number of the customer, displayed for each applicable adjustment type.

Transaction Number

The transaction number of the adjusted transaction.

Transaction Type

The transaction type of the adjusted transaction.

Adjustment Number

The adjustment number assigned to the transaction.

Adjustment Accounting Date

The accounting date of the adjustment.

Adjustment Entered Amount

The amount of the adjustment.

Entered Currency

The entered currency of the adjustment.

Adjustment Accounted Amount

The accounted amount of the adjustment in the ledger currency.

Adjustment Reason

The reason for the adjustment.

Page 24

This topic contains summary information about the AutoAdjustment Preview Report.

The AutoAdjustment Preview Report provides information about potential automatic transaction adjustments, generated after a run of the Create Automatic Billing Adjustments program.

The report includes information about the customer, transaction, adjustment amount, and adjustment status, and displays the total amount and count for both approved and pending adjustments.

The following table lists frequently asked questions about the AutoAdjustment Preview Report.

How do I find this report?

Scheduled Processes - Create Automatic Billing Adjustments

Who uses this report?

Financial Manager during period close processing.

When do I use this report?

To preview potential transaction adjustments when writing off transaction balances using the Create Automatic Billing Adjustments program.

What can I do with this report?

Set the AutoAdjustments Option parameter of the Create Automatic Billing Adjustments program to Generate Report Only.

What type of report is this?

Oracle Business Intelligence Publisher

Page 25

Use the AutoAdjustment Preview Report to review your potential transaction adjustments. The report is generated after a run of the Create Automatic Billing Adjustments process with the AutoAdjustments Option parameter set to Generate Report Only.

Note: This report is for automatic adjustments only. Use the Adjustment Register to review both manual and automatic approved adjustments.

The report includes, for each adjustment, information about the customer, transaction, adjustment amount, and adjustment status. The report displays the total amount and count for both approved and pending adjustments.

Once you're satisfied with the adjustments that will be generated, you can run the Create Automatic Billing Adjustments process again with the AutoAdjustments Option parameter set to Create Adjustments.

This table describes the column headings in the output of the AutoAdjustment Preview Report. These column headings are displayed for each adjustment type.

Column Heading

Description

Customer Name

The name of the customer on the transaction.

Number

The account number of the customer on the transaction.

Transaction Number

The original transaction number.

Transaction Type

The transaction type for the transaction.

Due Date

The due date for the transaction.

Adjustment Number

The number assigned to the adjustment to the transaction.

Adjusted Amount

The amount of the adjustment.

Balance Due

The remaining balance due on the transaction after the adjustment.

Status

The current status of the adjustment.

This table describes the row headings in the output of the AutoAdjustment Preview Report.

Row Heading

Description

Total Approved Adjustments

The total amount of approved adjustments for this run of the process.

Total Approved Adjustments Count

The total number of approved adjustments for this run of the process.

Total Pending Adjustments

The total amount of pending adjustments for this run of the process.

Total Pending Adjustments Count

The total number of pending adjustments for this run of the process.

Page 26

Use the Print Adjustments program to print adjustments to your transactions. The report provides a listing of adjustments for review. The report lists each adjustment separately, with summary information about the adjustment and the transaction that was adjusted.

This is a listing only. The report doesn’t provide any amount or count totals.

Review this report to verify your transaction adjustment process.

Order By

Arrange the information in the report by Adjustment Number, Customer, Postal Code or Transaction Number.

From/To Adjustment Number

Range of adjustment numbers to include in the report.

From/To Transaction Number

Range of transactions with adjustments by transaction number to include in the report.

Tax Registration Number

Confine the report to one customer tax registration number.

Última postagem

Tag