Dynamics Axapta Coverage of Technical Tutorials Version 2009, 2012

Microsoft Dynamics Ax, Application Integration Framework, X++ programming, AX 2009 , 2012. Enterprise portal, SharePoint , BI Tools, OLAP, OLTP, DAX, SQL Database, SSRS,SSIS,SSAS, Workflow.

Friday, October 24, 2014

Error while starting Ax 2009 Instance

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;

Thursday, October 16, 2014

Workflow Known Error -Due date exceeded in Ax 2012

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.

Tuesday, September 30, 2014

Get Database information in Axapta


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 .









Monday, August 11, 2014

Post Sales Order from business connector with CSharp in axapta

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);

Thursday, July 24, 2014

Number sequence cleanup activity in Axapta


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.

How to Change User logon Ideal time in Axapta

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.

Table reindex,Generate SQL scripts,truncate option from axapta


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.


Monday, July 21, 2014

Dynamics Axapta performance improvement points

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.

Thursday, July 3, 2014

Multiple line voucher or journal Entry in Axapta

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.

Sunday, June 29, 2014

Code for Tax adjustment in Free text Invoice in axapta

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();
Active Search Results Technology Blogs