Great,Plains,Dynamics,Partner, computer Great Plains Dynamics GP Partner Newsflash: Crystal Reports
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
Here you may need orientation session to understand whichDynamics GP reporting tool would fit you the best. In this small publication we would like toreview Great Plains reporting options for IT specialist as well as for companycontroller: 1. Whereyou should consider Dynamics GP native reporting versus Crystal. It is where you have predefined and ready touse and simple for modification Native Great Plains reports, such as SOP BlankInvoice form, AP Check with Stub on top and bottom Graphical and Text 2. FRxreporting realm. Here we are talkingabout Balance Sheet, Profit and Loss Statement and Statement of Cash Flow. The nice thing about FRx is the fact that ithas the link to Dynamics GP General Ledger tables: Account Master, AccountSummary Master (GL Monthly Summaries), GL Historical Tables. Having said all that above, you should expectFRx reports to based exclusively on Row Format, Column Layout and ReportingTree (consolidated Dynamics GP reporting, or reporting by account segment,department, product code). And now letsmove on and return to the topic of this publication Crystal Reports forMicrosoft Dynamics GP Great Plains 3. CRis sort of a bit challenging and you should have some prior Crystal Reporttraining under your belt or at least be comfortable to read Crystal Reportsuser manual to get yourself up and running. In our opinion fresh start, when you try to learn on CR wizard (whichconnects to Dynamics GP company directly and tries to make tables links inCrystal Reports designer) is not the best and ultimate way to create CrystalReports for Dynamics GP 4. CRSQL base recommendations. We recommendyou to consider basing Great Plains Crystal Reports on custom SQL Views or StoredProcedures. Dynamics GP DB architectureallows you to create and maintain custom SQL objects in DYNAMICS or GP companydatabases 5. CRindustry niche. Crystal Reports aregreat in cross modules reporting. Goodexample is the case when you would like to create Project Sales and Purchasingreport, where you pay your salesperson or account executive when the productsand services are sold (Sales Order Processing Module), money received (AccountsReceivables module) and products and services delivered (Purchase OrderProcessing module)
Great,Plains,Dynamics,Partner,