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

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

• dynamics ax

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

• dynamics ax

if you using aws for your ubuntu vps instance, just do this step1. check your log on /var/log/2. check your linux kernel header if your linux kernel header is too big, just purge itsudo apt-get autoremove and keep your header i did that and freed up until 2.9GB

Read More

• aws
• linux

i need to remove file that contains some string but need to do it on terminal this is how to doitfind . | xargs grep -l email@domain.com | awk ‘{print “rm “$1}’ > doit.shvi doit.sh // check for murphy and his lawsource doit.sh find . | xargs grep -l email@domain.com | awk ‘{print “rm “$1}’ […]

Read More

• computer programming
• freebsd
• linux

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

• dynamics ax

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

• computer programming
• dynamics ax

I have mikrotik router in my place, I have only private ip, so im using noip ddns to set my private ip to my domain the problem is, I cannot access my mikrotik if im using ssh from wan the trick is NAT mikrotik this is the solution Create New NAT Rule chain > dstnat […]

Read More

• mikrotik