46 Print Standard Reports

This chapter contains these topics:

You can print standard reports to review and manage A/R information, such as open account balances for all customers or specific customers.

These reports read information from the Customer Master (F0301) and A/R Ledger (F0311) tables.

The processing time for these reports depends on the amount of history retained in the Customer Master and A/R Ledger tables. You might want to print standard reports during off-peak hours.

Navigation

From Accounts Receivable (G03), choose Accounts Receivable Reports

From Accounts Receivable Reports (G0341), choose a standard report

46.1 Printing the Open A/R Summary Report

To review current summary information about account balances and aging records, print the following versions of the Open A/R Summary report:

  • Print the A/R Summary by Company

  • Print the A/R Summary by Category Code

  • Print the A/R Summary by Parent

Specify your aging information for this report in one of the following:

Location Description
A/R constants Specify the aging date, aging method and type of date (due date, invoice date or G/L date); define the aging categories.

When you have the processing option set to use A/R constants for aging information, any aging information set up in the processing options will be ignored.

Processing options Specify the aging date, aging method and type of date (due date, invoice date, or G/L date); define the aging categories.

You can select the rounding scale to be used on the Aging Buckets separately from the scaling used on other report amounts. Use the Rounding Factor processing options for rounding of non-aging amounts and for rounding of aging amounts.


46.1.1 Printing A/R Summary by Company

To review an alphabetic list of accounts and a summarized total of each customer's open items, print the A/R Summary by Company report. This aging report lists totals by company and a grand total of all open A/R items. You can print this report with or without promise information.

The totals and aging amounts reflect only transactions you select.

Figure 46-1 Open A/R Summary by Company report

Description of Figure 46-1 follows
Description of "Figure 46-1 Open A/R Summary by Company report"

46.1.2 Processing Options

See Section 104.1, "A/R Summary Report (P03413)."

46.1.3 Printing A/R Summary by Category Code

To review a summary of open A/R balances by category code and customer number, print the A/R Summary by Category Code report. This aging report lists summarized totals for each customer, a total by company, and a grand total for all companies.

Use processing options to specify which category code (1-10) you want to include on the report.

Figure 46-2 Open A/R Summary by Account Representative report

Description of Figure 46-2 follows
Description of "Figure 46-2 Open A/R Summary by Account Representative report"

This example uses category code 02 (account representative) from the Address Book system.

46.1.4 Data Selection and Sequence for A/R Summary by Category Code

Verify that the category code you specify for the data sequence is the same as the category code you specified in data selection.

46.1.5 Printing A/R Summary by Parent

To review a summary of child (subsidiary) accounts within each parent (national) account, print the A/R Summary by Parent report. This aging report lists totals for the parent and the company and a grand total of all accounts.

46.2 Printing the Open A/R Detail Report

To review open items such as invoices, sales orders, credit memos or unapplied cash for every customer, print the Open A/R Detail report. This report shows totals for each company and a grand total for all companies.

You can choose to print versions of this report that include:

  • Discount information and remarks

  • Aging (short and long)

  • Detail by account representative

  • Retainages

Specify your aging information for this report in one of the following:

Location Description
A/R constants Specify the aging date, aging method and type of date (due date, invoice date or G/L date); define the aging categories.

When you have the processing option set to use A/R constants for aging information, any aging information set up in the processing options will be ignored.

Processing options Specify the aging date, aging method and type of date (due date, invoice date, or G/L date); define the aging categories.

You can select the rounding scale to be used on the Aging Buckets separately from the scaling used on other report amounts. Use the Rounding Factor processing options for rounding of non-aging amounts and for rounding of aging amounts.


Figure 46-3 Customer Receipts History report

Description of Figure 46-3 follows
Description of "Figure 46-3 Customer Receipts History report"

46.2.1 Processing Options

See Section 104.2, "A/R Detail Report (P034201)."

46.2.2 Data Selection for Open A/R Detail

Set the Payment/Item Document Type to NE (not equal) RE (change to invoice gross amount). The Open Amount should be NE *ZERO. Other data selections are optional.

46.3 Printing the Open A/R Foreign Amounts Report

To review A/R detail for both foreign and domestic amounts, print the Open A/R Foreign Amounts report. This report is similar to the Open A/R Detail report, but includes:

  • The base company currency

  • The transaction currency

  • The original and open foreign balances

Figure 46-4 Currency Detail - Foreign and Domestic report

Description of Figure 46-4 follows
Description of "Figure 46-4 Currency Detail - Foreign and Domestic report"

46.3.1 Processing Options

See Section 104.3, "A/R Currency Detail (P03429)."