Printing Shipping Reports

Depending upon your business requirements, you may need to print various shipping documents. PeopleSoft Inventory provides the following reports:

Note: In order to print the Canadian customs invoice, NAFTA certificate of origin, U.S. Certificate of Origin, and shipper's export declaration reports, you must first run the Export Documentation Table Load (OMS6110) process to populate the OM_EXPORT_DOC table (the master table for the export documentation reports).

All reports can be accessed by selecting Inventory > Fulfill Stock Orders > Shipping Reports

Page Name

Definition Name

Usage

Shipping Document Page

RUN_INC6503

Enter search criteria and launch this process to print shipping documents. This report provides a copy of the orders and order lines shipped in a specific shipping ID. This report is written in Oracle BI Publisher using the XMLP report name INX6503.

Bill Of Lading (report) Page

RUN_INS6100

Enter search criteria and launch this process to generate one or more bills of lading. The bill of lading report lists the demand lines consolidated into one shipment and summarizes, by destination, the total cartons and weight for each order and provides a summary total at the end of the report. The report can include either domestic or export bills of lading that were defined using the Build Bill of Lading component or created by the Build Bill of Lading Requests process.

Shipping Manifest (report) Page

RUN_INS6200

Enter search criteria and launch this process to generate shipping manifests. This process prints shipping manifests created on the Build Shipping Manifest page. A shipping manifest includes one or more bills of lading that have been consolidated into a single shipment, regardless of the ship to address.

Packing Slip Page

RUN_INS6500

Enter search criteria and launch this process to print packing slips. Packing slips lists the order number, ship to address, item information for shipping, manufacturer information, lot information and storage information. Print packing slips for all stock requests in a business unit or for an individual order number. The bar code prints on this report only for interunit transfers.

Export Pro Forma Page

RUN_INS6600

Enter search criteria and launch this process to print export pro forma reports. An export pro forma is a special invoice often requested by European customs officials to verify consignment details for export and import duty clearance. Unless you select a specific order, the report extracts all shipped sales orders and intercompany transfers belonging to this business unit and shipping ID (including those that have not yet been depleted).

Defer Invoicing Page

RUN_INS6700

Enter search criteria and launch this process to print defer invoicing reports. This report lists all shipments not yet invoiced; enabling you to monitor your compliance with Italian law regarding deferred invoicing for shipments within Italy or involving third parties. This report can also be used for any similar requirements.

Canada Customs Inv Page (Canadian customs invoice)

RUN_OMC6114

Enter search criteria and launch this process to provide documentation for orders requiring a Canadian customs invoice. Before you can print this report, you must run the Export Doc Tbl Load page (export document table load page).

NAFTA Cert of Orig Page (NAFTA certificate of origin)

RUN_OMC6112

Enter search criteria and launch this process to provide documentation for orders requiring a NAFTA origin certificate. Before you can print this report, you must run the Export Doc Tbl Load page (export document table load page).

U.S. Certificate of Origin Page

RUN_OMC6111

Enter search criteria and launch this process to provide documentation for orders requiring U.S. origin certification. Before you can print this report, you must run the Export Doc Tbl Load page (export document table load page).

Shippers Exp Decl Page (shipper's export declaration)

RUN_OMC6113

Enter search criteria and launch this process to generate export declaration documentation for orders. Before you can print this report, you must run the Export Doc Tbl Load page (export document table load page).

Export Doc Tbl Load Page (export documentation table load)

RUN_OMS6110

Initiate the SQR that reads all of the bill of lading and shipment tables and then loads the data for the corresponding bills of lading into the OM_EXPORT_DOC table (the master table for the export documentation reports).

Field or Control

Description

Allow Printing Before Shipping

Displays the setup for this inventory business unit to enable shipping documentation to be created and printed early. To create or print shipping documents for demand lines in the fulfillment states of Unfulfilled, Releasable, Release, and Confirmed, the Allow Printing Before Shipping check box must be selected on the Setup Fulfillment – Shipping page. If this check box is clear, then you can only build and print shipping reports for demand lines in the Shipped and Depleted fulfillment states.

Print Bar Code or Print Bar Code on Report Flag

Select to print a bar code on the report. For the Bill of Lading report, this bar code is made up of the business unit and bill of lading number fields concatenated. For the Packing Slip report, the bar code prints only for interunit transfers and consists of the business unit, interunit ID, interunit line, and destination business unit fields concatenated. For both reports, the bar code can be used for the Interunit Receipt EIP.

Establish the default setting on the Setup Fulfillment component.

Page Break by Delivery ID

If the delivery management feature has been enabled in this inventory business unit, you can select this check box to cause a page break between delivery IDs. Deliveries are logical groupings of order lines that can be shipped together. PeopleSoft Inventory and Order Management can use these groupings for pricing sales orders, adding freight charges, and packing shipping containers. Each delivery is assigned a unique delivery ID.

See Understanding PeopleSoft Delivery Management and Freight Calculations.