Sorry, another question.
I have a validation rule on a 'StockQty' field, that limits its value to >=0 (meaning there cannot be a negative stock value)
When i try and run my linitation test query to make the stock quantity go into a negative value, successfully the error messgae popped up to say that due to validation rules it cannot be updated.
My main concern here is for the user. I only know why the error is being flagged and what it directly means. I fear it will not be as easy to ID the problem if multiple updating is occuring through out his/her working day.
Is there a way i make make these warnings more meaningful to the actual task being performed? i.e the warning would state 'would take stock to a negative number' when run through a query.
Obviously if a negative value is typed directly into the QtyStock field within the PO, the standard Validation message whould appear, but not when running an update query?
Thanks
I have a validation rule on a 'StockQty' field, that limits its value to >=0 (meaning there cannot be a negative stock value)
When i try and run my linitation test query to make the stock quantity go into a negative value, successfully the error messgae popped up to say that due to validation rules it cannot be updated.
My main concern here is for the user. I only know why the error is being flagged and what it directly means. I fear it will not be as easy to ID the problem if multiple updating is occuring through out his/her working day.
Is there a way i make make these warnings more meaningful to the actual task being performed? i.e the warning would state 'would take stock to a negative number' when run through a query.
Obviously if a negative value is typed directly into the QtyStock field within the PO, the standard Validation message whould appear, but not when running an update query?
Thanks
