Skip to main content

Posts

Showing posts from March, 2011

Dynamics AX 2009 System Requirements

Hardware Requirements Processor  Intel Pentium/Celeron family or compatible Pentium III Xeon or higher processor minimum; 1.1 GHz or higher recommended RAM  512 MB RAM or more recommended Monitor  Super VGA (1024x768) or higher resolution monitor Other  DVD drive (required for installation from DVD) Software requirements Microsoft .NET Framework 3.5 Microsoft .NET Framework 4.0 is supported when installed side-by-side with .NET Framework 3.5. Microsoft Windows Installer 3.1

Prerequisite for axapta 4.0 installation

For AOS(Application Object server) Windows 2003 Server (including SBS) Hotfix KB913184 should be installed. Windows XP Professional (SP2+) XP (Production excluded) For Ax Client Operating system Windows Vista all versions (SP1) Windows XP Professional (SP2+) Windows XP Tablet PC Edition (XP2+) Windows 2003 Server (including SBS) Windows 2000 Server (SP4+) For Database server   SQL Server 2005 (SP2 is recommended for performance) SQL Server 2000 SP4 and higher Oracle 10G Release 2 Enterprise Edition You can visit following website to get more details.

Microsoft MB6-818: AX 2009 Financials paper question 1 to 60

#1. You are the system administrator of dynamics AX 2009. Your company uses Microsoft dynamics AX 2009. In Microsoft Dynamics AX 2009, the Contro ller asks the Account to update an additional acquisition to an existing asset. Your company doe s not use the General ledger parameter option that allows multiple acquisitions. In order to updat e this transaction as an alternative to the above functionality, which transaction type must be defined for a journal to achieve this? #1. In order to achieve this, Acquisition must be defined for a journal. #2. In order to achieve this, Acquisition adjustment must be defined for a journal. #3. In order to achieve this, Acquisition adjustme nt before posting must be defined for a journal. #4. In order to achieve this, Acquisition adjustme nt after posting must be defined for a journal. 2  #2. You are the system administrator of dynamics AX 2009. Your company uses Microsoft dynamics AX 2009. There is a photocopier in your company and the phot

Execute sql query in axapta

static server ResultSet executeSqlWithResult(str _sql) { Connection sqlConnection; Statement sqlStatement; ResultSet sqlResultSet; SqlStatementExecutePermission perm; ; sqlConnection = new Connection(); sqlStatement = sqlConnection.createStatement(); perm = new SqlStatementExecutePermission(_sql); perm.assert(); sqlResultSet = sqlStatement.executeQuery(_sql); CodeAccessPermission::revertAssert(); return sqlResultSet; } static server int executeSqlStatement(str _sql) { Connection sqlConnection; Statement sqlStatement; SqlStatementExecutePermission perm; str sql; int result; ; sqlConnection = new Connection(); sqlStatement = sqlConnection.createStatement(); perm = new SqlStatementExecutePermission(_sql); perm.assert(); result = sqlStatement.executeUpdate(_sql); CodeAccessPermission::revertAssert(); return result;

Delete Transaction tables data in axapta

Delete Transaction tables data in axapta To deletes the transactional data and makes system clean for testing purpose. To retains all the setup and master data. we can use following class SysDatabaseTransDelete We can directly run this class from AOT. Before running this class please take backup of your company data.

Example of insert recordset in to table using axapta

syntax of insert recordset is insert_recordset DestinationTable ( ListOfFields ) select ListOfFields1 from SourceTable [ where WhereClause ] [ join ListOfFields2 from JoinedSourceTable [ where JoinedWhereClause ]] example of insert recordset is insert_recordset TableName (field1, field2) select field1, field2 from table2 where abc<= 1000;

Display Multi header using same report on different menu click in Axapta

public void init() { ; super(); salesTable = element.args().record(); DealerInvoice = element.args().parmEnum(); if ( DealerInvoice == DealerInvoice::Original) { headTxt = "Original"; } else if ( DealerInvoice == DealerInvoice::Gatecopy) { headTxt = "Gate Copy"; } else if ( DealerInvoice == DealerInvoice::ExtraCopy) { headTxt = "Extra Copy"; } else if ( DealerInvoice == DealerInvoice::DuplicateForTransporter) { headTxt = "Duplicate For Transporter"; } else if ( DealerInvoice == DealerInvoice::TriplicateForAssesses) { headTxt = "Triplicate For Assesses"; } }

Open many reports on a single click button

To Open many reports on a single click button, write code on click button str _menuItemOutputStr; Args args = new Args(); Args args1 = new Args(); Args args2 = new Args(); Args args3 = new Args(); Args args4 = new Args(); MenuFunction menuFuction; args.record(PurchProforma); args1.record(PurchProforma); args2.record(PurchProforma); args3.record(PurchProforma); args4.record(PurchProforma); new MenuFunction(menuitemoutputstr(_ExProforma_Purch1),MenuItemType::Output).run(args); new MenuFunction(menuitemoutputstr(_ExProforma_Purch1Duplicate),MenuItemType::Output).run(args1); New MenuFunction(menuitemoutputstr(_ExProforma_Purch1Triplicate),MenuItemType::Output).run(args2); new MenuFunction(menuitemoutputstr(_ExProforma_Purch1GateCopy),MenuItemType::Output).run(args3); new MenuFunction(menuitemoutputstr(_ExProforma_Purch1ExtraCopy),MenuItemType::Output).run(args4); super();

Reverse a Transaction in axapta

You can use the following examples of forms to reverse a transaction: • Click General Ledger, click Chart of Account details, and click Transactions • Click Accounts Receivables, then click Customers, and then click Transactions • Click Accounts Payables, then click Vendor, and then click Transactions Follow these steps to reverse a transaction at the transaction level. 1. Select the transaction to reverse. 2. Click Reverse transaction. 3. Select the date of posting for the reversal transaction. The date cannot be before the original posting date or in a closed period. 4. Click OK. The transaction itself and all related transactions that were created when the original transaction is posted are reversed. The results include the following: • Both new and old reversed transactions now receive a special marking ‘’R(eversed)‘’ allowing you to select these transactions in: o Reports o Inquiries o Periodic jobs • The ‘’R‘’ marking identifies all transactions se

Set Up General Ledger Parameters in Axapta

Follow these steps to set up the general ledger parameters for journals: 1. Click General ledger, click Setup, and then click Parameters. 2. On the Ledger tab in the General area, select one of the following methods to check the use of vouchers from the Check for Voucher used list: Reject duplicate - prevents the use of different transaction dates for the same voucher number. Reject duplicates within fiscal year - allows for different transaction dates for the same voucher number in different fiscal years. Accept duplicates - uses different transaction dates for the same voucher number in the Transaction Date field in journal lines. Warn in case of duplicates - Sets up system to notify you if journal lines with different transactions dates have the same voucher number. 3. Select the Check continuous numbers check box for the system to check for continuous numbers in the number sequences that generate vouchers in ledger. If this option is selected, no missing numbers can

Create a new dimension focus in axapta

Follow these steps to create a new Dimension focus for Account-Department. 1. To access the Dimension focuses form, click General ledger, click Setup, click Financial statement, and then click Dimension focuses. 2. Press CTRL+N to create a new dimension focus. 3. In the Set field, enter Acc-Dept. 4. In the Description field, enter Account – Department. 5. Click the Dimension tab. 6. Drag the Ledger account field from Available dimensions to Selected dimensions. 7. Drag the Department field from Available dimensions to Selected dimensions. 8. Click the Overview tab. 9. Press CTRL+S to save the record. Microsoft Dynamics AX 2009 displays a confirmation message. 10. Click the Yes button. 11. Close the Dimension focuses form.

Create a Dimension Value in axapta

Follow these steps to create a new dimension value. 1. To access the Dimensions form, click General ledger, and then click Dimensions. 2. Select the relevant dimension in the Dimension list. 3. Press CTRL+N to create a new line. The value in the Dimension field is populated based on the selection in step 2. 4. Enter a unique identifier for the dimension value in the Number field. 5. Enter a name for the dimension value in the Description field. 6. Select an employee responsible for this dimension, in the Employee drop-down list. This field is optional.   After dimension values are set up, you can assign them to the following: Ledger accounts General ledger transactions Accounts Receivable transactions Customers Accounts Payable transactions Vendors

Create Periods in a New Fiscal Year in axapta

Create the fiscal year for 2011, which begins on July 1, 2010. 1. In the Periods form, click the Create new fiscal year button to create the fiscal year for 2011. 2. Select the period length of one month. 3. Review the new fiscal year in the Periods form. Step by Step 1. Click General ledger, click Setup, click Periods, and then click Periods. 2. Click the Create new fiscal year button. 3. In the Enter start of fiscal year field, enter 7/1/2010. 4. In the Enter close of fiscal year field, enter 6/30/2011. 5. In the Desired length of period field, enter 1. 6. In the Unit field, click the arrow to select Months. 7. Click OK to create the year. The fiscal year for 2011 is added to the Periods form. Create Date Intervals Follow these steps to create date intervals. 1. To access the Date intervals form, click General Ledger, click Setup, click Periods, and then click Date Intervals. 2. Press CTRL+N to create a new record. 3. Enter a date interval code in the

Enable the Web server in Windows Firewall in Axapta Enterprise portal

After you create the SharePoint site, you must enable the Web server in Windows Firewall so users can access the site. If you do not enable the Web server in Windows Firewall, you can view the site on the local server, but no other users can view the site. 1. Click Start > Control Panel > Windows Firewall. 2. Click the Advanced tab. 3. In the Network Connection Settings section, click Settings. 4. Select Web Server (HTTP) and click OK.

Steps to create Axapta Enterprise Portal intranet site

Create an Enterprise Portal intranet site To create an Enterprise Portal intranet site 1. In the Microsoft Dynamics AX client, click Administration > Setup > Internet > Enterprise Portal > Web sites. 2. Click the Create site button. 3. Enter information in the Web Application, Title and Description, and Web Site Address sections. 4. Under Template Selection, click the Custom tab. 5. Click Microsoft Dynamics AX Enterprise Portal. 6. Enter information in the Site Owners and Quota sections, and then click OK.

Add the Guest user account to the Enterprise Portal in Dynamics Axapta

After you have configured Enterprise Portal, you must add the Guest user account to the Enterprise Portal Guest user group. 1. In the Microsoft Dynamics AX client, click 2. Click on EP_Gues. 3. Click on the Users tab. 4. Select the Guest user account in the Remaining users list box and click the left arrow button to move the user account into the Selected users list box. 5. Press CTRL+S to save changes. Administration ; Setup ; User groups.

Enable the Guest user account in EP

By default, the Guest user account is disabled. You must enable this account before anonymous users can access the Enterprise Portal Internet site. 1. In the Microsoft Dynamics AX client, click 2. On the Overview tab, select the Guest user account. 3. Select the Enabled check box. 4. Close the form to save changes. Administration ; Common Forms ; Users .

Delete the SharePoint site in Dynamics Axapta

To delete the SharePoint site, you must be a site administrator who has a Full Control permission level. 1. Open the Enterprise Portal site in your Web browser. 2. Go to the Site Settings page for the top-level Enterprise Portal Web site. 3. Under Site Administration, click Delete this site. 4. Click Delete to confirm. Delete the site in Microsoft Dynamics AX To delete the site in Microsoft Dynamics AX, you must be a member of the Administrators group in Microsoft Dynamics AX. 1. Click Administration ; Setup ; Internet > Enterprise Portal ; Web sites. 2. Select the site to delete and then press ALT+F9.

Disable an Enterprise Portal virtual server in Dynamics Axapta

To disable the virtual server, you must be a member of the Administrators group in Microsoft Dynamics AX. 1. Click 2. Clear the Enabled option for the virtual server, and then close the form. You can enable the virtual server again by selecting the Enabled option in the Manage deployments form. Administration ; Setup ; Internet ; Enterprise Portal ; Manage deployments.

How to Load image using axapta x++ code

void loadImage() { Image img; CompanyImage companyImage; ; companyImage = CompanyImage::find(InventTable.dataAreaId,InventTable.TableId,InventTable.RecId); if (companyImage.Image) { img = new Image(); img.setData(companyImage.Image); ItemImage.image(img); } else { ItemImage.image(null); } }