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