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 AX (Archived) / How can a user generat...
Microsoft Dynamics AX (Archived)

How can a user generate RECID

(0) ShareShare
ReportReport
Posted on by Community Member

Greetings:

We are trying to convert our chart of accounts from old system to new system and have gone far along. However, at this time, we are only concerned about how to generate or control the RECID field to correctly populate LedgerTrans table. I did happen to read http://msdn.microsoft.com/en-us/library/aa638594.aspx but that didn't help much. The reason for not doing through template (may be the last resort) is because we have too many companies and thus we are trying to control even the DATAAREAID with our code (something that templates doesn't allow).

Any ideas/thoughts are more than welcome. Please advise. Thanks.

Kind regards,

Manish Wadhwa. 

*This post is locked for comments

  • Carlos Herrando Profile Picture
    Carlos Herrando 169 on at
    Re: Re: Re: Re: Re: How can a user generate RECID

    Hello Kiran,

    There are serveral registers in the SystemSequences table. How do you determine what is the appropiate register to get and update the NextVal for the table you are inserting new registers?

    Regards

        Carlos

  • Kiran Vaswani Profile Picture
    Kiran Vaswani 465 on at
    Re: Re: Re: Re: Re: How can a user generate RECID
    Hello Manish,
    Very happy new year to you as well..
    You can not use other company in where clause other then dat as you just open SystemSequances table in sql server you will see there is only one dataareaId in all the records.
    You can use dat to generate your RecId and when you will see SystemSequances table then you can easily understand why we are using name as SEQNO.
    Hope this helps.

    Thanks.
  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Re: How can a user generate RECID

    Hey Kiran,

    Thank you so much for this quick response. I am a little confused over the where clause in the query. Does the dataareaid has to be mandatorily 'dat' or would that be company specific. Also I am not quite sure on name = 'SEQNO'. Whenever convenient, can you please throw some lights on these as well just for my better understanding.

    Really appreciate your insights here Kiran. And hey, Happy New Year! Hope you make the best of this new year to bring happiness among loved ones!

    Regards,

    Manish

  • Kiran Vaswani Profile Picture
    Kiran Vaswani 465 on at
    Re: Re: Re: How can a user generate RECID
    Hello Manish, Try this code ..

    ALTER procedure [dbo].[SP_GetAXRecID](@axRecid bigint output)
    as
    begin
    update [Server].Databse.dbo.systemsequences
    set @axRecid = nextVal = nextVal + 1
    from [Server].Databse.dbo.systemsequences where
    dataareaid = 'dat' and name = 'SEQNO'
    end
    I used this code when I tried to insert the data in AX from other sql server database through SP.
    Thanks.
  • Community Member Profile Picture
    Community Member on at
    Re: Re: How can a user generate RECID

    Hey Eric,

    We already have full control on DATAAREAID as its value (always known) can be programmed based on the company that you want to put data in. Our concern is around RECID. How do we generate that. I am hoping that Dynamics AX would have some build in function that generates RECID in appropriate manner. We can just use that in our PL/SQL.

    Any thoughts anyone?

  • Eric Greathouse Profile Picture
    Eric Greathouse 45 on at
    Re: How can a user generate RECID

    I'm guessing you are using AX. One thing that may work is importing into 1 company and then doing an update through SQL to give each account the correct DATAAREAID

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans