Software Information |
|
Microsoft Great Plains RW: Report Writer
Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Report Writer (RW) module allows for modification and creation of Great Plains reports to suit your business needs. RW is a powerful tool that allows you to draw data from virtually any area in your system, with a wide variety of layouts, fields, report logic, formatting, and data selection. Report Writer makes your report consistent over your entire organization by providing the capability to create customized versions of reports for specific individuals or groups, with targeted information designed to meet their specific needs. RW also has flexible scheduling options to publish reports as your business needs dictate, whether immediately, on a recurring basis, or selectively, in a variety of file formats including HTML and PDF. Features: ? Customized Reports ? Modify existing reports or create entirely new ones from information throughout the system. Use multiple fonts, colors, sizes, and graphics to design the report for specific audiences and improved usability. ? Flexible Report Writing Options ? Pull data from multiple locations for a single report, create restrictions to pinpoint specific information, perform calculations on data, and create new sorting methods to view information the way you want. ? Export to Excel and HTML ? Easily export reports to industry-standard file formats and use Microsoft� Excel to perform further calculations. Send e-mail reports to decision makers and publish reports on your business intranet. ? Scheduled Reporting ?Automate report publication with Report Scheduler, allowing you to set up recurrent or immediate publication for any report option or report created with Report Writer. ? Online Posting ? Publish reports to the Microsoft Business Solutions Business Portal and enable decision makers throughout the organization to view reports via a Web browser. Good luck with implementation, customization and integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-630-961-5918 or 1-866-528-0577! [email protected] Vincent is a Great Plains specialist in Alba Spectrum Technologies (http://www.albaspectrum.com) ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, Houston, Atlanta, Phoenix, New York, Los Angeles, San Francisco, San Diego, Miami, New Orleans, Toronto, Montreal and having locations in multiple states and internationally.
|
RELATED ARTICLES
Recovering Microsoft Great Plains Customization ? Tips for IT Director Remember nice and prosperous Clinton era? When you implemented innovative those old days accounting application ? Great Plains Dynamics. And did a lot of customizations to fit your business requirements precisely. You still remember the names of consultants and programmers who did the job and probably the name of the company ? Great Plains reseller in your business metro. This company more likely doesn't exist in the same form ? either closed the doors or merged and transformed to something else. When you tried to contact former programmers ? they more likely nicely let you know that they do not do this any more ? they got completely different job and profession. Great Plains Software was acquired by Microsoft and not part of Microsoft Business Solutions. In old good days Great Plains Software was taking care of popularizing its customization and growing Great Plains Dexterity programming expertise. Nowadays Microsoft Business Solutions has more concerns on merging all its ERP applications: Great Plains, Solomon, Navision, Axapta and making them run together as a set of modules (project Green). The End of Spyware? The US House of Representatives has recently passed the "Spy Act" - or to give it its full title - the Securely Protect Yourself Against Cyber Trespass Act. This aims to prevent software companies from installing spyware on users PCs without their knowledge, and anyone found guilty of breaching the act faces a fine of up to $3 million. Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant All of us know that Microsoft bought former Great Plains Software and formed Microsoft (Great Plains) Business Solutions in the earlier 21st century. It was total success for GPS, we guess, but for Great Plains Dynamics / eEnterprise / Dynamics C/S+ clients it was the time of change. First of all ? Great Plains Software, as being independent corporation in 1990th had to stake on certain future predictions. They decided that future should be based on these two basic principles: Microsoft Great Plains Implementation for Large Corporation ? Overview for VP IT Microsoft Business Solutions Great Plains was historically designed to serve mid-market first and then with addition and acquisition of new modules ? Great Plains Dynamics architects planned to enter into corporate market. When Microsoft SQL Server took its place as relatively reliable and stable database platform, Great Plains gained scalability. Let's consider the questions, you need to be placed and answered for your IT department in ERP selection, implementation, modification and customization. Five Steps to Rapid Development with TierDeveloper 4.0 Follow the steps below to quickly design, generate, and deploy a great portion of your real-life N-Tier application. Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer Microsoft Retail Management System serves retail single store as well as retail chains clientele. The customization scenarios, described in this article deal with the chains, when Microsoft RMS has multiple stores databases and Headquarters. Microsoft RMS is SQL Server-based application, so we will consider SQL programming ? SQL queries, views and stored procedures. Also Microsoft RMS could be integrated on the SQL level with other applications, such as Microsoft Great Plains, Microsoft CRM and non-Microsoft applications, such as Lotus Notes/Domino What is Software Piracy? There are several kinds of software piracy. The bottom line is when software is pirated, the developer does not receive compensation for their work. Razzle Dazzle Them Once upon a time not so long ago, there was a little boy who went to the market to try to sell his wares. He wasn't having any luck. "Who will buy my sweet red roses? Two blooms for a penny," he sang out hauntingly. Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants We'll give you non formal view, based on our consulting practice. Microsoft CRM or Siebel Siebel is traditional CRM market leader, however and mostly due to recession 200-2003, Siebel lost sizable portion of CRM market to new tiger, such as Microsoft CRM. Microsoft CRM s recent (2001) CRM answer from Microsoft and attempt top get market share from traditional vendors: Siebel, Oracle, Onyx. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision (the last two in progress). Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector ? Future Directions IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management) from now on can work in tandem. Microsoft CRM Lotus Notes Domino connector from Alba Spectrum Technologies provides seamless messaging in MS CRM through Domino. Our customers suggest future direction for the connector. Considering our consulting practice experience in MS CRM and Lotus Notes customization, upgrade, integration ? in this small article we'll reveal our half year development plans Cisco Certification: Introduction To ISDN, Part III Configuring PPP PAP Authentication Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer �Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market.� At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation market competitor to Oracle, PeopleSoft, SAP, IBM.� This article is brief review of Microsoft Great Plains integration with Microsoft Access.� This is also applicable to Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary - DYNAMICS.DIC and runtime DYNAMICS.EXE) and Great Plains Standard on MSDE� or MS SQL Server. If you are developer who is asked: how do we implement� Great Plains integration/interface� with your MS Access-based� system ? read this and you will have the clues on where to look further. Great Plains Integration Manager - this is rather end-user tool - it is very intuitive, it validates 100% of business logic, brings in/updates master records (accounts, employees, customers, vendors. etc.) brings in transactions into work tables.� The limitation of Integration Manager - it does use GP windows behind the scenes without showing them - so it is relatively slow - you can bring 100 records - but when you are talking about thousands - it is not a good option.� By the way you can program Integration Manager with VBA.� Microsoft Access is ODBC compliant and so you can do direct Integration Manager query to MS Access eConnect ? it is type of Software Development Kit with samples in VB.Net.� Obviously the development environment should be Visual Studio.Net.� eConnect will allow you to integrate master records - such as new customers, vendors, employees, etc., plus you can bring transactions into so called Great Plains work tables (eConnect doesn't allow you to bring open or historical records - you need to post work records in Great Plains, the same limitation applies to Integration Manager above)� eConnect is rather for ongoing integration.� It was initially created for eCommerce application integration to Great Plains. SQL Stored Procedures.� Obviously you have unlimited control and possibilities with SQL queries.� You need to know Great Plains tables structure and data flow.� Launch Great Plains and go to Tools->Resource Description->Tables.� Find the table in the proper series.� If you are looking for the customers ? it should be RM00101 ? customer master file.� If you need historical Sales Order Processing documents ? they are in SOP30200 ? Sales History Header file, etc.�� Do not change existing tables - do not create new fields, etc.� Also you need to realize that each GP table has DEX_ROW_ID - identity column.� Sometimes it is good idea to use inbound/outbound XML in the parameters - then you can deploy web service as a middle party between two systems. Data Transformation Services (DTS) ? Good tool for importing your third party data into staging tables in GP - then you can pull them in using either stored procs of Integration Manager.� You can also deploy this tool for EDI export/import.� You can have DTS working with Linked Server - SQL Server Construction for linking to Microsoft Access Great Plains Dexterity Custom Screens.� Sometimes users prefer to have seamlessly integrated into GP interface custom screens - for parameters settings and initiating integration.� Dexterity is a good option, however remember - it is always better to create new custom screen versus customizing existing one - due to the future upgrade issues.� Also - Dexterity is in phasing our by Microsoft Business Solutions. Modifier/VBA custom buttons on the existing screens - �alternative to Dexterity is you are comfortable with VBA and ADO. SQL Linked Servers ? you can do direct SQL queries to other ODBC compliant platform via SQL Linked Server (including Microsoft Access) - you may need to familiarize yourself with OPENROWSET command in Transact SQL.� This is also good option if you need cross-platform Crystal Report - pulling data from SQL Server and third party databases on the same report. Warning - do not place existing GP tables into Replication! - you will have upgrade issues. Happy integrating!� if you want us to do the job - give us a call 1-866-528-0577! [email protected] EDI: Electronic Document Interchange for Microsoft Great Plains ? Overview for Software Developer/Pr Microsoft Great Plains - Microsoft Business Solutions accounting and ERP system, originally targeted to mid-size - now, with advancements and increasing reliability of its database - Microsoft SQL Server, Great Plains is attractive solution for large corporation. Big companies usually have purchasing and order processing automation via so-called Electronic Document Interchange or EDI. EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Trailer of predefined fixed position fields. Crystal Reports - Microsoft SQL Server Microsoft SQL Server is the leader for inexpensive and middle size SQL solutions. Plus it is now capable to serve large enterprise on Microsoft Windows platform. Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few. Cisco CCNA Certification: Becoming A Truly Valuable CCNA. I've been active in the Cisco Certification track for four years, working my way from the CCNA to the coveted Cisco Certified Internetwork Expert title, and during that time I've conducted job interviews and casual conversations with hundreds of CCNAs and CCNA candidates. OSI Layers Model Introduction Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool DBxtra is a powerful query and reporting tool that hides many of the complexity and technical expertise required for creating connections to disperse data sources, building queries, designing reports, and delivery information throughout an enterprise or to your customer base. Begun, The Browser Wars Have As Mozilla Firefox nears 10% market share, with well over 25 million downloads direct from the makers website, and goodness knows how many through other sources, Microsoft announces that it will be releasing IE 7 ahead of schedule. Originally scheduled for release with Microsoft's new Longhorn operating system in 2006, it seems that Microsoft are reacting to the run away success that Firefox has had over the last few months. But is Microsoft's announcement just a response to Firefox's success, or is it truly a commitment by the software giant to improve the browsing experience of the masses? Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports Microsoft CRM is new player on the CRM software market.� The whole conception behind CRM seems to be different.� In case of traditional CRM software (Siebel, Oracle) - the application was designed with platform independence in mind.� Microsoft CRM is dedicated to Microsoft technology and so deploys all the Microsoft tools: Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc. If you are software developer, database administrator or web designer who is asked: how do we customize Microsoft CRM ? we are giving you directions in this article. Microsoft CRM SDK ? this is software development kit with C# and partly VB.net code samples ? it is supported by Microsoft Business Solutions technical support.� It is based on web service calls, if you are C# .NET developer ? you are excellently positioned to do this type of customizations.� This is the preferred modification scenario and this should be easily upgradeable customization.� VB.Net examples will be available soon. Legacy SQL Data integration.� This is also easy and safe.� If you have SQL database, sitting on the same or linked SQL Server ? you can create ASPX .Net application and simply integrate it into CRM.� You can place it on the navigation bar or menu in isv.config ? please refer to MS CRM SDK Legacy ASP integration ? this is somewhat more sophisticated.� You have to deploy HTTP handler to be a middle party between CRM which is .Net based and ASP which is legacy IIS.� The trick is ? you have to have INI file with security settings to penetrate into MS CRM with proper credentials, calling web service. Microsoft Exchange Programming.� Microsoft CRM has Exchange connector ? which moves CRM incoming email to MS if it has GUID in its subject.� You can alter this logic (for instance - move email to CRM if it doesn't have GUID but it is from the sender who is contact or account in MS CRM).� Refer to MS Exchange SDK onsyncsave event handling.� Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience. Direct SQL touch ? in #4 above I described you the scenario with MS Exchange handlers ? this would be ideal world if MS CRM SDK does the job.� But ? in real world this is not always true ? you have to do direct flags correction in CRM database (like making Activity closed, moving email attachments/octet streams, etc).� This is not supported by MBS technical support ? but you can rescue to this technique if you have to get job done. MS CRM Customization tool ?� this is rather end-user tool and we don't describe it here ? read the manual.� We've described above the options to use when this tool doesn't do the job Crystal Reports - feel free to create Crystal report - tables and views structure is self explanatory.� Try to avoid the temptation to create your own SQL view or stored procedure in MS CRM database, instead - create custom database and place your view and stored proc in it.� Happy modifying! If you want us to do the job - give us a call 1-866-528-0577! [email protected] |
home | site map |
© 2005 |