Wednesday, January 3, 2018

Microsoft Dynamics AX - [Fix] Improve DocuRef Delete Performance

The problem occurred while deleting a Sales Header. But in reality we have the problem every time we remove DocuRef containing a lot of records.

https://community.dynamics.com/ax/b/dynamicsaxexperience/archive/2016/01/23/slow-docuref-delete-performance

How to get sales/purchase tax/GST/VAT info for report?

For posted Sales Invoice report
1
2
select taxTrans where taxTrans.InventTransId == _custInvoiceTrans.InventTransId;
    salesInvoiceTmp.TaxValue = taxTrans.TaxValue;
For posted Free Text Invoice report
1
2
3
4
select taxTrans
    where taxTrans.Source == TaxModuleType::FreeTxtInvoice
        && taxTrans.SourceTableId == tableNum(CustInvoiceTrans)
        && taxTrans.SourceRecId == _custInvoiceTrans.RecId;

How to identify the user that was used to change an object from AOT in AX2012

Get the object name for which we need to track these (user and date&time) information's. Login to SQL Server Management Studio an...