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

Upgrading version 14 Customized C/AL Application to Microsoft Base Application version 25

(7) Share

Report

Posted on by FB-18061258-0

Hi,

I have an issue when i synchronize final customize extension (task 14.5 https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v25) :

PS C:\Windows\System32> Sync-NAVApp -ServerInstance BC250 -Tenant default -Name "YYY" -Version "3.0.0.0"

Sync-NAVApp: Changes to the tenant database could not be applied. Affected tables will not be available.
The first error was:
Cannot delete the Payment Terms table from the database because it contains data for the XXX company.
Retry the operation when the problem has been resolved.

I don't understand why Sync-NAVApp want to delete standard table Payment Term.

In my custom extension, i have only a table extension on this table.

Categories:

Dynamics 365 Business Central migration

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

YUN ZHU 101,846 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints.

Some known issues in Business Central on-premises

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/known-issues?wt.mc_id=DX-MVP-5004336

Thanks.

ZHU

Was this reply helpful? Yes No
FB-18061258-0 39 on at

Like (2)

Report
Copy link

Link copied!

Hi Yun ZHU,

Thanks for answer.

I have already read this page, but the Payment Term Table hasn't become temporary.

Best regards,

Fabien

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

Like (2)

Report
Copy link

Link copied!

Hi, good day

Can you run the process again? I've had an undocumented or unusual problem more than once, and it's because I misinterpreted or executed one of the many steps incorrectly.

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 9,123 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi

This is a known issue during upgrades from customized C/AL applications to the Microsoft Base Application—especially when transitioning to BC25. The error you're encountering:

“Cannot delete the Payment Terms table from the database because it contains data…”

suggests that the upgrade process is attempting to remove or replace a standard table that still contains data, which is not allowed unless the table is temporary or part of a migration app.

Here’s what’s likely happening and how to resolve it:

1. Table Ownership Conflict

If your legacy extension or upgrade path still references the Payment Terms table as a custom object (rather than the standard Base App object), BC interprets it as a candidate for removal

Even if you only have a table extension, the upgrade tooling may treat the table as part of your app if it was previously customized in C/AL

2. Migration App Misalignment

During Task 14.5, the system expects all standard tables to be owned by the Base Application

If your extension still claims ownership of the Payment Terms table (even indirectly), Sync-NAVApp will attempt to drop it and fail due to existing data

3. Resolution Steps

Ensure your final extension does not include the base table object, only the table extension

Use Uninstall-NAVApp for any legacy apps that may still claim ownership of the Payment Terms table

Run Sync-NAVApp with the -Mode ForceSync parameter to bypass schema validation (only if you're confident no data loss will occur)

powershell

Sync-NAVApp -ServerInstance BC250 -Tenant default -Name "YYY" -Version "3.0.0.0" -Mode ForceSync

4. Reference Threads and Documentation

Upgrade to Microsoft Base App – Task 14.5

Community thread discussing similar Payment Terms sync error

Known Upgrade Issues – Microsoft Learn

Here’s a link from a similar upgrade scenario showing how table ownership conflicts trigger sync errors:

https://www.sauravdhyani.com/2019/11/msdyn365bc-2019-wave-2-upgrading.html

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No
FB-18061258-0 39 on at

Like (3)

Report
Copy link

Link copied!

Thanks @Jeffrey Bulanadi, @Gerardo Rentería García,

I will try again and keep you informed

Bests regards,

Fabien

Was this reply helpful? Yes No