Microsoft Dynamics Axapta Technical,Functional Coverage

Some data stores in Axapta tables on posting of Sales order and the temporary lines not deleted then need to clean manually by following job. Accounts receivable --> Periodic --> Clean up --> Sales update history clean up. Delete both executed and erroneous data.

To Re-Index All Tables or All Indexes in Axapta You can do from this menu path. Go to Administration -> Periodic -> SQL Administration ->Select All Table/All Indexes->Go to Index Action button_>Re-index. Re-Index All tables from SQL Database

To see all fields of table in Axapta mostly we go to table element of AOT and browse table to get all fields name but if you are in any form and want to see all fields then its very easy. Just right click on form control go to recordinfo then click on show all fields you can see all fields in form. I hope it will save your time.

You can try following  Code to Post Production Journal BOM in axapta. ProdJournalCheckPostBOM PJCPostBOM; ; ttsbegin; PJCPostBOM = ProdJournalCheckPostBOM::newPostJournal(“Prod0003“,true); PJCPostBOM.run(); ttscommit;

You  can use expression in select query in axapta following way. LedgerTable LedgerTable ; info(strfmt('%1',(select firstonly AccountNum from LedgerTable order by AccountNum desc ).AccountNum));

If you want to write blog on Ax then you should select you excellent area to get success. If you are functional then do not write topic of technical code you should be strict with your area so it can get more success on functional area. Write topics as per version wise from lower version to highest. You will get more traffic on latest version because lot of companies implementing project in latest versions and they do not know much more about latest version so they will search more on latest version. If you are writing something in old version then do not write large theory type posts it should be short and valuable. In old version most people search for error and troubleshooting so your post should be type of answering for solution of error and troubleshooting. If you are Indian and working for Indian project then there are lot of complex question for tax related,excise ,cst,tds,wct,server tax,vat,additional duty ,custom duty,reverse service charge calculation etc so if you w

This is Countries List Which have users in Microsoft ERP. If you are sales person and search job or projects on ERP then you can search in below countries. United States Saudi Arabia Turkey Indonesia Thailand South Africa Latvia Poland Bulgaria Lithuania Bangladesh Philippines Colombia Malaysia Jordan Qatar Egypt Pakistan Nigeria Chile Iceland Belarus Kenya Tunisia Georgia Vietnam Unknown Region Ukraine Zimbabwe Bolivia Papua New Guinea Kosovo Algeria Serbia Kuwait Estonia Bahrain United Kingdom Sri Lanka Slovenia Morocco Moldova Iraq Guatemala Fiji Ecuador Cyprus Costa Rica Afghanistan Zambia Yemen Venezuela Uzbekistan Uruguay United Arab Emirates Uganda Turks and Caicos Islands Trinidad and Tobago Togo Tanzania Syria Switzerland Swaziland Suriname Sudan South Korea Solomon Islands Singapore Seychelles Senegal Saint Lucia Réunion Rwanda Russia Puerto Rico Peru Paraguay Panama Palestine Oman Nicaragua

You can add minutes to datetime following way.ACX_Base::getServerDateTime() method is used to get server current date time and addminutes is a method of datetimeutil class. info(strfmt("%1",DateTimeUtil::addMinutes(ACX_Base::getServerDateTime(), 540)));

This is Code to send mail From Enterprise portal web page using dataset in axapta. Following code you can write in ascx page and you can get required mail parameter from dataset by writing data method with return values. string fromId, toId, smtpHost, userIdpw, Body; int smtpport; MailMessage message = new MailMessage(); SmtpClient smtpClient = new SmtpClient(); fromId = (string)this.DatasetNm.GetDataSet().DataSetRun.AxaptaObjectAdapter.Call("fromEmailId"); toId = (string)this.DatasetNm.GetDataSet().DataSetRun.AxaptaObjectAdapter.Call("toEmailId"); smtpHost = (string)this.DatasetNm.GetDataSet().DataSetRun.AxaptaObjectAdapter.Call("smtpHost"); smtpport = (int)this.DatasetNm.GetDataSet().DataSetRun.AxaptaObjectAdapter.Call("smtpport"); userIdpw = (string)this.DatasetNm.GetDataSet().DataSetRun.AxaptaObjectAdapter.Call("userIdpw"); Body = (string)this.DatasetNm.GetD

This is very good link which I am posting here. code to remove identical copy X++ code to remove identical copy of object in axapta. If there is same copy of form1 as form2 then if you want to cleanup identical copy then you can use that link code in job. This code can work for var layer. You can also use same thing for user layer.