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

(0) Share

Report

Posted on by SJ-16091251-0

201

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 (5)

Answers (0)

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

Like (0)

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 6 on at

Like (0)

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.

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

Like (0)

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 201 on at

Like (0)

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 6 on at

Like (0)

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