Category: dynamics ax

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

• dynamics ax
• sql server

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 More

• dynamics ax

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 More

• dynamics ax

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 More

• dynamics ax

prelude 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 More

• dynamics ax
• ssrs

select NAME from SQLDICTIONARYwhere TABLEID = 505and FIELDID = 0

Read More

• dynamics ax
• sql server

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 More

• c#
• dynamics ax

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

• dynamics ax
• sql server

hi everyone,  this tutorial is how to make a email sender using ax 2012 static void HpJbTestEmail(Args _args) { #SysMailer LanguageId languageId; SMTPRelayServerName relayServer; SMTPPortNumber portNumber; SMTPUserName userName; SMTPPassword password; SysMailer mailer; System.Exception e; SysEmailParameters emailParams = SysEmailParameters::find(); str 200 messageBody; ; relayServer = emailParams.SMTPRelayServerName; portNumber = emailParams.SMTPPortNumber; userName = emailParams.SMTPUserName; password = SysEmailParameters::password(); messageBody […]

Read More

• dynamics ax

how to create lookup form on ax 2012 see my tutorial on youtube video links 

Read More

• dynamics ax