TCS Calculation Issue

pashya1972
pashya1972 Member Posts: 176
edited 2009-01-29 in NAV/Navision Classic Client
Hi,

We ve observed TCS wrong calculation issue.

In the beginning rounding off was "nearest to rupees 10" ..It was calculated tcs perfectly but since rounding off to 10 rs was not acceptable we drop the idea and make changes to nearest to rupee "1". But now the system does not calculating the TCS accurately . In 2-3 invoices TCS has not been applied due to wrong calculation. Set-up is overlook surcharge and rate @ 1% +10% Surcharge+2% cess+1% she cess.

Surprisingle TCS is calculating far below i.e. 50% or so. Also while checking it is observed that Say a base amount of invoice is 100000 it is showing 47K . I cud not find the diff as to why the system is taking base amt diff from the invoice?

Thanx'

Prashant

Comments

  • srinivas.chittem
    srinivas.chittem Member Posts: 142
    Hi Prashant,

    Please check the Effective dates, TCS%, Surcharge%.

    And TCS threshold Amount, Surcharge threshold Amount.

    Effective date is very important when we calculate TCS
    Regards,
    srinivas
    "Delighting Customers.... Through Delivery Excellence" .
  • ssingla
    ssingla Member Posts: 2,973
    Check for Invoice Discount and amount calculated in the structure. TDS/TCS Base amount is calculated as per the below formula:
    TCSBaseLCY := ABS("Line Amount" - "Inv. Discount Amount" + StructOrderLine."Amount (LCY)");
    CA Sandeep Singla
    http://ssdynamics.co.in
  • pashya1972
    pashya1972 Member Posts: 176
    I ve verified the structure however it seems to be ok.

    Attached herewith sample case.

    Prashant
  • ritesh.singh
    ritesh.singh Member Posts: 123
    working fine in base product. even with rounding nearest to Rs. 10.
    Check the setup once again and try to do the transaction in Base product.
    Thanks,
    Ritesh K Singh

Categories