FMS Query for User defined Object tax amount

[Former Member]

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

[former_member184146]

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