Skip to Content
0
Former Member
Jan 13, 2011 at 07:10 AM

UDF & TAX

47 Views

Hi Experts,

In my A/P Invoice I want to have UFDs where FMS will be attached to show the Tax amount in Title level. Like

U_BED will show BED tax amount

U_CESS will show Cess tax amount

U_Hcess will show Hcess tax amount

U_Vat will show Vat tax amount

U_CST will show CST tax amount

etc etc...

SELECT T1.[TaxSum] FROM OPCH T0 INNER JOIN PCH4 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[staType] = ' -90' and T0.[CardCode] ='V101631'

this query gives more than one value for BED tax amount.

Thanks in Advance