Wednesday 17 February 2016

Caching property against table groups in Ax 2012

Uses the following caching property for the table groups,
Table Group Cache Lookup
 Parameter  EntireTable
 Group  Found
 Main  Found
 Transaction  NotInTTS
 WorksheetHeader  NotInTTS
 WorksheetLine  NotInTTS
 Framework  N/A
 Reference  Found
 Worksheet  NotInTTS
 TransactionHeader  NotInTTS
 TransactionLine  NotInTTS

By default table group property for the custom table Miscellaneous,  As per the standard, Custom tables should not use this group.

Reference link is attached
table caching property

Note : Wrong caching leads to unnecessary database calls.






Calculate ledger balance by dimension set in X++ in AX2012/Dynamics 365 FO

There are a variety of ways users can view balances in the general ledger. Some of the most common options are: 1. Trial balance 2. Financia...