How to select multiple checkbox on form grid line data source in D365FO

(0) Share

Report

Posted on by Rahul.p

632

Dear Friends,

My requirement is if user will select multiple check box form line data source and he click on 'Create invoice proposal' button then some error will come and user unable to create 'project invoice proposal'.

Back end Form name is 'PSARetentionRelease'

Thanks & Regards

Rahul.

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

you may want to explore framework events on data source and selection control

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Can you provide more info about your error ? What error you are getting ?

Was this reply helpful? Yes No
Rahul.p 632 on at

Like (0)

Report

My requirement is if user will select one line from line data source and click on 'Create invoice proposal' button then he can able to create invoice proposal and no error will come, it is working fine.

But if user will select multiple line from line data source and click on 'Create invoice proposal' button then some error should come (Exp: Multiple line can not be select) and user unable to create invoice proposal.

Was this reply helpful? Yes No
Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

How are the checkboxes implemented? If it's a standard form, tell us its name and we can review the implementation by yourselves.

Was this reply helpful? Yes No
Rahul.p 632 on at

Like (0)

Report

Yes it is standard form
Front End info:
Project management and accounting ->Projects ->All projects

Back end info:

Form name: PSARetentionRelease

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report
You're just one step from finding the answer to my question. Open properties of the form control and you'll see it's bound to the Selected field of PSATmpRetentionReleaseTable data source. In the case of lines, it's the Selected field of PSATmpRetentionReleaseLine data source.

Therefore when you want to validate the data, you'll simply write queries against the data in temporary tables.

For example, if you want to know how many lines are selected, you can do this:

select count(RecId) from psaTmpRetentionReleaseLine where psaTmpRetentionReleaseLine.Selected;

Was this reply helpful? Yes No
Rahul.p 632 on at

Like (0)

Report

Dear Martin,

Thank you for your kind support.

Please tell me where and in which method i can write the above logic.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

Hmm, all right, let me do a few more steps for you.

You said you want to do it when pressing the button, therefore your next step is finding out what the button does. Find the button (CreateInvoiceProposal) and look at its type. I could be a menu item button and then you would check which object does the menu item point to. But in this case, is just a regular button and therefore expand its methods and open clicked method.

You'll see it calling psaRetenetionRelease object, therefore your logic should go there.

Open the class (PSARetenetionRelease) and explore its implementation. You may notice that it extends ProjInvoiceChoose, which has validate() method and that sounds like the right place for validations.

validate() is actually a framework method - ProjInvoiceChoose extends RunBaseBatch and validate() is a method of the RunBase framework.

This is the kind of things you must do when finding the right place for your logic.

Was this reply helpful? Yes No