Inventory and Logisticspublic

Transportation Management

Get Involved. Join the Conversation.

This is a public Forum  public

Topic

    amiresi sathish
    Replace Element using Intsaved query
    Topic posted August 21, 2019 by amiresi sathishRed Ribbon: 250+ Points, last edited August 21, 2019, tagged Freight Payment/Billing/Claims, Integration, Setup, Transportation Management 
    27 Views, 1 Comment
    Title:
    Replace Element using Intsaved query
    Content:

    I have two questions to ask;

    1.       In the below highlighted reference is used to match the invoice to shipment, this field may have shipment id or order id, I case of order id I need to pull the shipment id and replace this xml element value with shipment id. Hope this can be done using integration saved query. But don’t know how to define saved query in xml.

                                             <InvoiceGid>

                                                    <Gid>

                                                           <DomainName>DOMAIN</DomainName>

                                                           <Xid>20190808-S-00007-001</Xid>

                                                    </Gid>

                                             </InvoiceGid>

                                             <TransactionCode>IU</TransactionCode>

                                             <InvoiceNum>20190820-PARENT-0003</InvoiceNum>

                                             <InvoiceDate>

                                                    <GLogDate>20190820100000</GLogDate>

                                                    <TZId>CET</TZId>

                                             </InvoiceDate>

                                             <InvoiceRefnum>

                                                    <InvoiceRefnumQualifierGid>

                                                           <Gid>

                                                                  <DomainName>DOMAIN</DomainName>

                                                                  <Xid>SHIPMENT_ID/ORDER_ID</Xid>

                                                           </Gid>

                                                    </InvoiceRefnumQualifierGid>

                                                    <InvoiceRefnumValue>DOMAIN.OR-00001</InvoiceRefnumValue>

                                             </InvoiceRefnum>

    2.       I am creating Consolidated Invoice and Child Invoices from integration and child invoices are matching with shipments. And using agent action, approval process takes place on parent/consolidated invoice. I have two issues here.

    a.       After parent invoice approvals, voucher is generated but the cost of voucher is zero (I assume by this time child invoices are not completely processed hence the cost is zero), if approve after few mins then voucher is generated with correct amounts.

    b.       For consolidated scenario, approval process should take place only on parent invoice, and system compares parent invoice amount with sum of child invoice shipments. But how to validate each invoice cost line with related shipment cost line?

    Could you please check these 3 points and let me know feedback.

    Version:
    6.4.1

    Comment

     

    • Karl Baker
      • OTM does not have the Int Saved Query ability on every element. Int Saved Query is used for finding gids. Currently Int Saved Query is available only on the Parent Invoice element and is meant to find the parent invoice. 

      Why do you need this replacement?

      • Consolidated Invoice approvals
        1. "After parent invoice approvals, voucher is generated but the cost of voucher is zero (I assume by this time child invoices are not completely processed hence the cost is zero), if approve after few mins then voucher is generated with correct amounts."   Can you please provide a scenario for this.  The voucher should be created with total net amount due of the consolidate invoice. Not sure why it is being shown as zero.
        2. How to validate each invoice cost line with related shipment cost line?
          1. As of now there is hard reference between the shipment costs and invoice lines.
          2. When OTM checks for line level tolerance, the assumption was that each of the shipment costs and invoice line would be unique for the combination of Cost Type, Accessorial Code, Payment Method and General Ledger code.
          3. If the costs and invoice line are provided in this manner then each of shipment cost can be matched to invoice line.
          4. But for this combination (Cost Type, Accessorial Code, Payment Method and General Ledger code) if there are multiple costs or multiple lines, OTM does not have any effective way of matching the costs and lines. The logic tries to sort each of the groups costs and lines by cost and starts matching each with the other and checks for tolerance.
          5. Once the tolerance checks are done, when creating the voucher, we just create the voucher with the invoice line items as voucher invoice line items and the sum of each of voucher invoice line items as the total amount of voucher.

       

     

    community forum