c# business layer

  • Feb 04, 2022

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

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