Skip to Content
0
Jun 22, 2018 at 07:57 PM

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

551 Views Last edit Jun 23, 2018 at 06:06 AM 2 rev

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

Attachments

capture81.png (144.8 kB)
capture80.png (116.6 kB)
capture78.png (30.0 kB)
capture81.png (144.8 kB)
82.png (64.8 kB)