berikut ini adalah content mengenai upload purchline, melakukan customisasi di ax 2012 saya upload source code nya di sini HpCsUploadPurchLine class HpCsUploadPurchLine { } private void UploadPurchLine(PurchTable _header) { //standard variable int _cnt, i, TType; int64 _total; str 100 _texttmp; Filename _filename; Filename filepath; Filename filename; Filename fileType; str fileNameString,fileNamePath; DialogField dialogFileName; Dialog dialog; str […]

Read More

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

select NAME from SQLDICTIONARYwhere TABLEID = 505and FIELDID = 0

Read More

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