local_phone(877) 456-7632 local_post_officeinfo@msxgroup.com
Message Boards
Sign up Latest Topics

  Author   Comment  

Posts: 117
Reply with quote  #1 
In the current version of Microsoft Dynamics 365 Finance and Operations Financial Report Designer, reports cannot link to data in Excel spreadsheets. Prior versions of Report Designer (Management Reporter and FRx) could link to Excel spreadsheets and pull balances from those linked Excel spreadsheets into financial statements. This is not an option with 365. D365FO Financial Report Designer can only pull balances from the General Ledger. This includes Actuals, Budget, Quantity or any other Book Codes stored in the General Ledger. Any data stored in Excel spreadsheets would need to be imported into D365's General Ledger into one of the existing Book Codes (or add a new Book Code) in order to be included on financial statements.
Noah C. Moseley
MSX Group Senior Consultant and Certified Instructor

Email me if you need help installing, implementing or just need training on Microsoft Forecaster, Management Reporter or FRx. Plus, Prospero for Financial Reporting and Budgeting is now available. See our introductory video at http://msxgroup.com/prospero_video_introduction

Management Reporter | Prospero | Forecaster | FRx
Training | Consulting Services | Software Support
Previous Topic | Next Topic

Quick Navigation:

Easily create a Forum Website with Website Toolbox.