RE - Creating new record

Finance and Operations/AX Developer Forum
1

Hi Everyone,

I have a customized table,

Last calibration date Frequency Next calibration date Actual date Remarks

In this initially user will create a record, Next time if the user clicks new means v need to capture the Actual date field to be in Last calibration date and frequency also. This should happen every time while creating a new record.

Help me to solve this.

Regards,

Madhan

2

Hi Madhan,

Are you want to enter Last record value of Actual Date to new record in Last calibration date and frequency??

3

Hi Raj,

s… ur right…Everytime if i create new record means it should happen.

Regards,

Madhan

4

hi ,

u should get the last record value in the init value method of the datasource…

if u want to get the last record value u can see the last packingslipid in purchtable or salestable

thanks,

srikanth.

5

Then you OnInit() trigger of table u can write the code to get the last record using findlast and update the Last caliberation date with the last record’s active date.

Cheers,

[:)]

6

Hi Srikanth,

Can u help me in writing the code?

Regards,

Madhan

7

You need to find the last record with maximum recId and initiate the field values from the selected record, the logic need to be used in create method of form dataSource.

Example:

YourTable yourTableLocal;

select firstonly yourTableLocal order by RecId desc;

yourTable.Frequency = yourTableLocal.Frequency;

8

Thankz Kranthi… It is working fine