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:
Comments (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...
-
I've recently found an interesting feature of DAX4 Object Server: it can run not only as a service, but also as a console application st...
-
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...
-
static void CreateTransferOrderLine(Args _args) { InventTransferTable inventTransFerTable; InventTransferLine inventTransFerLine; ...