Troubleshooting
Problem
Publishing invoices by SendInvoice agent does not split line charges based on quantity in IBM Sterling Order Management.
Symptom
Steps to replicate:
- Create an order with one line having 3 quantity, where unit charge is 34$ and line charge is 102$.
- Fulfill this order using two shipments - one shipment with one quantity and another shipment with 2 quantity.
- Create invoice for these shipments
- 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.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21964165