Ax Helper

Month: December 2021

ax sql for department budgeting

  • Ronny
  • 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

ax 2012 – email sent

  • Ronny
  • Dec 06, 2021

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

how to create lookup form on ax 2012

  • Ronny
  • Dec 02, 2021

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

Read More