Documents rows update

[millicentdark]

Hi Experts,

i have created a user query and i am using it to update my document row discount values when the doctotal value changes.

My problem is when  the document number changes i have to go into the discount fields in the row and click in for the value to change. I dont want it that way.

I want a way that when my doctotal changes anytime the discount row values will change automatically. if my row values are total are 10 immediately my doctotal changes it should update all 10 rows discount column with the discount values.

Urgent help will be appreciated

Regards

Justice

[millicentdark]

above is my Query

[Former Member]

Hi,

For the above query i'm getting correctly as per your requirement. If the document total changes then all the discount % in rows are updated automatically according to the FMS.

[millicentdark]

(SELECT

       CASE

  WHEN $[$29.0.number] >= 500000  THEN 2

WHEN $[$33.0.number]>= 350000 AND $[$33.0.number] <= 499000 THEN 1.75

WHEN $[$29.0.number] >= 200000 AND $[$29.0.number] <= 349000 THEN 1.5

WHEN $[$29.0.number] >= 100000 AND $[$29.0.number] <= 199000 THEN 1

WHEN $[$29.0.number] >= 50000 AND $[$29.0.number] <= 99000 THEN 0.50

  ELSE  0

END)

[millicentdark]

Hi,

that is exactly what i did. But anytime my document total changes, my existing discount value does not change all discount fields automatically.

[Former Member]

Post your query here

[Former Member]

Hi,

Use refresh regularly option and select Document total in drop down list as per the attachment