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


Reply
  Author   Comment  
Noah.Moseley

Moderator
Registered:
Posts: 116
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
Noah.Moseley@MSXGroup.com
http://www.MSXGroup.com

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
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.