Sbo_TN

[former_member209725]

Hello Dear Experts,

I need Sbo_TN for A/P Invoice when A/P Invoice doctotal is equal or above than 30000/- then need a msg that This Invoice is liable for TDS.

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi.....

I think there is no need to apply SP for deducting TDS or get it into remind to the system.

TDS deduction generally happens when you set up TDS master and apply the TDS category to the parties whoever is liable to deduct TDS.

Generally when you fill the data into AP Invoice by default system is ready to deduct TDS if you see the WTax as YES in dropdown box.

So as per the TDS Threashold limit if DocTotal exceeds then it will cut the TDS automatically.......

Hope you got the right direction........

Regards,

Rahul

[former_member209725 · Accepted solution]

Hi Rahul..

Thanks for your reply with helpful information.

But for TDS there is one more rule if a particular invoice's total is Rs. 30000/ or above then that particular invoice must will be TDS Liable and other is if Party's Balance in one year goes above of Rs. 75000/- then TDS will be apply on total amount.

So that's why when user add Invoice and if first condition applies then system should raise message.

I have discussed on this matter to my Accounts Dept. and they told me the same and that's why I need this Sbo_TN.

Regards,

Ravi

[former_member206488 · Accepted solution]

Hi Ravi ,

Try this:

IF @object_type= '18' and @transaction_type in ('A','U')
BEGIN
IF EXISTS(Select T0.DocEntry From OPCH T0 Where T0.DocTotal > 30000 and T0.DocEntry=@list_of_cols_val_tab_del)
	BEGIN
       set @error='-101'
       set @error_message = 'Error Message !!'
	END
END

or if you want only ffor service type invoice:

IF @object_type= '18' and @transaction_type in ('A','U')
BEGIN
IF EXISTS(Select T0.DocEntry From OPCH T0 Where T0.DocTotal > 30000 and T0.DocType='S' and T0.DocEntry=@list_of_cols_val_tab_del)
	BEGIN
       set @error='-101'
       set @error_message = 'Error Message !!'
	END
END

Thanks,

Neetu

[former_member209725 · Accepted solution]

Hello Rahul..

I checked the Notification in entry level then I realize that I really don't need this TN. Basic funda is proper for TDS.

Thanks for a right suggestion.

I am closing this thread.

Regards,

Ravi

[former_member209725 · Accepted solution]

Hi Mam.

Thanks for your kind reply.

It works.

Regards,

Ravi

[Former Member]

Hi Ravi,

This SP is only for blocking the transaction. It is not for message only. Is that what you are looking for?

Thanks,

Gordon

[Former Member]

Hi Ravi,

Try This......

if @object_type= '18' and (@transaction_type='A' or @transaction_type='U')
begin
declare @tot as int
set @tot=(SELECT DocTotal FROM OPCH where DocEntry=@list_of_cols_val_tab_del )
if @tot>='30000'
begin
   set @error='100000'
       set @error_message = 'This Invoice is liable for TDS'
end
end

Thanks

Shafi