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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156