Skip to main content

Notifications

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

Error When Creating new Bank Account in a newly set up Company

Posted on by 20

Hi,

I need help on fixing the error when I am creating new Bank Account. In the No. field, I can't enter new value like "2422" for the new bank account that I want to create. It got me an Error: "Validation Results  The record in table contact already exists. Identification fields and values No = "CT000001".

This is for a newly created company and the configuration packages like Charts of Accounts, G/L Accounts, Vendor, Customer, and Items were exported and imported from our Production Company.

I hope anyone can help me. See attached image

.8231.image.pngpastedimage1675852002771v1.png

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,472 Super User 2024 Season 2 on at
    RE: Error When Creating new Bank Account in a newly set up Company

    Hi, If you want to enter manually, please confirm the following settings.

    pastedimage1675906941089v1.png

    pastedimage1675906957608v2.png

    Hope this helps.

    Thanks.

    ZHU

  • AlyssaTessTeam Profile Picture
    AlyssaTessTeam 22 on at
    RE: Error When Creating new Bank Account in a newly set up Company

    I have come across this also and my solution that I have found to work for us, is to go to the Contacts page, sort the page to the most recent contact and then that auto corrects the No Series for the Contact to the Last No Used.

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,785 Super User 2024 Season 2 on at
    RE: Error When Creating new Bank Account in a newly set up Company

    In the No. Series Page, what do you have under Last No. Used for contacts? It looks like this value is not correct. If you update this it should fix your issue. 

    pastedimage1675875880826v1.png

  • Suggested answer
    JodeRuiter Profile Picture
    JodeRuiter 976 User Group Leader on at
    RE: Error When Creating new Bank Account in a newly set up Company

    Good Morning!

    I have found that when I am getting strange errors, if I create a Configuration Package for that table and export it to Excel, I'm able to find orphaned records.

    Then, I typically remove the orphan from the Excel Config Record and reimport and the error is cleared up.

    We've been using Config Packages to fix table issues for a while now.

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,135 Super User 2024 Season 2 on at
    RE: Error When Creating new Bank Account in a newly set up Company

    Please click on the "How to report this issue" and copy to clipboard and paste the call stack here

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans