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 Moreax 2012 custom form sales order information
- Jun 12, 2023
if sales order has been submitted, you cannot added more information on sales line/sales order this is we make the custom form, added status on that sales order lnes download it here important notation source: public void close() { FormDataSource ds; ; super(); ds = element.args().record().dataSource(); ds.research(true); ds.refresh(); //auto refresh to form caller } public […]
Read MoreYou are entering emergency mode (debian/ubuntu)
- Jan 26, 2023
Sometimes if you experience this error
Read Moreaws ec2 ubuntu vpn client access to mikrotik
- Nov 15, 2022
aws ec2 ubuntu vpn client access to mikrotik ok, ill be quick on ec2 1. make sure your ecc has a security group allowed to be access to your ippublic 2. install pptpd 3. see these below script: pty “pptp your-vpn-server-ip –nolaunchpppd –debug” name username-on-vpn password password-on-vpn remotename PPTP require-mppe-128 require-mschap-v2 refuse-eap refuse-pap refuse-chap refuse-mschap […]
Read Moreax 2012 custom – upload purch line
- Oct 18, 2022
berikut ini adalah content mengenai upload purchline, melakukan customisasi di ax 2012 saya upload source code nya di sini HpCsUploadPurchLine class HpCsUploadPurchLine { } private void UploadPurchLine(PurchTable _header) { //standard variable int _cnt, i, TType; int64 _total; str 100 _texttmp; Filename _filename; Filename filepath; Filename filename; Filename fileType; str fileNameString,fileNamePath; DialogField dialogFileName; Dialog dialog; str […]
Read Moreprelude I need customized budget modules In My IT Department, so i Make a simple budget IT modules this is how to do it first you need to create the project, lets call it RfPjBudget lets break down the structure before going to deep code Group SSRS list of SSRS report that we will going […]
Read MoreSetting untuk Windows 10 Home Edition Bagi anda yang menggunakan Windows 10 Home edition, ada setting tambahan yang perlu dilakukan. Berikut langkah-langkahnya : Tekan Win+Q untuk membuka Taskbar Search.Ketik regedit di area teks kosong dan tekan tombol Enter. Klik Ya saat UAC meminta izin.Saat Anda mengakses Registry Editor, silahkan anda masuk ke path berikut;HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\SystemSetelah berada […]
Read Morelist ax 2012 table in sql server
- Jun 14, 2022
select NAME from SQLDICTIONARYwhere TABLEID = 505and FIELDID = 0
Read Morec# business layer
- Feb 04, 2022
in ax, we do have business layer call onion layer, the purpose is to separate the business layer for customization on users the concept is, layer sys will be overridden by layer gls on so on until layer usr all table and all function that customized will be replaced on those layer now, we make […]
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 More