Basic OTM Configurations - 07 - Invoicing

Note: This post is continuation to topic: Basic OTM Configurations - 01 and these configurations are specific to business scenario mentioned in that post. Link below to that post for quick reference:

Basic OTM Configurations - 01 - Domain, Items, Locations, and Equipment

https://www.oracle-otm.com/2020/08/basic-otm-configurations-01-domain.html

Invoicing

Once Shipment execution is completed, carrier sends invoice and OTM can:

• Match invoice to shipment based on MATCH rule

• Approve Invoice based on Invoice APPROVAL rule

• Allocate shipment costs to related order releases/POs based on weight or volume

Invoice Matching:

Carrier who executed the shipping function will send an freigh charge invoice for settlement.

In OTM, we can validate this invoice cost against the OTM planned shipment cost by first matching invoice to a shipment.

This can be done by matching rule.

Financials > Payment Rule Management > Match Rule: 

 

A match rule will try to identify a shipment for an invoice by matching:

·        Service Provider

·        Refnums as shown above. Here we are creating invoice with SID (Shipment ID) as refnum and matching this to shipment refnum SID. In a real time business scenario these numbers can be BOL Number, Container Number references, etc.

To trigger this matching process go to:

Invoice Actions > Auto Match Invoices

 

Invoice once matched to a shipment will be recorded in below table:

SELECT * FROM INVOICE_SHIPMENT WHERE INVOICE_GID = 'TCRP.20180518-0001'

Invoice Routes/Ports tab will show Match/approval notes, matched shipment details

 

Invoice Approvals

For a particular user to approve an invoice, note that OTM checks what is the invoice approval rule attached to the user definition.

So, create below invoice approval rule:

Financials > Payment Rule Management > Invoice Approval Rules:

 

 

This rule says approve all invoices from $1 to $1000.

Attach this rule to Approval Rule profile:

 

Attach this profile to the user record: 

 

Now we can approve invoice using below action: