user – roles – entity

  • Oct 13, 2023

how to get list of user access with roles and entity access? select b.ENABLE, b.id, b.NETWORKALIAS, c.AOTNAME, e.DATAAREA from SECURITYUSERROLE a inner join USERINFO b on a.USER_=b.ID inner join SECURITYROLE c on c.RECID=a.SECURITYROLE left join OMUSERROLEORGANIZATION d on d.SECURITYROLE=a.SECURITYROLE and d.USER_=b.ID left join COMPANYINFO e on e.RECID=d.OMINTERNALORGANIZATION where 1=1 and b.ENABLE=1 and a.ASSIGNMENTSTATUS=1 this query […]

Read More

select NAME from SQLDICTIONARYwhere TABLEID = 505and FIELDID = 0

Read More

for notes only this is sql for annual department budgeting: select pt.PURCHID, pt.PURCHNAME, pt.ORDERACCOUNT, pt.INVOICEACCOUNT, pt.DELIVERYDATE, pt.CREATEDDATETIME, pt.PURCHSTATUS, /* 3. invoiced */ pt.DATAAREAID, /* pt.SOURCEDOCUMENTHEADER, pt.SOURCEDOCUMENTLINE, */ pl.ITEMID, pl.QTYORDERED, pl.PURCHPRICE, /* pl.QTYORDERED * pl.PURCHPRICE as Total, */ pl.LINEAMOUNT, pl.PURCHUNIT, pl.ASSETID, PL.PURCHREQID, /* PL.PURCHREQLINEREFID, */ PRT.PURCHREQNAME, PRT.SUBMITTEDBY, PRL.NAME from PURCHTABLE pt inner join PURCHLINE pl on […]

Read More

Scenario user can Access to ALL MTL warehouse user can Access to ALL TJP warehouse exclude to “Finished Goods Warehouse TJP” warehouse MTL, TJP is Entity I put the XPO on the end of this article How to do it manually Goto Dynamics Ax, and Open AOT we will need, 1 Security Policy, 2 Tables, […]

Read More

in ax, we use table to transaction, and log transactions, and temporary table for report and printing sometimes the table is very big (contains alot of unused record), this is why we do need to check the database (specially the log table), so we can delete the record and reindex it SELECT t.NAME AS TableName, […]

Read More

while you tried to first time install ax, you must do the step by step and when you got into database synchronize there was an error ax 2012 error : text synchronize database specified field modelid of datasource projparameters does not exists in the database or the configuration key on the field solution: turn on […]

Read More

tutorial – how to create a printing form using SSRS to make a printing form using SSRS, we need 1 temporary tables, 1 SSRS Report, 1 controller class, 1 contract class and 1 DP (data provider) class. And also we gonna need menu items, and jobs (for testing data, incase we need it), and Modified […]

Read More

there are a few things that you must check while you restore the live database to development server, if you wants to activate your work flow check the batch server, make sure that the batch server links to development server Watch the check box “is batch server”, look at “maximum batch threads start time and […]

Read More

Hi Guys, case is, I have visual studio 2013 ultimate for deploying and modifying AX SSRS report, suddenly i have an error while I was deploying the reports   the error is: Error 1 An error occurred : Access is denied.Error 1 An error occurred : Access is denied. If User Account Control (UAC) is […]

Read More

server hardware for ax

  • Mar 08, 2017

this is my list server for AX as physical Server 2 Dell PowerEdge R715, @ 24Cores of Processor, 128RAM, 6x600GB SAS 15K (RAID 5), windows 2008 R2 Datacenter (64bit); as virtual machine Host (using HyperV); 6U; (recomended 3 R715, because we need more time to buy, if other server was down) 1 Dell PowerVault md3600i, […]

Read More