Skip to main content

Posts

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 are speci

Sales and Marketing History log table SmmTranslog in Axapta

 Dear Friends, DO you know that Sales and Marketing History log table SmmTranslog .  You Can get on below steps. Once its enabled then Sales order related log record you can check in smmtranslag table. I hope this will help you . Click  Sales and marketing  >  Setup  >  Sales and marketing parameters . On the  Transaction log  tab, in the  Track changes for  section, select the tables that you want to include in the transaction log.

Axapta Error Total of the transactions in the year is not 0.00. Total is 0.70.

 Getting this error message at the time of closing fiscal year close - openings transactions  Total of the transactions in the year is not 0.00. Total is 0.70. This is a serious error. Run \"Check\" on ledger transactions. Give your suggestion to solve this. This link can help you. https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/267481/total-of-the-transactions-in-the-year-is-not-0-00-total-is--0-03-end-year-closing-process

Error Item Requirement cannot be created for a project contract with multiple funding sources

 While clicking the project item requirement the following error showing, "Item Requirement cannot be created for a project contract with multiple funding sources"   And I tried to delete one funding source in contracts and it showing, "Transactions that are associated with this funding source have already been posted. This funding source cannot be removed."   there is no transaction for this customer before, still showing this error Please give your suggestion to solve this. Some suggestion given to this link https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/368155/project-contract-with-multiple-funding-sources-prevents-opening-the-item-requirement-table---workaround