Hi, I want to write a total function for delivery Qty at after.field. but i have a problem where

Order Delivery Qty Outstanding
--------------------------------------------
1000 100
200

Order is A table data and Delivery Qty is B table data, and Outstanding is Order - Delivery Qty.

Problem is delivery qty is present by total, but order not is total.

how i can write a script so Outstanding = Order - Delivery Qty. and finally get 1000 - 300 = 700.

Thanks. :)

Hi, I want to write a total function for delivery Qty at after.field. but i have a problem where

Order Delivery Qty Outstanding
--------------------------------------------
1000 100
200

Order is A table data and Delivery Qty is B table data, and Outstanding is Order - Delivery Qty.

Problem is delivery qty is present by total, but order not is total.

how i can write a script so Outstanding = Order - Delivery Qty. and finally get 1000 - 300 = 700.

Thanks. :)

Hello,


for example :


before.order:
before.layout:

reset variable order quantity
hold order quantity in variable oquan.orno


detail.x:
after.layout:
sum delivery in detail delivery = delivery + delivery quantity


after.order:
before.layout:
outstanding = oquan.orno - delivery


Regards

thanks guru;)