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

Too many dialog box when importing excel data (tables 38/39) Business central

(1) Share

Report

Posted on by xLekOx

I want to import all purchase orders from excel, I have the file whith a few fields of the tables 38 and 39 with all the data, but when I import the file, too many dialog boxes appear for confirm the change of the vendor ?¿ and that I have changed the order date ?¿

I dont know where is the error, i have to press the "Y" button to bypass thousands of this dialog boxes, and at the end, the process si correctly done.

Is there a way to avoid this questions ? Or anyway to fix the excel file for bypassing this dialog boxes ? Two dialog boxes from each order

Products and vendors are in the system, attached little example

Captura.PNG

PackagePROCESO DE...

COMPRAS2015_EXPOR...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

Like (0)

Report

Hi xLexOx,

Can you tell us what Dynamics 365 application this question is related to? There are several different solutions in the Dynamics 365 family, like: Sales, Finance, Supply Chain Management, Project Operations, and Business Central.
Can you also repost the screenshots? They now appear disabled due to a pending virus scan.

Was this reply helpful? Yes No
xLekOx 24 on at

Like (0)

Report

Business central

The error happend when validating this two fields, Buy-from vendor(and order date), vendor exists and is valid, but it says that is "new information", is there a way to ignore this message ? if I said yes to all the errors the process is done well.

Was this reply helpful? Yes No
Mansi Soni 8,909 Super User 2025 Season 2 on at

Like (1)

Report

Hello @André Arnaud de Calavon

Kindly move this question on the Business Central Forum for professionals to review and respond.

Regards,
Mansi Soni

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,373 Most Valuable Professional on at

Like (0)

Report

Hi

These are standard validations. Have you tried importing via configuration packages and ignoring validations? Pay close attention to this point.

How to Import Data Using Configuration Packages in Dynamics 365 Business Central - Dynamics 365 Business Central Insights

Dynamics 365 Business Central: Can we skip/ignore field validation errors? | Dynamics 365 Lab

Best

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (0)

Report

Hi, This requires customization to do, here are two simple examples, hopefully they will give you some hints.

Dynamics 365 Business Central: How to ignore messages while validating (Hide Validation Dialog)

https://yzhums.com/12853/

Dynamics 365 Business Central: How to ignore/hide “Order Date xx/xx/xx is earlier than the work date xx/xx/xx” message in Purchase Order

https://yzhums.com/43837/

Thanks.

ZHU

Was this reply helpful? Yes No
xLekOx 24 on at

Like (0)

Report

If I ignore the validation on "order date", no problem... but if I ignore validation on "Buy from vendor" it doesnt take the information of the vendor: name, direction, etc... and it result in many erros, as expected.

I only need to assume yes on prompt dialog.

Was this reply helpful? Yes No
Jeffrey Bulanadi 8,760 on at

Like (0)

Report

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (0)

Report

Hi xLekOx,

I assume you're using the Configuration Package feature. You can disable validation for all fields, allowing you to bypass the validation dialogs during the import process.

If you find this useful, feel free to mark this as the suggested and verified answer.

Cheers,
Jeffrey

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (0)

Report

Hi, As Jeffrey mentioned, you can disable validation by the following method.

More details:

Dynamics 365 Business Central: Can we skip/ignore field validation errors? | Dynamics 365 Lab

https://youtu.be/jRhslte2Bnw

But please note that there are certain risks. I personally think it is better to go through customization.

Thanks

ZHU

Was this reply helpful? Yes No