Finance forum

Sales Order Import through Data Management

(0) Share

Report

Posted on by Manikandan Boopathy M

Dear All,

I'm trying to import sales order's through Data Management.

I had successfully imported the Sales Order Header data.

When i import Sales Line Data(using entity : sales order line V2)

i'm getting the following error

"Results. update not allowed for field 'Sales order(SalesOrderNumber)'

Results. Validations failed"

Note: Number Sequence Setup against the Sales Order is set to manual.

Regards,

Manikandan.

Categories:

Development / Customization / SDK

I have the same question (0)

All responses (18)

Answers (1)

fatihgork 3,817 on at

Like (0)

Report
Copy link

Link copied!

Hi,

See below for a few quick checks:

- Make sure you line number is not the same within same sales order #.

- Make sure sales order number is present in your file and you do not select "Auto generate" for this field in mapping

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Manikandan,

Do you import SO header entity and SO line entity at the same time?

If so, please try to import separately, first SO header, then SO line.

Was this reply helpful? Yes No
Manikandan Boopathy M 65 on at

Like (0)

Report
Copy link

Link copied!

Hi Mr. Fatih,

Thank you for the reply and your valuable time.

1.Line Number is not same for each sales order #.

2.Sales order number is present in my file and where can i find "Auto generate" for the field mapping.

Thanks,

Manikandan.

Was this reply helpful? Yes No
Manikandan Boopathy M 65 on at

Like (0)

Report
Copy link

Link copied!

Hi Mattguo,

Thank you for your time and reply.

I imported SO header entity separately and it is successful.

When i try to import SO line entity i'm getting the above mentioned validation result.

Thanks,

Manikandan.

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Manikandan,

Please change the value of inventorylotid in excel.

Was this reply helpful? Yes No
Manikandan Boopathy M 65 on at

Like (0)

Report
Copy link

Link copied!

Hi Mattguo,

The value of Inventorylotid is different for all the lines.Should i give same for all the lines under single SO# ?

Regards,

Manikandan.

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Manikandan,

No, you should not give same value for all line.

Please check the value of inventorylotid already exists in other SO line.

If so, please change the value different from other SO line.

Was this reply helpful? Yes No
Manikandan Boopathy M 65 on at

Like (0)

Report
Copy link

Link copied!

Hi Mattguo,

The value for inventorylotid is different for all the lines.

Still i'm getting the same result.

"Results. update not allowed for field 'Sales order(SalesOrderNumber)'

Results. Validations failed".

Regards,

Manikandan.

Was this reply helpful? Yes No
Verified answer

MATTGUO 22,349 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Manikandan,

I have two SOs, "001311" and "001312"，"001311" has one line and the lot id is "013541". Now i want to import line into SO "001312" and there is same lot id as SO "001311", so i will get the same error as yours.

SO “001311”：

SO “001312”：

Error:

When i change the lot id to "013542" in SO "001312", i successfully import it.

Can you use one line to test to better find the reason ?

Was this reply helpful? Yes No
Manikandan Boopathy M 65 on at

Like (0)

Report
Copy link

Link copied!

Hi Mattguo,

Thank you the above mentioned points.

I can resolve the issue when i change the setup for number sequence of the inventorylotid as manual.

I have a doubt, whether i should add inventorylotid column in my file?

if yes, can i give manually the values for inventorylotid?

i tried manually by assigning some values for inventorylotid

it gives me the following result

"

Results. Field 'Lot ID' does not allow editing.

Results. Invalid specification of Lot ID

Results. Number sequence Inve_162 does not allow change to a lower number.

Results. Validations failed

"

What should be the number sequence set up for inventorylotid?

Below is my number sequence set up for inventorylotid

Thanks,

Manikandan.

Was this reply helpful? Yes No