最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Excel Add-in adding dimensions to a template

网络文摘 William 2683浏览 0评论

Importing values with dimensions and/or adding financial dimensions to ANY excel template (GL, budgeting, etc).

 

  1. Make sure all financial dimensions have been added to Dynamics 365 for Operations and activated. There is a status on each financial dimension that tells you if it is Active of Inactive. If any are showing Inactive after a refresh on the page, be sure to Activate them.
  2. Modify the DimensionCombinationEntity or DimensionSetEntity (for default dimensions). You can do this on both AX7 and Operations. Both instructions are included in the wiki: https://ax.help.dynamics.com/en/wiki/dimensions-overview/
  3. Create an integration format in the Financial dimension configuration for integrating applications: https://ax.help.dynamics.com/en/wiki/financial-dimension-configuration-for-integrating-applications/
  4. Add the financial dimensions to the Excel template and publish the template: https://ax.help.dynamics.com/en/wiki/off101-office-integration-enable-users-to-edit-data-in-excel/
  5. If you want to take it one step further and have lookups on the financial dimensions, you can then follow the steps in this wiki: https://ax.help.dynamics.com/en/wiki/add-dimensions-to-microsoft-excel-templates/

 

If you are simply importing values with entities in the Data Management area, you only need the integration format.

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址