Category: sql server
transaction marking
- Jul 15, 2025
Terkadang pada payment journal, ketika melakukan settlement, ada transaction marking yang lupa di lepas, dan kesulitannya, pada ax 2012 mencari transaction marking tsb harus di cari satu persatu jurnal yang melakukan marking tersebut. berikut ini adalah cara mencari transaction marking di mana, dengan sedikit custom dan tricks berikut ini flow nya: user membuka payment journal, […]
Read Moreuser – 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 More