News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Duplicated entries on ...

Small and medium business | Business Central, N...

Suggested answer

Duplicated entries on customer upload

(1) Share

Report

Report

Posted on by INITMAN007

96

Hello,

I have loaded Customers on Buiness Central using table 18. I left the customer number blank. I wanted Business central to generate the customer numbers as a test (experiment).

However, once the data has been loaded, BC has duplicated te entries. Any ideas why this is happening?

Thank you

Categories:

Business Central

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 73,698 Super User 2024 Season 2 on at

Like (1)

Report

Duplicated entries on customer upload

Customer Number is the primary key. If you leave it blank, as far as I know, the Configuration Package will consider it the same data.
You can assign numbers in Excel according to the No. Series rules and then import them.

Thanks

ZHU
INITMAN007 96 on at

Like (0)

Report

Duplicated entries on customer upload

Hi Sami,

I assigned a number series in BC in the sales & receivables set up. But not to the customers in the config package that i uploaded. I wanted to see if BC would automatically assign numbers

Thanks
Sami Ullah 284 on at

Like (1)

Report

Duplicated entries on customer upload

Hi,

How did you load the customers? Did you assign a number series to the customers when importing the data?

Regards
Sam

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans