Posts Tagged ‘Plains’
Great Plains Reports? Creating and typical design tools
Microsoft Dynamics GP reporting is an essential part of GP implementation and post production ERP support. Regarding the implementation of MRP typical mid-size, you must wait several information tools, especially if you think about reports genre: financial information, business processes specific reports, etc. Also, when Microsoft incorporates MS SQL Server Reporting Services or SRS and type recommended by the first tool of choice – Crystal Reports, you must do your homework in selecting the reporting tool that should be proposed and jobs. In this article we would like to review the main reporting tool for Microsoft Great Plains and give guidance
1. Great Plains ReportWriter or RW. This tool is integrated into the environment GP skill, which means that the work of the GP user interface and in the field of security of the Great Plains. RW is the tool to look first when you are customizing something which you call from GP interface: the form of sales order processing of the invoice, for example. Do not expect too much from Report Writer, as it has many limitations: you can work from existing GP screens for sets of parameters predefined by existing GP standard logic. To create custom reports in RW and the call from GP interface with a selection of custom settings, you must create GP Dexterity customization and call your report from there
2. Crystal Reports and SRS. These two report design tools compete on the market and, in some similar characteristics. When the base of the logic of relations GP SQL stored procedures, print the final report could be done with the same success of the Czech Republic and the SAR, so it is probably the tool of the question that is most comfortable for you their skills and experience. The advantage of SRS and CR is the following – you can actually create cons-modules and report every night. You should also consider comparing stored procedure in SQL views, stored procedure allows you to send the settings and create temporary tables in the code SQL script – that’s what can not be done in SQL views. However, if you’re looking at the creation of pure financial statements: income statement, balance sheet and cash flow – you need to keep reading
3. FRx. FRX advantage of Crystal Reports Designer and SRS is the connection to General Ledger interface Medicine. With FRx, you can also cross company boundaries and create a consolidated report. FRx allows you to create one’s own declaration of trees, where you can create a report with specific segments of the GP in multiple businesses. In addition, FRx give the link to the Excel spreadsheet, when you have something like small industry data accounting you want with the declaration of the consolidated />
4. Microsoft Excel reporting options. Imagine that you recognize the fact that most people trust their accounting department of Microsoft Excel and not follow company procedures to use complex tools such as MS Outlook or Microsoft CRM. In GP, you can export data to Excel in the bulleted list or a more advanced tool – Smart List Builder, where you can create custom views based on SQL statements that br
5. SQL Select statement. If your return and exploration and discovery of the data changes every day, and the creation of Crystal Reports can not be permanent, and if you have decent programmer and staff developer in SQL, you should consider ad-hoc SQL script command to export to Excel to generate the required reports. You should be aware that if their managers need to build data warehouses daily, then you must deploy SQL Server Analytical Services with Excel pivot tables or Cognos
6. Microsoft Access Reports option. If your IT people experience covers MS Access, consider using the ODBC connection to the database and use of access to GP reports
7. MS Visual Studio.Net custom programming reports. If you have a strong C # and Visual Basic developers should consider training in eConnect and then be able to create reports from Web applications. In case if you want to extend eConnect logic with direct access to the tables in the Grand Prix, please review GP tables structure – Tables of Microsoft Dynamics GP-> Tools-> Resource Description->
8. Archaic DB platforms. If you are still in GP 7.5 and earlier versions, you can use Pervasive SQL Server 2000 or Ctree FairCom /. If this is your case, you should use the following tools: MS Access, Crystal Reports (which are limited to ODBC driver limitations to cross GP modules restrictions), or GP Dexterity customization. Also, if you are in the previous version, you should consider upgrading if your business is in active mode – the current version of GP 10.0 and must use the Migration tool MS SQL Server GP version
9. Cross-platform reporting. In this case, we recommend that the first revision of MS SQL Server linked server concept can also consider other similar tools from Oracle EDI.
10. Generic ERP reports. If you are in PeopleSoft, Oracle E-Business Suite, Peachtree, MYOB. Second, the reporting tool requires the task
Dynamics GP partners and ISVs California, Illinois: Great Plains Technical Support
If you have Microsoft Dynamics GP, formerly Great Plains Dynamics, already implemented or are planning to view the presentation techniques or management, which would give some highlights of the technology, more customization, integration, options reporting, technical support and upgrade information. We assume that found in Southern California: Los Angeles and San Diego metro, in northern Illinois: Chicago subway or even the U.S., Canada nationally and internationally (if you need custom programming for GP skill, or the need SAP Business One Integration System Dynamics GP U.S.). Note also that if you have an earlier version of the Great Plains, you should know about your database platform: GP 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 and earlier versions are available in MS SQL Server , SQL Pervasive and 2000/Btrieve Ctree. In addition, more products from Great Plains Accounting 9.5, 9.2, 9.1 and earlier versions for DOS, Windows and Mac is also acceptable with some limitations, and which in turn can not help directly from Microsoft Business Solutions Act and can not sell licenses new user, are not compatible with what had historically
2. National Remote Support Dynamics GP. This option is really beneficial for the customer, not pay for our trip to the local level and not have to wait a consultant to carry out its agenda y. Technical support is theoretically available immediately through web session and phone conferencing. If you are international, you can use technologies such as VoIP Skype free conference call
4. Dynamics GP Integration with Microsoft RMS. We tested the codes, that integration is very specific to the configuration of RMS and how you want to map the dynamics of the objects of general protection. Integration of work or Dynamics GP SOP or credit management module, the more you understand purchase receipts POP integration and print barcode labels directly from the Great Plains – found that a reasonable number of customers prefer MS RMS maintain control of these processes in their ERP system, in our case Dynamics GP
6. Great Plains version update. Here, you must be active in Microsoft Dynamics GP Business Support Programme annual, if not call us for options to rewind. Then you have access to a new version registry key. Dynamic GP version update is to be expected, it should be by Reseller Dynamics GP and GP certified consultants, as there are patches and update the package of services and solutions. If you are in version 7.5 on Pervasive SQL / Ctree or older, must pass through the migration of GP in the process for Microsoft SQL Server. Update Dynamics GP should also include ISV-ins, reports GP ReportWriter modified modifiers VBA, Integration Manager, FRx Financial Reporting Update
10. Dynamics GP EDI or electronic document exchange integrations. We offer these scripts in views MS SQL Server and stored procedures, which should help avoid the high costs of EDI Accessories
Microsoft Great Plains Integration Manager 10.0 technical notes
Microsoft Dynamics GP version 10.0 advanced new technologies as eConnect in what appears to be the general trend within walking distance of unique tools such as Microsoft Dexterity to Microsoft specific platforms such as. Net, COM + and MS SQL Server stored procedures, you know eConnect core contains encrypted stored procedures. Historically Great Plains IM was based on OLE technology, which used the workstation doctor as an OLE server and validating the business logic is done in the GP forms, where OLE mechanism was entering values field. Take a look at traditional and new features available in version 10.0 of MI, in our opinion, is in transition to be completely rewritten in eConnect, but is currently available in two traditional and eConnect connectors:
/>
1. eConnect connector. For consultants GP should be aware that eConnect connector requires specific company, if you remember how OLE connector – which recognizes the company you are calling Integration Manager, and is not necessary to specify the parameters of society in the integration. eConnect requires the company’s objective to specify. eConnect integration performance should be higher compared to traditional connector, such as eConnect does not use OLE technology mimics slow and business logic (or in other words, it replicates the functionality of skill) in SQL stored procedures (running at the server). Typical integrations involving GP Sales Order Processing module (which includes scenarios of e-commerce) and the order processing module (which integrate EDI invoices, for example) and at the time, IM GP 10.0 eConnect connector allows these integrations, which you feel very optimistic />
3. Integration Manager VBA programming. This technology may seem obsolete VBA was popular in late 1990th to automate MS Excel, MS Access Type of access scenarios. However, VBA and always switch modules are available with Microsoft Dynamics GP purchase or upgrade. VBA scripts based on events, then you should consider options for changing the business logic in the integration of instant messaging, pre and post, pre and post document. Format this article is short and we can not give examples of VBA scripts here, but if you have a development budget and want to get technical assistance and advanced programming, we will be happy to help br
4. GP of advanced instant messaging. Translation technology. Each field is available for translation logic. You can load the translation table instant messaging directly in Excel. logic translation element allows you to mark the outside of your ID card to an inmate, or collection agency for example, allows you to translate this seller to customer identification, the collector is reversed one hand, means to collect sales
5. IM in cross platform integration, it should be noted here ODBC standard and advanced integrations. Microsoft SQL Server 2000 and 2005 the construction of the linked server can implement any SQL statement or OPENROWSET direct selection. It has now Oracle and Oracle E-Business Suite world, the concept of similar integration is available in Oracle EDI. If you are running Linux Red Hut and PHP and MySQL, please consider ODBC bridge or use of Java technology. If PHP is sitting on the MS Windows platform, you can implement direct call to MS SQL Server 2005 or 2000
6. GP Data Conversion and Integration Manager. Massage legacy data conversion is available and the use of instant messaging is very useful. Microsoft Dynamics GP offers a licensed or instant messaging initial migration, which limits the number of days
7. Tables integrate the most popular in the Great Plains: SOP10100, SOP10200, RM00101, RM00102 />
9. GP and Microsoft CRM connector. GP is out of IM, so should not be confused. MS CRM Business Connection is about the support of Scribe Software, so please check with these people first. In addition, SAP Business One is very popular among small business ERP and MRP (manufacturing module and extensions) platform, where you can have Microsoft CRM to be integrated. The part of Microsoft Dynamics CRM, you can use SQL views and stored procedures to store the exported data in custom database, and SB1 side are using SAP B1 SDK to program SB1 objects including: sales orders or invoices sale
10. XML Web service approach. Because XML is the text of the essence, the platform-independent data (or text files) flows. Web Service to open UNIX client, a doctor usually involve C3 side or VB.Net developer />
You Great Plains Technical Consultant
Microsoft Dynamics GP consulting field nowadays typically requires expertise and experience. If you are deploying Microsoft Great Plains in companies large or medium, it is expected that the new ERP application to integrate seamlessly into your existing IT infrastructure: Microsoft Windows domain, probably the system components are not Microsoft, and Linux Red Hut PHP and MySQL (Linux or another brand), the integration of Oracle database, and the like. Also take into account the needs of implementations of failing to compete MRP products: Oracle E-Business Suite, PeopleSoft, Peachtree, ACCPAC, MAS 90 or 2000 – then the need for expertise in the ERP conversion data will be even more valuable. We will try to maintain a reasonable balance in the council requires knowledge of ERP, to examine in this article />
1. Great Plains Dexterity – is more likely to be. Historically, in the early 1990th Great Plains Dynamics software has been designed on the platform GP Dex. Dex is, in fact, C-shell, which means that the C programming language was used in the development of integrated development environment for skill. Of course, Microsoft is currently the marketing and positioning in MS GP. Internet platform, so nice skill inheritance, in relation to. Net But here we have to play the role of apologetics Dex – the GP business logic was designed and programmed by Dex, and then upgrade the skill path modification is essential for
2. Great Plains data massage, this is linked to GP data conversion. ERP data conversion must stage, but usually is not something that is cheap and you should consider all options before embarking on large-scale data and immigration>
3. GP heterogeneous reports. Microsoft SQL Server allows SQL constructs implemented as a linked server, you can query the data (using the OPENROWSET) platforms other than Microsoft, such as Java, Oracle, Sybase and IBM DBII />
4. eConnect. This tool or SDK initially devoted to developers and developers of electronic commerce, the opening of Microsoft Dynamics GP Field objects in the programming and integration of electronic commerce. eConnect should be moderate learning lesson for C # or VB.Net MS Visual Studio developer, as a whole encrypted SQL stored procedures
5. SQL Script GP Integration. Of course, this approach is not “object oriented” and is not recommended for someone who is considered a rookie GP. However, if you are scripting for Great Plains more than 5 years, must recognize that the SQL scripts is the most effective way for the integration of results />
Microsoft Dynamics GP and Great Plains Support, Implementation, Customization in California
Sometimes Corporate ERP application resellers are too pushing in making Software licenses sold and having technical and functional ERP consultants to eat up budget and at the end of the way leaving you in limbo. Well, you are not the first and probably not the last one – seek second opinion in Corporate ERP implementation. In this small publication we will review how Microsoft Dynamics GP could be recovered, including its older versions, known as Great Plains Dynamics and eEnterprise and even such archaic application as Great Plains Accounting for DOS, Windows and Mac. We are available locally as you can judge from the publication header, however we are service also USA, Canada nationwide and internationally via remote support (web, phone, skype conferences):
1. Great Plains Second Opinion. Through our Great Plains Consulting practice with initial customers served back in 1995, we should assure you that Great Plains, being mid-market ERP, Accounting and MRP application, requires industry expertise (especially in complex cases, where you need industry vertical or horizontal solution to be implemented, such as Warehouse Management System, B2B or B2C eCommerce, Wholesale, Retail, Distribution, Logistics, Consignment, Healthcare, Memberships and Clubs, etc.) with very strong Great Plains technology expertise and multiple yours of exposure to such technologies as Great Plains Dexterity, eConnect, Extender, Integration Manager, VBA/Modifier, Report Writer, Crystal Reports, SQL Queries against Dynamics GP tables. At the same time, it is not too difficult to launch Dynamics GP Reseller business – you need to pass several GP certifications and you are ready to do your telemarketing and GP Sales presentations
2. Great Plains Dynamics Support. Here we assume that your implementation went OK and now you are in production with GP, trying to optimize Corporate ERP support budget. If the implementation itself was done by CPA oriented people, now you may shift your focus to technical support cases: Dynamics GP failed batch recovery, FRx installation on the new computer, applying new Dynamics GP Service Pack, Great Plains version upgrade, adding EDI or WMS, or ecommerce module, placing your company logon on Sales invoice form in Report Writer or having minor or major data repair via SQL update and delete statements
3. New Dynamics GP Implementation or recovering unsuccessful one. Here typically you are facing such issues as business processes mapping (where either Dynamics GP ISV Add-ons might be required or Dynamics GP Dexterity programming), plus data conversion from your legacy accounting (Quickbooks, Peach Tree, GPA for DOS, MYOB, Accpac, Macola, or even when you are downsizing from Oracle Financials, SAP R/3 or mySAP)
4. Dynamics GP Customizations. Microsoft Dexterity, while allowing you to have complete control over Dynamics GP business processes and data, requires multiple years of experience from Dexterity programmer to be engaged in the customization project professionally. We recommend you to check with Microsoft Business Solutions if your proposed Dynamics GP Partner is participant in so-called Source Code program (where their Dexterity programmers have access to Dynamics.dic dictionary with all the Dex Sanscript procedures, functions and triggers available). If you are deploying Great Plains for many years, chances are high that you have Dexterity customizations, as well as Modifier with VBA custom scripts, Integration Manager with VBA even handlers, Extender modifications, VBA Continuum scripts (where you can switch Dexterity custom dictionary context from Great Plains Dynamics to something like Intellisol Advanced Purchase Order Processing or Project Accounting and then run Dexterity Sanscript code against the switched dictionary)
5. FRx Financial Reporting. We have to say that FRx Financial Reporting is very popular and has interfaces to multiple Corporate ERP and Accounting applications, such as Dynamics AX, SL. And probably due to its diversification FRX has some settings, that should be done by professional FRx consultant and report designer (usually Sysdata specification set repair, rebuilding GL indexes, FRX version upgrade and service packs, there are also known issues on FRx catalog to be relaying on local computer personal data folders)
6. Great Plains Report Writer. Here you typically have such reports as SOP Blank Invoice form (where you place company logo), POP Purchase Order (to be officially mailed to your suppliers for bidding or participating in the tender). We saw issues in RW version upgrade, especially when you are on really legacy Great Plains Dynamics Version, such as upgrading from 5.0, 6.0, 7.0, 7.5 all the way to Dynamics GP 9.0, 10.0, 11.0 (also referred as Dynamics GP 2010)
7. Modifier with VBA. This technology proved to be the one which passed time test. If you are not a Dexterity programmer, and you still need to modify Great Plains forms – you can do it intuitively in Modifier, and then attach VBA scripts (where you can interact with GP tables – be sure you known the table you want to address) via archaic pre Microsoft .Net ADO technology
8. Integration Manager. Here you are usually facing such challenges as Data Massage, Migration or Conversion. IM could be considered as end user friendly tool, where you can quickly setup integration to pull data from text file (tab, comma or custom character delimited file), or if you need more industrial strength integration, you appeal to IM Advanced ODBC data source, where you can select the data from Text file (with aggregations, and preprocessing, comparing to simple ODBC), ODBC compliant DB platform, examples would be Oracle, MySQL/PHP, Progress, MS Access, Pervasive SQL, Ingress, IBM DBII
9. Great Plains Accounting for DOS, Windows and Mac. The most popular versions, where GPA customers were frozen since the year 2000 are GPA 9.5, 9.2, 9.1 (90 percent of the cases where GPA customer is using DOS interface, then 7% where GPA for Windows are in use and the rest goes to Macintosh). We are one of the few Microsoft Business Solutions VARs who are trained in Great Plains Accounting support and data recovery. From time to time MBS offers lucrative discounts to upgrade (or virtually walk away from GPA platform to Microsoft Dynamics GP current version 2010 as it is effective on August 2010)
10. Microsoft Small Business Financials. This small business ERP application was introduced as alternative to Great Plains Select on MS SQL Server version 7.0 (and probably even 6.0, but without a great push for sales). The idea was really great for the time, when Oracle was trying to introduce Oracle Financials in preset package (scaled down small business Corporate ERP), or SAP was in process to purchase and prepare for ERP market competition its SAP Business One. Later on (around 2008), MBS decided to expire support for Great Plains Small Business Financials and the last version was 9.0, from where you have to migrate to Microsoft Dynamics GP
11. Intellisol Advanced Purchase Order Processing or Project Accounting modules fate. It sounds like it was long negotiation between Great Plains Software and several Great Plains ISV partners to pick on which Add-on to be incorporated into Great Plains native set of modules. The winner was Matchdata, the company, based in Manila, Philippines, and Intellisol, Australian based Great Plains ISV lost its ground. There is migration tool, which should convert your Intellisol Advanced POP to Great Plains Purchase Order Processing transactions and master records
12. Requesting help? You can call us 1-866-528-0577, 1-630-961-5918 or email us help@albaspectrum.com We serve you in your local state, plus USA, Canada nationwide and internationally via Web sessions, phone and skype conferences
Great Plains for the implementation of large corporations general
Microsoft Dynamics GP is definitely a winner and break ERP. In this paper, we assume that you are not small or midsize business, where accounting options are well known and easily accessible. Here are recommendations to large companies in the business. First, you should already be in their previous roles in Oracle E-Business Suite, JD Edwards and Microsoft Axapta. Compared with the previous Grand Prix is a very good competitor, from approaches based on the budget. Budget does not mean he is not willing to pay, it means you do not have to pay for rich ERP functionality, it does not intend to use in the foreseeable future. Take a look at the strengths and potential weaknesses GP:
1. Microsoft SQL Server database platform. Here you have the scalability, which corresponds to the variety of businesses, from sole proprietorships to large corporations. SQL Server 2005 and 2000 are strong competitors for these established platforms Oracle DB, index, MySQL. The thinness of modern SQL platforms is that it is unlimited (limited by disk space addressing, server RAM, etc)
2. Luxury GP modules. Former name Great Plains Dynamics suite for the business enterprise was eEnterprise and later in the Great Plains Professional. Here we would like to briefly review modules such as manufacturing, collection management, Service Management Suite and Services, Microsoft CRM
3. Microsoft Dynamics GP Business Portal. This new platform is that coexists in the same schema and data are stored in the business of traditional databases CU. BP is the foundation of SharePoint Web application that allows you to automate functions such as electronic commerce (BP Order Management), Purchasing (Purchasing Management), HR (Employee Self Service), electronic document delivery. BP is likely that Microsoft Dynamics platform for electronic commerce, and significantly extend the traditional Great Plains user license model, where end users (employees, customers, customer extranet) will be incorporated
4. Several routines. These compliance rules important for W2 printing payroll 1099, said the state tax calculations, based on delivery address statements are available at the GP of the standard or the third part of the logic />
5. Employee Self Service. This is part of the Great Plains Business Portal, the module that allows you to avoid the cost of mailing paper pay stubs for direct deposit to their employees and contractors of W-2. If you implement GP Business Portal Employee Self Service, the insider can simply print its website statements BP
6. Updated version. Modern software and MRP vendors try to keep short-term updates regarding new version of its annual programs and software development. This is their internal decision – if you are interested in meeting with modern technology, you must decide where and how to upgrade step version upgrades. We recommend you upgrade to a version of the script while the GP version 8.0 and upgrade to this version, version 9.0, jump and wait until 10.0 is released and updated from 8.0 to 10.0
Oracle Dynamics GP Great Plains Integration Notes
3. Connecting to Oracle. Here you can think of several technologies. If you work for the department stores of Oracle, which should already be familiar with Oracle ODBC options at the end. If you are a circle of Microsoft SQL Server, consider creating linked to SQL Server (MS SQL Server 2005 or 2000) to open the door for Oracle databases
4. Text files as data exchange, CSV and tab-delimited. This approach is possible if Oracle is in your Unix or Linux Premium (also into account the exchange of XML data, which refers to the idea of separate text file on the platform). Text files exported from Oracle database should be easily treated, either in Dynamics GP eConnect or Integration Manager Add-on. If your goal is to move GL transactions Dynamics GP General Ledger, Oracle Financials, you can export new records GL Dynamics GP through the eyes of the SQL table GL20000
Dynamics GP Guru Series: Great Plains Reporting Tools
If you try to do your homework and prepare for Microsoft Dynamics GP, formerly Great Plains Dynamics and eEnterprise the report of the – we are pleased to offer this small publication. In general, use the tool that best fits your specification report and especially the type of report: financial reporting, management reporting and reporting on industry compliance. We will review each tool in its approach and must decide if you need more visibility to the tool of choice, before calling their dynamic GP Consultant:
1. FRx Financial Reporting: Balance, P & L, cash flow statement and consolidated versions of these reports should be considered in FRx. In the Great Plains also quick financing and advanced financial reporting, but FRx is a more advanced and allows you to consolidate more than trees and drill down to transactions. Just another argument – if you think that all reports can be designed in Crystal Reports – you are correct in theory, but in this case, the code of a stored procedure or SQL View connection with the General Ledger tables: GL00100, GL10000, GL20000, GL30000, etc. This is exactly the value of FRx is – this work is done in FRx and all you have to do is design Row Format, Column Layout, and possibly reporting tree. FRx works with budgets, a comparison with the previous year, multi-currency functionality, allows links to external Excel spreadsheet (Excel in complex cases, you can get information from heterogeneous database platforms: Oracle, MS Access, MySQL – to provide enterprise-wide consolidation, where appropriate)
2. GP ReportWriter. Here you have sex, naturally called the UI Great Plains – good example is the sales order invoice blank. You, of course, change this relationship RW. Dynamics GP Report Writer gives reasonable range of management options: AR and AP aging, the balance of GL, Asset Register, Customer Statement, collection letters with certain restrictions to MS Word, Sales Commission Report
3. Compliance with industry reports. A good example is here Porte – you can choose to do so in the Report Writer, or move to Crystal Reports. If your version of BOL require intermediate calculations, please consider Great Plains Dexterity custom plug-in which these calculations can be performed, or restrictions calculations can be done in a stored procedure (SQL database and may or Report glass or a custom report on the skill SP)
4. SSRS. Besides the models of SQL Server Reporting Services, please consider custom reports. In our opinion the advantage of the Czech Republic is based Web reports. For other aspects of this tool is very similar to Crystal Reports, Microsoft Access or Excel reports
Information 5. Do not hesitate to call us at: 1-866-528-0577, help@albaspectrum.coIf try to do your homework and prepare for Microsoft Dynamics GP, formerly Great Plains Dynamics and eEnterprise the report of options – that is pleased to offer this small publication . In general, use the tool that best fits your specification report and especially the type of report: financial reporting, management reporting and reporting on industry compliance. We will review each tool in its approach and must decide if you need more visibility to the tool of choice, before calling their dynamic GP Consultant:
1. FRx Financial Reporting: Balance, P & L, cash flow statement and consolidated versions of these reports should be considered in FRx. In the Great Plains also quick financing and advanced financial reporting, but FRx is a more advanced and allows you to consolidate more than trees and drill down to transactions. Just another argument – if you think that all reports can be designed in Crystal Reports – You are correct in theory, but in this case, the code of a stored procedure or SQL View connection with the General Ledger tables: GL00100 , GL10000, GL20000, GL30000, etc. This is exactly the value of FRx is – this work is done in FRx and all you have to do is design Row Format, Column Layout, and possibly reporting tree . FRx works with budgets, a comparison with the previous year, multi-currency functionality, allows links to external Excel spreadsheet (Excel in complex cases, you can get information from heterogeneous database platforms: Oracle, MS Access, MySQL – to provide enterprise-wide consolidation, where appropriate)
2. GP ReportWriter. Here you have sex, naturally called the UI Great Plains – good example is the sales order invoice blank. You, of course, change this relationship RW. Dynamics GP Report Writer gives reasonable range of management options: AR and AP aging, the balance of GL, Asset Register, Customer Statement, collection letters with certain restrictions to MS Word, Sales Commission Report
3. Compliance with industry reports. A good example is here Porte – you can choose to do so in the Report Writer, or move to Crystal Reports. If your version of BOL require intermediate calculations, please consider Great Plains Dexterity custom plug-in which these calculations can be performed, or restrictions calculations can be done in a stored procedure (SQL database and may or Report glass or a custom report on the skill SP)
4. SSRS. Besides the models of SQL Server Reporting Services, please consider custom reports. In our opinion the advantage of the Czech Republic is based Web reports. For other aspects of this tool is very similar to Crystal Reports, Microsoft Access or Excel reports
Information 5. Do not hesitate to call us at: 1-866-528-0577, help@albaspectrum.com If you try to do your homework and prepare for Microsoft Dynamics GP, formerly Great Plains Dynamics and eEnterprise the report of options – is pleased to offer this small publication. In general, use the tool that best fits your specification report and especially the type of report: financial reporting, management reporting and reporting on industry compliance. We will review each tool in its approach and must decide if you need more visibility to the tool of choice, before calling their dynamic GP Consultant:
1. FRx Financial Reporting: Balance, P & L, cash flow statement and consolidated versions of these reports should be considered in FRx. In the Great Plains also quick financing and advanced financial reporting, but FRx is a more advanced and allows you to consolidate more than trees and drill down to transactions. Just another argument – if you think that all reports can be designed in Crystal Reports – you are correct in theory, but in this case, the code of a stored procedure or SQL View connection with the General Ledger tables: GL00100, GL10000, GL20000, GL30000, etc. This is exactly the value of FRx is – this work is done in FRx and all you have to do is design Row Format, Column Layout, and possibly reporting tree. FRx works with budgets, a comparison with the previous year, multi-currency functionality, allows links to external Excel spreadsheet (Excel in complex cases, you can get information from heterogeneous database platforms: Oracle, MS Access, MySQL – to provide enterprise-wide consolidation, where appropriate)
2. GP ReportWriter. Here you have sex, naturally called the UI Great Plains – good example is the sales order invoice blank. You, of course, change this relationship RW. Dynamics GP Report Writer gives reasonable range of management options: AR and AP aging, the balance of GL, Asset Register, Customer Statement, collection letters with certain restrictions to MS Word, Sales Commission Report
3. Compliance with industry reports. A good example is here Porte – you can choose to do so in the Report Writer, or move to Crystal Reports. If your version of BOL require intermediate calculations, please consider Great Plains Dexterity custom plug-in which these calculations can be performed, or restrictions calculations can be done in a stored procedure (SQL database and may or Report glass or a custom report on the skill SP)
4. SSRS. Besides the models of SQL Server Reporting Services, please consider custom reports. In our opinion the advantage of the Czech Republic is based Web reports. For other aspects of this tool is very similar to Crystal Reports, Microsoft Access or Excel reports
Information 5. Do not hesitate to call us at: 1-866-528-0577, help@albaspectrum.com If you try to do your homework and prepare for Microsoft Dynamics GP, formerly Great Plains Dynamics and eEnterprise the report of options – is pleased to offer this small publication. In general, use the tool that best fits your specification report and especially the type of report: financial reporting, management reporting and reporting on industry compliance. We will review each tool in its approach and must decide if you need more visibility to the tool of choice, before calling their dynamic GP Consultant:
1. FRx Financial Reporting: Balance, P & L, cash flow statement and consolidated versions of these reports should be considered in FRx. In the Great Plains also quick financing and advanced financial reporting, but FRx is a more advanced and allows you to consolidate more than trees and drill down to transactions. Just another argument – if you think that all reports can be designed in Crystal Reports – you are correct in theory, but in this case, code <-! Nextpage -> View in a stored procedure or a SQL connection in the General Ledger tables: GL00100, GL10000, GL20000, GL30000, etc. This is exactly the value of FRx is – this work is already done and everything FRx you have to do is to design Format Row, column design, and possibly reporting tree. FRx works with budgets, a comparison with the previous year, multi-currency functionality, allows links to external Excel spreadsheet (Excel in complex cases, you can get information from heterogeneous database platforms: Oracle, MS Access, MySQL – to provide enterprise-wide consolidation, where appropriate)
2. GP ReportWriter. Here you have sex, naturally called the UI Great Plains – good example is the sales order invoice blank. You, of course, change this relationship RW. Dynamics GP Report Writer gives reasonable range of management options: AR and AP aging, the balance of GL, Asset Register, Customer Statement, collection letters with certain restrictions to MS Word, Sales Commission Report
3. Compliance with industry reports. A good example is here Porte – you can choose to do so in the Report Writer, or move to Crystal Reports. If your version of BOL require intermediate calculations, please consider Great Plains Dexterity custom plug-in which these calculations can be performed, or restrictions calculations can be done in a stored procedure (SQL database and may or Report glass or a custom report on the skill SP)
4. SSRS. Besides the models of SQL Server Reporting Services, please consider custom reports. In our opinion the advantage of the Czech Republic is based Web reports. For other aspects of this tool is very similar to Crystal Reports, Microsoft Access or Excel reports
Information 5. Do not hesitate to call us at: 1-866-528-0577, help@albaspectrum.com
Great Plains Dynamics GP Consultant News: Fixed
Microsoft Great Plains functional and technical consulting
implementing ERP modules setup, data migration, integration and conversion, the programming of Medicine and design custom reports. In this small publication that you would like to come up with concrete steps in implementing Fixed Assets module for Dynamics GP:
1. book depreciation. You can have as many books as required by its budgetary and management information. A book, obviously posts depreciation transactions to General Ledger module.
..
two methods of depreciation for the Class-Book, Book-Fixed Asset ID, you can set the following forms of depreciation: straight line original or remaining useful life, 150%, 175%, 200% PP (or decreasing ), the figures for soybeans, and others. Note that the database can be configured to the desired percentage
.. 3 points to buy the property
-. There are two options It is in accounts receivable and the second purchase order processing in both cases, the link is considered fixed assets – Acquisition of capital account display in the window defined by the same name. If you buy your inventory through POP (or even Dynamics GP Business Portal Management Application), we recommend using the method of Post POP through the FA, here you can check the account or the command line is marked capital goods. In this case, your item in stock is not going to your inventory control module, but it reappears as the theme of death in the FA module
4. FA transfer. You can transfer your FA items between two locations or physical locations. location could be his apartment, where people sit in several buildings, or physical location, which could be the level of office construction, or manufacturing
5. FA plans. This form allows you to leave FA element with the options of selling a product in cash, or simply abolish it. Please note that retirement could be canceled.
6. Mass action. You can make a mass retirement, changing the weight or mass transfer
7. user-defined fields. If you think you need for objects of fixed assets group of an additional parameter, which could be used in, say, Crystal Reports or SQL Server Reporting Services, has up to fifteen user defined fields in the design
8. integration of AF. capital module has its own integration tool. However, part of FA objects are also supported via eConnect. Please check with us on the details
Microsoft Dynamics GP 10. 0 is SQL 2005 application, however direct SQL scripting to feed or integrate eCommerce orders or invoices and payments might be complicated, due to rich GP business logic and its required validation in data integration. As eCommerce typically sends sales data to Great Plains Sales Order Processing module, which is really eConnect covered area, we recommend you first research Microsoft Dynamics GP eConnect technology, we will review eConnect in brief in this article below. Direct data feeding via SQL stored procedures is also OK if you try to restrict your integration functionality: do not allocate inventory items in SOP lines, create sales orders rather than invoices (to avoid building up GL distribution in your SQL scripting). Let’s begin:
1. eConnect. This tool and SDK was specially developed for eCommerce programmer, and later on Microsoft Business Solutions advanced eConnect and now it is covering other modules: POP, Payroll, General Ledger, etc. If you dig deeper, you will figure out that the heart of eConnect is set of encrypted SQL stored procedures. These procedures imitate GP Dexterity business logic in creating, deleting, modifying master records and work transactions. eConnect should be preferred tool as it validates Dex business logic and is recommended by MBS for e-commerce developers. If you think that eConnect is not a relevant tool for you, you can go ahead and take SQL querying route
2. SQL. Here you need to be comfortable with your GP SQL tables familiarity. The best tables reference could be found in GP workstation: tools->resource description->tables. Tables are sorted by series, you go to Sales, sort by tables physical name and jump to SOP10100 – this is Sales Header table, it keeps Sales Order, Invoice, Return, Quote document header. The second table will be SOP10200 – this one stores sales document lines: inventory items or non-inventoried items
3. eConnect and Batches posting. GP architecture has several phases of transaction life: work, open and history and among these phases only work transactions could be created in eConnect and be submitted for GP operator approvals. In eCommerce application you often want to post payments against invoice plus you want invoice to be posted and scheduled for delivery. If this is the case, you should research Alba Spectrum Posting Server, which is extension to eConnect and by technology it is Great Plains Dexterity application, appealing to Dex source code – developer places approved GP batches to custom table and posting server calls GP Dexterity native logic to post the batches
4. GP Integration Manager. If the volume of eCommerce transactions is relatively low and you are small organization, you can consider integration e-commerce transactions via IM over night. IM deploys GP as OLE server and so, GP workstation should be running behind the scenes. Some customers report IM performance issues, which is normal scenario for OLE server, where you open and feed data into GP hidden forms and screens.
