Trying to import line items to a sales order gives error: The system failed to commit the splits row. What does this mean?

Thanks.  Attached is the import scenario XML.

Just a bit of background to explain what I am doing.

We are about to go live having been working on moving from an old system to Acumatica. I have exported all the backorders that have been put in during the testing phase via a GI which we want to import into the system once we clear all the test data out.

I exported all SO information except SOLine data and reimported putting the old SO Number as Customer Order Number so we have a reference to the old number to match with the autonumbered new records.  I exported the SOLine data also separately and am just trying to get that back in against the newly created SO.

The first phase went fine and the new SO exists with the number specified in New Order No. I tested with just updating the external reference and doing nothing with line items and that is now working so I know it is finding the new SO.  When I try to import the Line items back in I get the error about splits row.

Thanks for any help,

Phil

Hello, I see Naveen answered. I too was able to import lines to existing Sales Order with a little bit different import scenario from Naveen’s. I simply added the four required Sales Order Details columns to my Excel, building 4 more columns on the spreadsheet I showed you earlier this morning.

Good luck!

Thanks both for your replies. I accidentally marked Laura’s reply as best answer but I was trying to mark Naveen’s. The problem was I was using Line Details instead of Details and both of your screenshots showed me that but I saw Naveen’s first.

I don’t seem to be able to change the best answer to Naveen.

Thanks both for all your help.  You are both lifesavers!

Phil

Hi @ppowell I have fixed the Answer 😀