TaxTrans Table Data Can be sorted by Tax Codes
static void Tax_1016(Args _args)
{
TaxTrans taxTrans_In;
VendInvoiceJour vendInvoiceJour;
DLSTax_1016 dlsTax_1016;
//real BED_EX_KA,Cess_EX_KA,EC_EX_KA,SHE_EX_KAR;
//INMF-110000059
delete_from dlsTax_1016;
{
while select ledgervoucher from VendInvoiceJour
{
while select * from taxTrans_In
where taxTrans_In.Voucher == vendInvoiceJour.LedgerVoucher
{
dlsTax_1016.Voucher = taxTrans_In.Voucher;
switch (taxTrans_In.TaxCode )
{
case 'BCD_CUST','CST_KA','CVD_CUST','EC_ST_Ka','ECESS_CUS','ECess_CVD','SHCess_CVD',
"CVD_CUST","ST_KAR",'SurCh_KA',"VAT_KA",'SHECess_CU','SHE_ST_KA':
break;
case 'BED_EX_KA':
dlsTax_1016.BED_EX_KA = taxTrans_In.TaxAmount;
break;
case "Cess_EX_KA":
dlsTax_1016.Cess_EX_KA = taxTrans_In.TaxAmount;
break;
case "EC_EX_KA":
dlsTax_1016.EC_EX_KA = taxTrans_In.TaxAmount;
break;
case "SHE_EX_KAR":
dlsTax_1016.SHE_EX_KAR = taxTrans_In.TaxAmount;
break;
}
}
dlsTax_1016.insert();
dlsTax_1016.clear();
}
}
{
info('Records Inserted');
}
}
static void Tax_1016(Args _args)
{
TaxTrans taxTrans_In;
VendInvoiceJour vendInvoiceJour;
DLSTax_1016 dlsTax_1016;
//real BED_EX_KA,Cess_EX_KA,EC_EX_KA,SHE_EX_KAR;
//INMF-110000059
delete_from dlsTax_1016;
{
while select ledgervoucher from VendInvoiceJour
{
while select * from taxTrans_In
where taxTrans_In.Voucher == vendInvoiceJour.LedgerVoucher
{
dlsTax_1016.Voucher = taxTrans_In.Voucher;
switch (taxTrans_In.TaxCode )
{
case 'BCD_CUST','CST_KA','CVD_CUST','EC_ST_Ka','ECESS_CUS','ECess_CVD','SHCess_CVD',
"CVD_CUST","ST_KAR",'SurCh_KA',"VAT_KA",'SHECess_CU','SHE_ST_KA':
break;
case 'BED_EX_KA':
dlsTax_1016.BED_EX_KA = taxTrans_In.TaxAmount;
break;
case "Cess_EX_KA":
dlsTax_1016.Cess_EX_KA = taxTrans_In.TaxAmount;
break;
case "EC_EX_KA":
dlsTax_1016.EC_EX_KA = taxTrans_In.TaxAmount;
break;
case "SHE_EX_KAR":
dlsTax_1016.SHE_EX_KAR = taxTrans_In.TaxAmount;
break;
}
}
dlsTax_1016.insert();
dlsTax_1016.clear();
}
}
{
info('Records Inserted');
}
}
Comments
Post a Comment