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

Error Creating Loan Record in Business Central - Default Dimension Issue

(1) Share

Report

Posted on by Sghotekar

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

All responses (4)

Answers (0)

Suggested answer

Andy Wingate 320 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
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.
gdrenteria 12,290 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
Suggested answer

Khushbu Rajvi. 4,744 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