Category: dynamics ax
ax 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 Moreax 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 Morehow to create lookup form on ax 2012
- Dec 02, 2021
how to create lookup form on ax 2012 see my tutorial on youtube video links
Read MoreAxapta crashes, error message: “xPropertySetData::unpack : Property not found : 256” when starting ax client
- Oct 07, 2021
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 Moreax 2012 queries with aggregat
- Sep 21, 2021
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 Morephp 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 Moreprint qr code on ax 2012/2009 report
- Feb 04, 2021
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 Morebelajar 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[ax 2012] address bar on listpage
- Jul 14, 2020
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 Morehow 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