Uploaded image for project: 'mod-invoice'
  1. mod-invoice
  2. MODINVOICE-331

Juniper - Approval failed invoice which built from order line with cost 0

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • P3
    • Resolution: Won't Do
    • 5.1.7
    • None
    • Standard Bug Write-Up Format
    • ACQ Sprint 128
    • 2
    • Thunderjet
    • Lotus R1 2022
    • Trinity College

    Description

      Overview:
      Trinity College is reporting seeing a transactions failed to create message for one of their invoices .

      Steps to Reproduce:

      1. Log into https://folio-iris.dev.folio.org/ as a user with admin permissions.
      2. Create an order with a $0.00 cost
        And 1 physical Item
        And fund distribution
        And currency GBP
      3. Create an invoice and add the order from step 2 as an invoice line and Amount for fund > 0 currency GBP
      4. Approve the invoice.
      5. Pay invoice

      Expected Results: Approval and payment are successfully $0.00 finished.

      Actual Results: Approval is failed,: 
      One or more transactions record(s) failed to be created

      Additional Information: 
      The network response is:

      1636106594873,"  ""errors"" : [ {"
      1636106594873,"    ""message"" : ""insert or update on table \""temporary_invoice_transactions\"" violates foreign key constraint \""paymentencumbranceid_transaction_fkey\"": Key (paymentencumbranceid)=(47cd5d37-de1b-4e09-a688-9febd69ba4aa) is not present in table \""transaction\""."","
      1636106594873,"    ""code"" : ""genericError"","
      1636106594873,"    ""parameters"" : [ ]"
      1636106594873,"  } ],"
      1636106594873,"  ""total_records"" : 1"
      

       
      Module versions:
      *mod-invoice-5.1.7
      mod-invoice-storage-5.1.1
      mod-finance-4.2.1
      mod-finance-storage-7.1.1*

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                dennisbridges Dennis Bridges
                Andrei_Makaranka Andrei Makaranka
                Dennis Bridges Dennis Bridges
                Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases