Announcements
No record found.
There's a table DTA00100 and a DTA amount field in the database.
What are these in practical finance/accounting terms?
*This post is locked for comments
DTA is the acronym for Dynamic Transaction Analysis, which later on became known as the Multi-Dimensional Analysis (MDA) module. MDA was later on replaced by Analytical Accounting, but get this... MDA still works and is fully integrated with FRx.
The DTA00100 table is the Analysis Group Master table and is the equivalent of the Transaction Dimensions in Analytical Accounting. A transaction dimension - or an Analysis Group in the case of MDA - is any criterion you want to define to analyze, i.e., cost centers, departments, or sales regions, etc. As you can already tell, it saves you from having to define these as a segment within your chart of accounts, especially when you have the need to create financials that analyze various aspects of your business.
I could certainly write a dissertation on the subject here, but is best if you take a look at the MDA manual (only as a reference):
download.microsoft.com/.../multidimensionalanalysis.pdf
You can also take a look at the Analytical Accounting manual here:
mbs.microsoft.com/.../AnalyticalAccounting.pdf
Thanks!
Thank you very much
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
