on 10-20-2015 12:59 PM
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
above is my Query
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
(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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
that is exactly what i did. But anytime my document total changes, my existing discount value does not change all discount fields automatically.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
9 | |
8 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.