Tuesday, April 3, 2018

Today we will continue to discuss Microsoft Dynamics AX. We briefly reviewed the user interface features to get to know Dynamics AX.
We saw that the navigation pane provides access to the modules and functionality such as General Ledger, Bank etc. Modules contain folders such as Journals, Inquiries, Reports, Periodic and Setup. Folders contain menu items which execute a function within the program such as opening a form, report or dialogbox.
The toolbar helps us with frequently performed tasks. Tasks include such things as converting units, creating language texts, displaying amounts in a different currency, navigating to other companies, clipboard actions, and changing dates.  Favorites are a way to create shortcut to items such as forms, reports, and queries that we use frequently. Favorites can be organized into folders and can be grouped.
Data appears in the form of records. Records may be created using templates. Templates give pre-filled data that can be used to create records. They may be available only to the user, or to all the users within a selected company, or they could be a system template such as to manage users. Records can be found, filtered and sorted.
We can also add notes, documents, spreadsheets and other files to records. Multiple notes can be created for the same record.
Dynamics AX provides a variety of tools for viewing and analyzing business data. We will go over these now. Reports can be generated in a variety of ways. The standard-reports are pre-constructed views of business data and they number in hundreds. Reports are available from their data sources such as general ledger. Auto reports enables us to view the data from a form and these data can be saved to the Application Object Tree AOT.

#codingexercise
In an M×N board with Q horses and their coordinates, moves are only possible by swapping horses.
These horses move as usual to any of their eight location from their current position . How many distinct chess board arrangements are possible.
Another solution possible is to enumerate all the squares that can be occupied by individual pieces say n and permute k horses in that space which leads us to P(n,k)

#sqlexercise
OVER clause is available from SQL server 2008 onwards.
eg:
SELECT ROW_NUMBER() OVER(PARTITION BY PostalCode ORDER BY SalesYTD DESC) AS "Row Number",   <other columns>
FROM <originating view>
ORDER BY PostalCode.

No comments:

Post a Comment