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

  • 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 see my tutorial on youtube video links 

Read More

Axapta crashes, error message: “xPropertySetData::unpack : Property not found : 256” when starting ax client solution: stop aos, delete kti and auc files, start aos

Read More

Got request from customer to list all item (and variant) with their latest cost price so this is the solution (download the xpo here) you can see we are using aggregate max on activation date,  

Read More

php API on IIS encryption

  • Apr 26, 2021

this is how I do it, connecting to IIS encryption (on android java) on php bridging <?php try{ $input = $_POST[“input”]; //contoh input : NvUlnUqBh1vvDWWoGvELKTwAKv9yKEBSYvfdTXNY2HUhPydLhzLhbBuB0FuBtlcSaTw2hyY2Ln8vmACu02knnxmzzCSaUtKBWwNcdCsAkTk= if($input != “”) { error_reporting(E_ALL); define(‘_HP_WEBSERVICE_URL_’,’http://192.168.50.44/inwcommerce/sirait.asmx?WSDL’); define(‘_HP_WEBSERVICE_NAMESPACE_’,’http://sirait.highpoint/’); $webservice = new SoapClient(_HP_WEBSERVICE_URL_, array(‘soap_version’ => SOAP_1_1, ‘uri’ => _HP_WEBSERVICE_NAMESPACE_)); $request = array(‘Input’ => $input); $action = $webservice->Mobile($request); $result = $action->MobileResult; } else […]

Read More

I will provide the content by screen shoot private void disclaimer() { //created by ronny //20210204 11:08 //and will be published on official websites } public class ReportRun extends ObjectRun { } public Container GenerateQRCode( str param) { FileIOPermission perm; BinData binData; container imageContainer; str 5000 tempFileName2; HpgCsFunction _f = new HpgCsFunction(); System.String netString; Microsoft.Dynamics.QRCode.Encoder […]

Read More

belajar golang di linux

  • Sep 07, 2020

(bahasa indonesia) point point penting dalam belajar golang instalasi golang siapkan enviroment sistemnya, saya menggunakan ubuntu LTS 18.04 download file berikut ini: wget https://golang.org/dl/go1.15.1.linux-amd64.tar.gz extract file tersebut : sudo tar -C /usr/local -xzf go1.15.1.linux-amd64.tar.gz edit /etc/profile : sudo nano /etc/profile tambahkan source ini ke baris paling akhir : export PATH=$PATH:/usr/local/go/bin untuk mengetes apakah sudah berhasil […]

Read More

this is how I put address bar on listpage, I just creating a new menu form and intend it to show it on address bar, but something happens it happens because you need to set IsDisplayedInContentArea for Yes now, close and open AX, 

Read More

how to make batch job

  • Jul 09, 2020

this is how to make batch job on ax 2012 this image below is self explanatory create a class Class Name : HpCsBtUpdate.processRecords See the pict above [SysEntryPointAttribute(false)] Info(“xxx”) will be as Log Batch create a menu action Object Type : Class Object : SysOperation Parameters : HpCsBtUpdate.processRecords Execute the menu action

Read More