1 2 3 Previous Next 30 Replies Latest reply on Dec 23, 2015 8:37 AM by okramis

    Help with Execute SQL Query ...   Tax Calculation based on payments within fiscal year

    binu.alexander

      Screen Shot 2015-12-21 at 3.35.14 PM.png

       

      I am trying to Calculate Tax Deduction (TDS)  in the Invoices Table.  The Table Schema is shown above .

       

      In Case a single Transaction ( TotalTransaction is > 30000 )   a OneTime_TDS of  1% is  calculated  ( CALC SHOWN ABOVE )

       

      In Case Sum of all    NetAmount Paid  ( in Current Fiscal Year i.e 1 April to 31 March   ) for a single Translator ( fk_Translator_ID )  is > 75000        Annual TDS of 1% needs to be calculated     (  CALC ATTEMPTED  ABOVE for Field Marked RED )

       

      I think it can be done using ExecuteSQL   or maybe even natively  ....      I am not able to figure it out ...   I tried unsuccesfuly

       

      Please give suggestions ... Thanks

        1 2 3 Previous Next