TDS calculations considering BP opening balances

[Former Member]

Hi All,

We have upload initial opening balance of Business Partners. Now, as the threshold limit is Rs.20000 for TDS calculations, how to consider the opening balance for futher calculation of TDS.

In some case, BP initial balance is below Rs.20000.

We are using SAP 2005B PL32 & TDS 4.6 version.

Please reply.

Thanks & Regards,

Abhishek

Edited by: Abhishek A on Sep 4, 2008 11:02 AM

[former_member200818 · Accepted solution]

>> We have upload initial opening balance of Business Partners. Now, as the threshold limit is Rs.20000 for TDS calculations, how to consider the opening balance for futher calculation of TDS.

>> In some case, BP initial balance is below Rs.20000.

If I understood your requireement right, try configuring the options TDS overlook, Surcharge overlook as per your specific business needs. You can access these properties in Business Partner Master Data -- Accounting Tab.

Usage of TDS Overlook:

Check this u201CCheck Boxu201D if Base TDS Amount is to be calculated from very first transaction for this business partner even though the TDS threshold limit is not crossed.

Usage of Surcharge Overlook:

Check this u201CCheck Boxu201D if Surcharge Amount is to be calculated from very first transaction for this business partner even though the Surcharge threshold limit is not crossed.

Further, I would recommend you to read this blog https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/10739. [original link is broken] [original link is broken] [original link is broken] This blog had few references to already posted TDS threads, and one of the thread gives you contact information of CitixSys, the organization who developed TDS addon and also providing support.

Good Luck.

Regards

Satish

[Former Member · Accepted solution]

Hi Satish,

Thanks for your reply but I am still unanswered for my one question that if BP initial balance is less than rs.20000. I had mailed Citixsys, but didnt got any reply. So, I will be very thankful if some body could sove my problem.

Regards,

Abhishek

[former_member200818 · Accepted solution]

>> I am still unanswered for my one question that if BP initial balance is less than rs.20000.

I am not sure what kind of functionality that you are looking for this specific condition.

I would request you to consider the option TDS Overlook based on my previous reply.

Please narrate the scenario with a transaction (if BP initial balance is less than 20000) and let me try to assist you (if possible).

Thanks for your understanding.

Best Regards

Satish

[Former Member · Accepted solution]

Hi Satish,

Thanks for the responce, my query is, if BP (Vendor) is having opening balance of say Rs. 15000 while initial balance uploading.

This means, futher billing of Rs.5000 should be without TDS tax amount & after crossing Rs.20000 (15000+5000), system should calculate TDS as applicable.

Hope this time I am able clarify the issue.

Regards,

Abhishek

[former_member200818 · Accepted solution]

I would appreciate If you write me back on the current system behaviour after you set TDS threshold limit for this BP and uncheck TDS Overlook option.

Please do write whether the opening balance is loaded using AP Service Invoice or by any other means.

Thanks & Regards

Satish

[Former Member · Accepted solution]

Hi Satish,

If we set threshold limit as Rs.20000 & unchecked TDS overlook then system calculate Invoice amount henceforth for threshold limit of Rs.20000. So, ultimately the limits becomes Rs.35000 ( Initial balance 15000+ Threshold limit Rs.20000) for that particluar BP.

BP initial balance is opening balance of the period,

example - If we started SAP B1 implementation from the month August then the balance from earlier months (July) needs to taken into consideration for TDS calculation, if the BP has not crossed the Threshold Limit.

Hope you got my issue.

Thanks & Regards,

Abhishek

[former_member200818 · Accepted solution]

Hi Abhishek,

Thanks for your time to reply.

I understood your requirement and unfortunately am not having the best solution to your requirement.

I guess if opening balance is not considered in TDS calculation, then it should be refered to citixsys only.

As a workaround, think of importing opening balance by using AP Service Invoice document and see how TDS calculation is working. {Try this in Test System).

If any update I will also post on to the thread.

I will also ask my known experts to work on this thread. Hopefully you would be getting reply.

Good Luck.

Thanks & Regards

Satish

[Former Member · Accepted solution]

Hi Satish,

Thanks for your valuable reply. The work around which you suggest difinitely going to help the issue, but the solution should be given in Add-on by Citixsys as you said.

Read you soon.

Thanks & Regards,

Abhishek

[former_member200818 · Accepted solution]

Hi Abhishek,

Thanks for your understanding.

Thanks & Regards

Satish

[Former Member · Accepted solution]

Hi All,

I also have a similar issue what you're discussing. But I am not able to see TDS overlook check box or field in customer/vendor master data under Account Management.

Can you pls suggest if I have to do any customisation changes?

Awaiting for your reply.

Thanks,

Srikanth

[Former Member · Accepted solution]

hi Srikanth,

If you have successfully installed the TDS add-on then in

BP Master Data ---> Accountint Tab ---> Tax Tab ---> Tick Subject to With holding Tax ---> In last row you can find TDS Overlook

This TDS Overlook will appear only when your add-on is connected.

Regards,

Abhishek