B JD Edwards EnterpriseOne Demand Scheduling Reports

This appendix contains the following topics:

B.1 Demand Scheduling Reports

You can run a variety of reports to analyze demand scheduling information. For example, you can print bills of lading or print information to analyze discrepancies for shipments, review demand activity, or analyze the efficiency of the advance ship notice process.

B.2 Demand Scheduling Reports A to Z

This table lists the Demand Scheduling reports, sorted alphanumerically by report ID.

Report ID and Report Name Description Navigation
R47191

Acknowledgement Accuracy Report

Provides information pertaining to the acceptance or rejection of the EDI Transaction Message along with up to five reasons why the ASN was accepted or rejected. Reports menu (G40R111), Acknowledgement Accuracy Report.
R470361

ASN On Time Analysis Report

Provides data to monitor the efficiency of the ASN process. Reports menu (G40R111), ASN On-Time Analysis.
R40R1010

CUM Reconciliation Report

Prints discrepancies between customers and suppliers CUM quantity figures. Reports menu (G40R111), CUM Reconciliation.
R40R1020

Demand Inactivity Analysis Report

Prints items that have been inactive for a specified period, or are obsolete, or which may have errors that prevent processing. Reports menu (G40R111), Demand Inactivity Status.
R49118

Demand Scheduling Bill of Lading

States that certain goods received for shipments are promised to be delivered at a specified destination, either to the carrier's agent or to a particular consignee or customer.

Prerequisite: Set up the document code BOL2 for the Demand Scheduling Bill of Lading.

Shipments and Loads menu (G4911), Work with Shipments. You can also select Confirm Shipments.

On Work with Shipments, locate the record and select Delivery Documents from the Row menu.

On Delivery Document Selection, complete the Doc Code field.

R47037

EDI ASN Update as Sent Report

Marks all documents that were transmitted as processed, preventing the same documents from being sent again. Reports menu (G40R111), EDI Update As Sent
R40R093

Purge CUM History Record

Deletes obsolete cumulative history records. You use data selection to determine which records to delete. You can use the processing options on the Process tab to specify whether to archive purged information and where. The system also purges attachments associated with the records.

The system purges information from the F40R42 table.

Demand Advanced & Technical Ops menu (G40R31), Purge CUM History.
R40R030

Shipment Analysis

Compares the required shipping date with the actual shipping date. Reports menu (G40R111), Shipment Analysis.
R49118

Transportation Bill of Lading Print

Used as a legal document for the transportation of goods. Fast path to menu BV (batch versions), locate batch application R49118.

B.3 JD Edwards EnterpriseOne Selected Demand Scheduling Reports

This section provides detailed information, including processing options, for individual reports. The reports are listed alphanumerically by report ID.

B.3.1 R40R1010: CUM Reconciliation

You can run the CUM Reconciliation report (R40R1010) to identify discrepancies between shipped values and received values. The report compares supplier and customer cumulative quantities and can assist the supplier in verifying the cumulative totals, so that future shipments accurately meet the customer requirements.

You can run this report automatically by setting the CUM Reconciliation Report Version processing option on the Versions tab in the processing option for the EDI Inbound Demand Edit/Update batch application (R47171).

This report provides information only and does not contain transaction processing. If a discrepancy exists, the supplier must identify the source of the discrepancy and take the proper corrective action.

B.3.2 Processing Options for CUM Reconciliation (R40R1010)

Processing options enable you to specify the default processing for programs and reports.

B.3.2.1 Default

These processing options enable you to specify how the system processes information for items and cumulative quantities.

1. Item Detail

Specify whether the system prints items with cumulative discrepancies on the CUM Reconciliation report (R40R1010). Values are:

Blank: Prints all items.

1: Prints only items with cumulative discrepancies.

2. Customer CUM Value

Specify whether the system compares the supplier's CUM quantity shipped to either the customer's CUM quantity shipped or to the customer's CUM quantity received when you run the CUM Reconciliation program (R40R1010). Values are:

1: Compares the supplier's CUM quantity shipped to the customer's CUM quantity shipped.

2: Compares the supplier's CUM quantity shipped to the customer's CUM quantity received.

B.3.3 Processing Options for Purge CUM History Record (R40R093)

Processing options enable you to specify the default processing for programs and reports.

B.3.3.1 Process

These processing options enable you to specify how the system purges cumulative history records.

1. Archive Purged Records

Specify whether the system archives purged records. Values are:

Blank: Do not archive.

1: Archive.

2. Archive Environment Name

Specify the environment in which the system archives purged records. This processing option is required if you are archiving purged records. The archive environment and data source must be different from the source environment and data source.

3. Archive Table Name

Specify the name of the table to which the system archives purged records. If you leave this processing option blank, the system uses the name of the table being purged. The purge program creates this table.

B.3.4 R40R030: Shipment Analysis

The Shipment Analysis report (R40R030) enables you to compare the required shipping date with the actual shipping date. You can configure the output of the report with these types of information:

  • The percentage of items that were shipped early.

  • The percentage of items that were shipped on time.

  • The percentage of items that were shipped late.

  • All records.

You can specify tolerance levels for time and quantity in the Shipment Analysis processing options on the Display tab, which enables you to establish the timeliness of shipments. For example, suppose you specify that thirty minutes is the tolerance for the Early Shipment Tolerance Level (Time) processing option. If the actual shipping date and time of an order is thirty minutes or less before the requested shipment date and time, the system considers the order to be on time.


Note:

Because this report does not consider the actual transportation of goods, it does not represent the entire shipping process.

The system uses the F40R41 table to process information for the Shipment Analysis report.

B.3.5 Processing Options for Shipment Analysis (R40R030)

Processing options enable you to specify the default processing for programs and reports.

B.3.5.1 Display

These processing options enable you to specify how the system processes information for shipment analysis.

1. Display Type

Specify which shipments the system includes when you run the Shipment Analysis program (R40R030). Values are:

Blank: The system includes all shipments.

1: Includes only late shipments.

2: Includes only early shipments.

3: Includes only on time shipments.

2. Display Early As On Time

Specify whether the system considers early shipments as on time shipments when you run the Shipping Analysis program (R40R030). Values are:

Blank: Display early as early.

1: Display early as on time.

3. Early Shipment Tolerance Level (Time)

Specify the number of minutes before the requested ship time that a shipment can be made before it is considered an early shipment. For example, if you specify 30 minutes, then anything that is shipped 30 or more minutes before the requested ship time is considered an early shipment.

4. Late Shipment Tolerance Level (Time)

Specify the number of minutes after the requested ship time that a shipment can be made before it is considered a late shipment. For example, if you specify 30 minutes, then anything that is shipped 30 or more minutes after the requested ship time is considered a late shipment.

5. Early Shipment Tolerance Level (Quantity)

Specify the minimum percentage of the requested ship quantity that an early shipment's actual quantity must exceed for the system to print the actual quantity on the report. For example, if you specify 10 percent, then any early shipment containing an actual ship quantity that exceeds 10 percent of the requested ship quantity is displayed on the report.

6. Late Shipment Tolerance Level (Quantity)

Specify the minimum percentage of the requested ship quantity that a late shipment's actual quantity must exceed for the system to print the actual quantity on the report. For example, if you specify 10 percent, then any late shipment containing an actual ship quantity that exceeds 10 percent of the requested ship quantity is displayed on the report.

B.3.6 R40R1020: Demand Inactivity Analysis

You can run the Demand Inactivity Analysis report (R40R1020) to identify items that have been inactive for a specified period, or are obsolete, or which may have errors that prevent processing. You can review historical records that are related to the demand header record and the actual number of days that have passed since demand processing occurred.

The system calculates the number of days by subtracting the EDI Batch Date on the demand header record from the Comparison Date processing option on the Defaults tab to determine the days since last activity. The system compares this result to the Number of Days for Comparison processing option you specify on the Processing tab. If the result is greater than or equal to the number of days, the system displays this information. You can also specify whether to print activity detail information.

B.3.7 Processing Options for Demand Inactivity Analysis (R40R1020)

Processing options enable you to specify the default processing for programs and reports.

B.3.7.1 Defaults

This processing option enables you to specify how the system processes information for demand inactivity analysis.

1. Comparison Date

Specify the date with which the system compares the batch date in the demand header information when you run the Demand Inactivity Analysis report (R40R1020). The system compares the two dates to determine how many days have elapsed since activity has been performed. The system then compares this number to the comparison days to determine whether to include on the report the number of days that has elapsed since activity has been performed.

B.3.7.2 Processing

These processing options enable you to specify how the system calculates the number of days for demand inactivity.

1. Number of Days for Comparison

Specify the number of days that have elapsed since activity has been performed. The system compares this number to the comparison days to determine whether to include the number of days that have elapsed since activity has been performed when you run the Demand Inactivity Analysis report (R40R1020).

2. Number of Days for Activity Detail

Specify the number of days of demand history that the system includes when you run the Demand Inactivity Analysis program (R40R1020). The number of days begins with the most recent record that the system locates in the F40R41 table.

B.3.7.3 Print

This processing option enables you to specify how the system displays activity detail on the report.

1. Print Activity Detail

Specify whether the system includes demand detail information when you run the Demand Inactivity Analysis report (R40R1020). Values are:

Blank: Does not include the demand detail information on the associated report.

1: Does include the demand detail information on the associated report.

B.3.8 R49118: Demand Scheduling Bill of Lading

A Bill of Lading is a report used as a legal document issued by the shipping company to a shipper, stating that certain goods received for shipments are promised to be delivered at a specified destination, either to the carrier's agent or to a particular consignee or customer.

The Transportation Bill of Lading Print report (R49118) provides information about shipments, such as item numbers, descriptions, and weights.

After you start this batch report, the system runs the Document Batch Print UBE (R49590). The system then runs the Transportation Bill of Lading Build report (R49110), using version ZJDE0002. This process builds a work file from the system tables and updates the necessary tables. The system then runs the R49116 batch report to use as the Bill of Lading for Demand Scheduling.

The system uses these tables when processing information for shipment reports:

  • F49111

  • F49110

  • F4620

  • F49594

B.3.9 Processing Options for Transportation Bill of Lading Print (R49118)

Processing options enable you to specify the default processing for programs and reports.

B.3.9.1 Print Options

These processing options enable you to specify which information the system includes on the Bill of Lading.

1. Unit of Measure for Weight Totals

Specify the unit of measure that the system uses to display the weight totals.

2. Print Delivery Instructions

Specify whether the system prints delivery instructions.

3. Print Shipment Attachments

Specify whether the system prints shipment attachments.

4. Print Routing Entry Attachments

Specify whether the system prints routing entry attachments.

5. Print Options and Equipment Information

Specify whether the system prints options and equipment information.

6. Global Message to print on each document

Specify a global message that appears on each document. Examples include engineering specifications, hours of operation during holiday periods, and special delivery instructions.

7. Print Additional Header Text

Specify whether to print additional header text that indicates whether the document is an original or a reprint. Values are:

Blank: Do not print additional header text.

1: Print header text that indicates that the document is an original.

2: Print header text that indicates that the document is a reprint.

8. Item Consolidation

Specify whether to consolidate item or parts on the Demand Scheduling Bill Of Lading.