Updata table field

fmhigue

I got a custom table

Table fields:

Reserved Quantity - Decimal
Qty on Sales Order - Flow Field from Sales Line


Reserved Quantity Availabe:= Normal field.
I need this one to get update on the fly. Whenever Qty on Sales Order changes.

Any ideas how to do it?

Savatage

sounds like some code on the validate of the sales line qty field needs to happen

How does Reserved Qty get origianlly populated? Is it entered in that custom table. When the sales line qty changes what do you want to have happen (update to what)?

fmhigue

Reserved Qty is enter manually on a form. It is basically part of the setup for the reserved.

When Sales Line changes I want to update Reserved Quantity Available.

What if I add a Function on the Reserve Items by Customer table. Then I call it from Sales Line.Quantity.

garak

in your scenario its a way to modify your custom field from the sales line (quantity)

garak

a other question: do you need this field "Reserved Quantity Availabe" as field in the table or is it possible to show the result only on form.
because the "Reserved Quantity Availabe" is a sum of you calcfield and, i think, your manuell field "Reserved Quantity". So you can also put a textcontrol on form with the calcformula you needed.

regards

fmhigue

Do you have anyt other idea to do it?