LEADER 05002nam 2200649 a 450 001 9910785377003321 005 20200520144314.0 010 $a1-282-89653-9 010 $a9786612896538 010 $a1-84968-095-7 035 $a(CKB)2670000000055149 035 $a(EBL)952065 035 $a(OCoLC)798535878 035 $a(SSID)ssj0000423153 035 $a(PQKBManifestationID)12147995 035 $a(PQKBTitleCode)TC0000423153 035 $a(PQKBWorkID)10432981 035 $a(PQKB)10285270 035 $a(Au-PeEL)EBL952065 035 $a(CaPaEBR)ebr10428654 035 $a(CaONFJC)MIL289653 035 $a(MiAaPQ)EBC952065 035 $a(PPN)228043271 035 $a(EXLCZ)992670000000055149 100 $a20101206d2010 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMicrosoft Dynamics NAV 2009 programming cookbook$b[electronic resource] $ebuild better business applications with NAV /$fMatt Traxinger 210 $aBirmingham [England] $cPackt Pub.$d2010 215 $a1 online resource (356 p.) 225 0 $aEnterprise : professional expertise distilled 300 $a"Over 110 simple but incredibly effective recipes for taking control of Microsoft Dynamics NAV 2009." 300 $aIncludes index. 311 $a1-84968-094-9 327 $aCover; Copyright; Credits; About the author; About the reviewer; Table of Contents; Preface; Chapter 1:Strings, Dates, and Other Data Types; Introduction; Retrieving the system date and time; Retrieving the work date; Determining the day, month, and year from a given date; Converting a value to a formatted string; Creating an array; Creating an Option variable; Converting a string to another data type; Manipulating string contents; Using date formulas to calculate dates; Chapter 2:General Development; Introduction; Repeating code using a loop; Displaying a Progress Bar 327 $aChecking for conditions using an IF statementUsing a CASE statement to test multiple conditions; Creating a function; Passing parameters by reference; Referencing dynamic tables and fields; Using recursion; Chapter 3:Working with Tables and Records; Introduction; Creating a table; Adding a key to a table; Creating transactions to alter data; Validating data; Retrieving a single record from the database; Using advanced filtering; Retrieving data using FIND; Adding a FlowField to a table; Creating a SumIndex field; Marking records for future use; Clearing filters, keys, and values 327 $aUsing temporary tables to store dataRetrieving data from another company; Merging records; Writing your own rollback routine; Chapter 4:Designing Forms; Introduction; Obtaining input without a form; Using the Form Generation Wizard; Changing text appearance; Preventing editable lookup forms; Adding an editable field to a non-editable; form; Creating a matrix form; Creating a wizard-style form; Designing a form based on a temporary; table; Updating a subform from a parent form; Updating a parent form from a subform; Chapter 5:Report Design; Introduction; Using the Report Generation Wizard 327 $aAdding custom filters to the request formSetting filters when a report is loaded; Creating a report to process data; Displaying a check mark on a report; Dynamically showing Sections on reports; Grouping data to display totals; Adding page totals to reports; Display page of X of Y; Using virtual tables to loop through data; Adding a watermark to a page; Chapter 6:Diagnosing Code Problems; Introduction; Using the debugger; Setting breakpoints; Using Code Coverage; Handling runtime errors; Using Client Monitor to diagnose problems; Finding errors when using NAS 327 $aImplementing Try / Catch / FinallyChapter 7:Roles and Security; Introduction; Adding roles through the User Setup table; Creating and assigning a security role; Using FILTERGROUP to restrict data; Checking for user-assigned roles; Checking Active Directory groups; Using security filters; Field-level security; Assigning menu suites based on company; Ending an idle session; Automatically adding users to NAV; Hiding values in Zoom; Chapter 8:Leveraging Microsoft Office; Introduction; Using the style sheet tool; Sending data to Microsoft Word; Sending an e-mail from NAV through Outlook 327 $aExporting data using the Excel buffer 330 $aBuild better business applications with Microsoft Dynamics NAV 2009 with this book and eBook 606 $aBusiness logistics$xComputer programs 606 $aIndustrial management$xComputer programs 615 0$aBusiness logistics$xComputer programs. 615 0$aIndustrial management$xComputer programs. 676 $a658.7028555 700 $aTraxinger$b Matt$01506047 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910785377003321 996 $aMicrosoft Dynamics NAV 2009 programming cookbook$93736076 997 $aUNINA