You are previewing Microsoft Dynamics NAV 2009 Application Design.
O'Reilly logo
Microsoft Dynamics NAV 2009 Application Design

Book Description

A focused book and ebook tutorial for Microsoft Dynamics NAV application development

  • Learn how Dynamics NAV ERP suite is set up and customized for various industries

  • Integrate numerous parts of a company's operations including financial reporting, sales, order management, inventory, and forecasting

  • Develop complete applications and not just skeleton systems

  • Covers the design and implementation of two new add-on services: The Squash application and the Storage & Logistics application

  • Also usable for previous versions such as 3.x, 4.0, and 5.0

  • Easy-to-read style, packed with hard-won practical advice

  • Real-world examples with step-by-step explanations

  • In Detail

    Dynamics NAV 2009 is an Enterprise Resource Planning (ERP) software product from Microsoft that can be used for variety of business needs. It is part of the Microsoft Dynamics family, and intended to assist with finance, manufacturing, Customer Relationship Management, supply chains, analytics, and electronic commerce for small and medium-sized enterprises.

    This book is a focused tutorial on Microsoft Dynamics NAV application development, so you can develop complete applications and not just application outlines. It will show NAV developers how to create different kinds of applications. Different kinds of application are vital in different industries like fashion, automobile, retail, books (education), and other industries. It starts off by introducing the supply chain that you will be using throughout the book. You will implement the Microsoft Dynamics NAV ERP suite and learn how it is set up and customized for various industries.

    You will be able to customize Dynamics NAV to suit the different aspects of a business such as Financial Management, Relationship Management, Production, Jobs, Trade, Storage, Logistics, and so on. The book will take you through these Microsoft-designed application features and show you how to customize and extend them safely. Thus, you will be able to create a structure of your own in Microsoft Dynamics NAV.

    A focused tutorial for Microsoft Dynamics NAV application development

    Table of Contents

    1. Microsoft Dynamics NAV 2009 Application Design
      1. Microsoft Dynamics NAV 2009 Application Design
      2. Credits
      3. Foreword
      4. About the Author
      5. Acknowledgement
      6. About the Reviewers
      7. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
          1. Where to find the Screens in this book
            1. Screenshots
          2. How to read the application schemas
          3. Number and date punctuation
        5. Reader feedback
        6. Customer support
          1. Errata
          2. Piracy
          3. Questions
      8. 1. Introduction to Microsoft Dynamics NAV
        1. Versions and history
        2. What is this book about
        3. Setup versus customization
        4. The beauty of simplicity
          1. Horizontal versus vertical solutions
          2. Open source
        5. Structure of this book
        6. The Role Tailored concept
        7. The building blocks
          1. Tables as user interface and business logic
          2. Dynamics NAV in throughout supply chain
          3. Some basics
            1. Number series
            2. Extended text
            3. Navigate
            4. Setup tables
            5. Posting groups
            6. Pricing
            7. Dimensions
        8. Data model principles
          1. Master data
          2. Journals
            1. The general ledger
            2. Balancing
            3. Flow fields and flow filters
          3. More journals and entries
            1. Posting Schema
            2. Sub and detailed entries
          4. Documents—combining the journals into processes
            1. Document structure
            2. Document transactions
          5. Other structures
            1. Relationship management
            2. Jobs
            3. Manufacturing
        9. Summary
      9. 2. A Sample Application
        1. Fit-gap analysis
          1. Designing a Squash Court application
          2. Look, learn, and love
            1. Drawing the table and posting schema
            2. The Project approach
            3. Interfacing with the standard application
        2. Getting started
          1. Creating squash players
            1. CreateVendor versus CreateCustomer
            2. Reverse engineering
        3. Designing a journal
          1. Squash Court master data
          2. Chapter objects
          3. Reservations
            1. Journal Template
            2. Journal Batch
            3. Register
          4. The Journal
            1. Reservation
            2. Invoicing
          5. Time calculation
          6. Price calculation
            1. Squash prices
            2. Price calc mgt. codeunit
            3. Inherited data
          7. Dimensions
            1. Master data
            2. Journal
              1. Posting
              2. Document
        4. The posting process
          1. Check line
          2. Post line
        5. Invoicing
          1. Invoice document
            1. Sales header
            2. Sales line
            3. Dialog
          2. Posting process
            1. Analyse the object
            2. Making the change
        6. Navigate
          1. FindRecords
          2. ShowRecords
            1. Testing
        7. Summary
      10. 3. Financial Management
        1. Chart of accounts
          1. Posting accounts
          2. The entry tables
            1. Sub accounting
          3. General journals
            1. Entry application
          4. Posting groups
          5. Dimensions
          6. Budgeting
            1. Creating budget entries
          7. Accounting periods
            1. Closing dates
          8. Currencies
          9. Consolidation
          10. VAT statement
          11. Data analysis
            1. General Ledger
            2. Account schedules
            3. Analysis by dimensions
          12. The setup
        2. Customizing financial management
          1. Sales line description to G/L entries
          2. Extra fields in the G/L entries
        3. Integrating with financial management
          1. Creating a G/L transaction
            1. The C/AL code
            2. Advanced entries
          2. Look, learn, and love
        4. Summary
      11. 4. Relationship Management
        1. How companies work
          1. Contacts
            1. Salutation codes
            2. Alternative addresses
            3. Create as
            4. Duplicates
            5. Search
          2. Profiles
            1. Automatic profiles
          3. Interactions
            1. Automatic interactions
            2. Finished interactions
          4. To-do's
            1. Opportunities
            2. Workflow
            3. Sales stages
              1. Activity codes
            4. Creating an opportunity
              1. Sales quote
              2. Close the deal
          5. Segments
            1. Add contacts
            2. Refine/Reduce contacts
            3. Segment criteria
            4. Mailing groups
            5. Log segment
          6. Campaigns
            1. Pricing
            2. Segments
            3. Activate
          7. Outlook integration
            1. E-mail logging
          8. The setup
        2. Customizing relationship management
          1. Salutation formula types
            1. Add the option
            2. Support the formula
            3. The GetSalutation function
            4. Set up the salutation formula
            5. Test the solution
          2. Customer and vendor numbering
            1. Disabling direct creation of customers and vendors
          3. Sharing contact information across companies
            1. Share tables
            2. Business relations
            3. C/AL code modifications
            4. Number series
            5. Final steps
            6. Alternative approaches
          4. Add contacts to segments
            1. Expand report
            2. Implement criteria filters
            3. Test solution
        3. Summary
      12. 5. Production
        1. What is production?
          1. History of production
          2. Production methodologies
          3. Raw materials
        2. Basic production principles
          1. Bill of materials
          2. MRP
            1. GIGO
          3. MPS
          4. Item costing
          5. Item tracking
          6. Quality control
          7. Energy and waste
          8. APICS
        3. Getting started
          1. Assembling
            1. The table and posting schema
            2. The items
            3. Item costing
            4. Item tracking
            5. The bill of materials
            6. Calculate standard cost
            7. Creating the inventory
            8. Adjusting cost item entries
            9. Posting inventory cost to G/L
            10. Check, check, and double check
            11. Recalculating standard unit cost
            12. BOM journal
            13. Check costing (again)
            14. Recalculating unit cost (again)
            15. Standard cost worksheet
            16. Item revaluation journal
            17. The result
          2. Item costing in ten steps
          3. Manufacturing
            1. The table and posting schema
            2. The items, machines, and work centers
              1. Items
              2. Machine centers
            3. Capacity
            4. Production bill of materials
            5. Routing
            6. Testing and low level code
            7. Simulation, sales orders, or inventory
              1. Make-to-stock
              2. Make-to-order
              3. The sales order
            8. Calculating MPS and MRP
              1. Requisition versus planning versus subcontracting worksheets
            9. Inventory profile offsetting
            10. Calculating a plan
            11. Production order workflow
            12. Purchase orders
            13. Finishing production
          4. Specialized production
            1. Jobs
          5. Kitting
            1. Sales process
            2. Kitting in Microsoft Dynamics NAV "7"
        4. Vertical industry implementation
          1. Fashion
            1. Bill of materials
            2. Shipping worksheet
          2. Automotive
            1. Tooling and amortization
            2. Item tracking
          3. Medicines
            1. Lot numbers and expiration dates
            2. Quality control
          4. Food
            1. Zero inventory
            2. Ordering schedules
          5. Furniture
            1. Calculations
            2. Inventory
        5. Summary
      13. 6. Trade
        1. The process
          1. Wholesale versus retail
        2. Sales and purchasing
          1. Transaction mirroring
          2. Sales
            1. Orders
            2. Quote and blanket order to order
              1. Quote to order
              2. Blanket order to order
          3. Creating a new sales order
            1. Sales header
            2. Sales lines
              1. Master data options
            3. Sales line fields
            4. Validation flow
              1. No. | field 6
              2. Quantity | field 15
              3. Unit price | field 22
              4. UpdateUnitPrice
              5. Line discount % | field 27
              6. UpdateAmounts
            5. VAT calculation
          4. Invoicing
            1. Prepayments
            2. Combined invoicing
              1. Manual
              2. Batch
            3. Credit Memo and Return Orders
          5. Purchasing
            1. Resources
            2. Drop shipments
              1. Manual
              2. Requisition worksheet
          6. Document releasing and approval process
            1. Status
            2. Releasing a document
            3. Manual versus automatic releasing
            4. Document approval
          7. Deleting sales and purchase documents
            1. Data deletion
            2. Deletion of shipments and invoices
          8. Document tables and row level locking
            1. Range locks in documents
            2. UpdateVATOnLines
        3. Inventory management
          1. Items
          2. Locations
          3. Variants
            1. Example
          4. Stock keeping units
            1. Example
            2. Creating SKU function
          5. Sales pricing
          6. Item ledger entry application
            1. Item application C/AL routine
            2. Requirements
          7. Value entries
            1. Direct cost
            2. Value entries and general ledger entries
          8. Transfer orders
            1. Example
          9. Requisition journals
            1. Reordering policy
            2. Extending reordering policy
            3. Virtual inventory
        4. Warehouse management
          1. Warehouse strategy levels
          2. Location setup
            1. Warehouse employees
          3. Bin code | level 1
            1. Example
            2. Bin content
          4. Receipt and shipment | level 2
            1. Warehouse request
            2. Limitations
          5. Put-Away and Pick | level 3
            1. Warehouse request
            2. Warehouse activities
            3. Level 2 and level 3 comparison
          6. Receipt + use put-away worksheet | level 4
            1. Whse.- activity register versus whse.-activity-post
          7. Directed put-away and pick | level 5
            1. Zones and default bins
            2. Bin calculation
          8. Implementing and customizing warehouse management
        5. Reservations
          1. Scenario
            1. Check-avail. period calc.
          2. Always versus optional reservation
          3. Reservation entries
          4. Creating a reservation
          5. Order tracking policy
            1. Example
            2. Replenishment
        6. Trade in vertical industries
          1. Fashion
            1. Sales orders
            2. Reservations
          2. Automotive
            1. Vehicle Information
            2. Parts management
          3. Pharmaceuticals/medicines
            1. Medication card
            2. Contribution invoicing
          4. Food
            1. Assortment
            2. Fast order entry
          5. Furniture
            1. Variant configuring
            2. One-off items
        7. Summary
      14. 7. Storage and Logistics
        1. How to read this chapter
          1. Chapter objects
          2. The process
          3. Using standard features
          4. Defining the modules
            1. Storage
            2. Logistics
            3. Invoicing
        2. The storage application
          1. Documents
          2. Look, learn, and love
            1. Journal
            2. Documents
            3. Master data
          3. Designing the table and posting schema
            1. Sharing tables
          4. Getting started
          5. Opening balance
          6. Products
            1. Warehouse
            2. Regions
            3. Shelves
          7. Registration worksheet
          8. Storage documents
            1. Receipt
            2. Put-away
            3. Shipment
            4. Picks
        3. The logistics application
          1. Designing the table and posting schema
          2. Getting started
            1. Shipments
            2. Routes
              1. Combining shipments
            3. Route optimizer
            4. Route follow up
          3. Incidents
            1. Follow up
        4. The invoicing application
          1. Process
          2. Income and expense
          3. Invoicing
            1. Sales Line
            2. Codeunit Sales-Post (80)
          4. Pricing methodology
            1. Storage prices
            2. Calculation
            3. Result
          5. Periodic invoicing
            1. Processing the buffer
          6. Combined invoicing
        5. Add-on flexibility
          1. Value added logistics
          2. Item tracking
          3. Third and fourth party logistics
        6. Summary
      15. 8. Consulting
        1. The process
          1. Fits
          2. Gaps
            1. Resource groups
            2. Time registration
            3. Item calculation
            4. Issue registration
        2. Getting started
          1. How many jobs
            1. Job card
          2. Job task and planning lines
          3. Job journal
          4. Job examples
            1. Chapter objects
            2. 1 | The new implementation
              1. Budgeting
            3. 2 | The infrastructure
            4. 3 | The upgrade
            5. 4 | The support team
          5. Time sheets
            1. Data and transaction model
          6. Purchasing
            1. Item costing versus work in progress
          7. Invoicing
          8. Calculating Work in Progress
            1. Example
            2. WIP post to general ledger
        3. Changing jobs
          1. Quantity budgeting
          2. Resource groups
          3. Calculations
          4. Issue registration
          5. Time sheet
            1. Registration
        4. Summary
      16. 9. Interfacing
        1. Interface types
          1. Import and export
            1. Manual
            2. Data pulling
            3. Data pushing
          2. Event driven versus timer driven
        2. Interfacing technologies
          1. File
          2. Automation Control and OCX
            1. OCX
            2. Automation Control
            3. Events
            4. .NET
            5. Automation wrappers
          3. ODBC/ADO
            1. Reading from Microsoft Dynamics NAV
            2. Writing to Microsoft Dynamics NAV
            3. Talking to other databases
          4. SQL Server interfacing
          5. C/FRONT
          6. Microsoft Message Queue
            1. NAS
          7. Web services
            1. Consuming web services in NAV
            2. Exposing a NAV web service
            3. Consuming a Microsoft Dynamics NAV web service
          8. Client add-ins
        3. Standard application interfaces
          1. Dataport
          2. XMLPort
          3. Office integration
            1. Word and Excel integration
              1. Style sheet tool
              2. Using style sheets in the RTC
            2. Word Automation
          4. Advanced Excel integration
          5. Outlook integration
            1. Outlook part
            2. ExtendedDatatype property
            3. Mail and SMTP mail Codeunits
            4. Outlook synchronization
            5. Exchange integration
              1. Interaction log entries
          6. SharePoint
          7. BizTalk
          8. Client Add-ins
        4. Interface methodologies
          1. The scenario
          2. The design
            1. The mapping
            2. The gaps
            3. What if it does not work
          3. The scenario
            1. The interface type
            2. The interface technology
              1. Active Data Objects
              2. Reliability
              3. NTimer.dll
            3. Logging
            4. The design
            5. The solution
              1. COMMIT
              2. Writing data
              3. Reading data
              4. Log, log, and log more
            6. Testing
              1. The RF database
              2. The test
            7. Viewing the results
              1. SQL statements
              2. The buffer tables
              3. The RF database
        5. Interfacing into the future
          1. SharePoint client in Microsoft Dynamics NAV "7"
          2. Microsoft Dynamics CRM
          3. Windows Azure
        6. Summary
      17. 10. Application Design
        1. Application lifecycle
          1. Design to use
            1. Forms
            2. Pages
            3. Role centers
              1. Squash application
              2. Storage and logistics
            4. Reports
          2. Design to maintain
            1. Naming
              1. Singular and plural
              2. Reserved words
              3. Names and abbreviations
            2. Quantity versus quality
              1. The framework concept
            3. Transformation tool
              1. Transform or design
          3. Design to support
            1. Second level support
          4. Design to upgrade
            1. Has Microsoft changed my (referenced) object
            2. Some redesign examples
              1. CRM (version 2.0)
              2. Dimensions (version 3.x)
              3. Bin code (version 3.x)
              4. Inventory valuation (version 3.x)
              5. Item tracking (version 3.6 and 4.0)
              6. MenuSuite (version 4.0)
              7. Jobs (version 5.0)
              8. Role tailored client (version 2009)
              9. Item costing (almost all versions)
            3. Documentation
            4. Split operational and financial information
          5. Design to perform
            1. OLTP versus OLAP
            2. Fast transaction posting
              1. Cleanup unused indexes
              2. Application setup
            3. Job queue
              1. Background posting
            4. Date compression and cleanup
              1. Date compression
              2. Data cleanup
            5. Locks, blocks, and deadlocks
              1. Native server versus SQL server
              2. Locking principles
              3. Deadlocks
              4. Blocking and deadlocks in Microsoft Dynamics NAV
            6. Impact on development
          6. Design to analyze
            1. Report design
        2. Version and object management
          1. What is a version
          2. Version numbering
            1. Combining versions
          3. Creating a version
            1. Tracking object changes
        3. Development methodology
          1. A sample approach
            1. Fit/gap analysis
            2. Prototyping
            3. Development
              1. Testing
            4. Implementation
            5. Maintenance and support
        4. The project
          1. Standard, customized, or both
            1. Add-on products
            2. Customizing
            3. Total cost of ownership
          2. Roadmap to success
        5. Summary
      18. A. Installation Guide
        1. Licensing
          1. Installing Microsoft Dynamics NAV
          2. Changing the license
            1. Restart service tier
        2. Installing the objects
          1. Importing a FOB file
          2. Installing the dynamic link library files
            1. Register NavMaps.dll
            2. Register VEControl.dll