Skip to main content

Posts

Showing posts from January, 2016

Find Ledger Account Id by Ledger dimension in Ax 2012

To Find Ledger Account Id by Ledger dimension in Ax 2012 you can get hint from below code. findByLedgerDimension is a method defined in Mainaccount table where you can pass ledgerdimension value . MainAccountId is field name which is created in MainAccount Table. MainAccount Table is main master table for Ledgers. info(strFmt("%1",MainAccount::findByLedgerDimension(3427167077).MainAccountId));

Get or split values start and end from range in Ax 2012

This is code sample to Get or split values from range in Ax 2012. For example you provided range from 100 to 110 and want both value start value and end value in some variable then you can use container to split range values. str range; str startValue,endValue; List ledgerRange= new list(Types::String); ListIterator listiterator; container con; range = "100..110"; rangevalue= strSplit(range,".."); listiterator = new listiterator(rangevalue); while(listiterator.more()) { con += listiterator.value(); listiterator.next(); } startValue = conpeek(con,1); endValue = conPeek(con,3); info(startValue); info(EndValue);    

Query to get Tax Registration Number by party Name in Ax 2012

This is the Query to get Tax Registration Number by party Name in Ax 2012. Intermediate table for DirPartyTable and taxRegistration is DirPartyLocation and registrationNumber is the field to get value of tax registration Number. DirPartyTable DirPartyTable; DirPartyLocation DirPartyLocation; taxRegistration taxRegistration; select * from DirPartyTable where DirPartyTable.Name == "TestName"; select * from DirPartyLocation where DirPartyLocation.Party == dirPartyTable.RecId; select registrationNumber from taxRegistration where taxRegistration.DirPartyLocation == dirPartyLocation.RecId; info(strFmt("reg %1",taxRegistration.RegistrationNumber));

Hints and steps to install Ax 2012 in Windows 8

Following are the Hints and steps to install Ax 2012 in Windows 8 1.Installation is easy but first of all you have to be aware regarding prerequisites and the platform, where you are going to run AX. a)  Microsoft .NET Framework Most Microsoft Dynamics AX components, including the Setup wizard, require .NET Framework 3.5 with Service Pack 1. For those components that require.NET Framework 4.0, it is listed as an additional requirement in this document. b)         Microsoft Windows® Installer 3.1 or Windows Installer 4.0 c)Additional requirements ·         .NET Framework 4.0 with the hotfix from Knowledge Base article number 2390372. ·         Microsoft SQL Server 2008 Native Client 2.First of all if you want to make your system stand alone, then you need to attach a domain with your client. for that thing you need to install windows server 2008R2/Windows server 2012 R2, then you can connect with this. or if you want to install directly in the Windows 8 then there is a tric