Category: sql server
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 Morelist ax 2012 table in sql server
- Jun 14, 2022
select NAME from SQLDICTIONARYwhere TABLEID = 505and FIELDID = 0
Read Moreax sql for department budgeting
- Dec 10, 2021
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 MoreScenario 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 Morein 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 Morewhile 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 Moretutorial – 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 Moredevelopment server cannot run workflow
- Dec 12, 2017
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 MoreHi 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 Moreserver 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