LEADER 04977nam 2200685 a 450 001 9910459683703321 005 20200520144314.0 010 $a1-283-37685-7 010 $a9786613376855 010 $a1-84968-219-4 035 $a(CKB)2670000000083230 035 $a(EBL)943980 035 $a(OCoLC)780490081 035 $a(SSID)ssj0000524183 035 $a(PQKBManifestationID)11340880 035 $a(PQKBTitleCode)TC0000524183 035 $a(PQKBWorkID)10545910 035 $a(PQKB)11012654 035 $a(MiAaPQ)EBC943980 035 $a(PPN)228049822 035 $a(Au-PeEL)EBL943980 035 $a(CaPaEBR)ebr10467633 035 $a(CaONFJC)MIL337685 035 $a(EXLCZ)992670000000083230 100 $a20110518d2011 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMicrosoft Dynamics GP 2010 reporting$b[electronic resource] $ecreate and manage business reports with Dynamics GP /$fDavid Duncan, Christopher Liley 210 $aOlton, Birmingham $cPackt Pub.$d2011 215 $a1 online resource (360 p.) 225 0 $aProfessional expertise distilled 300 $aIncludes index. 311 $a1-84968-218-6 327 $aCover; Copyright; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Meeting the Reporting Challenge; Trends in reporting; Increased flexibility; Reporting through all levels of an organization; Increased access to report generation process; Challenges in developing and writing reports; Intended audience; Data sources; Latency; Formatting and presentation; Ad hoc queries versus traditional reports; Security; Network access and general IT infrastructure; Developer resources; Summary 327 $aChapter 2:Where Is My Data and How Do I Get to It?DYNAMICS database versus company database; What is the DYNAMICS database?; Company database; Dynamics GP table naming/numbering conventions; Tables versus table groups; Physical table naming/numbering conventions; Alpha code; Table type; Sequence; Variant; Locating Dynamics GP data using the Resource Descriptions windows; Tables; Fields; Windows; Table Import; Accessing data at the table level using SQL Management Studio; Locating Dynamics GP data with additional tools; Dynamics GP 2010 Software Development Kit 327 $aDownloading the Software Development KitUsing the Software Development Kit; Support Debugging Tool; Downloading the Support Debugging Tool; Using the Support Debugging Tool; Summary; Chapter 3:Working with the Builders: SmartList and Excel Reports; Satisfying basic reporting needs with canned SmartLists; Structure of SmartList; Basic SmartList tools; Narrowing our result list with search criteria; Adding new columns; Changing the number of records returned; Achieving faster export to Excel with a simple dex.ini switch; Extending SmartList data to Excel by deploying Excel reports 327 $aDeploying Excel reportsMaintaining security for Excel reports; Shared network folder permissions; Database level permissions; Accessing and using Excel Reports; Connecting to Excel Reports via Windows Explorer; Connecting to Excel Reports via GP 2010; Creating and publishing new SmartLists by using SmartList Builder; Understanding the SmartList Builder window; Creating a new SmartList via SmartList Builder; Creating and publishing new Excel Report formats using Excel Report Builder; Understanding the Excel Reports Builder window; Creating a new Excel Report via Excel Reports Builder 327 $aAdditional tips and tricks for using the BuildersSummary; Chapter 4:Report Writer; Understanding the reports dictionaries and how Dynamics GP treats original versus modified reports; Storing Report Writer reports; Storing reports dictionaries locally; Storing reports dictionaries on a network share; Accessing Report Writer reports; Setting the Dynamics GP launch file; Setting security to custom/modified reports; Opening and navigating the Report Writer windows; Setting security permissions for using Report Writer; Opening Report Writer; Report Writer Resource windows; Fields; Data types 327 $aFormats 330 $aCreate and manage business reports with Dynamics GP with this book and eBook 606 $aAccounting$xComputer programs 606 $aCorporation reports$xData processing 606 $aBusiness enterprises$xFinance$xData processing 608 $aElectronic books. 615 0$aAccounting$xComputer programs. 615 0$aCorporation reports$xData processing. 615 0$aBusiness enterprises$xFinance$xData processing. 676 $a657.0285536 700 $aDuncan$b David$0806450 701 $aLiley$b Christopher$0982982 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910459683703321 996 $aMicrosoft Dynamics GP 2010 reporting$92243443 997 $aUNINA