Skip Headers
JD Edwards World Accounts Receivable Guide
Release A9.3

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

58 Process "As Of" Reports

This chapter contains these topics:

You can print period-end reports as of a specific date. To do this, you must first build a transaction worktable based on a specific "as of" date.


From Accounts Receivable (G03), choose Periodic Processes

From Periodic Processes (G0321), choose an option under the 'As Of' Reporting heading

58.1 Generating "As Of" Date Information

You generate "as of"date information by running Date File Generation. The program builds the "As Of' Accounts Receivable worktable (F0311A) that contains transactions with a G/L date less than or equal to the "as of" date you specify in the processing options. The program builds the "As Of" Accounts Receivable Ledger worktable from the A/R Ledger table (F0311).

The program selects transactions that are written to the worktable and examines every matching document (payments, adjustments, voids) related to the original document. Any matching document with a G/L date prior to the "as of" date is also written to the worktable. Any matching document dated after the "as of" date is written to the worktable if you set the appropriate processing option.

The "As Of" Processing allows you to rebuild the F0311A by company. You can rebuild using a different "as of" date for each company by setting the processing option for partial build. The system expects if the processing option is set to partial build, the company value in the data selection must have *VALUE or *RANGE. Input the correct company number(s) on the Value screen.


If more than 45 companies re needed for selection, simply add additional company selections. You can select up to 225 companies for the partial build, which is five separate Data Selection records separated with an OR statement.

The records for each company are written to the same F0311A file. If you choose to include only records for companies 00001 and 00050, existing records for those two companies will be deleted and the data will be rebuilt. The "As Of" date on each record is stored in the Date Updated (RPUPMJ) field. The data sequence on the reports sorts by the Date Updated (RPUPMJ) first.

Business unit security will be used in this process. Only those Business Units that you specify will be updated in this process.

58.1.1 Before You Begin

  • Determine if you will include paid items in the worktable. Including paid items increases the processing time significantly.

  • Schedule this procedure after business hours to ensure adequate processing time.

58.1.2 What You Should Know About

The Pay Status code for your F0411A records will automatically be set to P if there is no open amount existing in your Accounts Payable Ledger (F0411) record at the point in time of the "As of" date. An A will default if an open amount exists in your F0411 record (A = Approved, P = Paid). No other Pay Status codes will be written to the F0411A file. For example, if the F0411 record has an open amount and pay status of H, the record will be written to the F0411A with a pay status of A.

This as of build supports up to 999 pay items per document.

58.1.3 Processing Options

See Section 107.2, "Date File Generation (P03900)."

58.2 Printing "As Of" Reports

"As of" reports are versions of the Open A/R Detail (P034201) and Open A/R Summary (P03413) reports. Each report is based on the "As of" Accounts Receivable Ledger worktable and lists information as of the date you specify in Date File Generation.

This task consist of:

58.2.1 Before You Begin

  • Run Date File Generation (P03900) to create the A/R 'As of" worktable (F0311A)

  • Choose the appropriate "As of" DEMO version for the specific report. Verify the F0311A is in the Based on File field in Additional Parameters for the version of the "As of" report that you are running.

  • Set the appropriate processing option to use "As of" date processing.

58.2.2 What You Should Know About

Topic Description
Multi-Currency If the detail portion of the report includes more than one currency, the amount in the total line is a hash total and is meaningless. To avoid hash totals, you can include currency codes in your totaling levels.

58.2.3 Printing the Open A/R Detail Report

The Open A/R Detail Report lists information based on any "As of" date you specify in the worktable build. This report has several versions, including:

  • A/R Detail with Discount and Remarks

  • A/R Detail with Optional Aging

  • Customer Receipts History

  • Retainage Receivables

  • A/R Detail by Account Representative

Figure 58-1 Accounts Receivable Detail report

Description of Figure 58-1 follows
Description of "Figure 58-1 Accounts Receivable Detail report"

58.2.4 Processing Options

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

58.2.5 Printing the Open A/R Summary Report

The Open A/R Summary Report lists open A/R summary totals and associated aging. The transactions are summarized by customer number and company. This report has several versions, including:

  • Open A/R Summary by Company

  • Open A/R Summary by Parent

  • Open A/R Summary by Salesperson

  • Open A/R Summary by Category Code

Figure 58-2 Accounts Receivable Detail (Open A/R Summary) report

Description of Figure 58-2 follows
Description of "Figure 58-2 Accounts Receivable Detail (Open A/R Summary) report"

58.2.6 Printing the Open A/R by Business Unit and Address Report

The Open A/R by Business Unit and Address Report lists information about open amounts for customers based on business unit and address.

Figure 58-3 Open A/R by Customers and Business Unit report

Description of Figure 58-3 follows
Description of "Figure 58-3 Open A/R by Customers and Business Unit report"

58.2.8 What You Should Know About

Topic Description
Printing additional "as of" reports You can also run the following reports based on the "As of" Accounts Receivable Ledger worktable:
  • Currency Detail - foreign and domestic

  • Summary by Pay Status

  • Summary by Parent/Child

  • Problem Accounts Receivable

Verify that you set the appropriate processing option for the "As of" date processing.