Hello, Can any one please provide any macros to get reports from microsoft dybamics into
Macros to help getting reports from Microsoft dynamics
Answers
I've downloaded data from
Tell me about the text files you're downloading from Dynamics...Are they comma-separated values (CSV)? Tab-delimited? Or are they formatted reports?
If you can download your data as *data*--that is, as CSV or tab-delimited--you really don't need macros. In fact, macros would only get in your way.
Also, what data are you downloading? A GL Trial Balance? Sales history? Check register? Or something else?
Your question is probably on the right track but your question is not stated correctly and leads me to believe you don't have a good understanding of what a Macro is or does. An Excel macro cannot get data to jump from a database into Excel. Macros are coded in VBA language but run against data already in a spreadsheet.
You may also be misusing the term Macro, when what you need to refer to is VBA Application Coding that may reside inside an Excel Code Module that has been set up to extract data from a specified downloaded report that might be either in text file format or in a version of excel, as Charlie seems to have mentioned.
The best way for you to start your adventure in coding is to use the "Record Macro" feature on the "Developer" ribbon tab, that you will have to activate from the options button. This will allow you to record all your steps inside excel, and then you can edit your code in the VBA Module.
If you are trying to access files or other MS applications or using SQL Server links via ODBC connections, you will need a much more advanced understanding of Code structure.
You might be trying to do something conceptual that you aren't ready to execute. Guessing you might have some luck talking to your IT group. There is an Excel coding group on LinkedIn that might have some people who could further your
1
Valerie,
I agree, I too believe the wrong term is being used.
As for MS Dynamics and ODBC, the version I was used to was not that difficult to create a link. The first time or two out of the box may be a bit confusing, but with a little trial and error one can find the correct files to bring into the SQL statement.
However, if you don't really understand SQL, and not withstanding the MS wizard, you'll have more difficulty.
I made some interesting spreadsheets linked (one-way only) to Dynamics.
If you are using the report writer FRX with your Microsoft dynamics you can set the "output" in excel format rather than viewer or printed.. You might want to reach out to your MS dynamics consultant for more details on how to set these up. Then you determine the folder they will be directed to. You can also chain reports together for further calculations.
An even easier way to download data from MS Dynamics to Exel is SMARTLISTS, a list-ready module within Dynamics. You just pick what columns you need to see with pre-organized sets.
It is not as sophisticated as FRX reporting, yet is structurally beyond .csv downloading.
SMARTLIST is a baseline option in the software...I can't remember off the top of my head the click-through-tree to get to the option, but is relatively easy to find using Dynamic's HELP.
Another question would be what type of data and what type of reports are you trying to generate?
I have direct links into my Dynamic Tables to create dashboards and other reporting for Senior
What version of Dynamics are you using (SL, GP, AX NAV)
Most of the Dynamics financial / ERP systems have Excel based reporting - where you can print to excel. The excel files build the connection to the database in automatically without addition effort on your part.
There is really no macro needed - it is something you can setup through excel and your ERP deployment model. You use the data function in Excel if you are setting this up on your own.
I did a consulting gig for a Microsoft team that was using Dynamics to run part of their business. They did a system selection process that put internal solutions head to head with external solutions and they selected a product called Zap. It takes some work to get up and running but the reports are beautiful and fast.
Filed Under:
Budgeting & Forecasting