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...
-
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...
-
This article explains: How to picking list through a job using X++ in Dynamics AX. Applied on: Dynamics AX 2009 SP1 Create a job a...
-
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...