Showing posts with label ax administration. Show all posts
Showing posts with label ax administration. Show all posts

Monday, November 27, 2017

Thursday, November 23, 2017

AX - How get list of active AX users

select a.id, a.name, substring( a.networkdomain, 1, 25 ) as networkdomain,
substring( a.networkalias, 1, 25 ) as networkalias
from [dbinst].[dbo].userinfo a
where
a.enable = 1
order by a.id

AX - How set number sequence generation to manual

When you don`t want automatically generate number sequence, you can set it to manual (= manual inserting).
  • In area setup part select preferences dialog and find number sequence. Click View details for it.
  • In sequence set generation type to Manual.