Wednesday, January 31, 2018
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
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; |
Subscribe to:
Posts (Atom)
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...
-
The global search is a feature in Dynamics Ax 4.0 which allows you to search for a string in several tables (like a full text search). You s...
-
Combo boxes in Dialogs are added by adding a DialogField object with the type of an enum. The enum is then controlling what items you can pi...
-
A while ago I had the need to translate labels, I was creating eMail bodys while using SysMailer and wanted to use different languages for d...