Query for UDF

[Former Member]

Hi All

I need some help here , One of our clients doesnot report on vat or can't not claim , but the vendors they deal with some are vat vendors and do claim so it need to be shown on the marketing docs.

So what we've done is on the client side we used a UDF to display the vat amount per line.

So i need a query that will perform task like this.

Scenario.

Supplier is vat vendor then client selects a UDF with YES or No ( Defaults to No) , then based on the selection the Tax Amount UDF must be updated automatically by the query running in the back ground.

something more like this :- if vat udf = 1 ( Yes) then price x 0.14 --- tax amount

then the total must be be combination off the two fields price plus tax amount.

Hope it makes sense.

Bongani

[Former Member]

Hi Bongani,

It is better if you can use tax code to deal with this problem. The line total calculation is hard coded by system. If you try to add your calculation to it, you may voliate the support agreement with SAP.

UDF is used to facilate grouping, categorying or something similar. Or if you want some numbers in parall to system value, you can hold them in UDF.

Thanks,

Gordon

[Former Member]

Hi

Please check this thread .This might be of help

Thank you

BIshal