Supply chain | Supply Chain Management, Commerce

Generate automatic number sequences for sales and purchase order through data entity import

(2) Share

Report

Posted on by SJ-16091251-0

300

I am trying to import bulk sales and purchase orders. I have a number sequence set up for both of them as below:

When I try to import new sales orders, I am getting errors as below:

How can I generate the sales order numbers automatically?

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (12)

Answers (0)

Martin Dráb 238,763 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

You haven't told us whether you've configured sales ID as auto-generated in DMF source mapping. Please check that.

Was this reply helpful? Yes No
Imran Mustafa001 124 on at

Like (2)

Report
Copy link

Link copied!

Steps to fix the issue
Open your Excel or CSV template that you are using for the data import.
Look for the fields where you mapped Sales order number or Purchase order number.
Remove these mappings completely leave these fields blank or unmapped.
Save your updated file.
Go back to the data management workspace in D365.
Re-validate the entity to make sure there are no mapping errors.
Run the import again.
After this, the system will automatically generate the sales and purchase order numbers using the number sequences.

1 people found this reply helpful.

Was this reply helpful? Yes No
SJ-16091251-0 300 on at

Like (1)

Report
Copy link

Link copied!

@Martin Dráb @CU05071437-0- I did set it as Auto generated.

Have kept the sales order number field blank in excel that I am importing.

Am I missing out on something?

Was this reply helpful? Yes No
SJ-16091251-0 300 on at

Like (1)

Report
Copy link

Link copied!

@Martin Dráb / @CU05071437-0 - When I generate using the methods suggested above, the data is getting created as below which is not a per my number sequence. Do I need to define a number sequence anywhere:

Was this reply helpful? Yes No
Imran Mustafa001 124 on at

Like (2)

Report
Copy link

Link copied!

You can modify the sequence number to align with your predefined number sequence in the setup.

Was this reply helpful? Yes No
Martin Dráb 238,763 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

According to code in SalesOrderHeaderV4Entity.initValue(), it uses the number sequence defined for SalesId EDT (in Accounts receivable parameters). If it's not the case for you, I don't know why.

Was this reply helpful? Yes No
SJ-16091251-0 300 on at

Like (1)

Report
Copy link

Link copied!

@Imran Mustafa001 - Thanks for your reply. Where do you suggest to change the number sequence?

Was this reply helpful? Yes No
SJ-16091251-0 300 on at

Like (0)

Report
Copy link

Link copied!

@Martin Dráb - I have that setup as well. Wondering why it is still now working. Can it be because I have set it as continuous?

Was this reply helpful? Yes No
André Arnaud de Cal... 303,349 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can check if there are records in the status list for the number sequence. If so, then this can be indeed related to having the continuous option enabled. Try to disable the continuous setting.

Was this reply helpful? Yes No
Sagar121 1,151 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Is normal SO creation is taking correct number sequence?

Was this reply helpful? Yes No