Article Categories
» Arts & Entertainment
» Automotive
» Business
» Careers & Jobs
» Education & Reference
» Finance
» Food & Drink
» Health & Fitness
» Home & Family
» Internet & Online Businesses
» Miscellaneous
» Self Improvement
» Shopping
» Society & News
» Sports & Recreation
» Technology
» Travel & Leisure
» Writing & Speaking

  Listed Article

  Category: Articles » Technology » Computers » Article
 

Microsoft Dynamics GP Report Design




By Andrew Karasev

Microsoft Dynamics or former Microsoft Business Solutions products line, including Microsoft Dynamics GP – Great Plains, Microsoft Dynamics CRM, Microsoft Dynamics AX – Axapta, Microsoft Dynamics NAV – Navision – is now on the way to move to .Net platform, this will mean that for the development community we should pay more and more attention to Microsoft SQL Server Reporting Services and probably deemphasize Crystal Reports/Crystal Enterprise. At the same time Microsoft Business Solutions reopened Great Plains Source Code program for MBS partner channel, this signals to us that we need to rehabilitate old Great Plains/Microsoft Dexterity based tools: ReportWriter, Microsoft Dexterity itself to customize Microsoft Dynamics GP so-called "fat" client. Please read below "balanced" and "reasonably conservative" Microsoft Great Plains / Microsoft Dynamics GP 9.0 report design overview:

Let's first look at the advantages of using ReportWriter:
• Seamless integration with Great Plains forms – the most typical scenario – you modify SOP_Long_Invoice_Form or SOP_Blank_Invoice_From and then print your invoices with modified form – usually with your logo and changed formats and positions of the fields
• Parameters Entry Forms. Each existing report (Reports section) has associated parameters entry form.
Restrictions:
• No Cross-Modules links. You can not associate report with the tables from non-related modules. For example you can not have Sales Order Processing (SOP) and Purchase Order Processing data on the same report (you actually can – but you need Dexterity programmer help)
• Custom Reports. You do not have parameters entry interface for your custom reports, but you could use restrictions to restrict the selection. Custom reports could be used to export data from Great Plains in text (and then Excel format)
Advanced ReportWriter programming
• Rw_ functions in Great Plains Dexterity. When you need cross-modules data on the same report (Bill of Lading, which you could produce on the base of Picking List) you need to move the report you want to customize into your custom DYNAMICS.DIC and fill the gaps with RW_ functions – these are allowed to be placed on the report with parameters
If ReportWriter doesn't do the job:
• Crystal Reports. Current version 8.0 and 8.5 (July 2005) are MS SQL Server based, where Crystal Report could work at will and produce all the desired links – we recommend you to base Crystal Report on SQL Stored Procedure or SQL View. You call Crystal Report engine via Modifier/VBA – you need Customization Site Enabler license. If you are on Great Plains Standard version: 7.5, or Great Plains Dynamics/eEnterprise 7.0, 6.0, 5.5 or 5.0 Btrieve/Pervasive SQL/Ctree – you need to install Pervasive SQL driver (or Faircomm driver for Ctree)

Please do not hesitate to call us: 1-866-528-0577, 1-630-961-5918, Europe: +44 20 8123 2580, +45 36 96 55 20, Mexico: 52-55-535-04027, help@albaspectrum.com or skype: albaspectrum

 
 
About the Author
Andrew Karasev is technical consultant at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.ronix-systems.de http://www.greatplains.com.mx ), serving CA, IL, TX, FL, AZ, CO, NY, GA, NV, WA, LA, Germany, UK, Canada, Australia, New Zealand, Oceania, Brazil, Portugal, Spain, Mexico, Argentina, Chile, Colombia, Venezuela, Peru

Article Source: http://www.simplysearch4it.com/article/26376.html
 
If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/26376.html" as shown above and make it hyperlinked.



  Some other articles by Andrew Karasev
SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil
SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this article we would like to recommend SAP BO as ERP system for multinational corporation ...

SAP Business One in Illinois: implementation, upgrade, customization, integration
Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of diversified mid-size businesses, engaged in light assembly, ...

SAP Business One Chicago Market Review, plus customization, integration & data conversion
SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the Israel software development ...

Microsoft Dynamics GP Office Stack Integration advances –
Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains ...

eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes
This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion ...

Microsoft Dynamics GP Dexterity Customization
Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual ...

  
  Recent Articles
Microsoft Word. The power is under the hood
by Robert Duval

How To Select The Best Gaming Laptops
by Tim Childree

How To Select The Best Business Laptops
by Tim Childree

High-Tech Computer Rental for Business Promotion
by Michael Braganza

Managing a Worldwide Print Infrastructure from a Single Workstation in a Central Location
by Rick Ferguson

A Sneak Peek Into The World Of Refurbished Laptops
by Javier Fuller

Battery information
by goodbattery

Tell Me About Computers
by Khal Nuwar

Setting Up Your Own Internet Radio Station
by Jason Cole

Understanding Solar Energy
by Anna Stone

Mac FAXstf X Pro Faxing Program for Mac OS X Users
by Nivea David

How to Retrofit a Picture or an Image into Desktop Wallpaper for Your Computer
by Steve Dimeck

Can't connect to database