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

Error Creating Loan Record in Business Central - Default Dimension Issue

(1) Share

Report

Posted on by Sghotekar

100

Hi everyone,

I’m encountering an issue while trying to create a loan record in a specific company in Business Central. When I attempt to create the record, I get the following error:

{
"error": {
"code": "Application_DialogException",
"message": "The field No. of table Default Dimension contains a value (L10119) that cannot be found in the related table (Loan)."
}
}

Typically, when working with other tables, I first insert the record and then link the default dimension using the table ID, record number, dimension code, and dimension ID. However, this approach seems to be causing a problem with the loan table.

Has anyone experienced a similar issue or have suggestions on how to resolve this?

Regards
S. Ghotekar

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Khushbu Rajvi. 20,234 Super User 2025 Season 2 on at

Like (2)

Report

Error Creating Loan Record in Business Central - Default Dimension Issue

Hope you get some hint: https://forum.mibuso.com/discussion/65022/default-dimensions-error

https://support.microsoft.com/en-us/topic/update-16-17-for-microsoft-dynamics-365-business-central-2020-release-wave-1-application-build-16-17-30467-platform-build-16-0-30409-eb8b52bd-543c-48ca-88d4-a0d1c7808ae0

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

Like (0)

Report

Error Creating Loan Record in Business Central - Default Dimension Issue

Hi

Is this part of a custom development? If so, please contact the developer or company responsible.

Best

GR

Was this reply helpful? Yes No
Nyakinyua 55 on at

Like (1)

Report

Error Creating Loan Record in Business Central - Default Dimension Issue

This looks like a custom development. Sometimes the record in the "Loan" table might not be fully committed before the default dimension is being linked.
Ensure that the record is fully inserted and committed to the database before attempting to link the default dimension. You can use a COMMIT after inserting the loan record or ensure that the transaction completes before linking.

Was this reply helpful? Yes No
Suggested answer

Andy Wingate 326 on at

Like (1)

Report

Error Creating Loan Record in Business Central - Default Dimension Issue

Hello

Looks like you need to fully complete the insert into the custom Loan table before trying to set the Def Dim. Based on the error anyway - the system doesn't see that the row with No. L10119 was present yet.

Cheers

Andy

Was this reply helpful? Yes No