Skip to Content
avatar image
Former Member

FMS Query for User defined Object tax amount

Dear All,

Please find the attached pic  for the fms query i am looking for .

The tax amount column should be calculated based on Rate,Total amount and selected tax code.Can i come to know what method should be used to get the total amount.

Thanks&Regards

Darshan Desai

PIC1.PNG (30.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 05, 2015 at 10:42 AM

    Hi ,

         For tax Amount FMS , you need to use conditional Query based on your Tax Code.

    for example:

                        select case when taxcode=vat5 then "your formula based on tax code "

    when taxcode=BED then  "your formula based on tax code "

    from your table

    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded