Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Creating multiple invoice lines per invoice fails - Juniper HF #4(Harrassowitz Chicago)

Description

Current workaround Manual entry

Steps to Reproduce:

  1. Scenario

    • Go to Juniper Bugfest

    • Go to Settings/Data Import and review the Job/Action/Field mapping profiles for Create Large Harrassowitz serial invoice IMD+L and the attached invoice file 20201114072017.EDI and Word version 20201114072017.edi.docx and confirm that the field mappings are correct

    • Go to Data Import and upload the file 20201114072017.EDI

    • Assign the Harrassowitz job profile cited above, and import the file

Expected Results: should create 9 invoices with a total of 1326 line items

Actual Results: did not complete

Additional Information: EDIFACT files (file extension .edi) and corresponding human-readable Word versions (file extension .docx)

Import fails with the following error

It is related to the number of invoice lines per invoice that are being created. If there are too many the query above becomes too large and the request fails

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2

blocks

clones

defines

is cloned by

relates to

Checklist

hide

TestRail: Results

Activity

Show:

Ann-Marie Breaux November 29, 2021 at 9:50 AM

Tested on Juniper BF, using the file and job profile specified above, and it worked beautifully! Checked all invoice lines on all invoices, and the counts are accurate. Closing this issue.

cc: Thank you for all the great work on this! I know it has been a long trek, but I think the invoice importing is much more performant and stable than previously. Great job!

cc:

Oleksii Petrenko November 26, 2021 at 4:34 PM

Deployed to Juniper BF. Please proceed with verifications

Done

Details

Assignee

Reporter

Tester Assignee

Labels

Priority

Story Points

Sprint

Development Team

Thunderjet

Parent

Fix versions

Release

R2 2021 Hot Fix #4

RCA Group

Implementation coding issue

Affected Institution

Cornell
TAMU
University of Chicago

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created November 24, 2021 at 12:28 PM
Updated June 27, 2022 at 9:29 AM
Resolved November 26, 2021 at 3:27 PM
TestRail: Cases
TestRail: Runs