In Electronic reporting if you want to convert an amount into an amount with fixed 2 decimal places after the comma you can use NUMBERFORMAT function Here is an example NUMBERFORMAT(model.Payments.InstructedAmount, "#.00") If the amount is 12.3 then the result will be 12.30 If the amount is 12 then the result will be 12.00
Category: ER – Electronic Reporting
AX / D365FO – how to hide or display an xml element based on a particular condition in Electronic reporting
If you want to hide or show an XML element tag depending on a particular condition you can use the "Enabled" button (see below) In this case I want to show the xml element if the customer name is not empty. So enter a condition that returns true if the name is set and false … Continue reading AX / D365FO – how to hide or display an xml element based on a particular condition in Electronic reporting
AX / D365FO – Attach documents (in base64 format) in Electronic Invoice XML files
To attach a document in XML electronic invoices just follow these steps : In this example we'll create an Project e-invoice First be sure the customer has these 2 flags enabled in the E-INVOICE section :- eInvoiceregister- einvoice attachment Now create a ProjectCreate an item requirement orderPost the Packing slipReturn to the project and create … Continue reading AX / D365FO – Attach documents (in base64 format) in Electronic Invoice XML files
AX / D365FO – Electronic reporting – Register a new ER LCS repository #ax #d365fo #msdyn365fo
Register a new ER LCS Repository To create a new Electronic reporting LCS Repository you must login to D365FO portal with an Administrator Account. Go to Organization administration > Workspaces > Electronic reporting.In the Configuration providers section, select your configuration provider tile. Select Repositories.You can now open the list of repositories of your configuration provider. Select Add to open the drop-down dialog … Continue reading AX / D365FO – Electronic reporting – Register a new ER LCS repository #ax #d365fo #msdyn365fo
AX / D365FO – Electonic reporting – How to solve : Reference of the object ‘XXXXXX’ to the object ‘Base’ ({XXXXXXGUIDXXXXX},9) cannot be established
If you'rre getting this error while importing a derived Configuration, pay attention that the derived base configuration and the Parent configuration are the same version otherwise you'll get the following error : Reference of the object 'XXXXXX' to the object 'Base' ({XXXXXXGUIDXXXXX},9) cannot be established To solve this error simply rebase the derived configuration to … Continue reading AX / D365FO – Electonic reporting – How to solve : Reference of the object ‘XXXXXX’ to the object ‘Base’ ({XXXXXXGUIDXXXXX},9) cannot be established
AX / D365FO – Electronic Reporting – Change a Source Model in an existing ER Format
Do you have an existing ER format and you want to change the source mapping model? It's simply! Just access "Electronic reporting" > choose your format > click on "Designer" Click on "Mapping"> choose your model > click on "Edit" Now you can change the "Model" and the related "Definition"
AX / D365FO – Electronic Reporting – How to : Cannot see newly created tables in the data source table list
Have you created a new table or view and cannot see in the "Table" data source list view? That means you have to refill the list. To do that just press "Refill Table" button, wait a few minutes and the table will appear
AX / D365FO – Electronic Reporting Format a Date
In Electronic Reporting you can easily format a Date or DateTime using DATEFORMAT() or DATETIMEFORMAT() Here is an example of how to use it DATEFORMAT needs 2 input parameters : Date (or dateTime in case of DATETIMEFORMAT)format (which is the output conversion format) Code below shows how to convert current date in yyyyMMdd format DATEFORMAT(TODAY(), … Continue reading AX / D365FO – Electronic Reporting Format a Date
AX / D365FO – Electronic reporting Get current Legal entity name
How to get the Legal Enity name in Electronic reporting? It's easy.. there is a predefined function called "GetCurrentCompany()". You can find it in the formula editor.
AX / D365FO – Electronic Reporting set output file name
By default the name of the electronic reporting output file is made up of : "UserId"+ fixed string ".out". We can change this name in a static or dynamic way. In my case I prefer to set a unique name. For example consisting of : a static prefix (eg. PriceList) + LegalEntity+ execution date / … Continue reading AX / D365FO – Electronic Reporting set output file name
AX / Dynamics 365 For Finance and Operations blog 