cancel
Showing results for 
Search instead for 
Did you mean: 

TDS calculations considering BP opening balances

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member200818
Contributor
0 Kudos

>> 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
0 Kudos

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
Contributor
0 Kudos

>> 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
0 Kudos

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
Contributor
0 Kudos

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
0 Kudos

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
Contributor
0 Kudos

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
0 Kudos

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
Contributor
0 Kudos

Hi Abhishek,

Thanks for your understanding.

Thanks & Regards

Satish

Former Member
0 Kudos

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
0 Kudos

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

Answers (0)