Skip to Content

Documents rows update

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 20, 2015 at 12:14 PM

    Hi,

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


    Untitled.png (15.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2015 at 01:24 PM

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2015 at 01:44 PM

    (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)

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2015 at 01:45 PM

    above is my Query

    Add comment
    10|10000 characters needed characters exceeded

    • 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.