Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Multi-Dimensional Analysis (MDA) Integration

(0) ShareShare
ReportReport
Posted on by 140

Hi All,

I need help with the back-end integration of the MDA. I have to populate tables DTA10100 and DTA10200. My question is, how would I populate this without the use of e-connect? I need to properly map the fields to its corresponding table relationships, however, I am having a hard time doing so. For example, the SEQNUMBR column, how would I populate this? Where can I source the data of the following columns? I know some are through user input, some are system generated, but how would I determine? What are the table relationships going to DTA10100 and DTA10200?

Thanks!

DTA10100

Column Name

DTASERIES

DTAREF

ACTINDX

SEQNUMBR

GROUPID

DTA_GL_Reference

DOCNUMBR

RMDTYPAL

GROUPAMT

JRNENTRY

TRXDATE

PSTGSTUS

DEX_ROW_ID

DTA10200

Column Name

DTASERIES

DTAREF

ACTINDX

SEQNUMBR

GROUPID

CODEID

DOCNUMBR

RMDTYPAL

POSTDESC

DTAQNTY

CODEAMT

TRXDATE

DEX_ROW_ID

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Multi-Dimensional Analysis (MDA) Integration

    Marc,

    SEQNUMBR column, how would I populate this?

    Read  David Musgrave 's response in below post.

    community.dynamics.com/.../232201.aspx

    Here is the extract:

    <Quote>

    The 16384 sequence number increment is used so that lines can be inserted multiple times. It is used as it is a power of 2 which means it can be divided by 2 multiple times and remain a whole number. ie. no fractions. 16884, 8192, 4096, 2048, 1024, 512, 256, 128, 64, 32, 16, 8, 4, 2, 1.

    Each time you insert a line in a transaction, the new line number is the mid point between the line before (or 0 is this is the first line) and the line after.

    More recently on GL transactions the increment was changed to 500. This was purely because on a very large journal will many, many lines incrementing by 16384 could exceed the maximum value for the sequence number and generate errors. To avoid this issue, the increment was changed to 500. This can only be divided  a few times before getting a fraction 500, 250, 125, 62.5. But most people don't insert lines on GL transactions much anyway.

    </Quote>

    Cheers!

    Sanjay

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans