Auto generated and short-hand journal line description in Dynamics 365 Finance and Operation

I would like to tell you about 2 features in D365FO which are there for a long time but I don't know how many actually use it. So I decided to blog about it. These 2 simple features with high IMPACT are as below: 

1.Journal Description

2. Default Description 

 1. Go to General journal -> Journal Description 

This is form is used to create shorthand description which will be converted to Full-text description. 

The form is like below:

When you type acq -> it will be converted to 'Acquisition' on journal line description. This is applicable for all the journals in D365FO

 

This helps a lot if you are going to input lots of transaction lines particularly when it is closing journals etc. 

2. Go to General journal -> Default Description 

Form data looks like below:

I have set up some of the common default descriptions. Though this seems like a small thing but the impact is very high. This is applicable to both manual and automatic journals. In manual journals, if the description is blank, it will be generated using the below setup.  

when posting happens, Description is updated according to setup:

 

This is particularly helpful for reconciliations and data analysis from standard SSRS report as well as Financial reports from FR. 

SSRS report (Transaction list by date): Because detailed description it is easier to find the data more easily and searchable n SSRS as well as Excel when data is exported to Excel.

Financial report (Income statement):



Comments

  1. UnknownAugust 26, 2020 at 3:46 PM

    This is cool - I didn't know about the journal description functionality. Does this work across all journal types?

    ReplyDelete
    Replies
    1. Vinit GoyalAugust 29, 2020 at 3:59 AM

      Yes, It is all configuration and dynamics as per the need.

      Delete
  2. Fernando R.April 28, 2021 at 1:51 AM

    Thanks Vinit. And do you think is it possible to generate automatic description in General journals? For example, if I post a collection settling the invoice I want that journal automatically shows "Collection + Customer X + Invoice X". I was not able to set up this way in default descriptions.
    Thanks again.

    ReplyDelete
  3. danielMay 3, 2023 at 4:14 AM

    Thanks for sharing this, I wasn't aware of this thing, i was following this link before. You can also look this one i am sure you will be happy after seeing this.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to : get the Deep URL for a particular form with filter in Dynamics 365 Finance and Operations

Image
 If you are a developer and need to generate the Deep-link then you can follow the code mentioned in MS docs at https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/create-deep-links But if you want to share a few URLs with filters already applied to other users then you can use the feature of  'Get a link' in D365FO. Suppose I want to share the list of all sales orders for customer 'US-001'. Go to Account Receivable -> Orders -> All sales orders  Filter by customer account 'US-001' Then in the navigation ribbon, go to Options and click on 'Get a link'   Copy all and paste the URL into new browser window. You will only see the sales orders for US-001. If you want to generate lot of deep URLs then you can also enable  'Automatically update query parameter' Once you enable this, as soon as you apply a filter on forms URL will be updated with the query parameters like below: You can copy and share the link directl
Read more

How to: Solve issue when DVT script for service model MRApplicationService on machine XXX failed

Image
I was running binary update from LCS when my deployment failed. The step which failed had a description " DVT script for service model MRApplicationService on machine XXX failed" When I checked the log, It was showing "Financial Reporting DVTs ran with 2 failures". To resolve it, I just reset the DataMart and resumed the deployment from LCS which then completed successfully. Those who do not know how to reset DataMart, We have to run the following command in Windows PowerShell. cd J:\MROneBox\MRInstallDirectory\Server\MRDeploy Import-module .\MRDeploy.psd1 Reset-DatamartIntegration -Reason OTHER -ReasonDetail "DB Refresh" 1st line is to change the directory where MRDeploy.psd1 script exists. depending on the environment typologies  some other common places where it can be found is G:\MRApplicationService\MRInstallDirectory\Server\MRDeploy K:\MROneBox\MRInstallDirectory\Server\MRDeploy 2nd line is to import the Script 3rd line is for
Read more

How to: Display individual financial dimension value in grid control

Image
To display inventory dimensions in the grid we have control of dimension display which can be set up as per the requirement.  But there is no control in D365FO to display financial dimensions in grid control.  There are 2 ways it can be done.  1. Create display methods to display particular financial dimensions like the below method which displays division. I have seen many examples on the internet using multiple find methods but I prefer it by doing one query with joins to improve performance issues. public display DimensionValue getDimensionDivision() {         DimensionAttributeValueSetItem  dimensionAttributeValueSetItem;         DimensionAttributeValue                dimensionAttributeValue;         DimensionAttribute                        dimensionAttribute;               select DisplayValue from dimensionAttributeValueSetItem             join dimensionAttributeValue             join dimensionAttribute             where dimensionAttributeValueSetItem.DimensionAttributeV
Read more