Import purchase order headers using data management

(5) Share

Report

Posted on by ZM-04120653-0

Hi All,

I am new in functional consultancy. I am trying to import Purchase order headers using data management and receiving the below error:

Results. Field 'Purchase order' does not allow editing.
Results. Invalid specification of Purchase order
Results. Number sequence Purc_3 does not allow change to a higher number.
Results. Field 'Purchase order' does not allow editing.
Results. Invalid specification of Purchase order
Results. Number sequence Purc_3 does not allow change to a higher number.
Results. Validation of field 'Settlement type' failed
Results. Validations failed

I would appreciate guidance on this please.

Thank You

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (6)

Answers (5)

Sort by

Verified answer

Waed Ayyad 9,135 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Did you set the Purch table field on the import field? If yes, are you sure you follow the number sequence of Purch table? you can remove it from the import file and set it to be auto on the mapping of the fields.

Regarding Validation of field 'Settlement type' failed, what is the value that you added on the file?

Also, I suggest you create an export file with filter on one purchase order only in order to see how fields are set on the file.

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Verified answer

ZM-04120653-0 35 on at

Like (0)

Report
Copy link

Link copied!

"None" for the value in the Settlement Type Field.

Was this reply helpful? Yes No
Verified answer

Aymen CHELBI 620 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hello,

You have multiple errors, I suggest you try all these steps below :

Check Number Sequence settings (Organization Administration > Number Sequences).

Remove the PO number from the import file and let the system assign it.

Verify Settlement Type values.

Ensure POs don’t already exist.

Best regards,

Was this reply helpful? Yes No
Waed Ayyad 9,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Do you still need help?

Was this reply helpful? Yes No
Verified answer

Sagar Suman 6,775 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

HI,

You are getting the error for the PO number because the number sequence Purch_3 is setup to give automatic numbers, and you are trying to import the numbers by adding them in the file which is creating conflict.

1 - Want to use old PO numbers - Please set the number sequence to manual

2 - Want to use system generated numbers based on number sequence - Keep the purchase order numbers field blank in the import file and system will give the numbers.

Navigation Procurement and sourcing > Procurement and sourcing parameters > Number sequence > Purchase order

If you want to use your old PO numbers than make sure you set this to manual for time import is taking place and after that revert it,

For settlement type make sure none value is added with no special characters. Try and copy all the data into a fresh sheet and import again.

Was this reply helpful? Yes No
Verified answer

AnilCh 18 on at

Like (0)

Report
Copy link

Link copied!

Hi

Change the number sequence automatic to manual and mentioned the required PO in number in the imported file.

Was this reply helpful? Yes No