Hi,
I am reaching out regarding a customer requirement related to importing Sales Orders through the Import Scenario.
The customer needs to upload invoices in bulk, where each invoice contains multiple line items. We identified that column wise import of the Inventory Item field is not supported. Other fields can be mapped correctly, but the system consolidates the Inventory Items into a single line instead of creating separate lines for each item.
Customer Requirement
– Ability to import Sales Orders with multiple line items using an Excel template.
– Each Inventory Item should appear as a separate line in the Sales Order during import.
Issue Observed
– The Import Scenario does not support column-wise mapping for the Inventory Item field.
– Inventory Items are not created as separate lines.
Could anyone confirm whether Acumatica supports this functionality? If not, could you suggest an alternative approach to handle this requirement?
