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