Duplicated entries on customer upload

(1) Share

Report

Posted on by INITMAN007

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

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 71,232 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 92 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