New Dual Currency in F&O v8.1 - Fixed Asset Considerations

The new Dual Currency features added in version 8.1 include elements beyond just the General ledger.  A number of modules are impacted, including Fixed assets.  (Read about Dual Currency here).  

Reading through the above article addresses the changes in Fixed assets. However it does so more from an upgrade perspective rather than a new implementation.  During regression testing for a new implementation, we discovered that the Wizard referenced in the document MUST be run even though there are no transactions in a new database, and it must be run on every company that will have Fixed assets in it.  Failure to run the Wizard will prevent running an Acquisition or Depreciation Proposal.  The following error message is thrown if the Wizard is not run.

When running the Add reporting currency amounts to fixed asset books Wizard, you must run it through to the end of the process, even if no transactions appear in this form.

Then, you must select Yes in this form before clicking the Finish button.

This process executes in batch mode by default, so allow some time for the Wizard to complete processing before entering any asset transactions.

Note:  A similar Wizard exists for Cash & Bank transactions as well.  Make sure the Wizard process is completed before entering Bank transactions.

D365 F&O 8.1 Release Notes

For those who may not have seen them yet, here are the D365 F&O feature enhancements being rolled out between October 2018 and March 2019.  There are some really cool features like real Dual Currency and Derived Financial Dimensions that add much-desired functionality to the app.  Click on the image below and enjoy!

D365 F&O Keyboard Shortcuts List

Just discovered this today.  You can open a list of shortcuts from anywhere in the application.  Right click>>View shortcuts opens this form.

D365 for Ops System Email Template Setup - HTML vs. XSLT

We were getting an error in a workflow (Root element is missing) that leverages the System email template found in System administration>>Workflow>>Workflow parameters>>Email message. Note the references to HTML in the 'Upload email template' form below.  This would lead one to believe that the template uploaded must be in HTML format.

However, what we found was that during setup of this email template, XSLT was defaulted into the Layout field below.  The problem is, the Layout field is not exposed in this form by default.  We had to personalize the form to add the field.

The cause of the error was the mismatch between the Layout type (XSLT) and the HTML template that had been uploaded.  Once we discovered the mismatch and changed the Layout value to HTML, the email error was resolved.

Dynamics 365 for Operations - Disable User Session Date (System date)

While there are cases where you want users to be able to change their session date which controls the default Posting date on transactions, there are times such as immediately after Go Live, where you might not want new users to have that level of control. 

To disable users updating the session date for all users or a group of users, update System date security settings in the Client essentials security privilege.

Users will be able to see the Calendar object but not update their session date.

D365 for Ops – Management Reporter ‘Generator’ Security Role

This MR security role is inherited via the assignment of ‘Accountant’, ‘CFO’ and ‘CEO’ security roles in D365.  The assigned D365 security Duty is ‘Generate financial reports’ and includes these privileges and menu items.

Not explicitly reflected in these security settings in D365 is that in MR, these settings allow the Generator user to update and save certain report parameters BUT those parameters are saved under a user-specific generation parameters for the report and do not alter parameters in the default report.  This is good in that the Generator user can edit parameters without affecting the default report but could be bad in that two users running the same report might get different results. 

The parameters that can be changed and saved by a Generator user are indicated in the red boxes.

However, the only Save option available to the Generator user is ‘Save My Report Overrides’ which saves User-specific generation parameters for the report.

The risk in assigning Generator rights to multiple users is the potential for different versions of the same report which reflect different financial results.  This risk might be outweighed by the need for certain users to generate their reports on demand.

Beware the Penny Difference

If you're using Project Management & Accounting and Accounts Receivable in AX (D365 for Ops) and you have a Maximum penny difference and Maximum over/underpayment value set here in A/R Parameters>>Settlement -

Any Project invoice for an amount less than or equal to the Maximum over/under payment tolerance will transfer automatically to the general ledger account you have specified here -

When you post the Project invoice, it will post and offer this message -

And here are the journal vouchers created upon posting, indicating the write off from A/R account to the Rounding account.

Strange but true!