Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

What is DTA?

Posted on by 100

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

  • VinhTon Profile Picture
    VinhTon 100 on at
    RE: What is DTA?

    Thank you very much

  • VinhTon Profile Picture
    VinhTon 100 on at
    RE: What is DTA?

    Thanks!

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: What is DTA?

    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

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans