IBM Support

The invoice published by Send invoice transaction did not have line charges split based on quantity

Troubleshooting


Problem

Publishing invoices by SendInvoice agent does not split line charges based on quantity in IBM Sterling Order Management.

Symptom

Steps to replicate:

  1. Create an order with one line having 3 quantity, where unit charge is 34$ and line charge is 102$.

  2. Fulfill this order using two shipments - one shipment with one quantity and another shipment with 2 quantity.

  3. Create invoice for these shipments

  4. Trigger the send invoice transaction as agent.

    The invoices published by the agent have the complete line total under line charges.
    Consider the invoice for shipment with two quantity. The invoice published by SendInvoice agent had -
    <LineCharges>
    <LineCharge ChargeAmount="102.00" ChargeCategory="LineInfo" ChargeName="ChargeName" ChargeNameKey="20130621083344104298518" ChargePerLine="102.00" ChargePerUnit="0.00"
    InvoicedChargeAmount="102.00" InvoicedChargePerLine="102.00" InvoicedChargePerUnit="0.00" IsBillable="N" IsDiscount="N" Reference="" RemainingChargeAmount="0.00" RemainingChargePerLine="0.00" RemainingChargePerUnit="0.00"/>
    </LineCharges>

    Expected output ( as seen in getInvoicedetails)
    <LineCharges>
    <LineCharge ChargeAmount="68.00" ChargeCategory="LineInfo" ChargeName="ChargeName" ChargeNameKey="20130621083344104298518" ChargePerLine="68.00" ChargePerUnit="0.00" IsBillable="N" IsDiscount="N" IsManual="Y" IsShippingCharge="N" OriginalChargePerLine="0.00" OriginalChargePerUnit="0.00" Reference=""/>
    </LineCharges>

Cause

Incorrect template being used for SendInvoice.

Diagnosing The Problem

The OOB template has <LineCharges> under the tab <LineDetails>, while the template being used by you has <LineCharges> under <OrderLine>.
The tables yfs_line_charges and yfs_tax_breakup have different entries for record_type INV and ORD. The entry for record_type ORD is made at the time of order creation and record_type INV at the time of invoice creation. Due to incorrect template, Send invoice was using the entry of type ORD rather than INV.

Resolving The Problem

Follow the template provided by the product to achieve the expected output.

[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21964165

Page Feedback