Notifications
Announcements
No record found.
hi,
i am a dba new to AX, what i want to find is the control table that generate the RECID numbers for tables such as 'PriceDiscount' table,
can anyone advise?
*This post is locked for comments
It's SystemSequences table. But don't expect a simple one by one allocation, AOS takes and caches whole blocks of ID's for performance reasons and application logic can reserve a range of RecId's for its own purposes.
as you say simple its not, 800 records in there !!
how should i approach getting the next id and updating the nextrecid in here?
You shouldn't, you should leave this work to AOS.
Implement your requirement as integration between two applications (e.g. via WCF). AX database - especially kernel tables - is owned by AOS and you shouldn't try to change it directly. You don't have enough control over it.
in my case i want to batch insert a group of product discounts into ax for a specific customer as opposed to a user manually entering
how can i do such a task if i cant use/update the systemSequences table?
There are so many options...
For example, I guess you have your discounts in a file - AX can read the file and creates what's needed (and take advantage from all business logic for defaulting, validations etc.). You can start the process manually (user selects a file) or automatically (AX reads the file from predefined path at specific time or based on any other event).
Or maybe you would prefer to send discounts directly to Price Discount Journal Service.
Or use anything else what goes through AX business logic.
thanks for reply Martin - i am probably more used to less flexible erp systems than AX, where i have been forced to update control tables etc
i must have a play around with it and see what i can manage without using sql!
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
