Category: dynamics ax

prelude I need customized budget modules In My IT Department, so i Make a simple budget IT modules this is how to do it first you need to create the project, lets call it RfPjBudget lets break down the structure before going to deep code Group SSRS list of SSRS report that we will going […]

Read More

• dynamics ax
• ssrs

select NAME from SQLDICTIONARYwhere TABLEID = 505and FIELDID = 0

Read More

• dynamics ax
• sql server

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

• c#
• dynamics ax

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

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