Tag Archives: dynamics

Crystal Reports for SQL Based ERP Systems SAP Organization One particular, Microsoft Dynamics

Crystal Reports for SQL Based ERP Systems SAP Organization One particular, Microsoft Dynamics

SQL Server opens new horizons in Crystal Reports design and deployment. Right here you possibly can separate the report presentation from data choice layer. Instead of linking tables directly in CR it is easy to now develop SQL View or Stored Process and test their outcomes prior to opening Crystal Reports Designer. Speaking about particular Corporate or Smaller Enterprise ERP platform – here it is advisable to know table structure in order to create SQL View. In this modest publication we would like to offer you two examples: SAP Business enterprise A single and Microsoft Dynamics. Let’s start with advantages of SQL View and Stored Procedure as report information pulling:

1. SQL View. Let’s assume that you don’t prefer to do choose statement test directly in Crystal and would like to keep away from such annoying problems as duplicate rows and incorrect Mcsa Exams summaries. Plus you’d like to use such constructions as SQL Union. And as well as that you just do not wish to develop the entire report and then potentially comprehend that it does not perform as expected and you would must redo tables linking and redesign fairly substantially the entire report. Then what you may determine to perform is make SQL View and test its outcomes in SQL Server Management Studio

2. Stored Procedure. CR is treating final Select statement or Union as its base. Stored Process parameters are translated into Crystal parameters. What are the positive aspects of Stored Process? Properly in SP you’re not restricted to just sophisticated joins in Select statement or Union. Here you can use parameters, temporary tables, data update (be cautious usually do not compromise data integrity!). It really is also probable to use Exec statement and develop Choose statement on the fly analyzing the set of parameters. You can also use SQL cursors specially in creating temporary tables. Stored Procedure could give you the advantage of much better performance comparing towards the view as here Crystal doesn’t must apply restrictions towards the total View selection and each of the job are accomplished in high efficiency SQL Server. Let’s now move on to SAP B1 tables and fields

3. SAP Organization 1. For anybody who is not doing long-term programming project in Computer software Development Kit then there’s no should install it and review tables diagram from there. We recommend you just login SB1 user workstation and in menu mark View -> System Information. Let’s now assume that your custom report will should pull the fields from Sales Invoice. Open Sales invoice form and place the cursor over the field in question. Table and field name information will be displayed in the bottom left corner of the user interface. Some comments before you begin your SQL View or Stored Process creation. SAP BO is three tiers Compact Business ERP application. This means that direct data update via custom SQL statements will be detected by Watch Dog service and transmitted to SAP. Consider just information selection and try to steer clear of updates on the SQL Stored Process level

4. Microsoft Dynamics ERP and CRM Family. There are several products where direct pick from SQL Server database is OK. Among them GP (formerly known as Great Plains), NAV (former Navision), CCNA Certification SL (originally Solomon) and CRM. In the case of Dynamics AX Axapta direct access to SQL Server is not recommended and rather you should consider X++ code and such development tool as MorphX. Microsoft actually is trying deemphasize Crystal Reports and rather advise SQL Server Reporting Services (SSRS)

5. Financial Reporting where Crystal is not recommended. General Ledger is tightly connected with Accounting theory and double entry. When you really need to generate Balance Sheet, Profit and Loss Statement or Statement of Cash flow including consolidated versions please consider such tools as Microsoft Management Reporter or its predecessor FRx. If you ever decide to recreate P&L directly in Crystal you should expect to reproduce most of FRx enterprise logic and this is in our opinion not a feasible idea

http://endeavor30.articlealley.com/crystal-reports-for-sql-based-erp-systems-sap-organization-one-particular-microsoft-dynamics-2430171.html

MS CRM System Improvisation

MS CRM System Improvisation

Customer relationship management is a very widely implemented strategy for managing a company’s interactions with customers, client and sales prospect. Customer relationship management describes a organization’s business strategy including customer-interface departments as well as other departments. The more useful way to think about CRM is as a process that will help bring together lots of pieces of information about customers, sales, marketing effectiveness, responsiveness and market trends. A good customer relationship software solution ensures that your marketing and sales teams have customer information that they can easily use to significantly grow the value of your customer base. The benefits of CRM solutions are multi-faceted and range from optimization of customer service response times and satisfaction to reduction of operational cost. The main goal of a CRM Solution is to establish and maintain with the relationships with customers on an individual basis, and then use that information to treat different customers differently. Mindfire Solutions one of the leading software development and IT consulting company in India has deep expertise MS Dynamics CRM application development services. We have executed various projects in CRM, all of the projects can be found in the offshore CRM application development projects page.

Mindfire executed a project called as the MS CRM System Improvisation software solution. One of our clients was keen at improving the overall efficiency of their existing CRM system in order to manage their data, better understand and serve their existing and future customers. They approached Mindfire Solutions to analyze their existing CRM system and come up with a proposal to speed up their process. Mindfire’s able CRM developer took time to analyze their existing system, figured out the process in which their CRM system operates and proposed the client to automate the entire process in order to achieve a faster experience. More details about this case study can be found at CRM Improvisation System.

Mindfire Solutions provides a range of services in offshore Microsoft Dynamics CRM Development. Some of them are Microsoft Dynamics CRM Consulting, Development and Deployment, Dynamics CRM System Customization, Customer Management Solutions, CRM Development, Dynamics CRM Maintenance, Testing and Microsoft Dynamics CRM Offshore Remote Support. Mindfire’s team of Offshore Dynamics CRM Developers has good experience and knowledge in creating applications which provide insight into the most relevant, business-critical information for everyone in your organization, for effective decision making. You can outsource your CRM software development services to us, to get the benefit of most flexible hours of working, affordable cost, experienced Dynamics CRM consultants and time savvy benefits. We also have 100 hours risk free trial* for new clients.

http://dynamics.ezinemark.com/ms-crm-system-improvisation-7d30757861d5.html

Microsoft Dynamics GP and RMS Integration Options

Microsoft Dynamics GP and RMS Integration Options

If you are working in retail business and plan to deploy Microsoft RMS as your Point of Sale and Store Management system with back office on Microsoft Dynamics GP, this orientation is for you.  You may be already ware that there is integration (Great Plains Dexterity add-on), which comes with Great Plains Dynamics GP purchase.  This integration does very simple but reliable job, sending Daily Sales into GP General Ledger batch, plus it integrates AP transactions (as you may prefer to do merchandise restocking directly in MS RMS Store Operations or Headquarters modules, but you would probably like to keep AP check cutting from your Corporate ERP application, which is Dynamics GP).  If this is exactly what you need, please call to your Microsoft Dynamics GP Reseller or Consultant to discuss this Microsoft RMS to Dynamics GP integration acquisition and implementation.  If this simplicity doesn’t do the job for you, here are other options to consider:

1. Sales Order Processing, Purchase Order Processing (Purchase Receipts), Inventory Control (adjustments and transfer) synchronization between MS RMS and Dynamics GP.  This is pretty complete possibly integration scenario.  You send all your daily POS transactions from all your stores (after they are transferred overnight or hourly into your RMS Headquarters database).  Purchase Receipts could be done either in RMS or in Dynamics GP directly (in the case of Great Plains Purchase Receipts you can get advantage of more flexible barcode labels printing options, for example, plus they could be matched against Purchase Orders and even with some negotiation activity in Dynamics GP Business Portal Requisition Management module).  The same is possible with Inventory moves (from one RMS store to another or from one Dynamics GP Inventory Site to another)

2. RMS to Great Plains integration settings.  Here you really have more than other products could offer.  If your business has pretty complicated legal structure, where you one of your companies may own one or more RMS sales outlets, you can map one or more of your RMS stores to be associated with the GP Site (or multiple sites) in the one of the GP companies.  You can keep your expansion practice being flexible and purchase companies, without the need to fold them into your family owned company, just transfer them to Dynamics GP and Microsoft RMS platforms

3. Light version – integration of RMS POS transactions as AR Invoices and Returns.  In this case you do not bother to track your inventory items quantities, QTY Sold, Returned, Available in the Warehouse.  All you want to do is to track POS transactions distribution on precise GL Sales Accounts (in this case you can control your P&L directly in Financial Reporting, such as FRx or Microsoft Management Reporter, available for new version of GP 2010)

4. Integration Performance.  Alba Spectrum Integration between Dynamics GP and Microsoft RMS is coded exclusively in SQL Server Stored procedures, meaning that it is designed for ultimate volume of POS and Purchase Receipt/Inventory Adjustment and Transfer transactions, comparing to the competitive products coded in Microsoft Dexterity (Shell, specially programmed in C programming language with its own proprietary coding language Sanscript, where database manipulations are done via Dex cursors) or eConnect (this Dynamics GP SDK follows and replicates Dexterity source code business logic with 100% validation, where some of the performance might be slowed)

5. Versions supported.  Integration was introduced for Great Plains Dynamics and eEnteprise 7.5 on Microsoft SQL Server 2000 and Microsoft RMS 1.2.  Current version is available (for Dynamics GP 2010 or 10.0 and MS RMS 2.0).  As general recommendation, we suggest you to upgrade to current (or minus one) of Microsoft Dynamics GP and MS RMS, as if you do try to implement this tandem on older versions, chances are high that you will be paying extra price for technical support and possible fixes down the road

6. Dynamics GP Warehouse Management System as complete barcoding solution for your stores.  As an addition to the integration described above, in the case when you are mod-size retail and distribution chain, we suggest you to consider Dynamics GP WMS extensions.  This product works out of Dynamics GP Databases and naturally open such Great Plains business logics as SOP Sales Order, POP Purchase Receipt, Inventory transaction and transfer to barcode scanning

7. Recovering unsuccessful Dynamics GP implementation in retail environment.  If you are not happy (or up to the point to say frustrated) with your implementation progress, there might be various factors in place, including your next Corporate ERP selection homework lapses, the lack of industry expertise of your chosen Dynamics GP Partner or Consultant (typically we, consultants in ERP consulting community are trying the best to help you out, but from time to time we over estimate our ability to learn new product as the implementation happens).  Whatever was the reason, we are happy to review your case and give you second opinion

8. Give us a call: 1-866-528-0577, help@albaspectrum.com.  Local service in Illinois, Michigan, California, Texas.  We are positioned to do remote support for Dynamics GP implementations and Warehouse Management System user training.  International support is possible, our consultants speak Spanish, Russian, Chinese, Portuguese.  Our general customer profile is small and mid-sized retail stores USA, Canada nationwide, here we serve via short visits onsite for the implementation and user training and following remote support via web sessions and phone conferences

http://dynamics.ezinemark.com/microsoft-dynamics-gp-and-rms-integration-options-16784357092.html

Microsoft Dynamics CRM For Scalable Inventory Management

Microsoft Dynamics CRM For Scalable Inventory Management

When retailers or any other companies that deal in products use any inventory management system, they need it to have a lot of flexibility and scalability. What starts out as a small business will typically grow over time and the inventory management solution should also be able to cope with the expansion.

If you are a business that has inventory and products as well as vendors and orders and are looking for a scalable, robust and flexible system that will grow in tandem with your business, Microsoft Dynamics CRM is made just for you. As a matter of fact, this system is so robust that it blends in perfectly with the workings of a number of different industries.

Customized Functionality

Once zero2ten has customized the functions and created the perfect CRM solution for you, the functionality of expanding it to suit your business needs is something that we can help you with any point of time. It happens very often that there is lot of data that needs to be tracked, but the legacy system you use to maintain records is not scalable and you have to add another application to the existing one.

We will be able to provide you with the perfect add-ons for your CRM solution and you will be able to keep track of every piece of relevant information such as bins, barcodes, serialized items, warehouse locations, gridded items, order picking vendors PO’s and much more.

In Innovation Mode

We have added a dash of our special innovation quotient to the inherent qualities that the Microsoft Dynamics CRM has. With our solution, you can get customized mobile barcode-scanning applications which integrate seamlessly with the CRM. We are very focused in our approach towards providing customers with customized CRM solutions and have served a number of clients from the warehouse and retail space.

With every passing year, even as Microsoft upgrades it’s CRM, we too innovate a little more and ensure that you as a customer have the exact functionality you need- no less, no more. In fact, that is exactly what a lean system is all about. It provides you with all the muscle you need in terms of functionality, and has no excess fat at all.

The Lean System

That makes your custom Microsoft Dynamics CRM solution less complex and more user-friendly. The fact that all your staff can be provided with the kind of access they need and have quick visibility of all the relevant data, regardless of where they are, makes a significant difference to the manner in which your operations are run. When your staff has less administrative tasks to deal with and they can deal with requirements on the go, via their mobile devices, it is bound to have a positive impact on the productivity of your team and the profitability of your company.

All of this is possible but only if your solutions provider has the knowledge and the skill to provide you with the kind of solutions that will match your requirements to the tee. That is exactly what we at zero2ten do for every one of our customers- be they enterprise-scale or even from the medium or small niche segment. Check our website http://www.zero2ten.com/personalized-crm.aspx and let us know how we can be of service to you.

http://www.sooperarticles.com/technology-articles/computer-architecture-articles/microsoft-dynamics-crm-scalable-inventory-management-1367928.html

Infor Visual, Microsoft Dynamics AX and Epicor 9 ERP Software

Infor Visual, Microsoft Dynamics AX and Epicor 9 ERP Software

Infor Visual, Microsoft Dynamics AX and Epicor 9 ERP softwares come with all the options and functions necessary and helpful for manufacturing companies. Infor Visual, Epicor 9 and Dynamics AX also provide options and functions for distribution thus these ERP solutions can be utilized by manufacturing companies for managing their warehouse more efficiently and also as a solution for wholesale distribution companies.

Infor Visual comes with complete solutions for CRM providing facilities for quoting and estimating, custom pricing and commissions, sales forecasting and e business and web store front. Dynamics AX also provide CRM function where business relations with customers, vendors and leads are maintained and contacted. Epicor 9 too comes loaded with CRM solution for better work efficiency.

Infor Visual, Dynamics AX and Epicor 9 ERP software are more inclined towards manufacturing companies so there an option encompasses all the aspects of production planning, execution and manufacturing control functions. Infor Visual ERP solution provide options for MRP- materials requirement planning, advanced material planning, shop floor controls, quality management, BOM, production scheduling and lean manufacturing. Shop floor controls are available in extended core of Dynamics AX, it also provide options for master planning where purchase and production planning is done, inventory management and production where BOM is defined and every step of manufacturing is tracked down. Epicor 9 manufacturing module contains real time production management, rule based product configuration, product life cycle management, advanced planning and scheduling and support for lean manufacturing. Infor Visual, Dynamics AX and Epicor 9 ERP softwares provide complete solution for manufacturing and give necessary control to the

management to keep a track of every step and avoid redundancy.

Distribution is another feature incorporated in these ERP softwares for better management of finished products, raw material, multi dimensional inventory and shipping and receiving. Infor Visual comes with radio frequency enabled warehouse system. Dynamics AX provide the features of supply chain management through accounts receivables, inventory management and accounts payable with warehouse facility. Epicor 9 has features like supply chain management, planning and scheduling, product data management and production management, its sales management module covers the requirement of manufacturing or wholesale distribution companies for pending orders and shipping and logistics details.

Infor Visual provides features of financials and cost accounting in back office module these features contain general ledger, accounts receivable and payable with vendor and cash management. Cost accounting module covers the feature for human resource, time and attendance. Microsoft Dynamics and Epicor 9 too have similar facilities for finance and accounts. Dynamics AX contains expense management and environmental management as separate options as enhanced features for cost accounting. Epicor 9 comes with modules like financial management and enterprise performance management for better and in depth view of organizational performance in terms of profit and loss. Infor Visual, Dynamics AX and Epicor 9 ERP softwares come with handy features for improving the functionality of organization in an economic way to reduce cost and increase profit margins. It allows better inventory management and prevents dead and immovable stocks which increase operational margins of manufacturing as well as wholesale distribution

companies.

Read Microsoft Dynamics AX Review – advantages and disadvantages. Also read about Low Cost ERP Software. Read review on Infor ERP Software.

http://nickmutt.articlealley.com/infor-visual-microsoft-dynamics-ax-and-epicor-9-erp-software-1606389.html

Compare Microsoft Dynamics CRM to Prophet CRM

Compare Microsoft Dynamics CRM to Prophet CRM

Make your company profitable with CRM software.

In today’s world when the market is so competitive, companies have to take care to keep their customers coming back, and one of the best ways to do this is by using customer relationship management, otherwise known as CRM. Having a good CRM software system in place is important if you are going to make your company a profitable and successful one. However, there are a variety of different software options, including software like Prophet CRM and Microsoft Dynamics CRM software. Prophet is a software that is offered by Avidian and of course Microsoft Dynamics CRM is offered by Microsoft. Both CRM software programs have quite a bit to offer, but you may want to take the time to compare the two options before you decide if Microsoft Dynamics CRM is the right choice or if Prophet is the best choice for your company. So, let’s take a look at both Microsoft Dynamics CRM and Prophet, how they compare, and which one is the best choice for most companies.

The benefits of Microsoft Dynamics CRM.

Microsoft Dynamics CRM is a software option for businesses that was designed to help meet integration requirements for a variety of different business systems, whether they are complex ones or even simple ones. Also, Microsoft Dynamics CRM was designed to work with different types of software applications that business use, such as Microsoft applications and other applications from different providers as well. In fact, Microsoft Dynamics CRM actually will even work with software that is custom designed as well. One of the main benefits of using Microsoft Dynamics CRM for your business is that it works so well at providing your employees with information that is up to date. You’ll also find that with Microsoft Dynamics CRM, you’ll be able to share the information between different departments as well. Having Microsoft Dynamics also helps businesses to be able to streamline their processes. Microsoft Dynamics makes it easier on employees, since they don’t constantly have to reenter information. This gives them the opportunity to work on other important sales tasks that will keep your company making a lot of sales.

Microsoft Dynamics CRM is great, but Prophet CRM software is better.

Now for a look at the Prophet CRM software, and how it works. Prophet was designed and is marketed by the Avidian company, and unlike Microsoft Dynamics CRM, this is a software option that has been awarded many different awards. In fact, one of the best CRM software options on the market today is considered to be Prophet. Sure, Microsoft Dynamics CRM does have much to offer, but they have a hard time coming close to what Prophet can offer businesses for their CRM needs. First of all, the Prophet system is very easy to use and it is also extremely easy to implement into a company as well. The price on Prophet is reasonable as well, and it is cost effective. In fact, you’ll be able to have this software customized just like you want it, which is not something that all CRM software options, such as Microsoft Dynamics CRM can offer. Automated emails are another benefit that Prophet offers as well, which makes following up with customers a breeze. A calendar option is also a part of the Prophet system, which can be helpful. You can even make reports with Prophet which help to keep track of how the company is performing so you can make sure that you company is working at it’s best.

Prophet CRM software system is a better option.

While both Microsoft Dynamics CRM and Prophet CRM have a lot to offer, if you are looking for the best possible CRM software system for your business, you’ll want to go with Prophet instead of the Microsoft Dynamics system. Prophet can offer a better option for a price that is cost effective, which makes it a better choice than Microsoft Dynamics. So, if you are ready to start growing your business, increasing your sales, and enhancing your overall business success, instead of turning to Microsoft Dynamics CRM for help, consider going with Prophet CRM software. This software has so much to offer and there have been many awards offered to Avidian for this software as well. In fact, Prophet actually has a four star rating with PC World, which is not easy to get. So, until Microsoft Dynamics CRM can boast about the same awards, you’ll be best going with the Prophet software.

Author Bio: James Wong is the co-founder and CEO of Avidian Technologies, makers of Prophet, The easiest CRM software for Outlook, CRM – Your Business Solution.
For more information about Avidian, visit www.avidian.com

http://noeal11.articlealley.com/compare-microsoft-dynamics-crm-to-prophet-crm-863795.html

Know the Differences of Infor Visual, Microsoft Dynamics AX and Epicor 9 ERP Software

Know the Differences of Infor Visual, Microsoft Dynamics AX and Epicor 9 ERP Software

Infor Visual, Microsoft Dynamics AX, Epicor 9 ERP software are especially designed in order to help manufacturing companies. Their features and functions cover every aspect involved in manufacturing a product and they also offer efficient solutions for distribution, including warehouse management and shipping management. This makes Infor Visual, Microsoft Dynamics AX, Epicor 9 ERP software also suitable for being used by wholesale distribution companies, although they are more oriented towards manufacturing businesses.

Infor Visual claims to be appropriate for any company, regardless its size. It allows the user to plan the production in an efficient manner, to schedule the jobs, to manage the inventory and to take the best decisions in what concerns materials and suppliers. It has options like materials requirement planning and advance materials planning. It also makes quality management a lot easier and, as well as Dynamics AX, provides a shop floor control option.

Dynamics AX is suitable to be considered by companies that intend to expand their activity or to enlarge their customer base. It will help those companies to manage the change in the most profitable manner.

Epicor 9 also has a lot of options that help planning the production, planning the sales and making the best choices in what concerns the supply chain. Its sales management module makes it suitable for wholesale distributors because it allows a comprehensive management of the orders and it offers support for logistic details.

Infor Visual, Microsoft Dynamics AX, Epicor 9 ERP software all provide solutions for the inventory management, keeping shipping products and receiving materials under control at all times.

Another useful feature that Infor Visual, Microsoft Dynamics AX, Epicor 9 ERP software have is related to financial management. They improve and fasten the processes that take place in the financial department of the company. The cost accounting module that Infor Visual has also covers the management of the human resources. Dynamics AX also has such a module and it comes with an expense management option and with an environmental management option. Financial management is possible with Epicor 9, too and this also has a separate module for measuring and managing the performance of the company. It is helpful in establishing a strategy on the long run and in taking the best decisions in what concerns the company.

Infor Visual, Microsoft Dynamics AX, Epicor 9 ERP software provide valuable solutions for companies and help the management control every phase of the activity. They definitely lead to a decrease in the operational costs and it can certainly be said that Infor Visual, Microsoft Dynamics AX, Epicor 9 ERP software are an investment that will pay off very fast.

Read Microsoft Dynamics AX Review – advantages and disadvantages. Also read about Low Cost ERP Software. Read review on Infor ERP Software.

http://ryanmutt.articlealley.com/know-the-differences-of-infor-visual-microsoft-dynamics-ax-and-epicor-9-erp-software-1618543.html

Comparison on Sage ERP X3 vs Microsoft Dynamics AX ERP Software

Comparison on Sage ERP X3 vs Microsoft Dynamics AX ERP Software

The debate on Sage ERP X3 vs Dynamics AX makes taking a decision very difficult because they are both competitive, manufacturing oriented and capable of providing effective business solutions. In order to find out which one is most suitable for a certain company, one needs to make an in depth analysis of the features and options the software provides.

Sage ERP X3 vs Dynamics AX is a very close competition from the point of view of the features. They both offer similar solutions for every business process involved in a manufacturing company. CRM, BOM, order management, sales management, material planning, shop management, accounts payable or accounts receivable are just a few features both products have. A difference between them can be noticed when it comes to managing warehouses, because this option is better defined in Dynamics AX. On the other hand, Sage ERP X3 is in advantage when it comes to the CRM module because it has a few extra features than its “competitor”.

Dynamics AX covers every aspect involved in manufacturing and distributing products. It even has an option that allows the user to develop a portal of the company that brings together customers, employees, suppliers and other interested parties in order to improve communication and collaboration. Another feature that is not found in Sage ERP X3 is the environmental management. This means that using this software will allow the company to monitor their consumption of energy and emissions. Dynamics AX also has a reporting component which assists the management decision, offering guidance in making the best business choices. Besides all these, it is popular software because it is compatible with other widely used Microsoft products.

Sage ERP X3 vs Dynamics AX might seem like a very balanced debate and the costs of software might help someone take a decision easier. The first product claims to be the most affordable available on the market and to deliver maximum functionality at low operational costs. It also provides tools that will help the management take the best decisions in what concerns business aspects and it has access options that ensure employees, customers and suppliers can easily access information, either online or through client-server operation. All the hard work involved in keeping the web store inventory is eliminated due to the fact that Sage ERP X3 provides support for e-business. This also allows a better management of the company’s website and a better web design.

Deciding between Sage ERP X3 vs Dynamics AX can only be done after considering the particularities of the company, since they both have features that differ so slightly.

Find information on the benefits of Web Based ERP system. Read information on SAP R/3 Architecture and system management. Read review on Infor ERP Software, advantages and disadvantages.

http://ryanmutt.articlealley.com/comparison-on-sage-erp-x3-vs-microsoft-dynamics-ax-erp-software-1618541.html

Crystal Reports for SQL Based ERP Systems SAP Business One, Microsoft Dynamics

Crystal Reports for SQL Based ERP Systems SAP Business One, Microsoft Dynamics

SQL Server opens new horizons in Crystal Reports design and deployment. Here you can separate the report presentation from data selection layer. Instead of linking tables directly in CR you can now create SQL View or Stored Procedure and test their results prior to opening Crystal Reports Designer. Talking about specific Corporate or Small Business ERP platform – here you need to know table structure in order to produce SQL View. In this small publication we would like to give you two examples: SAP Business One and Microsoft Dynamics. Let’s begin with advantages of SQL View and Stored Procedure as report data pulling:

1.SQL View. Let’s assume that you do not want to do select statement test directly in Crystal and would like to avoid such annoying issues as duplicate rows and incorrect summaries. Plus you would like to use such constructions as SQL Union. And in addition to that you do not want to create the whole report and then potentially realize that it doesn’t work as expected and you would have to redo tables linking and redesign pretty much the whole report. Then what you may decide to do is create SQL View and test its results in SQL Server Management Studio

2.Stored Procedure. CR is treating final Select statement or Union as its base. Stored Procedure parameters are translated into Crystal parameters. What are the advantages of Stored Procedure? Well in SP you are not restricted to just sophisticated joins in Select statement or Union. Here you can use parameters, temporary tables, data update (be cautious do not compromise data integrity!). It is also possible to use Exec statement and build Select statement on the fly analyzing the set of parameters. You can also use SQL cursors especially in building temporary tables. Stored Procedure could give you the advantage of better performance comparing to the view as here Crystal doesn’t have to apply restrictions to the total View selection and all the job are done in high performance SQL Server. Let’s now move on to SAP B1 tables and fields

3.SAP Business One. If you are not doing long term programming project in Software Development Kit then there is no need to install it and review tables diagram from there. We recommend you just login SB1 user workstation and in menu mark View -> System Information. Let’s now assume that your custom report will need to pull the fields from Sales Invoice. Open Sales invoice form and place the cursor over the field in question. Table and field name information will be displayed in the bottom left corner of the user interface. Some comments before you begin your SQL View or Stored Procedure creation. SAP BO is three tiers Small Business ERP application. This means that direct data update via custom SQL statements will be detected by Watch Dog service and transmitted to SAP. Consider just data selection and try to avoid updates on the SQL Stored Procedure level

4.Microsoft Dynamics ERP and CRM Family. There are several products where direct select from SQL Server database is OK. Among them GP (formerly known as Great Plains), NAV (former Navision), SL (originally Solomon) and CRM. In the case of Dynamics AX Axapta direct access to SQL Server is not recommended and instead you should consider X++ code and such development tool as MorphX. Microsoft actually is trying deemphasize Crystal Reports and rather recommend SQL Server Reporting Services (SSRS)

5.Financial Reporting where Crystal is not recommended. General Ledger is tightly connected with Accounting theory and double entry. If you need to produce Balance Sheet, Profit and Loss Statement or Statement of Cash flow including consolidated versions please consider such tools as Microsoft Management Reporter or its predecessor FRx. If you decide to recreate P&L directly in Crystal you should expect to reproduce most of FRx business logic and this is in our opinion not a feasible idea

6.Please call us 1-866-304-3265, 1-269-605-4904 (for international customers, where our representative pick up the phone in St. Joseph, MI call center) help@efaru.com. We have local presence in Chicagoland, Southern California, South West Michigan, Houston and Dallas areas of Texas. We serve customers USA, Canada, Mexico, Brazil nationwide and internationally via web sessions and phone conferences (Skype is welcomed). Our consultants speak English, Spanish, Portuguese, Russian, Chinese. Our core expertise is in International Business

Andrew Karasev is Great Plains Certified Master, MVP, help@efaru.com 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project http://www.efaru.com and founder of Alba Spectrum information space

http://akarasev.articlealley.com/crystal-reports-for-sql-based-erp-systems-sap-business-one-microsoft-dynamics-2390906.html