Microsoft Dynamics NAV 2013 Application Design电子书

Microsoft Dynamics NAV 2013 Application Design

Table of Contents

Microsoft Dynamics NAV 2013 Application Design

Credits

Foreword

About the Author

Acknowledgments

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

Instant updates on new Packt books

Preface

What this book covers

What do you need for this book

Who this book is for

Conventions

Where to find the screens in this book

Screenshots

How to read the application schemas

Number and date punctuation

Reader feedback

Customer support

Errata

Piracy

Questions

1. Introduction to Microsoft Dynamics NAV

Versions and history

What is this book about

Setup versus customization

The beauty of simplicity

Horizontal versus vertical solutions

Open source

Design patterns

Architectural patterns

Design patterns

Implementation patterns

APIs

Structure of this book

The Role Tailored concept

The building blocks

Tables as user interface and business logic

Dynamics NAV in throughout supply chain

Some basic design patterns

Number series

Extended text

Navigate

Setup tables

Posting groups

Pricing

Dimensions

Architectural design patterns

Master data

Journals

The general ledger

Balancing

Flow fields and flow filters

More journals and entries

Posting schema

Sub and detailed entries

Combining the journals into processes

Document structure

Document transactions

Other patterns

Relationship management

Jobs

Manufacturing

Summary

2. A Sample Application

Fit-gap analysis

Designing a squash court application

Look, learn, and love

Drawing the table and posting schema

The project approach

Interfacing with the standard application

Design patterns

Getting started

Creating squash players

CreateVendor versus CreateCustomer

Reverse engineering

Designing a journal

Squash court master data

Chapter objects

Reservations

The journal

Reservation

Invoicing

Time calculation

Price calculation

Squash prices

Price Calc Mgt. codeunit

Inherited data

Dimensions

Master data

Journal

Posting

The posting process

Check line

Post line

Invoicing

Invoice document

Sales header

Sales line

Dialog

Posting process

Analyze the object

Making the change

Navigate

FindRecords

ShowRecords

Testing

Summary

3. Financial Management

Chart of accounts

Posting accounts

VAT versus sales tax

The entry tables

Sub accounting

Working with general journals

Entry application

Posting groups

Dimensions

Budgeting

Creating budget entries

Accounting periods

Closing dates

Currencies

Consolidation

VAT statement

Data analysis

Chart of accounts

Account schedules

Analysis by dimensions

The setup

Customizing financial management

Sales line description to G/L Entries

Extra fields in the G/L Entries

Integrating with financial management

Creating a G/L transaction

The C/AL code

Advanced entries

Look, learn, and love

Summary

4. Relationship Management

How companies work

Contacts

Salutation codes

Alternative addresses

Relationships with customer and vendor

Duplicates

Profiles

Automatic profiles

Interactions

Automatic interactions

Finished interactions

To-do's

Opportunities

Workflow

Sales stages

Activity codes

Creating an opportunity

Sales quote

Closing the deal

Creating segments

Adding contacts

Refine/reduce contacts

Segment criteria

Mailing groups

Log segment

Campaigns

Pricing

Segments

Activate

Outlook integration

E-mail logging

The setup

Customizing relationship management

Salutation formula types

Support the formula

The GetSalutation function

Setup the salutation formula

Test the solution

Customer and vendor numbering

Disabling the direct creation of customers and vendors

Sharing contact information across companies

Share tables

Business relation

C/AL code modifications

Number Series

Final steps

Alternative approaches

Adding contacts to segments

Expanding report

Implementing criteria filters

Test solution

Summary

5. Production

What is production?

Production methodologies

Raw materials

Basic production principles

Bill of materials

Material requirements planning

Garbage In Garbage Out

Master Production Schedule

Item costing

Item tracking

Quality control

Energy and waste

Association for Operations Management

Getting started

Assembling

Design patterns

The items

Item costing

Item tracking

The bill of materials

Calculating the standard cost

Creating the inventory

Adjusting cost item entries

Posting inventory cost to G/L

Check, check, and double check

Recalculating the standard unit cost

Assembly orders

Check costing (again)

Recalculating the unit cost (again)

Standard cost worksheet

Item Revaluation Journal

The result

Summarizing item costing in 10 steps

Manufacturing

The items, machines, and work centers

Capacity

Production bill of materials

Routing

Testing and low-level code

Simulation, sales orders, or inventory

Make-To-Stock

Make-To-Order

The sales order

Calculating MPS and MRP

Requisition versus planning versus subcontracting worksheets

Inventory profile offsetting

Atomic coding

Calculating a plan

Production order workflow

Purchase orders

Finishing production

Specialized production

Jobs

Vertical industry implementation

Fashion

Bill of materials

Shipping worksheet

Automotive

Tooling and amortization

Item tracking

Medicines

Lot numbers and expiration dates

Quality control

Food

Zero inventory

Ordering schedules

Furniture

Calculations

Inventory

Summary

6. Trade

The process

Wholesale versus retail

Sales and purchasing

Transaction mirroring

Sales

Orders

Quote to order and blanket order to order

Quote to order

Blanket order to order

Creating a new sales order

Sales header

Sales lines

Master data options

Sales line fields

Validation flow

No. | field 6

Quantity | field 15

Unit price | field 22

UpdateUnitPrice

Line Discount % | field 27

UpdateAmounts

VAT calculation

Code cloning

Invoicing

Prepayments

Combined invoicing

Manual

Batch

Credit memo and return orders

Purchasing

Resources

Drop shipments

Manual

Requisition worksheet

Document releasing and approval process

Status

Releasing a document

Manual versus automatic releasing

Document approval

Deleting sales and purchase documents

Data deletion

Deletion of shipments and invoices

Inventory management

Items

Locations

Variants

Stock keeping units

Creating a SKU function

Sales pricing

Item ledger entry application

Item application C/AL routine

Requirements to apply an item ledger

Value entries

Direct cost

Value entries and general ledger entries

Transfer orders

Example

Requisition worksheets

Reordering policy

Extending the reordering policy

Virtual inventory

Warehouse management

Warehouse strategy levels

Location setup

Warehouse employees

Bin code | level 1

Example

Bin content

Receipt and shipment | level 2

Warehouse request

Limitations

Put-away and Pick | level 3

Warehouse request

Warehouse activities

Level 2 and level 3 comparison

Level 4 – receipt with Put-away worksheet

Whse.- activity register versus whse.-activity-post

Level 5 – directed put-away and pick

Zones and default bins

Bin calculation

Implementing and customizing warehouse management

Reservations

Check-avail. period calc.

Always versus optional reservation

Reservation entries

Creating a reservation

Order tracking policy

Example

Replenishment

Auto increment

Trade in vertical industries

Fashion

Sales orders

Reservations

Automotive

Vehicle information

Parts management

Pharmaceuticals/medicines

Medication card

Contribution invoicing

Food

Assortment

Fast order entry

Furniture

Variant configuration

One-off items

Summary

7. Storage and Logistics

How to read this chapter

Chapter objects

The process

Using standard features

Defining the modules

Storage

Logistics

Invoicing

The storage application

Documents

Look, learn, and love

Journal

Documents

Master data

Drawing the design pattern

Sharing tables

Getting started

Opening balance

Products

Warehouse

Regions

Shelves

Registration worksheet

Storage documents

Receipt

Put-away

Shipment

Picks

The logistics application

Drawing the design patterns

Getting started

Shipments

Routes

Combining shipments

Route optimizer

Route follow up

Incidents

Follow up

The invoicing application

Income and expense

Invoicing

Sales Line

Codeunit Sales-Post (80)

Pricing methodology

Storage prices

Calculation

Result

Periodic invoicing

Processing the buffer

Combined invoicing

Add-on flexibility

Value-added logistics

Item tracking

Third- and fourth-party logistics

Summary

8. Consulting

The process

Fits

Gaps

Resource groups

Item calculation

Issue registration

Getting started

How many jobs

Job Card

Job task and planning lines

Job journal

Job examples

Chapter objects

The new implementation

Budgeting

The infrastructure

The upgrade

The support team

Time sheets

Design pattern

Purchasing

Item costing versus work in progress

Invoicing

Calculating work in progress

WIP post to general ledger

Changing jobs

Quantity budgeting

Resource Groups

Calculations

Issue registration

Summary

9. Interfacing

Interface types

Import and export

Manual

Data pulling

Data pushing

Event-driven versus timer-driven

Interfacing technologies

File

Automation control

Events

Limitations

DotNet interoperability

Client extensibility

Open Database Connectivity (ODBC)/ADO

Reading from Microsoft Dynamics NAV

Writing to Microsoft Dynamics NAV

Talking to other databases

SQL Server interfacing

Microsoft Message Queue

Application server

Web services

Exposing a NAV web service

Consuming a Microsoft Dynamics NAV web service

Standard application interfaces

Office integration

Word and Excel integration

Style sheet tool

Advanced Excel integration

Outlook integration

Outlook part

ExtendedDatatype property

Mail and SMTP mail codeunits

Outlook synchronization

Exchange integration

Interaction log entries

Office 365

SharePoint

Client add-ins

Interface methodologies

The scenario

The design

The mapping

The gaps

What if it does not work

The scenario

The interface type

The interface technology

Active data objects

Logging

The design pattern

The solution

COMMIT

Writing data

Reading data

Log, log, and log more

Testing

The RF database

The test

Viewing the results

SQL Statements

The buffer tables

The RF database

Interfacing into the future

Cloud-enabled Microsoft Dynamics NAV

Summary

10. Application Design

Application life cycle

Design to use

Pages

Role centers

Squash application

Storage and Logistics

Reports

Design to Maintain

Naming

Singular and plural

Reserved words

Names and abbreviations

Quantity versus quality

Loosely coupled

Design to support

Second-level support

Design to upgrade

Has Microsoft changed my (referenced) object

CRM (Version 2.0)

Dimensions (Version 3.x)

Bin code (Version 3.x)

Inventory valuation (Version 3.x)

Item tracking (Version 3.6 and 4.0)

MenuSuite (Version 4.0)

Jobs (Version 5.0)

Dimensions (Version 2013)

Item costing (almost all versions)

Documentation

Split operational and financial information

Design to perform

OLTP versus OLAP

Fast transaction posting

Cleanup unused indexes

Application setup

Job Queue

Background posting

Date compressing and cleanup

Date compression

Data cleanup

Locks, blocks, and deadlocks

Native server versus SQL Server

Locking principles

Deadlocks

Blocking and deadlocks in Microsoft Dynamics NAV

Impact on development

Design to analyze

Report design

Version and object management

What is a version

Version numbering

Combining versions

Creating a version

Tracking object changes

Saving older versions

Development methodology

A sample approach

Fit/gap analysis

Prototyping

Development

Testing

Implementation

Maintenance and support

The project

Standard, customized, or both

Add-on products

Customizing

Total cost of ownership

The Road to Repeatability program

Roadmap to success

Summary

A. Installation Guide

Licensing

Installing Microsoft Dynamics NAV

Changing the license

Restarting service tier

Installing the objects

Importing a FOB file

Installing the Dynamic Link Library files

Registering NavMaps.dll

Registering VEControl.dll

Index