Microsoft Dynamics Axapta Technical,Functional Coverage

General Features of the BOM Designer in axapta 2012 Use the BOM designer to perform the following actions: • Create new BOM versions or edit the existing ones. • Edit and delete BOM lines. • Check BOMs for errors, for example, BOM circularity. • Check which BOM versions  are attached to the selected BOM. • Check at which sites the BOM versions are assigned. • Print BOM and BOM lines for the selected BOM. • Verify the site to which the BOM line belongs

use index hint on a join in Axapta InventTrans inventTrans; InventDim inventDim; ; while select inventTrans index hint ItemIdx where inventTrans.ItemId == 'X' join inventDim where inventDim.inventDimId == inventTrans.inventDimId && inventDim.inventBatchId == 'Y'

The complete syntax for the While select statement in axapta [while] select [reverse] [firstfast] [firstonly] [firstOnly10] [firstOnly100] [firstOnly1000] [forupdate] [nofetch] [crosscompany] [forcelitterals | forceplaceholders] [forcenestedloop] [forceselectorder] [repeatableRead] [validTimeState] [ * | <fieldlist> from] <tablebuffer> [ index [hint] <indexname> ] [ group by {<field>} ] [ order by {<field> [asc][desc]} ] [ where <expression> ] [ outer | exists | notexists ] join [reverse] [ * | <fieldlist> from] <tablebuffer> [ index <indexname> ] [sum] [avg] [minof] [maxof] [count] [ group by {<field>} ] [ order by {<field> [asc][desc]} ] [ where <expression> ] ] <fieldlist> ::= <field> | <fieldlist> , <field> <field> ::= fieldname | <function>(<field>)

Data sets in Microsoft Dynamics AX provide a generic data access layer that allows for external presentation layers to bind to Microsoft Dynamics AX tables and data types.

How can you compare layers of Axapta i) Microsoft Dynamics AX menu >Tools >  Development tools > Code Upgrade > Compare layers ii) Enter the name of Project iii) Select the Surce Layer used as the base layer for the comparison. iv) Select Reference Layer that you want to compare to the Source Layer. v) A new private project will be created in the Project node.

create a new language in AX 2009 For creating new language follow the steps. i) Go to AX Menu > Tools > Development Tools > Label > Label File Wizard. ii) Check on Create new label Language then click on Next button. iii) Select language. iv) You can also create new language id by click on Create new language button.

Microsoft bought four independent ERP packages for small to medium business over the years. Microsoft now markets all four + CRM under the Dynamics branding. The ERP packages are AX (Axapta), Great Plains, Navision and Soloman. These four ERP's fit into various customer requirements better or worse depending on what your business requirements are. AX is the choice if a very high degree of customization is required by the customer. The others, not so much.  AX is for EnterpriseMicrosoft Great Plains is TIER 2 application whereas Microsoft AX is TIER 1. TIER 2 means for Small and Medium Size Enterprises  and TIER 1 means Enterprise. Enterprise means where employee count is more than 20,000 and more than 200 concurrent users.