You can view item shipments with expediting information using the Expediting report.
Before you run this report, you must run a database job (assigned to the Expediting report) that prepares the data for this report. We recommend that you run this job at least once a day. For more details see Manage Synchronization Jobs.
-
This is an interactive report.
-
Click and select the column where you want to search, type the search criterion in the Search box, and click Go to apply the search.
-
To change the number of displayed rows, select a value from the Rows list.
-
Additionally, you can customize the report to meet your requirements, save the report, and download the result in csv or html format (see Use Actions menu).
You can click an agreement number to open the Details - Agreements and Line Items page, where the line items of the selected agreement appear. For more information, see Agreements and Line Items.
Click a requisition number to open the Requisitions page, where the line items of the selected requisition appear. For more information, see Requisitions.
You can click the Ident Code values to open the Ident Information page. For more information, see Ident Information.
All displayed data is retrieved from the P.70.72 Expediting Details screen in Smart Materials, except the following:
-
On-time Qty = Item Ship Qty – Delayed Qty.
-
Delayed Qty = Item Ship Qty with Delayed MRR Receive Days > 0.
-
Supplier Promised (CIP) – Is fetched by the m_pck_bir_custom.get_planned_ship_date CIP function. By default, the function returns the promised contract date (Prom Contract field on P.70.72 screen)
-
Supplier Actual (CIP) – Is fetched by the m_pck_bir_custom.get_actual_contract_date CIP function. By default, the function returns the actual contract date (PO Actual field on P.70.72 screen).
-
Delayed Supplier Delivery Days = Supplier Actual (CIP) – Supplier Promised (CIP).
-
Latest Item Receipt Date = Inventory Item Receiving Date (Recv Date field on Receiving screen).
-
Latest MRR Receipt Date = Material Receipt Date on MRR header (Matl Recv Date field on Receiving screen)
-
Latest MRR Post Date = The latest post date of an MRR related to the selected item shipment.
-
Delayed Supplier Qty = The quantity with Supplier Actual (CIP) later than Supplier Promised (CIP). If the Supplier Promised (CIP) is in the past, and the Supplier Actual (CIP) is empty (NULL), the item shipment is considered as delayed.
-
On-time Supplier Qty = The quantity with Supplier Actual (CIP) not later than Supplier Promised (CIP).
-
Delayed MRR Receive Days = Latest Item Receipt Date – Req On Site. If Req On Site is in the past the Latest Item Receipt Date is not available, the Delayed MRR Receive Days are calculated as Synchronization Job Run date – Req On Site.
-
Actual Ship Date = Is fetched by the m_pck_bir_custom.get_actual_ship_date CIP function. By default, the function returns the actual ship date (Actual Ship field on P.70.72 screen).
Data Sources
The table below shows the Smart Materials screen(s) where the data is entered that is displayed in this report. Additionally, this table shows the synchronization table and the CIPs used by the report, and the name of the log file created by the sync job or the report.
Screen |
P.70.72 Expediting Details |
Table |
P170_IR_DATA |
CIP |
m_pck_bir_custom.get_planned_ship_date (-> Supplier Promised (CIP)) m_pck_bir_custom.get_actual_contract_date (-> Supplier Actual (CIP)) m_pck_bir_custom.get_actual_ship_date (-> Actual Ship Date) m_pck_bir_custom.get_exp_cip1(to 10)_header (-> CIP1 to 10 label) m_pck_bir_custom.get_exp_cip1 to 10 (-> CIP1 to 10 value) |
Log File |
sync_p170_ir_......log |
The following table shows all values displayed in the report, with the related Smart Materials screen and field where the value is displayed, the database table and column where the value is stored, and CIPs, functions, or procedures that are used to retrieve the value. Optionally, additional comment on the value is entered in the last column.
Value |
Screen |
Field |
Database Column |
Other Source/Comment |
---|---|---|---|---|
Project |
P.70.71 |
Project |
m_req_to_pos.proj_id |
|
Agreement Number |
P.70.71 |
Order Number |
m_po_headers.po_number |
|
Original Order Type |
P.70.71 |
Type |
m_pck_mscm.fetch_po_type(poh_id) Order type of supplement 0 |
|
Engineering Requisition |
P.70.71 |
Engineering Requisition |
m_req_to_pos.r_id (-> m_reqs.r_code) |
|
Supplier |
P.70.71 |
Supplier |
m_po_headers.sup_id (-> m_suppliers.sup_code) |
|
Expediter |
P.70.71 |
Expediter |
m_pck_exped_workload.get_expediter(base_poh_id,r_code,origin_code) |
|
Inspector |
P.70.71 |
Inspector |
m_pck_exped_workload.get_inspector(base_poh_id,r_code,origin_code) |
|
Company |
P.70.71 |
m_po_headers.sup_id (-> m_suppliers.company_id -> m_companies.company_name) |
||
Buyer |
P.70.71 |
Buyer |
m_po_headers.buyer |
|
Origin |
P.70.71 |
Origin |
m_po_headers.origin_id (-> m_origins.origin_code) |
|
Pos |
P.70.72 |
Pos |
m_po_line_items.poli_pos |
|
Sub Pos |
P.70.72 |
Sub Pos |
m_po_line_items.poli_sub_pos |
|
IS Pos |
P.70.72 |
IS Pos |
m_item_ships.item_ship_pos |
|
IS Sub |
P.70.72 |
IS Sub |
m_item_ships.item_ship_sub_pos |
|
Item Type |
P.70.72 |
Item Type |
m_item_ships.ident (-> m_idents.commodity_id -> m_commodity_codes.ity_id -> m_item_types.ity_code) |
|
Commodity Code |
P.70.72 |
Commodity Code |
m_item_ships.ident (-> m_idents.commodity_id -> m_commodity_codes.commodity_code) |
|
Ident Code |
P.70.72 |
Ident Code |
m_item_ships.ident |
m_pck_mscm.get_ident_code(ident) |
Short Description |
P.70.72 |
Ident Short Description |
m_pck_std_custom.ident_desc |
|
Tag Number |
P.70.72 |
Tag Number |
m_item_ships.tag_number |
|
Incoterm |
P.70.72 |
Incoterm |
m_item_ships.frt_id (-> m_freight_terms.frt.code) |
|
Delivery Place |
P.70.72 |
Delivery Place |
m_po_line_items.freight_value |
|
Delivery Type |
P.70.72 |
Delivery Type |
m_item_ships.dd_id (-> m_delv_desigs.dtp_id -> m_delv_types.dtp_code) |
|
Delivery Designation |
P.70.72 |
Delivery Designation |
m_item_ships.dd_id (-> m_delv_desigs.dd_code) |
|
Routing Method |
P.70.72 |
Routing Method |
m_item_ships.rm_id (-> m_routing_methods.rm_code) |
|
Order Quantity |
P.70.72 |
Order Quantity |
m_po_line_items.poli_qty |
|
Item Ship Quantity |
P.70.72 |
Item Ship Quantity |
m_item_ships.item_ship_qty |
|
Received Quantity |
P.70.72 |
Received Quantity |
m_pck_expediting.get_rec_qty_ship(item_ship_id) |
|
Latest MRR Receipt Date |
P.70.72 |
Material Receipt Date on MRR header (Matl Recv Date field on Receiving screen) |
||
Quantity Unit |
P.70.72 |
Quantity Unit |
m_item_ships.ish_qty_unit (-> m_units.unit_code) |
|
Supplier Promised (CIP) |
P.70.72 |
m_pck_bir_custom.get_planned_ship_date |
||
Supplier Actual (CIP) |
P.70.72 |
m_pck_bir_custom.get_actual_contract_date |
||
Delayed Supplier Delivery Days |
P.70.72 |
Supplier Actual (CIP) - Supplier Promised (CIP). If Supplier Actual (CIP) is not available, the Delayed Supplier Delivery Days are calculated as Synchronization Job Run date – Supplier Promised (CIP). |
||
On-time Supplier Quantity |
P.70.72 |
The quantity with Supplier Actual (CIP) not later than Supplier Promised (CIP) |
||
Delayed Supplier Quantity |
P.70.72 |
The quantity with Supplier Actual (CIP) later than Supplier Promised (CIP). If the Supplier Promised (CIP) is in the past, and the Supplier Actual (CIP) is empty (NULL), the item shipment is considered as delayed |
||
Req On Site |
P.70.72 |
Req On Site |
m_item_ships.req_site_date |
|
Latest Item Receipt Date |
P.70.72 |
Inventory Item Receiving Date (Recv Date field on Receiving screen) |
||
Delayed MRR Receive Days |
P.70.72 |
Latest Item Receipt Date – Req On Site. If Req On Site is in the past the Latest Item Receipt Date is not available, the Delayed MRR Receive Days are calculated as Synchronization Job Run date – Req On Site |
||
On-time Quantity |
P.70.72 |
Item Ship Qty – Delayed Qty |
||
Delayed Quantity |
P.70.72 |
Item Ship Qty with Delayed MRR Receive Days > 0 |
||
Latest MRR Post Date |
P.70.72 |
Latest MRR Post Date |
The latest post date of an MRR related to the selected item shipment |
|
Item Ship Weight |
P.70.72 |
Item Ship Weight |
m_item_ships.item_ship_weight |
|
Weight Unit |
P.70.72 |
Weight Unit |
m_item_ships.weight_unit_id (-> m_units.unit_code) |
|
Forecasted Delivery Date |
P.70.72 |
Forecasted Delivery Date |
m_item_ships.delv_date |
|
Prom Ship Date |
P.70.72 |
Prom Ship |
m_item_ships.prom_ship_date |
|
Curr/Rev Prom Ship |
P.70.72 |
Curr/Rev Prom Ship |
m_item_ships.rev_prom_ship_date |
|
Prom On Site |
P.70.72 |
Prom On Site |
m_item_ships.forecast_eta_site_date |
|
Pred On Site |
P.70.72 |
Pred On Site |
m_item_ships.pred_on_site_date |
|
Actual On Site |
P.70.72 |
Actual On Site |
m_item_ships.actual_on_site_date |
|
Actual Ship Date |
P.70.72 |
Actual Ship |
m_pck_bir_custom.get_actual_ship_date |
|
Order Type |
P.70.71 |
Order Type |
m_pck_mscm.fetch_po_type(poh_id) |
|
CIP1 |
m_pck_bir_custom.get_exp_cip1_header m_pck_bir_custom.get_exp_cip1 |
|||
CIP2 |
m_pck_bir_custom.get_exp_cip2_header m_pck_bir_custom.get_exp_cip2 |
|||
CIP3 |
m_pck_bir_custom.get_exp_cip3_header m_pck_bir_custom.get_exp_cip3 |
|||
CIP4 |
m_pck_bir_custom.get_exp_cip4_header m_pck_bir_custom.get_exp_cip4 |
|||
CIP5 |
m_pck_bir_custom.get_exp_cip5_header m_pck_bir_custom.get_exp_cip5 |
|||
CIP6 |
m_pck_bir_custom.get_exp_cip6_header m_pck_bir_custom.get_exp_cip6 |
|||
CIP7 |
m_pck_bir_custom.get_exp_cip7_header m_pck_bir_custom.get_exp_cip7 |
|||
CIP8 |
m_pck_bir_custom.get_exp_cip8_header m_pck_bir_custom.get_exp_cip8 |
|||
CIP9 |
m_pck_bir_custom.get_exp_cip9_header m_pck_bir_custom.get_exp_cip9 |
|||
CIP10 |
m_pck_bir_custom.get_exp_cip10_header m_pck_bir_custom.get_exp_cip10 |