How to: Add custom template to "Open lines in excel" for general journals (Part 2)

In my last post, I have shown how to update an existing document template. In this post, I will show how to add a new template to the General journal form. This requires  X++ changes.

1. We will reuse the template created in the last post. In the Visual Studio project, add a new resource and select the template. It should like below:

2. Create a new class that extends DocuTemplateRegistrationBase and implements LedgerIJournalExcelTemplate like below. Copy the entire content of class 'LedgerDailyJournalExcelTemplate', Fix the compilations errors by replacing LedgerDailyJournalExcelTemplate with your class name and make changes as highlighted below:

Compile the project and reload the System document on the Document template form. You should see the custom template added and the same will be visible on General journals


Comments

  1. hp7390October 29, 2021 at 12:56 PM

    Can we do this in F&O itself? Or we need to do this in visual studio only?

    ReplyDelete

Post a Comment

Popular posts from this blog

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 : 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: Mass update product images in Dynamics 365 Finance and Operations using data management

Image
In this post, I will be sharing how to use data management to import product images with detailed steps: For the import of product images, we will use 'Product document attachment' data entity. For image upload, we need to have a package. so first we will generate a sample package from D365FO. Go to Data management -> Export -> Create new processing group as below: Now Export and download the package. The zip file will look like below: Now we have sample zip, let us update it for import.  Update the Excel file as below and add the images to Resources-> Product document attachments folder Zip the entire package and import it. The result looks like below: You can add as many images as you want. 
Read more