Start/End Receipt Date: Enter a date range to indicate which receipts to include in the report. Customer Reciprocal Relationship: Yes or No indicates whether this relationship is Reciprocal. Amount: The balance of the transaction valuated at the exchange rate used when the transaction was approved. This can be the invoice date, receipt date, or credit memo date. Lists the Payables and Receivables transactions belonging Transaction: The transaction type. If this adjustment is against a deposit, Receivables displays the invoice date of the invoice. Enter the desired process options and schedule. Bank Name: The remittance bank names that are listed in the previous section. Reopen the period if adjusting entries need to be added. creates revenue distributions for transactions that use invoicing For more information, refer to the Oracle Financials RXi Reports Administration Tool User Guide. Important: The Current Value and the Credit Class Value may be the same if the profile option for the Customer Profile Class was updated to the same value as the customized profile option. Leave this parameter blank to include all numbers for this document sequence name. You can use this section to see how much of the prior periods sales are collected. Performance Improvements for Journals for Mexico Report. Type: The line type (for example, Line or Tax). Or, to display all unapplied and unresolved receipts as of a particular date, enter a date for the GL Date To parameter only. Total for Non-Sufficient Funds: The total amount of all receipts with reversal category of NSF. Second Status: Enter the second bills receivable status to include in the report. Receivables provides the tools to reconcile the subledger (AR) with General Ledger. Balance Due: The open balance on the bill. Registry ID/ Low High: Range of party IDs of customers to include on the report. memo amounts against the transaction, and total adjustment amounts Additionally, Receivables prints the unrealized gain or loss for each transaction type and subtotals for each transaction type and customer. Exc Rate: The exchange rate used to convert a foreign currency receipt to your functional currency. Receipt Method: The receipt method of the transaction you are crediting. It is less likely that reports will be needed prior to this date. Base Due Date on Trx Date: Use this parameter to indicate whether you want AutoInvoice to calculate invoice due dates based on transaction dates or based on either the ship date, sales order date, or default date. The list of values for this parameter depends on the Reporting Level that you specified. Customer Number: The customer drawee customer number. Use this report to review the status of your Remittance Batches and a total for the Remittance Batches in each currency within a status. and revenue scheduling rules. Use the Reporting Context parameter to select an operating unit. This is the amount that still needs to be entered into Receivables. Note: Items on the Other Receipt Applications report do not affect the customer balance, and are not recorded on the Applied Receipts Register. For example, invoice, debit memo, credit memo, chargeback, or adjustment. Currency: The currency you want used to select receipts for this report. Unearned Discount: Amount: The projected unearned discount amount for each debit item. Receivables prints information for each disputed debit item and displays totals in the entered currency. Reference Number: A reference number to uniquely identify this report. Working with Attribute Sets, Oracle Financials RXi Reports Administration Tool User Guide, Using the RXi Reports Concurrent Program, Oracle Financials RXi Reports Administration Tool User Guide. Oracle Fusion Cloud Financials 22A What's New Note: This report captures collectors that are assigned at the customer account or site level in the Customers set of pages. payments, on-account credits, credit memos, adjustments, and past Optional Grouping Characteristics: Any additional transaction attributes you specified to group your transactions. You can enter Freight, Receivable, Revenue, and Tax account types. Layout for printing credit memos. Receipts that have started, but not yet completed, the creation or approval process also appear in this report. Otherwise, Receivables sorts information according to the Customer Name field. Counts: Percent Change: The percent change of transaction numbers between your current and prior periods. Grouping Rules, Oracle Receivables Implementation Guide, AutoInvoice Line Ordering Rules, Oracle Receivables Implementation Guide. Select the same GL Dates for all the reports. Includes information about the receipt Remittance Date To: Enter the last remittance date to include in the report. As such, the use, reproduction, Sample OTBI Reports In Oracle Fusion Receivables Navigation: Navigator > Receivables > Accounts Receivable > Tasks > Receivables to Ledger Reconciliation. Tax Code: The tax code that you assigned to your customer. Customer Number: Receivables prints information between the low and high customer numbers that you specify. The Detailed option will produce extra detail lines for each receipt in the remittance batch. number, due date, and overdue amount of transactions. This organization-specific report is always based on current date. Total for: All Customers/Total For: All Types: The grand totals for all customers for each numeric column in your report if you sort by Customer. to a specific netting settlement in PDF format. Start Date: The date on which this receipt method becomes active. Lists the changes Credit Memos: Total amount of credit memos, if any, that were applied to this invoice line. GL Date: The General Ledger date for the adjustment. areas: You schedule and run all Receivables reports from Document Sequence Number To: Enter the last document sequence number that you want to report to. Unapplied: Cnt: The number of receipts that are unapplied. Lists unpaid invoices according to the specified customer. Carrier: The freight carrier for your customer, if you entered one. unit, customer, transaction number, and collector. Note: If you have access to only some operating units that are assigned to the selected ledger, then a message will inform you that the report provides only a partial view of the ledger. to a specific netting settlement in spreadsheet format. Net Total: The Net Total of sales for the respective VAT Number. Common reasons for differences between transactional amounts and accounted amounts include: My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. You revalue open items based on the revaluation rate that you specify, which is either an end of period rate or a daily rate. The AR Reconciliation report lets you obtain a quick update on the status of your receivables by comparing transactional data against accounting data. Remittance Bank Branch: The remittance bank branch name. When you rollback a transaction after a document number has been assigned to it, the document number is removed. Difference: The total for the difference between the Open Functional Amount and Revalution Open Amount for each accounting flexfield, balancing segment, and the entire report. Payment Terms: The payment terms for this business purpose. Transaction Issue Date From: Enter the first bills receivable issue date to include in the report. For example, if you entered low and high batch name values, then submit the report for batches 1-999, 1000-1999, and so on. Total for Stop Receipts: The total amount of all receipts with reversal category of Stop Receipt. Foreign Currency: Debits: The foreign currency debit amount for each Accounting Flexfield that is referenced by a category that you include in this report. Lists the Payables and Receivables transactions belonging Adjustment/Credit Memo/Invoice/Receipt Number: The transaction number for each unposted transaction. For a complete list of the types of manual adjustments that remove invoices from collectibility analysis, see: Modifying Invoices Under Collectibility Analysis. Complete month-end activities such as importing billing information, applying receipts and approving adjustments.2. Currency: The type of currency and the totals, by column, for each column in your report. Information in this section includes area code, telephone number, extension, status, and whether this telephone number is primary. Related Customer Name: Name of the related customer. When reconciling, the Applied Receipts Register's total should match the Applied Receipts Journal. Summarize: Enter Yes to print information in summary format. Invoice Type: If you want to restrict the transactions that appear on statements specify the transaction type to be included here. Even if these items do not affect aging, they may still affect GL balances, if postable. Net Receipt Amount: The total amount of the receipt. GL Date: (Date) to (Date): The general ledger date range you selected as your reporting option. Oracle Receivables prints a total for each GL Date. The Applied Detail report lists all applied amounts, unapplied amounts, and miscellaneous cash. Standard Memo Lines, Oracle Receivables Implementation Guide. Amounts: Current Period: The total amount of each transaction for the current period you specify. Report for the process that creates receipts for Information in this section includes area code, telephone number, extension, status, and whether this telephone number is primary. If two customers with the same name exist, then Receivables includes both customers on the report. SIC Code: Receivables prints the Standard Industry Classification code for your customer. Ledger Currency: Currency you want to use for the report output. Before an automatic receipt can be included in this report, it must be confirmed or created as confirmed, and the receipt class assigned to it must have Require Remittance set to Yes. Foreign Currency: The foreign currency amount, if this transactions was invoiced in a foreign currency. On-Account Cash: The total of this customer's on-account payments. Currency Code: To include only receipts in a specific currency, enter a currency. Open Revalued Amount: The total for each accounting flexfield, balancing segment, and the entire report. You can also run the Automatic Transactions Batch report in Summary or Detailed mode from the Submit Request window to review a previously created bills receivable batch. This report lets you review all customer relationships that have been defined. Receivables displays the currency you select at the top of each page of this report. Quantity: The quantity of the item for the line. You can order by Batch and Deposit Date. Receivables provides predefined reports to Estimated Contingency Expiration Date: Expiration date of any contingency on this invoice line. You can print bills belonging to a bills receivable batch or a bills receivable remittance batch. Includes information Branch: The branch name of the customer bank assigned to this customer. by batch. Receivables always prints 1 for the invoicing rules, ADVANCED INVOICE and ARREARS INVOICE. Adjusted Balance: Receivables calculates and displays the adjusted balance for this customer. You can enter Freight, Receivable, Revenue, and Tax account types. Status: Receivables prints Active or Inactive to indicate the status of your accounting or invoicing rule. Order By: Your sort by option. In the remitted status it will appear as entering the status (as a positive amount) as well as leaving the status (as a negative amount). If you leave these fields blank, Receivables prints information for all receipt dates. Balances Real Time Subject Area for Budgetary Control. Use the Standard Request Submission windows to submit Bills Receivable Reminder Letters. The information contained herein is subject to change without notice and is not warranted to be Bucket Name: Enter the bucket set to use for aging. Choose one of the following options: Show Receipts at Risk: Receipts at Risk are receipts that have either not been cleared or factored receipts that have not been risk eliminated. Name: The name of the customer for this transaction. Average Days Late: The average number of days late for receipts by customer and currency. You can copy these attribute sets and customize their layouts to suit your reporting needs. Current Period: Enter the current period date range to include in this report. Location: The customer billing location for which you want to generate a statement. Customer Name: To restrict the search to a specific name, enter a customer name (optional). Customer Tax Reference Number: The tax reference number for this customer. Receivables sorts the batches by currency and by status within each currency. Postable: The post to general ledger status for this group of transactions. This is the default. This letter contains an introductory paragraph, individual transaction information, and the outstanding balance due for a customer site as of a specific date. GL Account Type: The general ledger account type for the sales journal information on this page of the report. The As Of Date defaults to the system date. Customer Name From/To: To limit the report to one customer, enter the same customer name in both fields. Type options include: Use this report to review a list of receipts for the range of dates, receipt numbers, or document numbers that you specify. Ship-To: The ship-to customer and address for this transaction. Choose HTML, Tab Delimited, or Text. Specify a Schedule and your Completion Options for this request. Note: Receivables ages transactions according to due date. Reconciliation is the process by which the transactional data recorded in subledgers is compared with the accounting data generated by subledger accounting to create the journal entries that post to the general ledger. The aging reports are sorted by company with each item allocated to a company. and schedule. Daily. Receivables summarizes all of your transactions for the two periods so you can spot, track, and take action on developing trends. Note - You may want to exclude these activities if they typically post to non-receivable accounts. Customer types are Internal and External. Sum for (Customer Name) Customer: For each customer, Receivables prints the total transaction amount balance due and dispute amount in the entered currency. Receipt Date Low/High: Enter a date range to indicate which receipts to include in the report. If you leave this field blank Receivables includes all segments. The detail reports display the real-time details that make up balances See: Modifying Invoices Under Collectibility Analysis. may be trademarks of their respective owners. enabled for Multifund Accounting. gain or loss. Invoice Number: The invoice number of the adjusted transaction. Amount: The amount of this invoice line item distributed to this revenue account. Receivables prints the grand totals for all transaction types if you sort by Type. AutoAccounting, Oracle Receivables Implementation Guide, Transaction Batch Sources, Oracle Receivables Implementation Guide. This report will show a difference between Receivables and GL account balances only if items did not successfully post to GL accounts. Accounting Period: Print report information for the current period that you specify. This section displays all of your remittance banks and bank accounts that refer to receipts listed in the previous section. Alternate Name: Sort customers according to the value you entered in the Alternate Name field of the Customers window. If you are reconciling everything, you do not need to select any values. Entered Dr/Cr: The invoice or receipt distribution amount in the currency in which it was entered. When you drill down in the Receivables to General Ledger Reconciliation report, you see real-time details that make up balances from the summary report. Journals are posted to the subledger or general ledger that did not come from Receivables. Prior Period Totals: The total counts and amounts for all payment batches, payments, other receipts, payment statuses, and adjustments for the prior period you specify. Use the Standard Request Submission windows to submit the Bills Receivable Summary report. Choose: GL Account: The GL account range to include in the report. Remittance Method: The remittance method. Percent Change: The percent change of transaction numbers between your current and prior periods. Currency: The currency code for past due items on this page. Current Period: (Date) to (Date): The current period date range you selected to print on this report. Debit items that have any adjustments whose status is pending are treated as disputed items. If your customer uses more than one currency, Receivables displays each currency separately. This report, in conjunction with the Account Analysis report in Oracle General Ledger, provides information needed to reconcile your accounts receivable subledger with the General Ledger. Use the Standard Request Submission windows to submit the Sales Register. In this case, you cannot submit this report if you want to review only your unearned discount exposure. If other subledgers post to these accounts, then you might need to make corrections in those subledgers, make manual corrections in the general ledger, or reconcile your other feeder systems separately. The attribute set determines how information is ordered and what information is included in report. Exchange Rate: The exchange rate for the transaction. Steps to be completed before running the AR Receivables to General Ledger Reconciliation Report. This information includes the currency type and the amount in that currency for each of the following indicators. Customer Name: Receivables selects and prints your report information from the customer name range you specify. transaction number, and transaction date. Currency Subtotal: The entered and functional currency subtotal amount for invoices with the same currency and postable status. Use this report to review a summarized history of transactions that affect your customer's invoices, commitments, debit memos, chargebacks, and on-account credits. In other words, Open Revalued Amount = Revaluation Open Amount - Open Functional Amount (with sign). Use this report to review open foreign currency invoices, debit memos, and chargebacks revalued according to the revaluation rate that you specify. Provides a list of all transactions that have revenue Note: If you have a transaction with multiple installments and do not print installments in order, Receivables will treat any skipped installments as printed. Note: The values entered for Global Rule Set Information are independent of all other report input parameter sections that utilize the parameter Using Rule Sets. To print all installments, do not enter an installment number. If you do not enter an installment number, Receivables prints all installments. The default is No. If you run the report in Detailed mode, the report also includes information about the transactions assigned to each bill. Use this report to review summary information for your customer commitments. If there is no contact or no telephone number for the contact, Receivables prints the telephone number associated with the address. Telephone: The contact's telephone number. reports that cover the following areas: You can schedule and run reports from the Scheduled Percent: Receivables prints the percent of revenue you want to recognize for each period. The report total should tie to the total of the Receipts Journal, which displays the GL account assignments of all the receipts. Period: The period numbers for your accounting or invoicing rule schedule. and customer balances. Batch Source/Name/Activity: The receipt batch source and receipt batch name for each unposted transaction. Document Number From/To: If you use sequential document numbers and you want to print a range of documents, enter the range of document sequence numbers. Amount: The line distribution amount in the functional currency. Includes information on lockbox receipts If you want to preview your post to see if your debits match your credits, run the Sales Journal with a posting status of Unposted. Lists all invoice installments selected in a payment As Of Date: Receivables selects and prints your report information from the as of date you specify. These columns indicate that the actual balance in the general ledger, less all activities except those with source of Receivables, equals that which is recorded in the Receivables subledger. Page: The page number of this transaction. Account Name: The customer bank account name assigned to this customer. Remittance batches that have been deleted. Bill-To Location: Receivables prints the Bill to Location, if this business purpose is Ship-To. Total Bank Account: The total amount of receipts deposited into this bank account. Revenue journals for invoices and credit memos that post to account types other than income. Receivables prints the Unposted Items Report for all items that are not posted for the specified GL date range. Includes information about the remittance Which Receivables Report Relates To Transaction Register In Fusion? Total Report: The total amount of all remittances for the parameters you specify. Line No: The transaction line item number that refers to this revenue account. Receivables posts revenue amounts to a Suspense account if you are importing invoices through AutoInvoice and both of the following are true: the amount specified for an invoice line does not match the Price * Quantity, the Create Clearing option for the transaction batch source is set to Yes. A. Customer: Enter the customer name if you want to print a statement for a specific customer. In this case, Receivables does not display any of your identified or unidentified payments, or on-account credit memos. Receivables Projected Gains and Losses Report. 1. Specify a complete GL date range to display all unapplied and unresolved receipts for that period. Receivables prints transactions whose dates are within this range. Use this report to review a list of receipts that are waiting to be cleared by your remittance bank. This value is 1 for functional currency transactions. Execution Reports. Invoice Print Preview Report: Choose this option to review the invoices, debit memos, chargebacks, deposits, guarantees, credit memos, on-account credits that will print if you specify these report parameters. The examples in the following table assume a Net 30 payment term: GL Date: The invoice general ledger date range you want to include in this report. 2. Drawee Number From: Enter the first customer drawee customer number to include in the report. Invoice No: The invoice, debit memo, chargeback, credit memo, or on-account number associated with each transaction. Cash Application Owner To: The report should include work items to the given cash application owner. Class: The class that is associated with each debit item. Ordering Rule Name Range: Print report information from the ordering rule name range you specify. If this is software, software documentation, data (as defined in the Federal Acquisition Ideally the Summary report should display no differences between receivables transactional amounts and accounted amounts. These statuses can change whenever events such as receipt application or the expiration of contingency periods occur. This report provides aging, customer credit history, and a brief look at the last transactions Receivables recorded for this customer. Bill-To, Credit Memos, Dunning, etc.) Inactive Customers: The current number, prior number, percent change, and total number of inactive customers to date. However, Receivables will correctly include such transactions only once when calculating the total Outstanding Amount. Use this report to review details of receipts that appear in your Journal Entries report. Batches: QuickCash: The number, amount, and percent change of QuickCash payment batches from the current and prior period. The Open Items Revaluation report also provides a complete list of all open items and explains the balance of your Receivables account. You specify your split amount in the Split Amount field in the System Options window. If no party relationships exist for a customer, then Receivables does not include this section. to a bills receivable batch, or belonging to a bills receivable remittance Lists withholding for a supplier. Transaction Class: Receivables prints your report information for the transaction class you specify. If you are using manual or partial automatic numbering, Receivables only validates that the numbers are unique, not that they are sequential. The report lists all work items in the queue of Cash Application Owner/s selected in the query parameters. Deposit Number Low: Enter the first remittance deposit number to include in the report. Receivables prints all open items with a GL date that is less than or equal to the As Of Date you specify. Customer Number: Print report information for the customer number range that you specify. Prior Period: The number of transactions for the prior period that you specify. If you set the parameter to Yes, an X will print in the Tax field if the line has tax associated with it. Apply Date: The date of the receipt application or application reversal. Customer Location: Receivables groups your overdue items by the customer address. Transaction Type: The transaction type of the overdue item. Postable: A Yes or No indicates whether the invoices, credit memos, deposits, and guarantees on this page of the report can post to your general ledger. Contingency Removal Event: Contingency removal event that is associated with the revenue contingency on this invoice line. Customer Number: The number of the customer that was excluded from automatic update. If you do not choose a transaction type, the Setup Details report will provide setup information for every transaction type defined in the AutoInvoice interface tables. For example, you can easily see the number and amount of invoices created during your current and prior periods to compare overall productivity. Bank: Receivables prints your report for the bank range, if you entered one. Using the receipt number you can see the detailed information on the Receipt Journal report. On Hold: Enter Yes to include bills receivable on hold. Use the Standard Request Submission windows to submit the Bills Receivable By Status report. Print Detailed Balance Forward Bills Template. This total is the quantity shipped times the unit price. Credit Memos Posted to General Ledger: Amount: The total credit memo amount posted to your general ledger on the date in the Date column. Transaction Date: The date of the transaction assigned to the bill. Average Days Late = Sum of Days Late / Total Number of Receipts. In addition, this report excludes invoices that are assigned deferred accounting rules. In Collection: The amount of your customer's account that is in collection. Credit Memos Entered: Count: The total number of credit memos entered on the date in the Date column. Over 90 Days Past Due: Receivables prints your customer's open item information based on the aging bucket you define as your fifth bucket in the Aging Bucket window. Open Orig. Late Charge Rate: Past due items are subject to a LATE CHARGE of (Percent) per month which is an ANNUAL RATE of (Percent). My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Report for the process that writes off unapplied The Adjustment Register also includes reductions to guarantees and deposits, although these reductions do not affect the commitment balance. Adjustments: The number, amount, and percent change for each adjustment activity name for the current and prior period.