Finance | Project Operations, Human Resources, ...

Form Validation

(0) Share

Report

Posted on by Community Member

I just want a simple validation code....

this is my form A named -> ProjInvoiceTable

In this billing rules lines it is showing contract value field , on this field i have to put validation.. (Contract Value Field is coming from PsaContractLineItems-> LineValue)

It is also showing the field Contract value with the sum of all lines of Milestones ..

It is the form ProjFundingSourceDetail and the PO lines is my Customized Tab..

now the thing I want is the sum of this BaseAmount(Coming from table FXProjFundingPOLines) field in POLines Tab must not be greater than the LineValue field of PsaContractLineItems ..

In both tables i.e PsaContractLineItems and FXProjFundingPOLines, common reference is ContractId....

this validation i had to put ...

I have the same question (0)

All responses (9)

Answers (0)

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

What challenges you are facing ? You know the relationship then its just the matter of pulling value and doing comparison ? Write it in the modified field event of the table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello sir ,

I was writing it on the validate field post handler , but its was not working ..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

..

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi UDIT,

You could follow Sukrut's suggestion and write your code in the modified event handler.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Obed Miranda Picado on at

Like (0)

Report

Hi. Can you give it a quick look to this docu https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/validations-defaults-unmapped-fields

Validations can be defined on the tables that back up entities, at both the field level and the record level. Validations can also be defined at the data entity level.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I dont want it at data entities , I want to perform validation at table or form level ..

Was this reply helpful? Yes No
Obed Miranda Picado on at

Like (0)

Report

Hello,

Please check the documentation provided again on https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/validations-defaults-unmapped-fields#validations You would want to use the validateWrite method to do the validation at the table level.

There is also a validateWrite method on the FormDataSource object which you could leverage if you want to validate at the form level https://docs.microsoft.com/en-us/dynamicsax-2012/developer/methods-on-a-form-data-source

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

[FormDataSourceEventHandler(formDataSourceStr(ProjInvoiceTable, PSAContractLineItems), FormDataSourceEventType::ValidatedWrite)]

public static void PSAContractLineItems_OnValidatedWrite(FormDataSource sender, FormDataSourceEventArgs e)

{

FormRun formRun = sender.formRun();

FormDataSource formDataSource =

formRun.dataSource(formDataSourceStr(ProjInvoiceTable,PSAContractLineItems ));

PSAContractLineItems psaContractLineItems,psaContractLineItems1 = formDataSource.cursor();

FXProjFundingSourcePOLines fxProjFundingPOLines ;

real a, b;

if(fieldNum(PSAContractLineItems, LineValue))

{

select sum(BaseAmount) from FXProjFundingPOLines

where fXProjFundingPOLines.ContractId == psaContractLineItems1.ProjInvoiceProjId;

a = fxProjFundingPOLines.BaseAmount;

select sum(LineValue) from psaContractLineItems

where psaContractLineItems.ProjInvoiceProjId == psaContractLineItems1.ProjInvoiceProjId;

b = psaContractLineItems.LineValue;

if(b > a)

{

checkFailed("Wrong");

}

}

This is my code suggest me the right code please

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

[FormDataSourceEventHandler(formDataSourceStr(ProjInvoiceTable, PSAContractLineItems), FormDataSourceEventType::ValidatedWrite)]

public static void PSAContractLineItems_OnValidatedWrite(FormDataSource sender, FormDataSourceEventArgs e)

{

FormRun formRun = sender.formRun();

FormDataSource formDataSource =

formRun.dataSource(formDataSourceStr(ProjInvoiceTable,PSAContractLineItems ));

PSAContractLineItems psaContractLineItems,psaContractLineItems1 = formDataSource.cursor();

AcxProjFundingSourcePOLines acxFundingPOLines ;

real a, b;

if(fieldNum(PSAContractLineItems, LineValue))

{

select sum(BaseAmount) from FXProjFundingPOLines

where FXProjFundingPOLines.ContractId == psaContractLineItems1.ProjInvoiceProjId;

a = acxFundingPOLines.BaseAmount;

select sum(LineValue) from psaContractLineItems

where psaContractLineItems.ProjInvoiceProjId == psaContractLineItems1.ProjInvoiceProjId;

b = psaContractLineItems.LineValue;

if(b > a)

{

checkFailed("Wrong");

}

}

This is my code suggest me the right code please

Was this reply helpful? Yes No