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.

case scenario, In share point service administration site is working and default database is connecting with static IP of sql database if user removed static ip of database server then sharepoint stop working.  I tried to change ip with pc name in sharepoint administration then still problem exists. Now timeout error is not coming but sometimes error is coming like “ share point issued an error please contact to system administration” from user side. This error is coming for only one ep page. On sql event log error. Unknown SQL Exception 10054 occured. Additional error information from SQL Server is included below. A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) Please share your views for the same Possible solution: Remove static Ip of database from sharepoint administration after that is Site stop working then re-configure share

Eventlog error details. The Execute method of job definition Microsoft.SharePoint.Search.Administration.SPSearchJobDefinition (ID f563b66c-e273-42f4-b0db-4106a63f0a83) threw an exception. More information is included below. Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. EP Page is being timeout. Possible solution: Increase time out on IIS for website, increase time out at web.config files.

I am facing this error on event log. I checked that EP and sharepoint site is working fine but still this error is coming after re installation of EP The description for Event ID 27745 from source Windows SharePoint Services 3 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: #50071: Unable to connect to the database SharePoint_Config on xxxx.xx.xx.xxx.  Check the database connection information and make sure that the database server is running. the message resource is present but the message is not found in the string/message table

I am facing this error in eventlog. could anyone advice the reason and solution for this error. Faulting application SAPISSVC.EXE, version 7.0.0.1, time stamp 0x4f27b98d, faulting module kernel32.dll, version 6.0.6001.18538, time stamp 0x4cb73957, exception code 0xc0000142, fault offset 0x00000000000b1b48, process id 0x2804, application start time 0x01cf55faf48cdb27.

Super() is used together with inheritance. Calling Super() means calling a method with the same name in parent class. The parent can be a normal class in X++, or it can be a kernel call.