Page 20 - Guide to selling TMS Pro_031618
P. 20

REPORT TEMPLATES



          The Smart Reporting feature allows users to create and save their own report                                               Examples of sample reports and how to build them:
          templates. Below is the list of available columns for building reports within

          the Gelnius Grids.                                                                                                          1   Daily Carrier Manifest Report - Add columns:
                                                                                                                                             -  Case No            - WT                  - Consignee            - Length
                                                                                                                                             -  On bx              - Carrier             - ST                   - Width
          Number                              Ship Date                          Status
                                                                                                                                             -  Tracking Number    - Service Type        - ZIP                  - Height
          Ship Name                           Due Date                           Delivered
          Ship Address 1                      Inco Terms                         MIT Reference
                                                                                                                                      2   Delivery POD Report - Add columns:
          Ship Address 2                      Outer PK Quantity                  MIT Date
          Ship City                           Inner PK Quantity                  Created By                                                  -  Trans Number       -  Shipper Code       - Consignee Name       -  POD Name
                                                                                                                                             -  Carrier Tracking Number  - Shipper Name   - Consignee Address 1  -  Number of Pieces
          Ship State                          Total Weight                       Created Date
                                                                                                                                             -  Carrier Name       - Shipper Address 1   - Consignee Address 2  - Part Number
          Price                               Is Dangerous Goods                 Updated By
                                                                                                                                             -  Service Type       - Shipper Address 2   - Consignee City       - Weight
          Ship Country Code                   Trans Type                         Last Updated
                                                                                                                                             -  Total Base Cost    - Shipper City        - Consignee State      - Length
          Ship Postal Code                    Order Reference                    Total Weight (LB)
                                                                                                                                             -  Total Surcharge Cost   - Shipper State   - Consignee Postal     - Width
          Ship Contact Name                   Order Reference 2                  Total Weight (KG)                                           -  Total Net Cost     - Shipper Postal      - POD Date             - Height

          Ship Contact Phone                  Order Reference 3                  Total Volume (ft.)                                          -  Ship Reference     - Consignee Code      - POD Time
          Ship Contact Email  Address         Order Reference 4                  Total Volume (m)

          Cons Name                           Order Reference 5                  Actual Ship Date                                     3   Receiving Manifest Report - Add columns:
          Cons Address 1                      Order Reference 6                  Exception Date                                              -  Contact Name       - BOL                 - Date Notified
          Cons Address 2                      Order Reference 7                  Date Voided                                                 -  Carrier Name       - Date Received       - Description
          Cons City                           Pickup Request Number              Parent Consol Trans Number

          Cons State                          Carrier                            Master Waybill                                       4   Receiving Manifest Report - Add columns:
          Cons Postal Code                    Service Level                      Consol. Shipment Count                                      -  State Code         -  Carrier Service    - Date Est Ship

          Cons Country Code                   Carrier Track No                                                                               -  Shipment Count     - Trans Reference 1   - Shipper
          Cons Contact Name                   Routed Date                                                                                    -  Trans Number       -  Trans Reference 2  - Consignee
                                                                                                                                             -  Tracking Number    -  Date Received      - Payment Type
          Cons Contact Phone                  Carrier Booking Number
                                                                                                                                             - Carrier             - Date Packed
          Cons Email Address                  Received Date
          Billing Term                        Packed Date














          19   GELNIUS TMS PRO - GUIDE TO SELLING - CONFIDENTIAL & PROPRIETARY                                                                                  GELNIUS TMS PRO - GUIDE TO SELLING - CONFIDENTIAL & PROPRIETARY    20
   15   16   17   18   19   20   21   22