Import Scenario - the system failed to commit the transaction row

I’ve also tried this and still not working:

Hii ​@RacheleDickie ,

This error usually occurs when the import scenario doesn't properly finish one Purchase Order before starting the next. Since the first PO imports successfully, I'd verify that the scenario correctly identifies the beginning of each new document (Order Type and Order Nbr. as Key fields), commits the header only after it's fully populated, and executes Save only once after all detail lines are imported.

I also noticed the mapping includes <Line Number> twice with =-1. Normally only one <Line Number> mapping is needed when inserting new lines, so I'd remove the duplicate and test again.

If the issue still occurs, I'd also check whether any header fields (Vendor, Branch, Date, etc.) are changing before the previous document is saved, as that can also trigger the "The system failed to commit the transaction row" error. 

Mapping should be like this :

<Key: OrderType>

Type = "Normal"

Vendor = Vendor

Date = Date

Vendor Ref. = VendorRef

Promised On = DueDate

<Line Number> = -1

Inventory ID = ItemCode

Order Qty. = Qty

Unit Cost = Price

<Action: Save>

​@tareshpatil51 After save you have one more action dialog box- move forward before save.

Thank you for sharing your solution with the community ​@RacheleDickie!