Skip to Content
Former Member
Nov 14, 2014 at 07:36 AM

I need a small query.



Plz have a look on below image.

i am having some tax types.

in below figure i Selected Test

in Test it is having some tax types.

what i need is..

i need to capture vat rate.

in below figure

vat rate is 4 ....

i want to run the query base on Tax code like

Select Rate from table where taxcdoe = 'Test'

how can i get the

other wise

plz have a look on second image. vat1

i need capture vat4 amount 16

Actually i need fms at row level at udf

when ever i select the tax code in tax code vat amount should be copied to the udf value

each tax contains only one vat either 4 or 5 or 6 that amount should come into udf

can i get the value..

I need your valuable suggestions..


vat1.png (181.3 kB)
VAT.png (181.6 kB)