Skip to main content

Notifications

Community site session details

Community site session details

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

General Journals - stop auto removing Description when the Account Type is changed

(1) ShareShare
ReportReport
Posted on by
Hi,
 
Currently we have a process where we import a general journal with all our bank movements and the description.
From here, in Dynamics the uses allocates the correct account type and code to each entry.
Our issue is, when we import the account type automatically defaults to g/l account,
When we change it to say Vendor, the description we imported is removed and replaced with the Vendor details.
Is there any way of stopping this?
 
Thanks in advance! 
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    13,219 Moderator on at
    General Journals - stop auto removing Description when the Account Type is changed
    You can use the hidden Keep Description field. Not sure how you import the general journal, but try to import the Keep Description = true as well. That will preserve the description.
     
    I also have the free app below that you can download to expose the Keep Description on the page.
     
  • Suggested answer
    YUN ZHU Profile Picture
    79,587 Super User 2025 Season 1 on at
    General Journals - stop auto removing Description when the Account Type is changed
    Hi, another workaround is to import the Description as well when importing. This will overwrite the default automatically generated Description.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Jun Wang Profile Picture
    7,645 Super User 2025 Season 1 on at
    General Journals - stop auto removing Description when the Account Type is changed
    not sure how you import the entries, but if your excel is integrated with BC, you are able to populate all your fields correctly there, then publish back to BC. this way, you won't worry about the changing fields.
    this is officially called Business Central Add-in for Excel
     
    hope this might help you.
  • Suggested answer
    gdrenteria Profile Picture
    16,226 Most Valuable Professional on at
    General Journals - stop auto removing Description when the Account Type is changed
    Hi
    You could try using the "Keep Description" field of the "Gen. journal line", setting it to TRUE. I hope I can help you a little.
    Best regards
    Gerardo
  • Suggested answer
    Ben Baxter Profile Picture
    5,520 Super User 2025 Season 1 on at
    General Journals - stop auto removing Description when the Account Type is changed
    Not out-of-the-box, as there is Validation on the No. field in Journals.  You'll need to write an Extension to preserve the existing Description when a No. is changed.  You may want to consider a prompt as to whether to change the description, as sometimes you may make a change and want the Description to use the Default Description for the new No.  Expanding that a bit, you could make it User specific by adding a Boolean in the User Setup to control whether the Description changes based on the User making the entries.
     
    Hope this gives you some ideas.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,304 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans