Skip to main content

Posts

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
Recent posts

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

File Attachment option missing for new form in EP in AX 2012

 Problem: Hi All, I have created a new form in EP in AX 2012 and added attachments button on Action Pane on EP form. But the Attachments button is disabled. I am not able to attach any documents. Does anyone know if I have to do something else apart from just adding the attachments web menu item in the action pan? Hints:  refer sales order form in EP which has attachments button.There are some standard ep forms which have the attachment functionality. Try to refere that and set the similar properties. Record should be selected to enable this. Please comment to solve this issue.

How to create workers in approved state through DIXF in D365?

How to create workers in approved state through DIXF in D365? Actually it is creating records in Inactive workers. Any help would be appreciated. Hints: Any workflow is created to approve worker record creation?? if not; then you can simply use "Employee" data entity. Mention the employment start date for each employee and upload. It will update the record in both Workers and Employee forms.

Automated Bank Reconciliation in Dynamics 365 Finance and Operations

 How to Automated Bank Reconciliation in Dynamics 365 Finance and Operations ? Tips: Set the advanced bank reco tab enabled for the bank, set the parameters for this, set the recon matching rules, import MT940 and system will do the reconciliation. for MT940, you may have to ask the users to contact in the bank to get the MT940 format. users may have to apply for this in bank to get this on monthly or weekly basis (whatever).