Hi ,
I made an import scenario to override the subaccount of some sales orders. It keep gives me an error preventing the upload. Could you please anyone check and assist me with the upload?
I have attached the Import scenario here.
Thanks,
Dulanjana
Answer
Import Scenario to Update SO Line - Sub account
Best answer by lauraj46
Hi
When posting your question, it’s helpful to include the error message that you received. That being said, I took a look at your import scenario and it looks like the problem is with your detail line lookup.
On the <Line Number> row, a value of -1 means to insert a new detail record. Your scenario is attempting in insert a new detail record, and populate the line number and subaccount.
I’m guessing that instead you are trying to update an existing line. There are a couple of approaches to do this:
- Instead of -1, specify an index for the detail row to update. This should be the [SOLine.SortOrder] field minus 1.
- If the SKUs are unique on an order, you can make the <Line Number> row inactive (it can’t be deleted).
Hope this helps!
+8Hi
When posting your question, it’s helpful to include the error message that you received. That being said, I took a look at your import scenario and it looks like the problem is with your detail line lookup.
On the <Line Number> row, a value of -1 means to insert a new detail record. Your scenario is attempting in insert a new detail record, and populate the line number and subaccount.
I’m guessing that instead you are trying to update an existing line. There are a couple of approaches to do this:
- Instead of -1, specify an index for the detail row to update. This should be the [SOLine.SortOrder] field minus 1.
- If the SKUs are unique on an order, you can make the <Line Number> row inactive (it can’t be deleted).
Hope this helps!
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.