09 November 2010

Validate The salesLine unit price should not less than the item cost price

SalesTable(form)->DS->SalesLine->salePrice(Field)->Validate()

public boolean validate()
{
boolean ret;

ret = super();
ret = element.validate_price();

return ret;
}
--
SalesTable(form)->Methods->

public boolean validate_price()
{
boolean ret = true;
InventTableModule inventTableModule;

;
//in this line we are using our own find method, or we can use select query.
//inventTableModule = InventTableModule::find_price(SalesLine.ItemId);
select firstonly inventTableModule where inventTableModule.ItemId == SalesLine.ItemId;

if(inventTableModule.Price > SalesLine.SalesPrice)
{
ret = false;
info("the cost price is grater then the sales price ");
}

return ret;
}

No comments:

Post a Comment

Give me the commetns and solutions

How to add the Display method in the form level in D365 F&O

 The below examle is to add the form -Data source level adding display method and assigning to form design control.