cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic Calculation of Penalty in MIRO

Former Member
0 Kudos

Hi Experts,

The scenario is as follows :-

A Purchase Order for procurement of coal is placed say 100 tonnes of coal @ Rs. 20/- per tonne. The freight cost say Rs. 10 per tonne is maintained in condition tab of PO. A transport vendor is assigned in freight tab while creating the Goods Receipt against the freight condition maintained in PO.

The transporter is allowed a tolerance of 0.5% on the PO Quantity. i.e. the transporter has to delivered at least 99.5 tonnes of coal. Suppose he delivered 90 tonnes of coal. Then there is a short fall of (99.5 - 90 = 9.5 tonnes).

GR is prepared for 90 tonnes for which the freight cost will be Rs. 10/- per tonne x 90 tonnes = Rs. 900/-.

A penalty amount of (Rs. 10 per tonne X 9.5 tons x 1.5 = Rs. 142.50/-) is to be deducted from Rs. 900/- and amount to be paid to vendor is Rs. 900/ - Rs. 142.50/- = Rs. 757.50/-.

The client wants to deduction the amount of penalty automatically at the time of MIRO. In the MIRO after entering all the details and the user click on the Simulate button and financial entries are displayed, the entries should display the amount Rs. 757.50 instead of Rs. 900/- and post the same amount after clicking on Post button in MIRO.

Please suggest a BADI, User exit or logic for this process or suggest a solution to configure this process.

Thanks & regards

AJ

Accepted Solutions (0)

Answers (3)

Answers (3)

ami_selarka
Employee
Employee
0 Kudos

Do we have s solution for this?

Former Member
0 Kudos

Hi Satish,

Thanks for your quick response.

I wil confirm where the difference of the penalty amount will go.

Can you suggest any user exit or badi wherein i can either deduct the penalty amount of Rs. 142.50 from the freigtht amount at the MIRO level.

Also please suggest if the penalty amount can be calculated at the time of MIGO and the freight amount to be posted is minus the penalty, so that the entries following to MIRO will have only the amount to be paid and also the freight cost which will be uploaded on material cost will be the actual amount that will be paid to the transporter.

Thanks in advance.

AJ

Former Member
0 Kudos

Hi Ashutosh,

Please confirm with the client, Where the difference of Rs. 142.50 will go?

As after the GR is done the freight amount will get loaded on the material/Inventory and at the time of IR they want to reduce the price for the freight.

If they want it to be posted to the material again then the complete stock of the material i.e. 90 pcs should exists.

You can try an user exit which gets triggered at the time of simmulating the invoice (be sure that the user should simulate the invoice every time it is a must).

The exit will check,

PO qty <> IR populated qty or IR qty is < PO qty (IR populated qty will be equal to the GR qty if Gr Based IV is ticked -- Assumed)

If not then get the tollerance from PO and line item and calculate the amount as per your formula.

Activate the material tab in IR (IMG),replace the line with material code (can be taken from PO/GR) as Dr. entry with the calculated value.

Take help of good ABAPER.

This can be done.

Cheers,

Satish Purandare