I had this problem when upgraded from Nav 2009 v6.0 to Nav 2009 R2 6.0 SP1.
(in R2 6.0 SP1) Purchase Invoice with TDS (e.g. Invoice value Rs 100, TDS value Rs 10, Pay to Vendor Rs 90)
Now after posting this invoice
- In posted purchase lines → “TDS Amount” & “Total TDS including SHE cess” = 10
- In G/L Entry it shows proper figure
- TDS Entry - > “TDS Base amount” = 10, “TDS amount” = 0, “Total TDS Including SHE CESS” = 0
- Vendor Ledger Enty → “Total TDS Including SHE CESS” = 0
- Detailed vendor ledger → “Total TDS Including SHE CESS” = 0
now in nav2009 v6.0 TDS Entry table shows proper figure rest all table ( vendor ledger, detailed vendor ledger) shows 0.
Is this normal or something i missing in setup?
Has anyone else faced this kind of issue in NAV 2009 R2 Sp1?
“TDS base amount” should be “Invoice amount” right? Why in my case its taking “TDS amount” as “TDS base amount”?
Hi,
Yes there is bug in R2 version
Go to CU 12
Go to Function ‘Code’ and comment CalculateTDS function
IF GenJnlLine.“Bal. Account No.” <> ‘’ THEN BEGIN
ConvertTDSAmountstoLCY;
TotalTDSInclSHECess := TotalITAmountLCY;
Posting := TRUE;
//CalculateTDS; Commented to calculate correct TDS amount.
ConvertTDSAmountstoLCY;
IF “Check Printed” THEN BEGIN
IF TotalTDSInclSHECess <> TotalITAmountLCY THEN
ERROR(Text16522);
END;
Thanks Amol but this is not working… I am facing the same problem… did you missed telling me something??
Sorry for wrong reply… well initially i commented only one “CalculateTDS” so it was not working…now after commenting both it worked great… thanks alot Amol
IF GenJnlLine.“Bal. Account No.” <> ‘’ THEN BEGIN
ConvertTDSAmountstoLCY;
TotalTDSInclSHECess := TotalITAmountLCY;
Posting := TRUE;
//CalculateTDS;
ConvertTDSAmountstoLCY;
IF “Check Printed” THEN BEGIN
IF TotalTDSInclSHECess <> TotalITAmountLCY THEN
ERROR(Text16522);
END;
END ELSE BEGIN
Posting := TRUE;
//CalculateTDS;
ConvertTDSAmountstoLCY;
END;
Hey Amol…thanks for the reply… Now do you have any idea how to bring the missing values due to this bug in VEndor ledger Entry & TDS entry table?
Need to reverse those invoices and post it again.
oh thats a bit problem… since lots of invoices were posted & also the date is locked for previous month posting… nothing can be done in direct table?
Hi,
Changing in table is not correct way.
Best way tell your account personnel to pass difference JV in TDS Receviable account which will resolve the problem but this will not change the value in respective tables but your COA will be corrected.
well thanks to god but its posted correct value in G/L account for TDS… my problem is only for Vendor ledger table, TDS entry table, detailed vendor ledger table.
Actually i created a report in which I needed TDS amount across every invoice no so I took Vendor ledger table as Dataitem. So just need the proper value in that table.
what you say?
Be Careful while changing entries in Tables.