How to calculate RCM only on NetAmount or split amount in FB60 ?

[former_member197696]

Hi All ,

Good morning.Hope you are doing great!

I am trying to post an invoice and its freight value in FB60.

The below mentioned is my excat scenario in our plant.

Freight Invoice RS 25000 . Deduction Amount RS 1200.

Customer Freight RS 23800( 25000-1200 ). TDS is 238 (1% of 23800 )

Amount payable to customer RS 23800 - 238 (TDS) = 23562.00

RCM should be on the customer freight which is on 23800 i.e 595 (5% of 23800 ).

In our custom program we have developed logic accordingly .You can see the output which is as expected. RCM / TDC are properly calculated and outclearing , outward freight details are displayed as expected

We are facing an issue when we try to replicate the same in FB60.

When I click on Simulate

RCM is calculated on 25000 as well as 1200 which is wrong.

I want to calculate RCM on AMOUNT 23800

Is there any way I can apply settings to achieve this.

I have only the below mentioned way to achieve this

In the above mentioned picture , the only change I have made is

Posted 23800 (25000 - 1200) in first line item with taxcode(12 in this case)

1200 second line item as out clearing as well. Now both the outclearing GL would combinely have 25000.

Posted 1200 for outward freight .

This is just a temporary solution which we came up but we would like to post outclearing as 25000 for future reference purpose and calculate RCM on 23800.

Would kindly request to share any info if you have faced similar kind of an issue .

I would like to make the amount(23800) which displays on the header as default to calculate tax and not the one in the table.

Hope I was clear. Please message back for any other info.

Thanks in advance

KK

[former_member197696]

Thanks for the edit Juren.

I will not repeat this further.

Have a great day.

[sanilbhandari · Accepted solution]

Hi

The system would not know the base amount on which tax needs to be calculated. In such a case, you would have to specify the tax base amount on which the tax needs to be calculated. You can control this through a configuration change as below:

IMG>Financial Accounting (new)>Financal Accounting Global Settings>Tax on Sales/Purchase>Basic Settings>Change field control for base amounts

Maintain the configuration for your tax procedure here. Note that this would be applicable for all the company codes in the country to which the tax procedure is assigned. Once you have maintained this configuration, an addtional column for tax base amount will open up under the tax tab in FB60 and MIRO. If the user does not select the calculate tax automatically, the system will show up the field and allow you to calculate the tax on amount you want, in your case Rs 23800 as specified in the example above.

Regards

Sanil Bhandari