Details
Assignee
UnassignedUnassignedReporter
Tetiana ParanichTetiana ParanichPriority
P3Development Team
FolijetRelease
Trillium (R2 2025)RCA Group
TBDTestRail: Cases
Open TestRail: CasesTestRail: Runs
Open TestRail: Runs
Details
Details
Assignee
Unassigned
UnassignedReporter
Tetiana Paranich
Tetiana ParanichPriority
Development Team
Folijet
Release
Trillium (R2 2025)
RCA Group
TBD
TestRail: Cases
Open TestRail: Cases
TestRail: Runs
Open TestRail: Runs
Created January 27, 2025 at 2:53 PM
Updated March 12, 2025 at 1:54 PM
Preconditions:
Authorized user with following permissions is logged in:
Data Import File Upload - all permissions
Data import: Can upload files, import, and view logs
Settings (Data import): Can view, create, edit, and remove
Invoice: Can view, edit and delete Invoices and Invoice lines
Steps to reproduce:
Go to Settings/Data Import/Field mapping profiles
Find the Default - Harrassowitz serials invoice and go to Actions/Duplicate. Adjust the new field mapping profile:
Profile name: Test Harrassowitz invoice with space
Description: Delete
Batch group: Select one from the dropdown list
In the Invoice note field, add RFF+API[2] " " NAD+SU+++[1]
Vendor name: Click Organization lookup, find the Harrassowitz vendor and select it
Payment method: Select one from the dropdown list
Currency: delete the mapping and select USD
Description: Change the existing mapping from {POL_title}; else IMD+F+050+[4-5] to {POL_title}; else IMD+L+050+[4-5]
PO line number: Change the mapping from RFF+SNL[2] to RFF+LI[2]
Subscription info: Add IMD+L+085+[4-5] " " IMD+L+086+[4-5]
Subscription start date: Add DTM+194[2]
Subscription end date: Add DTM+206[2]
Comment: Add IMD+L+085+[4-5] " " IMD+L+086+[4-5]
Save the field mapping profile
Duplicate the field mapping profile you created in Step 2 and adjust as follows:
Profile name: Change to Test Harrassowitz invoice with hyphen
Invoice note field: Change to RFF+API[2] "-" NAD+SU+++[1]
Subscription info: Change to IMD+L+085+[4-5] "-" IMD+L+086+[4-5]
Comment: Change to IMD+L+085+[4-5] "-" IMD+L+086+[4-5]
Save the updated field mapping profile.
Go to Settings/Data import/Action profiles. Create a new Action profile by clicking Actions/New action profile
Name: Change to Test Harrassowitz invoice with space
Action: Create
FOLIO record type: Invoice
Click on Link profile, and select the Test Harrassowitz invoice with space field mapping profile
Save the profile
Go to Settings/Data import/Action profiles. Create a new Action profile by clicking Actions/New action profile
Name: Change to Test Harrassowitz invoice with hyphen
Action: Create
FOLIO record type: Invoice
Click on Link profile, and select the Test Harrassowitz invoice with hyphen field mapping profile
Save the profile
Go to Settings/Data import/Job profiles. Create a new Job profile by clicking Actions/New job profile
Name: Change to Test Harrassowitz invoice with space
Action: Accepted data type: EDIFACT
In the Overview, click +Action, and select the Test Harrassowitz invoice with space action profile
Save the profile
Go to Settings/Data import/Job profiles. Create a new Job profile by clicking Actions/New job profile
Name: Change to Test Harrassowitz invoice with hyphen
Action: Accepted data type: EDIFACT
In the Overview, click +Action, and select the Test Harrassowitz invoice with hyphen action profile
Save the profile
Now you should have 2 complete job profiles, one to test the multi-field syntax with a space between the elements, and one to test with a hyphen between the elements.
Go to the Data Import app
Import the attached MichHarrasowitzSerial.edi invoice file.
Select the Test Harrassowitz invoice with space job profile, run the job, and confirm
Go back to Data Import and impost the same invoice, this time using the Test Harrassowitz invoice with hyphen job profile
Pay attention to the job status.
Actual result: The job completed with errors after importing .edi file when mapping profile contains fields with hyphen.
Expected result: The job completed after importing .edi file when mapping profile contains fields with hyphen. The invoice and invoice lines are created.
Environment: https://bugfest-ramsons-aqa.int.aws.folio.org, https://bugfest-ramsons.int.aws.folio.org