Skip to main content

Posts

Showing posts from August, 2021

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.