Calculating the Net Amount on Sales Order Line using a custom formula
I have to calculate the Net Amount on Sales Order Line by adding the number of months for which the item will be sold on that price. For this purpose, I have created extension of the form SalesTable and used the event handler OnValidating for the Data Field ‘Line Amount’.
Following is the code I have written:
D365FO x++ Present Value function like PV function in excel
I need to calculate present value of given value and interest rate. In excel there is a function PV(), the same result I have to calculate using x++. Please suggest the solution, I have tried to find the function but in vain.
How to perform MAX date in data entity
I am attempting to create a data entity with the SysUserLog table to export the latest login date for a user (createdDateTime field). I am unsure how to perform the MAX date with a data entity to represent the following SQL query: