This appendix contains the following topics:
The JD Edwards EnterpriseOne Console provides a variety of reports to help you review and manage the information in the metrics. This table lists the reports, sorted alphanumerically by report ID:
Report ID and Report Name | Description | Navigation |
---|---|---|
R80D010 | Populates the Sales Order Fact table (F80D010) from the Sales Order Detail table (F4211) and the Sales Order Detail History table (F42119). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D0201 | Populates the GL Account Balances Fact table (F80D020) with data from the Account Ledger table (F0911). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D0202 | Populates the GL Account Balances Fact table (F80D020) with data from the Account Ledger table (F0911). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D100 | Populates the PMD - Date Dimension table (F80D100) with the days, months, quarters, and weeks in each year for the view by display on the console. | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D112 | Populates the SOD Alert Master (F80D135) and SOD Alert Detail (F80D136) tables. | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D200 | Determines the days sales outstanding by using a 52-week sales calculation divided by 360 and then divided into the total open accounts receivable and populates the Days Sales Outstanding Aggregate table (F80D200). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D201 | Determines the days payables outstanding by using the last 52 weeks of cost-of-goods sold divided by 360 and then divided into the total open payables and populates the Days Payables Outstanding Aggregate table (F80D201). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D202 | Calculates cash to cash cycle time as DSO plus DSI minus DPO and populates the Cash to Cash Cycle Time Aggregate table (F80D202). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D203 | Populates the Forecasted Cash Flow Aggregate table (F80D203). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D210 | Calculates on-time, early, and late shipments for each date and populates the On Time Shipment Customer Request Date Aggregate table (F80D210). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D211 | Calculates on time, early, and late shipments for each date and populates the On Time Shipment Promise Ship Date Aggregate table (F80D211). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D212 | Calculates the past-due order amount and number of past-due sales order lines and populates the Past Due Aggregate table (F80D212). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D213 | Calculates the backorder amount and line count for unfilled sales orders and populates the Back Order Aggregate table (F80D213). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D214 | Calculates the difference between the promise ship date and the requested ship date by item and populates the Variance Aggregate table (F80D214). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D215 | Determines the book-to-ship days value and the number of lines shipped for each sales order and populates the Book to Ship Aggregate table (F80D215). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D220 | Calculates the days sales in inventory and the number of inventory turns and populates the Inventory Aggregate table (F80D220). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D221A | Populates the General Ledger Aggregate table (F80D221) with data from the Item Ledger table (F4111). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D221B | Populates the General Ledger Aggregate table (F80D221) with data from the Sales Order Detail (F4211) and Sales Order History (F42119) tables. | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D230 | Calculates on-time, early, and late production completions and populates the On Time Manufacturing Completions table (F80D230). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D231 | Determines the actual production costs for all finished goods and calculates the variance to planned production costs from the work orders and populates the Manufacturing Production Costing table (F80D231). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D240 | Calculates the booked order value for each day and populates the Booked Order Aggregate table (F80D240). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D241 | Calculates the shipped revenue for each sales order and for each day and populates the Shipped Orders Aggregate table (F80D241). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D242 | Calculates the projected revenue for each day and populates the Projected Revenue Aggregate table (F80D242). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D243 | Calculates the backlog value for each day and populates the Backlog Aggregate table (F80D243). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D250 | Calculates on-time, early, and late deliveries from each supplier and populates the Supplier On Time Delivery Aggregate table (F80D250). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D251 | Calculates the actual lead time for items and populates the Material Lead Time Exception Aggregate table (F80D251). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D252 | Calculates the quality pass percentage for each purchase order received and populates the Supplier Pass Quality Aggregate table (F80D252). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D253 | Populates the AP Daily Counts and Amounts table (F80D253). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D254 | Populates the AP Discount Information Aggregate table (F80D254). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D255 | Populates the AP Open Payables Aggregate table (F80D255). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D256 | Populates the AP Voucher Paid Late Aggregate table (F80D256). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D272 | Populates the Most Profitable Customers Aggregate table (F80D272). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D273 | Populates the Most Profitable Products Aggregate table (F80D273). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D274 | Populates the Most Profitable Brands Aggregate table (F80D274). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D280 | Populates the AR Daily Counts and Amts Aggr table (F80D280). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D281 | Populates the AR Delinquency Info Aggregate table (F80D281). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D282 | Populates the AR Discount Information Aggregate table (F80D282). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D283 | Populates the AR Open Chargeback Aggregate table (F80D283). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D284 | Populates the AR Open Receivables Aggregate table (F80D284). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D285 | Populates the AR Total Chargebacks Aggregate table (F80D285). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |
R80D701 | Populates the Unposted Transactions Aggregate table (F80D701). | Type BV in the Fast Path field and click the arrow.
Enter the report ID number in the Batch Application field on the Available Versions form. |