Hi,
I have a field in the Parts Table that stores quantity of items on order. This field is updated by the application when user posts purchase orders and then the qty is reduced when qty is received. But I get, quite of few times, that the value in the field does not match the actual on-order quantity. Probably somewhere the code is missing to make correct updates.
Do you think it would be better to calculate this value "on-the-fly" instead of relying on the program updating it?
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham