This appendix contains the following topics:
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.
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. |
This section provides detailed information, including processing options, for individual reports. The reports are listed alphanumerically by report ID.
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.
Processing options enable you to specify the default processing for programs and reports.
These processing options enable you to specify how the system processes information for items and cumulative quantities.
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.
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.
Processing options enable you to specify the default processing for programs and reports.
These processing options enable you to specify how the system purges cumulative history records.
Specify whether the system archives purged records. Values are:
Blank: Do not archive.
1: Archive.
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.
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.
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.
Processing options enable you to specify the default processing for programs and reports.
These processing options enable you to specify how the system processes information for shipment analysis.
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.
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.
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.
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.
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.
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.
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.
Processing options enable you to specify the default processing for programs and reports.
This processing option enables you to specify how the system processes information for demand inactivity analysis.
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.
These processing options enable you to specify how the system calculates the number of days for demand inactivity.
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).
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.
This processing option enables you to specify how the system displays activity detail on the report.
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.
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
Processing options enable you to specify the default processing for programs and reports.
These processing options enable you to specify which information the system includes on the Bill of Lading.
Specify the unit of measure that the system uses to display the weight totals.
Specify whether the system prints delivery instructions.
Specify whether the system prints shipment attachments.
Specify whether the system prints routing entry attachments.
Specify whether the system prints options and equipment information.
Specify a global message that appears on each document. Examples include engineering specifications, hours of operation during holiday periods, and special delivery instructions.
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.
Specify whether to consolidate item or parts on the Demand Scheduling Bill Of Lading.