Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

How is DTAREF in DTA10100 generated?

(0) ShareShare
ReportReport
Posted on by 110

Here is an example:

DTASERIES DTAREF ACTINDX SEQNUMBR GROUPID DTA_GL_Reference DOCNUMBR RMDTYPAL GROUPAMT JRNENTRY TRXDATE PSTGSTUS DEX_ROW_ID
2 201805833665417718N       717 16384 CASH FLOW                                                       0 200 20180583 00:00.0 1 65

DTAREF NO: 201805833665417718N
JRNENTRY: 20180583

It is obvious that the first charactes  of DTAREF is referring to the journal entry number ( i underlined and bolded the numbers below)

201805833665417718N .

So what is the remaining characters? 3665417718N ?   How is it generated?

*This post is locked for comments

  • TYong Profile Picture
    5 on at
    RE: How is DTAREF in DTA10100 generated?

    how would you calculate it for the PM module?

    thx.

  • Christclark Profile Picture
    110 on at
    RE: How is DTAREF in DTA10100 generated?

    Hi Mariano,

    Looks like I don't need the computation though it is good info.
    The DTA_Index from the GL tables is the DTA_REF already:

    GL10000 Transaction Work
    GL20000 Year-to-Date Transaction Open
    GL30000 Account Transaction History

    Sample:

    DTA_Index
    2018051057601.16418
    DTAREF
    201805105760116418N

    So I just have to add the type of transaction at the end.

  • Christclark Profile Picture
    110 on at
    RE: How is DTAREF in DTA10100 generated?

    Hi Mariano,


    Just a follow-up to my previous reply .

    Do I have to take in consideration the columns mentioned below of TABLE GL20000  when creating transactions in the MDA tables (DTA10100 and DTA10200) for the posted GL transactrions ?

     


    TABLE GL20000
    OrigDTASeries
    DTA_GL_Status
    DTA_Index

  • Christclark Profile Picture
    110 on at
    RE: How is DTAREF in DTA10100 generated?

    Hi Mariano,

    I notice one thing, in GL20000, column DTA_Index is somehow similar to DTAREF.

    JRENTRY=20180591

    DTA_INDEX=2018059156071.17

    DTAREF=2018059156071.17718N  

    Is it something I should watch out?

    Let me repeat the scenario.

    There are posted transactions in GL from January to May. However, this June  Multidimensional Analysis has been implemented and those posted transactions need to have Multidimensional Analysis.

    So the propose solution is to create MDA for the tables below via SQL:

    DTA10100   --Transaction Analysis Groups

    DTA10200   --Transaction Analysis Codes

    Is there anything I should be aware of?

  • Mariano Gomez Profile Picture
    26,225 on at
    RE: How is DTAREF in DTA10100 generated?

    Correct!

  • Verified answer
    Christclark Profile Picture
    110 on at
    RE: How is DTAREF in DTA10100 generated?

    Alright.  so if the time in serer is 8:45:36 AM.

    Journal entry number is 2018056 and transaction type is normal.

    8(hour)* 3600 = 28800 + 36(seconds) = 28836

    45(minutes)* 60=28800

    28800+28836=57636

    2018056+57636(journal entry number)=2075692

    20180562075692N

     

    I hope i get it right.

     

    So if I have 1000 journal entry numbers, I can use 2075692 in the middle part  of 2075692since the first part of it is the journal entry number

  • Mariano Gomez Profile Picture
    26,225 on at
    RE: How is DTAREF in DTA10100 generated?

    You don't need to randomize the number, simply apply the logic I gave you, although I don't see a reason why a random number won't work, since that's what they were trying to do to begin with :)

  • Christclark Profile Picture
    110 on at
    RE: How is DTAREF in DTA10100 generated?

    Thanks Mariano for your swift response and detailed explanation.

    The main reason I am asking it because  we implemented MDA(Multidimensional analysis). However, it is the middle of the year already and there are transactions on the past months which needs to have MDA. I was checking which tables needs to be modified and they are:

    DTA10100   --Transaction Analysis Groups

    DTA10200   --Transaction Analysis Codes

     

    I am planning to add the transactions via SQL  and I was wondering how that column was created. I think as long as the first part of DTAREF column which is the journal number and last character(transaction type) is matching, it should be fine.

    The middle part which is int DTA index can be random numbers?

    I hope my plan is fine or do you suggest any other actions?

  • Verified answer
    Mariano Gomez Profile Picture
    26,225 on at
    RE: How is DTAREF in DTA10100 generated?

    Journal Number + int(DTA Index) + Transaction Type

    N = Normal/Standard

    R = Reversing

    The DTA Index is calculated with a rather complex formula:

    1) You gather the hour portion from the server time

    2) You multiply times 3600 to convert all of it to seconds

    3) You will then increment that value by the seconds portion of the server time and add the minutes portion of the server time, times 60

    4) Finally, a couple calculations more and you add the journal entry to the resulting seconds digit. The end result is a string with an integer value + a period + a decimal portion.

    This logic may change depending on where the transaction was originated, so for example, if the transaction was originated in SOP, instead of the journal number, you would see something like the invoice number as part of it.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans