Brokerage and Forwarding

Job Details

The Job page is accessed via Brokerage and Forwarding > Job Management > Job Details. Choose a Job ID and click Go/Refresh.

A job facilitates the Buy and Sell perspective so that you can easily visualize cost/revenue and therefore the profit margin on providing transportation services to a customer.

This page is very configurable.

The purpose of the job is to provide one business object that brings together the objects and activities required by logistics service providers. Below lists the primary functions the job provides:

  • The ability to group buy shipments, sell shipments, non-freight related charges, and customer bills related to a job and perform existing functions/actions against those objects.
  • International forwarders the ability to manage jobs from various perspectives depending on responsibility; for example, Export Only, Import Only, Import and Export, Consolidations, etc.
  • The ability to manage settlement functions at the job level.
    • View job profitability which includes all expenses and revenues related to the job.
    • Perform billing functions.
    • Manage non-freight related charges (both buy and sell).
  • A single outbound interface for a job.

The Job Detail page provides the following information:

  • The Consol ID if the job has a consol.
  • Order Releases that are assigned to the job with summary information such as object ID, locations, dates, weight/volume, and remarks.
  • Customer Bills
  • Revenue (including non freight-related charges) based on the bills that have been generated for the order.
  • Expenses incurred from the Buy shipments that have been created for the order.
  • Profit/loss based on the difference between the revenue and expenses.

Note: As you work on this page, remember to click Go/Refresh after performing actions or editing records.

By default, each section of the page is blank until you assign order releases to the job.

For each object that appears in the sections below, you can perform various SmartLinks and Actions that are available for that business object as well as click its ID to edit the object.

Click Actions on the Job Details page to perform specific actions for the job such as Add or Remove Order, Generate Customer Bill, etc.

You can also configure the appearance of some of the data columns and sections on this page.

Order Releases

This section of the page lists the order releases or order movements (depending on your configuration choice when the job was created) that are assigned to the job. Summary order information appears for each order in the list.

The property glog.job.financial.order.INVPARTY controls if the involved party displays in this section.

Level 1 Remarks also appear beneath each order release if the job is configured to show order releases.

If an order has related buy/sell shipments they automatically appear in the Expense/Revenue sections of this page, respectively.

Add/Remove Orders

Use the appropriate Job actions to assign/remove orders.

Customer Bills

Oracle Transportation Management supports customer billing at the shipment, consolidation, and job level.

The property glog.job.financial.custbill determines whether the Customer Bills section appears.

The primary billing functions provided at the job level are:

  • Create multiple bills for a job based on the sell shipments and non-freight related charges that are assigned to the job. To create a customer bill for a job, you must use the Generate Bill action at the top of the Job Details page.
  • Track incremental adjustments at the line level where the original bill is related to multiple sell shipments. Use the Bill Adjusted Costs action anytime you change or add sell shipments or non-freight related charges to create additional bills that reflect the changes.

You can also remove a bill using the Delete Bill action at the top of the page.

After the bill is created it will appear in this section (after a refresh). The Total Amount Billed is the sum of all customer bills related to the job.

Revenue

The Revenue section is divided into freight and non-freight sections. The following properties allow you to hide or display specific information:

Freight-Related Revenue

The first section shows the freight charges that result from the sell shipments that were created from one or more of the order releases that are assigned to the job. Several columns of summary shipment data appear including the shipment ID, shipment start and end date/time, source/destination location, service provider, transportation mode, and shipment cost. The following additional fields can appear if you configure the appropriate properties:

Field

Description

Display Property

Code ID (General Ledger)

Displays the General Ledger Code assigned to each shipment cost record if the same code applies for each cost record. If there are multiple cost records with different general ledger codes, the word MIXED appears.

You can manually assign a general ledger code to shipment cost records using the Shipment Manager Financials tab or they can be assigned using the Assign General Ledger Codes action.

For NFRCs, general ledger codes can also be entered manually or assigned via an NFRC Rule.

glog.job.financial.codeID

Payment Method Code

Displays the payment method code assigned to each shipment cost record if the same code applies for each cost record. If there are multiple cost records with different payment method codes, the word MIXED appears.

You can manually assign a payment method code to shipment cost records using the Shipment Manager Financials tab or they can be assigned using the Apply Payment Terms action.

For NFRCs, payment method codes can also be entered manually or assigned via a NFRC Rule.

glog.job.financial.paymentTerms

Total Weight

Displays the total weight of the shipment.

glog.job.financial.wgtvol

Total Volume

Displays the total volume of the shipment.

glog.job.financial.wgtvol

 

Secondary Charges

If a shipment has secondary charges, they appear indented beneath each shipment to which the secondary charges belong.

Non-Freight Related Revenue

By default, this section is blank until you record non-freight related charges that typically represent fees that are not necessarily associated with the actual transportation charges. Click New to create a new charge. The new button only appears if the glog.job.newNFRC property is configured to show it.

Note: You can also create NFRC rules that automate the creation of non-freight related charges.

Total Job Revenue

The Total Job Revenue is the total of all freight and non-freight related charges. This value determines the profit of the job (see below).

Expenses

The Expenses section is also divided into freight and non-freight sections.

The property glog.job.financial.amount determines whether the Allocation Amount, Total Amount, or both amounts appear in the Expense section.

The property glog.job.financial.buy.show_servprov enables you to show or hide the service provider field in this section.

The property glog.job.financial.buy.show_transportmode enables you to show or hide the transport mode field in the expenses section.

Freight-Related Expenses

The first section shows the freight charges that result from the buy shipments that were created from one or more of the order releases that are assigned to the job.

Secondary charges also appear beneath each buy shipment, if applicable.

Columns of summary shipment data, similar to the sell shipments above, appear for each buy shipment.

The Alloc Amt/Total Amt column displays the allocated cost vs the total cost of the buy shipment. The Alloc Amt column is populated after you successfully allocate the cost of a shipment.

The Amt fields determine the profit on a job as described in the Profit section below.

You can display Total Weight and Volume as well as the level of location detail shown by configuring a Job property.

You can also control whether to display both Alloc Amt and Total Amt fields or just one or the other. These display options determine how the Total Job Cost is calculated.

Non-Freight Related Expenses

You can record charges of this type from an expense perspective. See non-freight related revenue for details.

Total Job Cost

The Total Job Cost is the total of all freight and non-freight related charges. However, the way in which this is calculated depends on the display of the Alloc Amt and Total Amt fields. The display of these fields is controlled by a Job property mentioned above.

The following rules apply:

  • If both fields are displayed (default), the Total Job Cost is the sum of the Alloc Amt for each buy shipment plus all non-freight related revenue charges.
  • If only the Alloc Amt field appears, the above calculation is also true.
  • If only the Total Amt fields appears, the Total Job Cost is the sum of the Total Amt for each buy shipment plus all non-freight related revenue charges.

Profit

The Profit section shows the total profit (positive amount or loss (negative amount) for the job. Profit is calculated as Total Job Revenue minus the Total Job Cost.

The property glog.job.financial.show_profit enables you to hide or display this section (hidden when false). This can be domain-specific by adding the property as glog.job.financial.show_profit.DOMAIN.

Display Option Properties

You can control the display of specific columns/data on the Job Details page by configuring several job properties.

Related Topics