Sunday, 27 March 2011

To Calculate TDS while Invoicing Purchase Order

One of our customer needed How much TDS is Deducted to be shown on Invoicing screen as once TDS posted cant be reversed .

Hence the solution is -


Public void calcWithholdTaxes(ParmId  ParmId)
{
    PurchTotals                     purchTotals_1;
    Purchtable                      _purchtable;
    purchline                       _purchline;
    amountcur                       withholdtax;
    int                                      i;
    purchparmtable               parmtable;
    ;




    select PurchId from parmtable where parmtable.ParmId == ParmId;
    select * from  _purchTable where _purchTable.PurchId == parmtable.PurchId;


       while select * from  _purchline where _purchline.PurchId == parmtable.PurchId


       {
        purchTotals_1 = PurchTotals::newPurchTable(_purchTable);
        purchTotals_1.calcWithholdTax_IN(_purchTable,_purchLine);
        withholdtax+=purchTotals_1.parmTaxWithholdAmount_IN();
       }




      tdsamt.text(strfmt('%1',withholdtax));


}


Call this method in PurchEditLines Form init() method.




No comments:

Post a Comment