04977nam 2200685 a 450 991045968370332120200520144314.01-283-37685-797866133768551-84968-219-4(CKB)2670000000083230(EBL)943980(OCoLC)780490081(SSID)ssj0000524183(PQKBManifestationID)11340880(PQKBTitleCode)TC0000524183(PQKBWorkID)10545910(PQKB)11012654(MiAaPQ)EBC943980(PPN)228049822(Au-PeEL)EBL943980(CaPaEBR)ebr10467633(CaONFJC)MIL337685(EXLCZ)99267000000008323020110518d2011 uy 0engur|n|---|||||txtccrMicrosoft Dynamics GP 2010 reporting[electronic resource] create and manage business reports with Dynamics GP /David Duncan, Christopher LileyOlton, Birmingham Packt Pub.20111 online resource (360 p.)Professional expertise distilledIncludes index.1-84968-218-6 Cover; 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; SummaryChapter 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 KitDownloading 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 reportsDeploying 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 BuilderAdditional 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 typesFormatsCreate and manage business reports with Dynamics GP with this book and eBookAccountingComputer programsCorporation reportsData processingBusiness enterprisesFinanceData processingElectronic books.AccountingComputer programs.Corporation reportsData processing.Business enterprisesFinanceData processing.657.0285536Duncan David806450Liley Christopher982982MiAaPQMiAaPQMiAaPQBOOK9910459683703321Microsoft Dynamics GP 2010 reporting2243443UNINA