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

Duplicates when importing sales budget with config package

(6) Share

Report

Posted on by MS-03120953-0

387

Hi,

Im importing a new sales budget for 2026 using Config package. But duplicate entries for each budget entry is displayed after the import

Any reasons why

Many thanks

Categories:

Microsoft Dynamics NAV

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Dhiren Nagar 2,856 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Without seeing the data and how your are doing the import, it is difficult to comment upon it.

It's better to use built in Excel function or Edit in Excel or copy paste function.

1 - Use Built in Export and Import function.

2 - Use edit in excel for quick data entry into Item Budget entry table.

3 - Last way is to do a copy paste of data from excel to Item Budget entry. It would be similar to edit in excel. In this case your column in BC screen and columns in Excel needs to be same.

I hope this helps.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards,

Dhiren.

LinkedIn - https://www.linkedin.com/in/ca-dhiren-nagar-5079081b2/

Blog - https://dhirennagar.blogspot.com/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,128 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, It looks like a similar problem: Sales Budget - edit in excel

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,790 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

I would recommend using the option directly in the sales budget:

It is more complex to determine what happens with the configuration package, since we don't have all the context.

I hope this helps.

Best regards,

Andrés

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 11,195 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Duplicates happen because Configuration Packages insert records instead of replacing them, so if budget entries for 2026 already exist (or if the key fields in your package don’t fully match the Sales Budget Entry primary key), Business Central treats the import as new lines and creates additional records. Config Packages are mainly meant for initial setup, not repeated transactional-style imports, so they don’t “merge” data automatically . The safest fix is to delete the existing 2026 budget entries before importing, or use the built-in Import from Excel on the budget page and choose Replace instead of Add to avoid duplicates .

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No