Stop sales trasaction at the point of 'confirmation' if the contribution ration or margin is less than a stated ammount

Above subject refers - I used [abbas replied on 2013-2-8 7:38] resolution to try to achieve - stop error on CONFIRMATION if the contribution ratio of that sale is less than 3%

My issue is that the figure entered for the percentage does not affect the contribution ratio data - only negative value affects the throw error.

How can I find the contributionRation field in the sales order form from sql database?

Any pointer to perform this task will be highly appreciated!!!

Mezie


void clicked()

{

//CustConfirmJour _custconfirmjour;

ContributionRatio _ContributionRatio;

;

Select SalesId from _custconfirmjour where _custconfirmjour.SalesId == salesTable.SalesId;

If (_ContributionRatio <= 1)

{

throw error(strfmt(‘STOP ERROR - AT LOSS TRANSACTION - REQUIRES MGT APPROVAL TO PROCEED!!’));

}

else

{

super();

}

}