Skip to main content

Posts

How to get , Mark and Marked records in Axapta(Ax 2012 and D365 FnO)

  Mark all records: public void selectall(boolean _select) { CustTable     localCustTable; localCustTable = this.getFirst(); while(localCustTable) { this.findRecord(localCustTable); this.mark(_select); localCustTable = this.getNext(); } } Read marked records: CustTable     localCustTable; localCustTable = this.getFirst(1); //get marked while(localCustTable) { //do something localCustTable = this.getNext() }   OR: for(localCoInfo = CustTable_ds.getFirst(1);localCoInfo;localCoInfo = CustTable_ds.getNext()) { //do something }

Refresh Data, Dictionary, Element by code in Axapta

  // Reset data CG_RefreshAll::reset(); CG_RefreshAll::doDictionaryFlush(); SysEvent::fireEvent(SysEventType::FlushDictionary); if (args && args.parmEnum() == NoYes::No) info("@SYS68566"); // Data flush CG_RefreshAll::doDataFlush(); SysEvent::fireEvent(SysEventType::FlushData); if (args && args.parmEnum() == NoYes::No) info("@SYS98783"); // AOD Flush CG_RefreshAll::doAODFlush(); CG_RefreshAll::clearManagedCaches(); CG_RefreshAll::clearGlobalObjectCaches(); SysEvent::fireEvent(SysEventType::FlushAOD); SysExtensionCache::clearAllScopes(); CG_RefreshAll::clearGlobalCaches(); if (args && args.parmEnum() == NoYes::No) { info("@SYS68564"); }

Date Time Formatting On SSRS Report using D365FnO

 

LOG Tables and MRP Log temporary Tables in Axapta

 Batch job log tables .. BATCHHISTORY BATCHJOBHISTORY BATCHCONSTRAINTSHISTORY BATCHJOBALERTS MRP temporary tables  ReqTrans reqTransCov reqPo reqLog REQPROCESSITEM REQPROCESSLIST REQPROCESSTHREADLIST REQPROCESSTRANSFILTER reqRoute INVENTSUMLOGTTS Reqcalctask Reqcalctasksbundle Requnscheduledorders Reqcalctasktrace Reqprocesslist Reqprocessthreadlist reqprocesstransfilter

X++ Code to create Customer Delivery Address in Axapta

  This is X++ Code to create Customer Delivery Address in Axapta , This code can help you for Ax 2012 and D365 FnO also.   LogisticsPostalAddress address; custtable = Custtable::find("1223"); address.Street = “abc”; address.ZipCode = “334223”; address.City = “xt”; addressView.Party = CustTable.Party; addressview.initFromPostalAddress(address); DirParty = DirParty::constructFromPartyRecId(CustTable.Party); roles = [LogisticsLocationRole::findBytype(LogisticsLocationRoleType::Delivery).RecId]; DirParty.createOrUpdatePostalAddress(addressView,roles);

Ax 2012 Market support will be expired by Microsoft soon & D365fo is future

 Dear Friends, Ax 2012 Market  support will be expired by Microsoft soon like Jan 2023 so if you are late then start learning Microsoft dynamics 365 Finance and operation part . If you are technical then its not very easy to learn like AX 2012 because standard object you can not modify so it will be new learning but base logic will be same. I want to suggest How to learn d365fo easily. Join or subscribe D365 fo Related channels on YouTube . Check tools in LCS (Life cycle services) Learn about Azure subscription. Power Dev Aps learning Visual studio knowledge must SQL Server latest version  Power BI  Finds groups in Facebook and join big members group. Rest suggestion will share in next post thanks.

Function to use in AOT Queries in Ax 2012

 The following functions can be used in any query. Note that the functions are case sensitive and need to be put in brackets. currentUserId() currentEmployeeId() currentBusinessRelationsAccount() currentContactPersonId() currentCustomerAccount() currentVendorAccount() -------------------------------------------------------------------------------------------------------------------- Date (x and y in the below functions denote integer value for the parameter)   day(int relativeDays = x) dayRange(int relativeDaysFrom = x, int relativeDaysTo = y) greaterThanDate(int relativeDays = x) lessThanDate(int relativeDays = x) monthRange(int relativeMonthsFrom = x, int relativeMonthsTo = x) yearRange(int relativeYearsFrom = x, int relativeYearsTo = y) Range of date dateRange(date startDate, date endDate) currentSessionDate() currentSessionDateTime() ------------------------------------------------------------------------------------------------------------------ The below given functions ...