I have a problem. I am getting the following error in the status bar:
FRM-40735:WHEN-VALIDATE-ITEM trigger raised unhandled exception VALUE_ERROR.
The problem situation is like this. I have a order entry form in which i will be entering the orders. For each order, i should enter the diff items that needs to be ordered along with its item details. How much Qty, item name, date etc.
This item price details of how much each item costs are stored in a different form. In the order entry form, in the items form we have QTY and UOM which are database items. Along with this, we have created two non-database of QTY and UOM for a different distribution to enter the details over there.
While entering the item details, when i enter the QTY to some number and try to proceed to next item, It doesnt move from that item and stops there and displays the above error in the status bar down the form. I cant move forward or backward.
In the item price details form, if the item has only one line, then it works fine. but if the same item has two lines, then this problem is occuring. For ex:- We closed one item and opened the same item with a diff price on a diff start active date. we closed the item by giving end active date and started the same item by giving a date greater than the end active date.
If the item is opened once with start active date and not ended, then it works fine. But only for the case above, its giving the problem.
Help Appreciated from you form gurus....