Receivables standard application reports and lists

Receivables information for reporting is located throughout the navigation menus. In addition, you can create a report from any list.

This table contains the standard application reports and lists for Receivables. To find the reports, use the menu search. Search for the Report name unless a name is specified in the Menu name column.

Report name Description Menu name
Adjustment Maintenance Report View a list of application adjustments and pending maintenance adjustments for a company. n/a
Adjustments By Period Report Analyze trends in deduction adjustments that are categorized by discounts, chargebacks, or write-offs. Enhances the analysis of deduction management. n/a
Advanced Dunning Letter File Generation Create a file of letters selected for dunning by Advanced Dunning Letter Selection. You can produce a print file, a comma-separated value file, or both. n/a
Advanced Dunning Letter Selection Select customers for dunning letter notification. Dunning letters are past-due notices. n/a
Application Audit View applications that require review before they can be posted. Before you can use this report, Application Review Required must be selected for the receivables company. n/a
Application Close Close all transaction entries, cash applications, and cash application adjustments. n/a
Application Conversions Maintain conversion application records after you run Convert Applications. Maintain Conversion Applications
Application Reversal Creation Update application reversals that were created in Payment Reversal and Transaction Reversal. n/a
Auto Cash Application Apply payments or credit memos to open items for selected customers. n/a
Automatic Memo Application Apply these types of credit memos:
  • Invoices or debit memos that cross reference open items.
  • Invoices or debit memos that do not cross reference open items for selected customers.
n/a
Automatic Prepayment Apply Apply customer payments that have been designated as prepayments to cross referenced transactions. n/a
Automatic Transaction Removal Remove transactions according to the selection parameters. n/a
Basic Dunning Letter File Generation Create a file of letters selected for dunning by Basic Dunning Letter Select. You can produce a print file, a comma-separated value file, or both. n/a
Basic Dunning Letter Select Select customers for basic dunning letter notification. Dunning letters are past-due notices. n/a
Bill Of Exchange Risk List the due date of bills of exchange that have been remitted for payment at a discount. The bills of exchange are still at risk with the bank. n/a
Cash Batch Release Report Release unreleased cash batches for a company. n/a
Cash Forecasting Report Create a report for cash forecasting. n/a
Chargeback Creation Create a report by customer and chargeback number. The company total is included. This report can be run for Company Customer records where Print Chargebacks is selected on the Cash Application tab. n/a
Company Aging Report Create a transaction aging report for a company. n/a
Conversion Comments Maintain conversion comments records after you run Convert Comments. Maintain Conversion Comments
Conversion Disputes Maintain conversion dispute records after you run Convert Disputes. Maintain Conversion Disputes
Conversion Distributions Maintain conversion distribution records after you run Convert Distributions. Maintain Conversion Distributions
Conversion Invoices Maintain conversion invoice records after you run Convert Invoices. Maintain Conversion Invoices
Conversion Payments Maintain conversion payment records after you run Convert Payments. Maintain Conversion Payments
Conversion Results View results and errors for these conversions: Convert Invoices, Convert Payments, Convert Distributions, Convert Applications, Maintain Adjustments, Convert Disputes, and Convert Comments. n/a
Convert Applications Import cash application and adjustment records to Receivables from a file created by an external source. n/a
Convert Comments Import transaction comments to Receivables from a file created by an external source. n/a
Convert Customers Import customer records to Receivables from the customer conversion file. n/a
Convert Disputes Import disputed transaction records to Receivables from a file created by an external source. n/a
Convert Distributions Import distribution records to Receivables from a file created by an external source. n/a
Convert Invoices Import invoices, debit memos, and credit memos to Receivables from a file created by an external source. n/a
Convert Payments Import payment records to Receivables from a file created by an external source. This process adds existing payments that have updated balances and Global Ledger in the external source. n/a
Credit Exception Report View customers that have exceeded their credit limit or have transactions that exceed a specific number of days past due. n/a
Critical Review Report Generate a list of customers. Use the parameters to select criteria. For example, filter on percent of credit limit used, open orders, current balance, specific risk code, and days past due. n/a
Customer Add Alert Create a report of customers that have been added where the system date is equivalent to a customer's start date. Start date is defined on Customer. n/a
Customer Aging Report Create a transaction aging report for a customer group. You can run the report for all customers or for a single customer in a customer group. The report is created as of the date you specify for an accurate aging. You can define aging periods and options or leave the fields blank to use the aging options defined for the customer group. n/a
Customer Balance Conversion Update customer, customer group, and national account balances for all open items. Convert Customer Balances
Customer Conversion Maintain conversion customer records after you run Convert Customers. Customer Conversion Maintenance
Customer Conversion Results View results and errors for Convert Customers. n/a
Customer Credit Alert View customers where the current balance plus the open order amount is greater than the customer credit limit. This calculation is based on the Over Limit Percent or Percent of Credit Limit that you selected for the report. n/a
Customer Data Export Export summary aging data for company customers and for company customer’s receivable invoice detail records by a Transaction User Field 1 field. The invoice detail record’s Transaction User Field 1 field represents a user supplied invoice attribute. n/a
Customer EFT Adjustments Create adjustments to the prenotifications before you process them. EFT Adjustments
Customer Grand Livre View detailed customer transactions and balances by account number and customer for one or more accounting periods. n/a
Customer Interface Results View results and errors for the Interface Customers process. n/a
Customer Review Selection Select customers for credit review. n/a
Customer Statistic Report List statistics for customers including the average number of days beyond terms, invoice payment averages, and transaction activity by category and period. n/a
Dishonor Bill Of Exchanges Mark bills of exchange that have not been honored by the bank. n/a
EFT Extract Review open items for extraction and create a flat file for EFT adjustments. n/a
EFT Notification Extract Select open items for prenotification or final notification. n/a
EFT Notification Print Create prenotification and final notification print files and flat files. n/a
EFT Payment Creation Create customer payment records in an ACH format or a non-formatted layout and apply payments to eligible open items. n/a
Finance Charge Initiation Begin assessing finance and late payment charges. n/a
Finance Charge Late Payment Assess finance and late payment charges for customers with finance charge options defined on the customer. Run Application Closing before this report so that all applications are included. n/a
Interface Customers Add or change customer records from an externally loaded customer interface file. n/a
Interface Customers Maintain customer interface and conversion records before they are processed into Receivables. Customer Interface Maintenance
Interface Invoices Maintain interface invoice errors that occur after you run Interface Invoices. Invoice Interface Maintenance
Interface Invoices Process invoice interface and conversion records into Receivables. n/a
Interface Lockbox Import lock box payments to Receivables from a file created by an external source. Interface Lockboxes
Interface Lockboxes Maintain lock box payment interface errors after you run Interface Lockboxes. Lockbox Interface Maintenance
Interface Payments Maintain payment interface errors after you run Interface Payments 2. Payments 2 Interface Maintenance
Interface Payments Maintain payment interface errors after you run Interface Payments. Payments Interface Maintenance
Interface Payments Import payments to Receivables from a created file by an external source. Use the Pay Code field to override the pay code. n/a
Interface Payments Import payments to Receivables from a created file by an external source. Interface Payments 2
Interface Results View results and errors for these interfaces: Interface Invoices, Interface Payments, Interface Lockboxes, Interface Payments 2. Receivables Interface Results
Last Statement Balance Build Create a last statement balance amount for a customer. n/a
Mass Customer Update Change several customer records at one time. n/a
National Account Aging Report Create a transaction aging listing for all national account customers or an individual national account. n/a
National Account Transaction Update Delete national account relationship records and update national account balance records. National Account Trans Update
Payment Request Notice Print Print payment request notices that are created in Returned Payment, Finance Charge Late Payment, and Chargeback Creation. n/a
Period Closing Report Close the current period and year for Receivables, update record status, and update customer period statistics. Period Close Report
Project Aging Report Create a transaction aging report for activity-based parameter selections. AR Customer Project Aging Report
Project History Report View all transactions, cash application adjustments, and non-asset receivables payment transactions that are associated with a project. n/a
Project Report View all transactions, cash application adjustments, non-asset receivables payment transactions, and miscellaneous distributions that are associated with each activity. n/a
Rebuild Receivable Project Transactions Create activity-based transaction records. n/a
Receivable Activity Summary View receivables activity and close payment averages. A static aged trial balance is created for each customer in a company. n/a
Receivables Tie Back Report Create a receivables tie back listing for a company. You can select an accounts receivable code to further define the report. Use this report to reconcile the receivables general ledger account to the supporting detail of the Receivables solution. n/a
Receivables Transaction History Report View all the transactions for a range of Global Ledger dates for a company. n/a
Regulatory Foreign Invoices Report on sales to foreign countries. n/a
Remittance Selection Select bills of exchange for remittance. n/a
Report Group Aging Report Create a summary aging listing for a process level report group. n/a
Self Balancing Report Update distribution balance records to enable future reporting. n/a
Statement Print Create statements of account for customers using the statement options that are defined for each customer. The statement cycle code that is assigned to the customer determines whether to create an open item or balance forward statement. n/a
Summary Aging Report Create a summary aging report. You can summarize transactions in total or summarize transactions for a specific process level or range of sales representatives. There is one line for each customer's transactions. n/a
Transaction Status Update Update the transaction status of records. n/a
Transferred Transaction Report List Return To Maker (RTM) records that are created in Returned Payment for a company. You can include unreleased or released RTMs on the report. n/a
Unrealized Gain Loss Report Calculate unrealized gains and losses for open, non-base currency transactions and create entries for posting to Global Ledger. n/a
Unreleased Interfaced Invoices Maintain and release unreleased invoice data errors that occur after you run Interface Invoices. Unreleased Invoice Interface Maintenance
User Sort File Build Create user sort transaction records from invoice, debit memo, and credit memo transaction records. n/a
Voucher Reference Report Assign a voucher number to invoices that have been ordered for a selected company and year. This report is sequenced in ascending general ledger date order. n/a