Andrew Karasev, Alba Spectrum http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and Canada nationwide. Local service in Chicago, Houston, Dallas, San Diego. Please visit our information portal Pegas Planet: http://www.pegasplanet.com . If you need custom programming for GP, we are happy to help you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We also provide instant support to new and existing clients via web sessions
Former Great Plains Small Business Manager, recent version s 9.0, Small Business Financials is in essence GP Dexterity application with similar code base as regular Microsoft Great Plains Dynamics GP, but with scaled down functionality. SBF is available exclusively on Microsoft SQL Server platform and this fact opens great opportunities for SQL programmers and consultants to fix SBF data and program integrations. In this small publication we would like to give your reports design highlights
1. Report Writer Reporting. Small Business Financials allows you only to change the position of the fields, if you need to really change report design – place new fields, add calculated fields, then you need to do it in GP ReportWriter module, and then transfer it back to SBF in the form of Export (or package). This is pretty much a standard practice in supporting and upgrading Small Business Financial customers – they need to be backed by Great Plains Dynamics GP customization partner
2. Advanced Financial Analysis reporting. Yes, SBF has AFA as default and preferred reports for Balance Sheet, P&L, Cash Flow Statement. AFA is another Dex module which builds its reports on GP account categories
3. Crystal Reports for SBF. Here you have the opportunity and the challenge as CR is just a tool and it doesn’t give your GP report wizard. We recommend you to familiarize yourself, if you are software developer or programmer with SBF tables structure, this is very similar to GP. If you have MSDN subscription, please download Dynamics GP 9.0 demo CD and install it for testing with demo company
4. SRS or Microsoft SQL Server Reporting Services. Similar to Crystal Reports, SRS should be based on SQL Stored Procedures, however it gives you more freedom in deploying ecommerce or web interface for report users
5. eConnect. This SDK is not available in standard package for Small Business Financials. You would need to upgrade to Microsoft Dynamics GP Business Ready to deploy eConnect integration and reporting functionality
- Related Videos
- Related Articles
- Ask / Related Q&A
- Microsoft Dynamics Gp Implementation Faq
- Workflow in Microsoft Dynamics Gp 10.0
- Microsoft Dynamics Gp 10.0 – Improved and Enhanced
- Improve Cash Management Capabilities With Microsoft Dynamics Gp 10.0
- Microsoft Dynamics Gp – Typical Customizations
- Great Plains Integration Tools: Microsoft Dynamics Gp Integration Manager
- Microsoft Dynamics Gp 10.0 Customization Scenarios
- Microsoft Dynamics Gp 10.0 Technical Notes or Under the Hood
Mac DVD Creator from Topsofts Offers You the Best Function
By: topsofts | 06/01/20104Media DVD Creator for Mac can easily and speedily convert and burn AVI, MPEG, DivX, WMV to DVD, or burn DVD folder, ISO file to DVD on Mac as a professional DVD burner.
Microsoft Dynamics GP 2010 Payroll Tax Update Notes
By: Andrew Karasev | 05/01/2010If your organization processes US Payroll internally in Microsoft Dynamics GP 10, 9.0 or earlier version: GP 8.0, 7.5, Great Plains 7.0, 6.0, 5.5, 5.0, in this small publication we would like to review annual Payroll Tax rates update methods.
Windows 7 Reveiw
By: Jolly Nick | 05/01/2010Windows seven is one of the new operating systems offered by Microsoft. Whereas the previous operating systems offered by Microsoft tend to boast a large number of options, Windows 7 is made to offer a focused upgrade for you computer. The main goal of Microsoft for this specific operating system is to come back up with one that's absolutely compatible with hardware and applications that also are operating for Windows Vista.
Stop and think - Don’t use Free Registry Cleaners. Why?
By: Dana G. | 05/01/2010Computer runs fine, if it is not showing any errors. Though most of the computers got errors and slow down with time. The major reason behind this is an error in computer registries. Most of the computer users rely on free registry cleaners for PC cleanup. However, free software packages are not recommendable at all for PC maintenance. Top reason is that the free cleaners carry risk of infecting the machine with Malware.
Lean Supply Chain Profiles Ultriva by Manufacturing Journalist TR Cutler
By: Thomas Cutler | 05/01/2010Lean Supply Chain Profiles Ultriva by Manufacturing Journalist TR Cutler
Logistics Management Features TraceGains
By: Thomas Cutler | 05/01/2010Logistics Management Features TraceGains
What is the Best Wii Unlock Software?
By: Dan Wardrope | 05/01/2010Its very difficult to scour the internet to find good Wii unlock software websites. And once you find them, how the hell do you know if they are decent? Its like trying to find a needle in a haystack! I am going to help you find the best software out there through my experiences of late.
Why Good Collaboration Tools Are Worth Every Penny
By: Grace Kang | 05/01/2010We're seeing new collaboration solutions pop up left and right, all claiming to enhance team collaboration. A huge mistake that many businesses are making, however, is turning to free "collaboration tools". While "free tool" always sounds enticing, it also always means less functionality, less features and zero customer support.
Microsoft Dynamics GP: Recovering Failed Implementation Notes
By: Andrew Karasev | 04/01/2010 | SoftwareYour Microsoft Dynamics GP (Microsoft Great Plains, Great Plains Dynamics or Great Plains Accounting for DOS, Windows or Macintosh), not successful implementation story might be not unique. GP is mid-market Corporate ERP application, where industry expertise might be required, plus profound technical exposure for your chosen Dynamics GP Partner. Of course, if you are insisting on coming through quick Sales cycle, there is often a temptation to sell you Dynamics GP software license...
Exporting Data from Dynamics GP Notes for Consultant
By: Andrew Karasev | 03/01/2010 | Information TechnologyThere might be situations, where you need to extract info from Microsoft Dynamics GP (formerly known as Great Plains Dynamics or Microsoft Great Plains) table. In this small publication we will describe you two scenarios. First, when you need one tame data export for following data conversion into future Corporate ERP accounting system (when you are walking away from Dynamics GP to something like SAP Business One, Oracle eBusiness Suite, etc.), and second - when you need ongoing data export
SAP Business One Full Service in Chicago and Atlanta Consulting Notes
By: Andrew Karasev | 02/01/2010 | SoftwareThis small and mid-size business Corporate ERP and MRP application is relatively new on US accounting software market, however it is so flexible and robust (plus it has SAP brand, which is important in the sense of reliability and future commitment), that it provides tough competition to such traditional lower mid-market Corporate ERP applications as Microsoft Dynamics GP (formerly known as Great Plains Dynamics), Microsoft Small Business Financials (this small business corporate ERP...
Great Plains US Payroll Tax Update Service Notes
By: Andrew Karasev | 31/12/2009 | SoftwareFor customers on older versions of Microsoft Dynamics GP, Great Plains Dynamics and eEnteprise, in the case when you are processing Payroll internally (including W2 printout and mailing to your employees) - we would like to let you know that it is possible to update Federal, State and Local Taxes directly in Dynamics GP Payroll tables. We traditionally offer this service at the end of the calendar year, or in January at your convenience.
Microsoft Dynamics GP Applying Service Packs Technology
By: Andrew Karasev | 30/12/2009 | SoftwareIf your organization deploys Microsoft Dynamics GP Corporate ERP, formerly known as Great Plains Dynamics, Microsoft Great Plains, we would like to review new Service Packs applying technology in this small publication, especially after hearing opinions from former Great Plains Consultants, who are now working in Industry IT departments.
Migration to SAP Business One from Great Plains Accounting Notes
By: Andrew Karasev | 30/12/2009 | SoftwareThere are still customers, who are on Great Plains Accounting for DOS, Windows or Macintosh, typically versions 9.5, 9.2, and earlier. When Great Plains Software encouraged its GPA customers to convert to Great Plains Dynamics at the end of 20th Century (as there was a concern of GPA not being year 2000 compliant, plus support for GP Accounting was about to expire those old good days), large number of GPA customers followed the advise and migrated.
Microsoft Dynamics GP 7.5, 9.0 version update notes
By: Andrew Karasev | 27/12/2009 | SoftwareAs recession seems to be over, now it is time to take care about your Corporate ERP application, and if it is Microsoft Dynamics GP (also known as Microsoft Great Plains and Great Plains Dynamics), this small publication might be helpful on introduction level
Ecommerce to Dynamics GP Real Time Integration: Order Connector
By: Andrew Karasev | 25/12/2009 | SoftwareIf your back office Corporate ERP application is Microsoft Dynamics GP, former versions were also known as Microsoft Great Plains and Great Plains Dynamics, and you have in-house developed ecommerce web application with items catalogs with advanced price lists (especially in B2B ecommerce scenarios), shopping cart, credit card processing, we would like to present you this small publication in the form of FAQ and orientation session.