05002nam 2200649 a 450 991078537700332120200520144314.01-282-89653-997866128965381-84968-095-7(CKB)2670000000055149(EBL)952065(OCoLC)798535878(SSID)ssj0000423153(PQKBManifestationID)12147995(PQKBTitleCode)TC0000423153(PQKBWorkID)10432981(PQKB)10285270(Au-PeEL)EBL952065(CaPaEBR)ebr10428654(CaONFJC)MIL289653(MiAaPQ)EBC952065(PPN)228043271(EXLCZ)99267000000005514920101206d2010 uy 0engur|n|---|||||txtccrMicrosoft Dynamics NAV 2009 programming cookbook[electronic resource] build better business applications with NAV /Matt TraxingerBirmingham [England] Packt Pub.20101 online resource (356 p.)Enterprise : professional expertise distilled"Over 110 simple but incredibly effective recipes for taking control of Microsoft Dynamics NAV 2009."Includes index.1-84968-094-9 Cover; 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 BarChecking 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 valuesUsing 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 WizardAdding 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 NASImplementing 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 OutlookExporting data using the Excel bufferBuild better business applications with Microsoft Dynamics NAV 2009 with this book and eBookBusiness logisticsComputer programsIndustrial managementComputer programsBusiness logisticsComputer programs.Industrial managementComputer programs.658.7028555Traxinger Matt1506047MiAaPQMiAaPQMiAaPQBOOK9910785377003321Microsoft Dynamics NAV 2009 programming cookbook3736076UNINA