Transportation Management

Get Involved. Join the Conversation.

Topic

    amiresi sathish
    Not able to Split the Invoice
    Topic posted July 10, 2018 by amiresi sathishRed Ribbon: 250+ Points, tagged Freight Payment/Billing/Claims, Operational Planning, Transportation Management 
    252 Views, 2 Comments
    Title:
    Not able to Split the Invoice
    Summary:
    Not able to Split the Invoice
    Content:

     

    Hi ,

    We are looking for solution on current flow which are following for Multi-payer invoicing. A site of Customer has two divisions, Industrial and Automotive. 
     This site has one logistics department. Say for example, Indistrial order is 300 KG and Automotive order is 700 KG 
     The rates are like 
     0.1 to 500 KG - 10 EUR per 100 KG 
     500.1 to 1000KG - 7.5 EUR per 100 KG 
     So, if i build shipments separately, for Industrial, i will be paying 10 * 300/100 = 30 EUR 
     For automotive i will be paying, 7.5 * 700/100 = 52.5 EUR 
     So a total of 82.5 EUR 
     Whereas, if i combine both orders, i will be paying 7.5 * 1000/100 = 75 EUR 
     So, in order to achieve the consolidated cost, they build and send it on 1 shipment. However, when paying the carrier, they want to make payment such as 30% of 75 EUR from Industrial and 70% of 75 EUR from Automotive. 
     This is because of legal and VAT considerations. 

    Now let me brief about OTM setup:

    1. Plan the orders --> Shipment --> Allocation --> Invoice --> Voucher (Maintains )

    2. Interface Allocation base to ERP

    3. in Middle wear consider depart from Involved party from Release inv party from allocation base xml. They can consider only one Department. 

    So tried below approaches

    1. Perform shipment recharge - Not at all working raised a SR with Oracle

    2. create buy shipments --> Allocate shipment based upon Order weight --> Create sell shipment based upon 'Order release allocated cost'

    --> here if i use allocation on header its effecting other orders since they follow Line level allocation.

    Can anyone suggest solution to issue separate  invoices for each department..

    Thanks in Advance.

     

    Comment

     

    • Karl Baker

      Amiresi,

      OTM does support the generation of multiple invoices for a shipment - but the current split rule criteria can only support the following criteria:

      • Per Shipment Cost Lines
      • Per Shipment Cost Type
      • Per Shipment Cost Accessorial

      I can not think of a way to use the existing functionality to support the business division and weight allocation method you require. 

       

      Below is the Help topic that covers the current Split Rule Criteria and capabilities.

      Split Rule Criteria

       Related Topics

      This page is accessed via Financials > Power Data > General > Split Rule > Split Rule Criteria field.

      Before an invoice or bill is created, OTM verifies if there is a split rule defined for that process. Using the split rule, OTM generates single or multiple invoices/bills which are based on the split rule criteria. The split rule criteria can be any of the following:

      • Per Shipment Cost Lines
      • Per Shipment Cost Type
      • Per Shipment Cost Accessorial

      Example

      Let's look at an example where a shipment is defined with cost as shown in the below table:

      S.No

      Cost Type

      Shipment Cost

      Accessorial Code

      Special Service Code

      1

      Base

      US$ 5000

       

       

      2

      Accessorial

      US$ 500

      UNLOADING

      UNLOADING

      3

      Accessorial

      US$ 300

      PACKING

      PACKING

      4

      Accessorial

      US$ 400

      LOADING

      LOADING

      5

      Accessorial

      US$ 700

       

       

      6

      Accessorial

      US$ 100

       

       

      7

      Accessorial

      US$ 200

      HANDLING

       

       

      OTM uses the split invoice criteria to split the invoices.

      Per Shipment Cost Lines

      If you select 'Per Shipment Cost Lines,' then OTM generates one invoice for each cost line. From the above example, you see that there are seven cost lines defined in a shipment. OTM will generate seven invoices, one invoice for each cost line (one invoice is for base cost line and other six are for accessorial cost lines).

      Per Shipment Cost Type

      If you select 'Per Shipment Cost Type', then OTM splits the invoice based on the cost types defined for the shipment.

      The valid shipment cost types are:

      • Accessorial
      • Base Cost
      • Circuitry
      • Delta
      • Discount
      • Stop-off
      • Other

      Based on the above example, OTM generates one invoice for each cost type. There are seven cost lines defined for that shipment but only two distinct cost types, so OTM will create two invoices in this case (one for base cost and one for all accessorial costs).

      Per Shipment Cost Accessorial

      If you select 'Per Shipment Cost Accessorial' then OTM generates a separate invoice or bill for each distinct accessorial cost and then generates an additional invoice or bill which contains all other costs such as Base cost, Circuitry, Delta, Discount, Stop-off, and Other.

      Based on the above table, the following details explain how OTM generates invoices when you select the per accessorial cost split rule criteria:

      • One invoice for each distinct accessorial cost with accessorial code and special service code: In the above table, there are three accessorial costs with an accessorial code and a special service code. So OTM will generate three invoices for these accessorial costs.
      • One invoice for distinct accessorial cost with an accessorial code but without a special service code: In the above table, there is one accessorial cost with an accessorial code but no special service code. So OTM will generate one invoice.
      • One invoice for all accessorial costs without an accessorial code: In the above table, there are two accessorial costs without an accessorial code or special service code. So OTM will generate one invoice for both the accessorial costs.
      • One invoice for all other costs: In the above table, there is one cost other than accessorial. So OTM will generate one invoice for this base cost.

       

       

    • LAKSHMIDEEPAK GADDIPATI

      Hi,

      I am not sure what ERP you are using. But any ERP should have GL,COST/PROFIT center . So assigning GL/other attributes at order level and sending a allocation base and let ERP assign the cost to respective GL and COST/PROFIT centers.

       

      Thanks,

      Deepak