Skip to main content

Posts

Error Cannot create a record in Purchase orders in axapta 2012

If you are facing this troubleshooting in ax 2012 You may face  the below error while creating new Purchase order in AX 2012. If This error is coming in only one company and you are not able to create PO in same company. ... Cannot create a record in Purchase orders (PurchTable). Purchase order: COM-0000XX, COM-00XXXX. The record already exists. Microsoft.Dynamics.Ax.Xpp.DuplicateKeyException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.DuplicateKeyException' was thrown. at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue) at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.insert(IntPtr table) at Microsoft.Dynamics.Ax.Xpp.Common.doInsert() at Dynamics.Ax.Application.PurchTableType.Insert(Boolean _interCompanySilent, Date _accountingDate, Boolean , Boolean ) in PurchTableType.insert.xpp:line 21 at Dynamics.Ax.Application.PurchTable.Insert(Boolean _interCompanySilent, Date _accountingDate, Boolean , Boolean ) in PurchTable.insert.xpp:li

Three tier Extended architecture in axapta

THREE TIER ARCHITECTURE EXTENDED ARCHITECTURE

Dimensions Data model in ax 2012

New inventory reconciliation in Microsoft Dynamics AX 2012

This is video link to learn about Microsoft Dynamics AX 2012 Production Module, Inventory Reconciliation. This feature is backporter from AX 2012 to AX 2009 RU8. This video will show you new inventory reconciliation in Microsoft Dynamics AX 2012. Click below link to visit this video. New inventory reconciliation in Microsoft Dynamics AX 2012

Number sequence in axapta 2012

To create a new number sequence: exclusively in 2012  1. On the Number sequences list page, in the New group, click Number sequence. The details page opens. 2. Enter a new code and name for the new number sequence on the Identification FastTab. 3. Select a scope on the Scope parameters FastTab. Depending on the scope selected, enter the appropriate segment values. For example, if the scope is Company, select the company for which this number sequence is being defined.  Note Although the Legal entity and Company scopes are technically equivalent, for ease of use, we have decided to keep them as separate scopes. The Company scope is used for all references for which the underlying table is a “per company” table that uses the DataAreaId field and whose SaveDataPerCompany property is set to “Yes”. For example, this scope is used for the number sequence for the customer account number in the Customer table (CustTable).  The Legal entity scope should be used for references for which

Next generation of Axapta

Next generation of Axapta is Ax 2012 R2 and MS dynamics Ax 7. You can see From Microsoft Dynamics AX road map image