Skip to main content

Notifications

Announcements

Forum Structure Changes Complete – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Error Creating Loan Re...
Small and medium business | Business Central, N...
Suggested answer

Error Creating Loan Record in Business Central - Default Dimension Issue

(1) ShareShare
ReportReport
Posted on by Sghotekar 78

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

  • Suggested answer
    Andy Wingate Profile Picture
    Andy Wingate 320 on at
    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 Profile Picture
    Nyakinyua 52 on at
    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 Profile Picture
    gdrenteria 11,307 Most Valuable Professional on at
    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. Profile Picture
    Khushbu Rajvi. 3,952 on at
    Error Creating Loan Record in Business Central - Default Dimension Issue

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Forum Structure Changes Complete – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,912 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,355 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans