Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

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

Posted on by 126
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! 
Categories:
  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,775 Super User 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
    YUN ZHU 64,563 Super User 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
    Jun Wang 5,659 Super User 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
    gdrenteria 5,292 Super User 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
    Ben Baxter 4,263 Super User 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans