How to throw error on click of button even if single SalesQuotationLine has value for Config Id

(0) Share

Report

Posted on by Rahul Dahiya

Hi,

I am working on a task where I need to throw an error even if a single SalesQuotationLine has a value for Config Id field.

So, for this I have write code on Onclicked event of confirm Button & the config Id field is coming from InventDim Datasource of SalesQuotationTable Form.

I need to stop the confirmation status of this Quotation & throw error if line has config Id filled with value, but this code is not working as expected.

[FormControlEventHandler(formControlStr(SalesQuotationTable, ButtonUpdateConfirmation), FormControlEventType::Clicked)]
    public static void ButtonUpdateConfirmation_OnClicked(FormControl sender, FormControlEventArgs e)
    {
        InventDim inventDim = sender.formRun().dataSource(4).cursor();
        SalesQuotationLine salesQuotationLine = sender.formRun().dataSource(2).cursor();

        while select salesQuotationLine join inventDim where inventDim.inventDimId == salesQuotationLine.InventDimId
        {
            if(inventDim.configId)
            {
                throw Error(" Is not a product master");
            }

 

        }



    }

Thanks,

Rahul

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

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

Like (1)

Report

Your code likely runs too late. Business logic doesn't belong on clicked() anyway. Instead, look at the standard code for confirmation and put the logic there. It's likely done through the FormLetter framework.

Putting code at the right place will also resolve the problem of identifying table buffers by hard-coded IDs of form data sources.

There is need for a while loop. You can simply check if there is any line with configId and throw an error if it is.

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

The class called by ButtonUpdateConfirmation is SalesQuotationEditLinesForm.

You'll need to decide when you want to run your validation. Don't forget that posting may include several quotations and that records may be selected from a query when running the posting (in such a case, you don't know the quotations when pressing the button).

Was this reply helpful? Yes No
Rahul Dahiya 70 on at

Like (0)

Report

Hi Martin,

Thanks for this solution.

I tried to write code in button as well, that was actually act too slow & not working as expected.

I write code in validate method of SalesQuotationEditLinesForm class & its working now.

Thanks,

Rahul

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to throw error on click of button even if single SalesQuotationLine has value for Config Id

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to throw error on click of button even if single SalesQuotationLine has value for Config Id

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates