SAP Tolerance Limits: Explanation, Demo and Configuration - YouTube

Channel: Abdullah Galal - SAP, CMA

[0]
in this video i will explain the meaning of聽 tolerance limits in sap and how to configure them聽聽
[5]
in the purchase order and the purchase invoice聽 if you find the content on this channel helpful聽聽
[9]
and you would like to support then you should聽 check the channel membership program that i聽聽
[13]
activated on youtube today this will allow you to聽 support the channel and in return as a thank you聽聽
[19]
i will post extra content: videos and posts聽 that only the members can see this will not聽聽
[25]
impact the original content i publish every week聽 on the channel for everyone but i will add extra聽聽
[30]
content for the members so if you are interested聽 go to the youtube channel and click on join and聽聽
[36]
there you will find another video explaining聽 the program and all the details you need
[46]
the tolerance limit is the difference聽 between any two numbers in the system聽聽
[49]
and you can find it in all sap modules and the聽 difference can be either a value or a percentage聽聽
[55]
so for example in the purchase order when we聽 insert the purchase price of any item we can聽聽
[60]
configure sap to check the purchase price against聽 the cost of the item in the material master data聽聽
[66]
and if the difference is bigger than the tolerance聽 limit then the user will either receive a warning聽聽
[71]
message or an error message and this will notify聽 the user to check and confirm the details inserted聽聽
[77]
and this is very important let's assume that sap聽 is not going to compare the purchase price against聽聽
[82]
the cost of the item and the user who is doing聽 the purchase order he did a mistake he inserted an聽聽
[87]
additional zero in the price so instead of posting聽 a price of 10 usd per piece he inserted a price of聽聽
[94]
100 usd per piece and this is a very easy mistake聽 now after this he saved the purchase order and聽聽
[100]
we move to the second step in the process which is聽 the goods receipt and when we do the goods receipt聽聽
[105]
no one is checking the value the stock keeper聽 is receiving some items he is going to count聽聽
[109]
the quantity he received and he is going to post聽 a goods receipt and the financial entry we post聽聽
[115]
at the goods receipt time will be wrong because聽 the value of the purchase order is wrong we are聽聽
[120]
going to discover the mistake only in the invoice聽 receipt when the accountant does the three-way聽聽
[125]
matching where he is going to compare the聽 purchase order against the goods receipt against聽聽
[130]
the invoice receipt and in the purchase order聽 he will find a price of 100 but in the invoice聽聽
[135]
he will find the price as 10 usd per piece and聽 here he will discover the mistake and this can聽聽
[140]
be very complicated because most of the time the聽 inventory that we received is already consumed聽聽
[146]
so if we are a production company then we receive聽 some raw materials these raw materials go directly聽聽
[152]
to the production line then after a while we聽 receive the invoice we find that there was a聽聽
[156]
mistake in the purchase order we have to go and do聽 either adjustment entries which is not justified聽聽
[162]
so it's not related to the purchase order or聽 we reverse all the goods and movements we did聽聽
[168]
trying to fix the mistake that someone did in the聽 purchase order when he inserted an additional zero聽聽
[173]
by mistake so now you understand how important聽 the tolerance limit is and we can configure the聽聽
[178]
tolerance limit to be either a percentage or a聽 value so for example if the user is inserting聽聽
[183]
a purchase price that is 10 percent higher than聽 or lower than the cost of the item then he will聽聽
[189]
receive a warning message so he can confirm his聽 entries the tolerance limits also exist when we聽聽
[194]
are posting the invoice for the purchase order so聽 if the user tries to insert a value in the invoice聽聽
[200]
that is much higher or lower than the value we聽 agreed on in the purchase order he will either get聽聽
[206]
a warning or an error message and in this case he聽 has to check with the vendor whether the invoice聽聽
[210]
is wrong or he has to check that he inserted the聽 right values in the screen now let's go to sap聽聽
[216]
s4hana and see how we can configure the tolerance聽 limits for the purchase order and the purchase聽聽
[221]
invoice now i will start by showing you how the聽 tolerance limit message looks like then i will聽聽
[226]
go into the configuration to check the message聽 let's start a purchase order so transaction ME21n聽
[237]
vendor ag01 again the same聽 information like every time
[249]
material is 3031
[256]
plant eg10
[259]
and quantity is 100聽聽
[264]
storage location is ag 11. okay now this is聽 a material that i'm going to buy now and if聽聽
[272]
we check the material master data so double聽 click here sorry double click on the material
[279]
and go into accounting one you can see that this聽 is a moving average material and the periodic unit聽聽
[286]
price or the moving average is 20 per 1 meter so聽 this is our price 20 per one now let's go back聽聽
[294]
to the purchase order now i'm going to change聽 the price to be completely different from this聽聽
[300]
amount so we can see the tolerance limit message聽 so let's say i'm going to buy one meter for 50 inr聽聽
[309]
now this is the message that is related to the聽 tolerance limit so effective price is 50 inr聽聽
[315]
material price is 20 inr so it works whether you聽 have a material that is using moving average or聽聽
[321]
a standard cost both of them will work and as you聽 see this is a warning message so it's yellow and i聽聽
[327]
can click on ok and i can continue processing the聽 pictures order normally as if nothing happened so聽聽
[333]
the warning message is only a notification to the聽 user that something might be wrong but it's not an聽聽
[339]
error there is a way in the system to convert most聽 of the messages including this one from warning to聽聽
[346]
error if needed this is something that's not聽 related to the tuner instrument configuration聽聽
[350]
it is actually related to any message you see in聽 the system so whenever you find a warning message聽聽
[355]
usually there is a way to transfer it to an error聽 message and this i will show in a different video聽聽
[360]
but for now let's look into the tolerance limit聽 messages so now because i have a net price聽聽
[366]
that is much higher than the cost i have in the聽 material master data i receive the owning message聽聽
[371]
for the tolerance limit how can we configure this聽 let's go into the configuration so i will move to聽聽
[378]
the configuration screen /oSPRO click on sap聽 reference img go into material management
[389]
purchasing we are now working with the tolerance聽 limits in purchase order so open purchase order聽聽
[397]
as i told you you can find tolerance limits聽 everywhere so for every transaction or for聽聽
[402]
every area of the system you have a聽 different configuration transaction聽聽
[407]
this one and look for set tolerance limit聽 for price variance so if you want to know聽聽
[413]
more details about the configuration activity as聽 usual you can click on the activity documentation聽聽
[418]
otherwise you can just go directly聽 into the screen and here you have聽聽
[422]
the configuration for the tolerance limit聽 by company code so my company code is AG01
[432]
and here we have two transaction keys or聽 tolerance keys so the first one is for price聽聽
[439]
variance the second one is from the maximum cash聽 discount deduction allowed now i'm working with聽聽
[444]
the price variance one if you understand the聽 concept from the price variance you can apply聽聽
[448]
it to the maximum cash discount or you can apply聽 it anywhere else so for now i am changing this one聽聽
[454]
pe so double click so for the tolerance key聽 p price various purchasing company code ag01聽聽
[462]
amounts in inr we have lower limit tolerance and聽 upper limit tolerance lower limit this means that聽聽
[468]
you are the the purchase price is lower than the聽 cost upper limit means that the purchase price聽聽
[474]
is higher than the cost so for upper limit聽 we can have either absolute or percentage聽聽
[482]
and same for lower limits so absolute means聽 a value and percentage is a percentage of the聽聽
[487]
value you are inserting so for example if i聽 say i want to check the absolute limit and i聽聽
[492]
say 5 inr it means that we cannot exceed a聽 difference of 5 a in r even if the price is聽聽
[499]
1 000 we can never exceed 5 inr but if i say a聽 percentage of 10 it means that if the price is聽聽
[507]
one thousand or if the cost is one thousand then聽 the price can be up to one thousand one hundred聽聽
[513]
we have ten percent tolerance percent tolerance聽 limit allowed so the configuration i have here is聽聽
[520]
to check the limit with a percentage and聽 the maximum percentage allowed is 10 percent聽聽
[525]
i also have a check for the lower limit so if the聽 price of the in the purchase order is lower than聽聽
[532]
the cost it can be okay up to 20 percent聽 after this i will receive earning message聽聽
[538]
so let's see if this is correct so as you see聽 here we have 10 percent allowed let's go back to聽聽
[544]
the purchase order and the the cost for the item聽 is 20 and we have 10 allowance which means we can聽聽
[552]
buy up to 22 without receiving a message so let's聽 say 21 inr so this is still higher than the cost聽聽
[559]
the cost is for 20 but now i am inserting 21. if聽 i check the winning messages there is no earning聽聽
[566]
message for the tolerance limit why because聽 i am within the 10 percent that i configured聽聽
[572]
and if i exceed so if i say 25 for example and聽 then enter i will get the warning message because聽聽
[581]
i exceeded the 10 percent so now you understand聽 how the tolerance limit works this is how it works聽聽
[586]
with a percentage you can use the same example聽 and configure an absolute value it will work the聽聽
[592]
same way now i will click on ok and continue聽 with my process so save the purchase order
[600]
copy the po number then i will post聽 the invoice so let's go slash n m-i-r-o聽聽
[608]
so now we know how the translate works for聽聽
[612]
the percent order let's see how it works聽 for the invoice invoice date 2601 2020
[622]
the pictures order number uh 2021
[627]
and the po number is this enter now as you see i聽 don't have an amount or a quantity because we did聽聽
[633]
not post the goods receipt in this case we have聽 to insert the amount and the quantity manually聽聽
[638]
so the purchase order had 100 units and the price聽 was 25 each so the amount i'm going to pay now聽聽
[646]
let's say five thousand and the聽 quantity is again one hundred
[656]
so the total is five thousand and now let's聽 look into the warning messages we have here聽聽
[663]
and there is one message saying price too聽 high tolerance limit of five percent exceeded聽聽
[670]
so this is the tolerance limit聽 for variance verification actually聽聽
[674]
it is one of the tolerance limits because in voice聽 verification has many tolerance limits and i will聽聽
[679]
show you this in the configuration now so how can聽 we configure this five percent let's close this聽聽
[686]
and again go to the configuration screens聽 spro sap reference go to materials management
[698]
purchasing no this time we will go聽 into logistics invoice verification
[706]
and here there is invoice block then set tolerance聽 limit this is a different transaction than the聽聽
[717]
one we used for purchase order and it also聽 works the same way with the company code so聽聽
[722]
my company code is ag01 now this time for invoice聽 verification see how many tolerance keys we have聽聽
[730]
as i told you there are many tolerance limits聽 related to the invoice verification so for example聽聽
[736]
you have amount for item without order reference聽 or with order reference or form small difference聽聽
[742]
automatically and many others now if you would聽 like to understand the difference between these聽聽
[747]
two tolerance keys you can go back to the spro聽 menu here and click on the documentation here聽聽
[754]
sap is explaining why everyone is used now the one聽 that is impacting my demo is the price variance so聽聽
[763]
if i go again to my company called ag01 and this聽 is the one that's impacting me price variance聽聽
[771]
so if i click here we also have lower limit upper聽 limit the same as the one used in pitches order聽聽
[776]
but these are different limits that are used聽 for price variance in invoice verification so聽聽
[782]
for lower limit we have absolute percentage for聽 upper limit this is the one i'm interested in聽聽
[787]
so absolute and we have percentage so as聽 you see here we have check limit 100 000 inr聽聽
[794]
so the if the invoice is 100 000 inr higher than聽 the purchase order then the user will receive a聽聽
[801]
warning and i also have a percentage check limit聽 at five percent so if the invoice amount is five聽聽
[808]
percent higher than the purchase the purchase聽 price we should get a warning message which聽聽
[814]
is what happened when we did the invoice right聽 now so if i go back the warning i'm getting here聽聽
[821]
is tolerance limit of five percent exceeded the聽 what i wanted to show you here is if we have both聽聽
[828]
the value and the percentage configured sap will聽 pick the lower one so since five percent is lower聽聽
[835]
than one hundred thousand sap is picking five聽 percent but if i have a value that is lower than聽聽
[842]
the percentage sap will pick the value so聽 if i go here and i make this one inr save
[852]
now let's go back and try聽 to process the invoice again聽聽
[856]
remember that whenever you change the聽 configuration you have to restart the transaction
[862]
so now i'm restarting the invoice聽 and again the same details
[868]
purchase order
[879]
and the amount is 100 let's say again聽 5000 the same amount and the same quantity
[887]
amount is 5000 now i'm getting the warning message聽 if i check the message is a little different this聽聽
[895]
time price too high tolerance limit of 1i and聽 r exceeded because the value is lower than the聽聽
[901]
percentage that we set up in the configuration sap聽 is checking with the value now we understand the聽聽
[906]
meaning of tolerance limits in sap and how they聽 can be configured for purchase orders and invoice聽聽
[911]
verification if you like the video don't forget聽 to share it with others who may be interested聽聽
[916]
and leave me your comments tell me if聽 you find it helpful and whether you have聽聽
[920]
any experiences with this topic thank you聽 for watching and i'll see you again soon