Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

Microsoft Dynamics AX 2012 R3 Financial Management

By : Mohamed Aamer Ala El Din (USD)

2.7 (3)

Microsoft Dynamics AX 2012 R3 Financial Management

2.7 (3)

By: Mohamed Aamer Ala El Din (USD)

Overview of this book

This book is intended for application consultants, controllers, CFOs, and other professionals who are engaged in a Microsoft Dynamics AX implementation project. Basic knowledge of financial terms, concepts, and Microsoft Dynamics AX terminologies is required.

Preface

Preface

What this book covers

Exceptions and considerations

What you need for this book

Who this book is for

Sections

Conventions

Reader feedback

Customer support

Free Chapter

Processing Data

Processing Data

Introduction

Creating a new project, package, and model

Creating a new number sequence

Renaming the primary key

Adding a document handling note

Using a normal table as a temporary table

Copying a record

Building a query object

Using a macro in a SQL statement

Executing a direct SQL statement

Enhancing the data consistency checks

Using the date effectiveness feature

Working with Forms

Working with Forms

Introduction

Creating dialogs using the RunBase framework

Handling the dialog event

Creating dialogs using the SysOperation framework

Building a dynamic form

Adding a form splitter

Creating a modal form

Modifying multiple forms dynamically

Storing the last form values

Using a tree control

Adding the View details link

Selecting a form pattern

Full list of form patterns

Creating a new form

Working with Data in Forms

Working with Data in Forms

Introduction

Using a number sequence handler

Creating a custom filter control

Creating a custom instant search filter

Building a selected/available list

Creating a wizard

Processing multiple records

Coloring records

Adding an image to records

Building Lookups

Building Lookups

Introduction

Creating an automatic lookup

Creating a lookup dynamically

Using a form to build a lookup

Building a tree lookup

Displaying a list of custom options

Displaying custom options in another way

Building a lookup based on the record description

Building the browse for folder lookup

Creating a color picker lookup

Processing Business Tasks

Processing Business Tasks

Introduction

Using a segmented entry control

Creating a general journal

Posting a general journal

Processing a project journal

Creating and posting a ledger voucher

Changing an automatic transaction text

Creating a purchase order

Posting a purchase order

Creating a sales order

Posting a sales order

Creating an electronic payment format

Data Management

Data Management

Introduction

Data entities

Building a data entity with multiple data sources

Data packages

Data migration

Importing data

Troubleshooting

Integration with Microsoft Office

Integration with Microsoft Office

Introduction

Configuring and using the Excel Data Connector add-in

Using Workbook Designer

Export API

Lookup in Excel - creating a custom lookup

Document management

Integration with Power BI

Integration with Power BI

Introduction

Configuring Power BI

Consuming data in Excel

Integrating Excel with Power BI

Developing interactive dashboards

Embedding Power BI visuals

Integration with Services

Integration with Services

Introduction

Authenticating a native client app

Creating a custom service

Consuming custom services in JSON

Consuming custom services in SOAP

Consuming OData services

Consuming external web services

Improving Development Efficiency and Performance

Improving Development Efficiency and Performance

Introduction

Using extensions

Caching a display method

Calculating code execution time

Enhancing insert, update, and delete operations

Writing efficient SQL statements

Using event handler

Creating a Delegate method

Customer Reviews

2.7 (3)

5 star

43.8%

4 star

31.3%

3 star

18.8%

2 star

0%

1 star

6.3%

Posting types in Microsoft Dynamics AX

In Microsoft Dynamics AX, there are two ways to post transactions to general ledger accounts. The first type is through the posting profile that represents the integration point between general ledger and subledgers, and it generates the entries automatically according to the posting profile setup. The second type is journal entries that post directly to ledger accounts. The two ways are explained in detail as follows:

Posting profile: This is the integration point between the subledgers (fixed assets, payables, inventory, banks, receivables, project, and production) and the general ledger. It is a set of ledger accounts that are used in generating the automatic ledger entry in which a transaction occurred. It is possible to select different ledger accounts for each type of subledger transaction. Microsoft Dynamics AX offers flexibility in posting profile setups.
Journal posting: The journal model in Microsoft Dynamics AX is a journal header that contains voucher lines, in which the default data in the journal name (header) is copied into voucher lines such as currency and sales tax, which can be changed in the voucher line. Every subledger has its own journal name based on the transaction type.

The voucher line can be a ledger account, vendor account, customer account, fixed asset, bank, or project. If the selected account is an option other than the ledger account, the subledger posting profile will directly post to the ledger account.

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Microsoft Dynamics AX 2012 R3 Financial Management

Search

Your notes and bookmarks