LEADER 05280nam 22006611 450 001 9910453499803321 005 20200520144314.0 010 $a1-84968-893-1 035 $a(CKB)2550000001137078 035 $a(EBL)1343638 035 $a(OCoLC)862940267 035 $a(SSID)ssj0001139811 035 $a(PQKBManifestationID)11643925 035 $a(PQKBTitleCode)TC0001139811 035 $a(PQKBWorkID)11220552 035 $a(PQKB)10899239 035 $a(MiAaPQ)EBC1343638 035 $a(PPN)228047471 035 $a(Au-PeEL)EBL1343638 035 $a(CaPaEBR)ebr10789465 035 $a(CaONFJC)MIL536779 035 $a(EXLCZ)992550000001137078 100 $a20131207h20132013 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMicrosoft Dynamics GP 2013 reporting /$fDavid Duncan, Christopher J. Liley 205 $aSecond edition. 210 1$aBirmingham :$cPackt Publishing,$d[2013] 210 4$dİ2013 215 $a1 online resource (386 p.) 300 $aIncludes index. 311 $a1-84968-892-3 311 $a1-306-05528-8 327 $aCover; Copyright; Credits; About the Author; Acknowledgments; About the Author; Acknowledgments; 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 the report generation process; Challenges in developing and writing reports; Intended audience; Data sources; Latency; Formatting and presentation; Ad hoc reports 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?System database versus company database; System 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 2013 Software Development Kit; Downloading the Software Development Kit 327 $aUsing the Software Development KitSupport Debugging Tool; Downloading the Support Debugging Tool; Using the Support Debugging Tool; Summary; Chapter 3: Working with the Builders: SmartList and Excel Reports; Utilizing canned SmartLists to meet basic reporting needs; Structure of SmartList; Basic SmartList concepts; Narrowing our result list with search criteria; Adding new columns; Changing the number of records returned; Modifying a dex.ini switch for faster export to Excel; Extending SmartList data to Excel by deploying Excel Reports; Deploying Excel Reports 327 $aMaintaining security for Excel ReportsThe shared network folder permissions; The database level permissions; Accessing and using Excel Reports; Connecting to Excel Reports via Windows Explorer; Connecting to Excel Reports via GP 2013; Creating and publishing new SmartLists using SmartList Builder; Understanding the SmartList Builder window; Creating a new SmartList Object via SmartList Builder; Deploying new Excel Reports with Excel Report Builder; Understanding the Excel Reports Builder window; Creating a new Excel Report via Excel Report Builder 327 $aAdditional tips and tricks for using both BuildersSummary; Chapter 4: Report Writer and Word Templates; Storing and accessing Report Writer reports; Storing Report Writer reports; 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 to use Report Writer; Opening Report Writer; Report Writer Resource windows; Fields; Data types; Formats; Pictures; Strings; Report Modification windows; Report Definition; Report Table Relationships; Sorting Definition 327 $aReport Restrictions 330 $aA practical guide to creating and managing reports as well as identifying the most appropriate reporting tool for any reporting challenge, this book employs real-life, step-by-step examples in a part tutorial, part reference manner.If you are a Microsoft Dynamics GP developer, consultant or power user who wants to create and manage reports, then ""Microsoft Dynamics GP 2013 Reporting, Second Edition"" is for you. A working knowledge of Microsoft Dynamics GP is required. A basic understanding of business management systems and reporting applications such as Microsoft Excel and SQL Reporting Ser 606 $aBusiness report writing 606 $aElectronic data processing 608 $aElectronic books. 615 0$aBusiness report writing. 615 0$aElectronic data processing. 676 $a658.81202 700 $aDuncan$b David$0806450 701 $aLiley$b Christopher J$0982863 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910453499803321 996 $aMicrosoft Dynamics GP 2013 reporting$92242957 997 $aUNINA