Skip to main content

Posts

Showing posts from August, 2014

Error Removal of suspension of recId allocation for table VendInvoiceInfoTable has failed in axapta 2012

Problem: Error executing code: The field with ID '0' does not exist in table 'SalesPurchJournalLineExtension_IN'. Removal of suspension of recId allocation for table VendInvoiceInfoTable has failed. Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.    at Dynamics.Ax.Application.SysRecIdSequence.Removerecidsuspension(Int32 _tableId) in SysRecIdSequence.removeRecIdSuspension.xpp:line 23    at Dynamics.Ax.Application.formletterParmData.Removerecidsuspension() in formletterParmData.removeRecIdSuspension.xpp:line 15    at Dynamics.Ax.Application.formletterParmData.Catchall() in formletterParmData.catchAll.xpp:line 9    at Dynamics.Ax.Application.formletterParmData.Createdata(Boolean _append, Boolean ) in formletterParmData.createData.xpp:line 63    at Dynamics.Ax.Application.formletterParmData.Createdata(Boolean _append)    at Dynamics.Ax.Application.PurchFo...

Table level best practices in Ax 2012

--> Set Title fields --> Create primary index --> Create basic methods like find, findRecId, exist. --> Add method documentation in every method. --> Method name should be camel casing --> Add BP deviation comment on every display or edit method. --> Create groups containing relevant fields. -->Run the BP check on your table (right click on table -> Add-ins -> Check Best Practices) and it will show the most crucial BP deviations you might have there. --> Use pascal casing for field names and table name.