Finance | Project Operations, Human Resources, ...

How long the normal import customer and vendor master in average ?

(0) Share

Report

Posted on by Teevo

362

Hi guys,

Just curios to know, when we import customer master, with DMF, with some normal (basic) information of customer data, contact persons and addresses.

How much record is the average per minute ?

Same question about vendor as well. Btw, this is for D365 FO, not AX or on-premise.

Because some say, for customer, it may took 5 records only per minute, so for 400 customer only can takes up to 1.5 hours. Now I have 6,000, not included few contact person in 1 customer, and few addresses for 1 customer. I'm getting dizzy to even think about the upload process for how long.

For vendor, I have close to 10,000 vendors.

Thanks,

All responses (3)

Answers (0)

Layan Jwei 7,349 Super User 2024 Season 2 on at

Like (0)

Report

How long the normal import customer and vendor master in average ?

Hi Teevo,

is your questions answered? if yes then please verify the answers that helped. Thanks.
Suggested answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (1)

Report

How long the normal import customer and vendor master in average ?

There are many variables, as Layan alludes to, including how many fields in the master record you're populating but my experience over the years has been in the neighborhood of 125 records per minute. 10,000 vendors would take ~80 minutes in a sandbox (Tier 2) environment.
Suggested answer

Layan Jwei 7,349 Super User 2024 Season 2 on at

Like (1)

Report

How long the normal import customer and vendor master in average ?

Hi Teevo,

I don't really think thay 400 customers will take 1.5 hours.

The speed depends on alot of factors like environment itself(if it's devBox or Prod), complexity of the entity, the network...etc

You could test this yourself..Try importing 100 records via DMF 3 times and see how much time it takes in those three trials.

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future