Dynamics Community Forum Thread Details

Multi-Dimensional Analysis (MDA) Integration

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

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

Quick Links

Leaderboard