web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How is DTAREF in DTA10...
Microsoft Dynamics GP (Archived)

How is DTAREF in DTA10100 generated?

(0) ShareShare
ReportReport
Posted on by Christclark 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

I have the same question (0)
  • Verified answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    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.

  • Christclark Profile Picture
    Christclark 110 on at

    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?

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    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 :)

  • Verified answer
    Christclark Profile Picture
    Christclark 110 on at

    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. 

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Correct!

  • Christclark Profile Picture
    Christclark 110 on at

    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?

  • Christclark Profile Picture
    Christclark 110 on at

    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
    Christclark 110 on at

    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.

  • TYong Profile Picture
    TYong 5 on at

    how would you calculate it for the PM module?

    thx.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans