Posts

Featured post

Run ER reports using Electronic Messaging Functionality in D365

-
Image
 What's the Problem: After you've created your ER format, mapped it to data sources, and completed it, you can run it from the  Electronic reporting  workspace. After the report is generated, you can save it locally.  Due to this, we need to give access to the Electronic reporting Workspace to Business Users. To control the following aspects of the reporting process, set up electronic message processing: Log information about who generated the report. Log information about when the report was generated. Save the reports that were generated for previous periods. Solution: Create an electronic message processing in the system to run the required ER reports. In the Electronic messaging functionality, we can create a sequence of steps for users when trying to generate the EM processing. The following example shows how you can set up electronic messaging to generate a report that is based on an exporting ER format for Microsoft Excel. If you want to follow this example, the exportin
4 comments
Read more

How to bind the field with data type as Enum in Electronic Reporting in D365FO

-
Image
How to bind the field with data type as Enum in Electronic Reporting in D365FO Step 1: Add Enumeration from Data Source Type >> Dynamics 365 for Operations Step 2: Then use the formula of CASE to get the values from Enum. Happy Learning By Neeraj Kumar
1 comment
Read more

Calculate Preposted tax document on Purchases order confirmation in D365FO using Electronic reporting

-
Image
What's the Problem : Some of the customers demand printing the tax amount in the Purchases order print at line level. As we know, there is no table in the standard D365 to save the line-level tax amount in any posted tables. To get the tax amount at line level, the tax document needs to be calculated at run-time with available information on the Purchases Order line. Presently we use the customized class to calculate the tax amount at line level using the below code : static void GSTTotal (Args _args) { vendPurchOrderJour vendPurchOrderJour; ITaxDocument taxDocument; ITaxDocumentComponentLineEnumerator componentLineEnumerator; ITaxDocumentComponentLine componentLineObject; ITaxDocumentMeasureEnumerator measureEnumerator; TaxAmount taxAmount,taxValue; TaxComponent_IN taxComponent; ; vendPurchOrderJour = vendPurchOrderJour::findRecId( 5637291565 );      /Need to pass Confirmation journal recid taxDocument = TaxBusinessService::getTaxDocument
Post a Comment
Read more

Fun with REPLACE ER function in D365FO

-
Image
Please visit  http://regexstorm.net/Tester before reading the blog. REPLACE ER function REPLACE FUNCTION The  REPLACE  function returns the specified text string as a  String  value after all or part of it has been replaced with another string. Syntax REPLACE ( text , pattern, replacement, regular expression flag) Arguments text :  String The valid path of a data source of the  String  type. pattern :  String If the  regular expression flag  argument is  TRUE , this function returns the specified string after it has been changed by applying the regular expression that is specified by the  pattern  argument. The regular expression is used to find the characters that must be replaced. Example : REPLACE ("+1 923 456 4971", "[^0-9]", "", true)  applies a regular expression that removes all non-numeric symbols, and it returns  "19234564971" . If the  regular expression flag  argument is  FALSE , this function returns the specified string after the se
Post a Comment
Read more