What is Layers in Axapta 2012 and Why layer concept in ax

Layers in Axapta

It holds all elements that are displayed in the AOT

Total 8 application layers are available, all layers are a hierarchy of levels in the application, 

and application modification and deletion are not interfering in the next lower level

Current level application modification are overshadow to the element on a lower level

Only top level version of an application element used when application is compiled

Below layers available to Customer and Partners

Usp    User layer for specific functionality and customization                         

Usr  

                                 

Cup                       

Cus Customer Layer    

 

Below layers available to partners and independent software vendor (ISV)

Vap  value added reseller layer – customized solution, developed by VAR’s

Var                        

Isp  independent software vendor layer

Isv

Slp  Solution layer, Microsoft endorsed industry solution

Sln

Below layers available from Microsoft to deliver base application

Fpp  Feature pack layer, control by Microsoft

Fpk

Glp  Globalization layer, developed for some countries

Gls

Syp  System layer, lowest layer where STD application developed, includes core application

Sys

Layers are benefits in terms of

Protection of source code

It keeps separate from modification

On Sys, GLS and FPK layers only Microsoft dynamics ax development team can work

Converting amount into word formate in ax 2012

Converting amount into word formate in ax 2012:
 tmpStr = numeralsToTxt(5500));
At first declare a global string variable in the report and asign value in this variable like the following....

tmpStr = numeralsToTxt(5500));

 Here 5500 is a argument I passed for better understanding, here you will pass the amount variable and then "tmpStr" returns through a Display method.

How to stop dragging table in visual studio Design or SSRS report ?

I finally figured this out. A rectangle works as a container for data regions.
 If I place the table into a rectangle, it will only grow within the boundaries of the rectangle,
without pushing other report items around. In order for this to work, though,
 the table must be a child control of the rectangle.
 This is achieved by dropping a new table into an existing text box,
or by dropping an existing table some place outside of the rectangle,
then moving it back inside. If you just draw a rectangle around the table,
 it will not become a child. This can be verified by right-clicking on the table.
If it only says "select body" and not "select rectanglex" as well, it is not a child of the rectangle. Alternatively, it is possible to place other items (text boxes, etc into a rectangle that is on one side of a table. The top edge of the rectangle must be above the bottom edge of the table. Then any controls in the rectangle will be unaffected by the growth of the table, but other items below the table will.

Thank You..

Cannot execute a data definition language command on (). The SQL database has issued an error in ax 2012

Step 1 – Synchronize the SQL database

1. Navigate to Administration module -> Periodic -> 'SQL Administration'
2. Select the table and click table actions check/synchronise
   1. Sometimes you will not be able to determine which tables are causing the error so just do this for all
3. Click 'Start' with the default options.
    

Step 2 – Step 1 with 'Remove unknown indexes' in the check/synchronise step

1. Follow steps 1 and 2 from step 1

Step 3 – Check the Event Viewer (SQL and AOS box)

1. This should give you a good indication on where to go for the issue going forward as there could be index violations.