Microsoft Dynamics Axapta Technical,Functional Coverage

If you are getting error " A currency to convert from is required to retrieve exchange rate information " on posting statement in Retail then following suggestion can be your solution. It can be resolve you need to check tables-RetailTransactionSalesTrans -currency may be missing in table-RetailTransactionSalesTrans from the currency column .

Following are Installation Steps for Enterprise portal in Axapta 2009/4.0. 1. Installation of .Net framework 2.0 and 3.0. 2. Installation of Client. 3. Installation of Business connector. 4. Installation of Enterprise portal server from Ax Server setup. 5. Installation of Sharepoint 3.0 administration. 6. Run Sharepoint product and technology wizard by using default selection. 7. After wizard completion run configuration wizard from ax (Administrator->setup->Internet->Configuration wizard->then run Manage deployment) 8. Create or register EP Site. 9. If site not created successfully then try with new name which is not used previously. 1. After that site will show in Ax client you can open it.

If you are facing below error while  while starting Ax 2009 Instance. "Concurrent number of AOS for this application Exceeds the licensed number". It means you have single AOS license but You have installed multiple AOS and trying to access using load balancing. You can solve your error following way. Open sql query editor and do following steps SELECT * FROM dbo.SysServerSessions WHERE Status = 1; Change the Status value by using following  update query: UPDATE  dbo.SysServerSessions SET Status = 0 WHERE Status = 1;

This is Workflow Known Error -Due date exceeded in Ax 2012 but solution still not found on searching on internet. X++ Exception: invalid tracking submission expected context Workflow and expected type Submission actual context Workflow and actual type Fault. at SysWorkflow-faultWorkflowInstance SysWorkflow-internalFault SysWorkflow-fault WorkflowTrackingTable-saveTracking SysWorkflowWorkItem-escalate X++ Exception: invalid tracking submission expected context Workflow and expected type Submission actual context WorkItem and actual type DueDateExceeded. at WorkflowTrackingTable-saveTracking SysWorkflowWorkItem-escalate Could any one give right comment and answer I tried, IISReset,Full compilation of CIL and application,Restart AOS Services and Server but problem not resolved. Workflow stop working after this error.

1. Click Area Page node: Administration -> Inquiries -> Database -> Database information.Switch to the General tab on the Database information form.  2. Switch to the System variables tab on the Database information form. to get System variables  on form. 3. Switch to the ODBC tab on the Database information form to get ODBC  Details .

This code can help you AxaptaRecord AXSalesTable = ax.CreateAxaptaRecord("SalesTable"); AXSalesTable = ax.CallStaticRecordMethod("SalesTable", "find", SalesId) as AxaptaRecord; AxaptaObject axSalesFormLetter_Invoice = ax.CreateAxaptaObject("SalesFormLetter_Invoice"); axSalesFormLetter_Invoice.Call("new"); axSalesFormLetter_Invoice.Call("update", AXSalesTable);

  1. Click Navigation Pane node: Basic -> Setup -> Number sequences -> Number sequences. 2. Select the number sequence line. 3. To perform cleanup of number sequence of current selection Click the Clean up -> Click on Current menu button. Form name: NumberSequenceCleanUp 4. To perform cleanup of number sequence of current selection Click the Clean up -> Click on All menu button. 5. Click the OK button.

To Change User logon Ideal time in Axapta you can choose below option. 1. Click Area Page node: Administration -> Users. 2. Click the User options button. 3. Change Automatic shutdown from '0' to '10 it means if user is ideal for 10 min then ax application will close after that.

1. Click Navigation Pane node: Administration -> Periodic -> SQL administration. Form name: SQL administration 2. Click the Table actions -> Browse table menu button. Form name: Table browser: CustTable 3. Close the Table browser: CustTable form. 4. Click the Index actions -> Reindex menu button. 5. Click the Generate SQL scripts -> .... for creating tables menu button. Same as you can check other option like truncate table,check synchronization etc.

Performance Improvement for Ax Application. If you are facing performance problem in axapta then you can do following task to improve performance. 1. First you need to check which table has maximum transactions then you concentrate on those tables which has lot of records.  2. You can create index on tables which is taking long time on select query. 3. You can delete unwanted transaction log data and usage data if required. 4. You can set re-indexing job for all table through job in sql. 5. You can review logic and loop for customization tables you can tune logic to improve performance. 6. You can increase RAM in sql database if its not fulfilling transaction requirements. 7. You can install more AOS and do load balancing. I hope those points can help you to improve performance.

As we listen lot of time like multiple line voucher Entry and Single line voucher. If we want to understand this terms in better way than you can go on below points. 1. If you enter any journal line with offset account that means its single line entry. Voucher.  - Account- Debit- Credit- Offset account V00001   -AC01-1000-                     -O00001 2. If your Entry like this Voucher.  - Account- Debit- Credit- Offset account V00001   -AC01-1000-  V00001 -O00001 -          -10000         - This type of Entry is treated as multiple line voucher Entry.

This is a Code for Tax adjustment in Free text Invoice in axapta. You can try this code in job to check the effect of adjustment. CustInvoiceTable _custInvoiceTable; CustInvoiceCalcTax custInvoiceCalcTax; TaxFreeInvoice _taxFreeInvoice; TaxRegulation _taxRegulation; ; ttsbegin; select firstonly _custInvoiceTable where _custInvoiceTable.InvoiceId == "test5"; custInvoiceCalcTax = new CustInvoiceCalcTax_Table(_custInvoiceTable); _taxFreeInvoice = new TaxFreeInvoice(custInvoiceCalcTax); _taxFreeInvoice.calc(); _taxRegulation = TaxRegulation::newTaxRegulation(_taxFreeInvoice); _taxRegulation.allocateAmount(33.47); _taxRegulation.saveTaxRegulation();

This is a Code to Tax adjustment for Ledger Journal in axapta You can try this code in Job in AOT. I hope it can help you to get class and method details for tax adjustment. LedgerJOurnalTrans LJTrans; TaxLedgerJournalCalculate taxLedgerJournalCalculate; TaxLedgerJournal taxLedgerJournal; TaxRegulation TaxReg; ; ttsbegin; select firstonly LJTrans  where LJTrans.JournalNum == "000787_j"; taxLedgerJournal = TaxLedgerJournal::construct(TaxJournalCall::Journal, LJTrans, null); TaxReg = new TaxRegulation(); taxLedgerJournal.calcAndPost(); TaxReg.setTax(taxLedgerJournal); TaxReg.createSumsFromTmp(); TaxReg.allocateAmount(7.8); TaxReg.saveTaxRegulation();

If you want to know inventory value with dimension details then you can Go to Inventory Report from following menu path. Inventory Management -> Reports -> Status -> Inventory Value By Inventory Dimension In this report you can select dimension like batchid,warehouse, inventory location etc. Inventory value you will get correct after inventory recalculation and closing.

Trial balance report is to show closing balance of particular period. If you want to know opening debit,credit,current period debit and credit amount and balance till date for particular account then you can get details from following report. General Ledger -> Reports -> Transaction -> Periodic -> Trial Balance You can view  report by using summary and details option. You can check other option to know more details about report.

If you want to disable Dialog  to Report to display report output without opening of dialog box. You need to set Properties of report design . You can reset Interactive property of report to no at design.

If you are facing Buffer size error in Axapta during any process then you can resolve this error by increasing buffer size from AOS Server configuration. Buffer size setting is available in Application Object Server configuration.

To Change current session date in axapta you can find in following menu. Tools- > Session date If you will change session date for your client then it will change for your client session only it will not affect other users session. Once you will close your ax client then real current date will be set automatically.

First you need to check Amount global type has been set properly or not on following menu. Administration -> Setup -> System -> Adjust Global Types. Then you need to find EDT( Extended data type ) then you need to set Number of Decimals property on the Amount extended data type to as per your requirement.

To   create record buffer at runtime in axapta you can get hints from below code. DictTable dictTable = new DictTable(tableId); Common targetTable = dictTable.makeRecord(); It will create buffer dynamically.

If you are getting below error on workflow . Stopped (error): X++ Exception: Could not find user at SysWorkflowDueDateProvider-resolve SysWorkflowDueDateProvider-resolveDueDate Then you need to check following things. 1. Check workflow configuration is user assigned for workflow approval elements . 2. Check user relation form if there is not employee assigned then you need to assign employee on user relation form.

To Execute or call SQL Stored Procedure in Axapta by code you can get hints from below code. You can also pass parameter with stored procedure in string format. UserConnection Conn; Statement Stmt; str SqlStmt; SqlSystem sqlSystem; SqlStatementExecutePermission sqlPermission; ResultSet resultSet; str StrFromdate,StTodate; StrFromdate =strFmt("2010-01-01"); StTodate =strFmt("2014-03-31"); sqlSystem =new SqlSystem(); SqlStmt =strFmt('Exec SP_StoredProc \'%1\',\'%2\'',StrFromdate,StTodate) ; Conn =new UserConnection(); Stmt = Conn.createStatement(); sqlPermission =new SqlStatementExecutePermission(SqlStmt); sqlPermission.assert(); Stmt.executeUpdate(SqlStmt); CodeAccessPermission::revertAssert();

To Call query in Axapta by code you can try below code. You need to create query in aot query node then pass query using querystr method in queryrun object. QueryRun queryRun; int cnt; ; queryRun = new QueryRun(queryStr(Query1)); if (queryRun.prompt()) { while (queryRun.next()) { cnt++; }

The inventory settlements table is to store information generated during inventory closing and periodic adjust  job run. This table can be cleaned up or compressed using the following menu in Axapta. Inventory management--->Periodic--->Clean up--->Inventory settlements clean up.

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.

Primary index uniquely identifies records in any given table. Each unique combination of Primary Key fields uniquely identifies only one record in the table. There can only be one primary key per table. Cluster Index is the physical order in which records are stored in the table. Cluster Indexes do not have to be unique.

What is the difference between Index and Index hint? Index is used to give the control to the database for optimization. AX Kernel will add an OrderBy with all the fields of the index. Index Hint tells the database to use specified index and no other one. All Tables should have at least one find method that selects and returns one record method should be a Boolean variable called method; from the table that matches the unique index specified by the input parameters.