馃攳
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
Most Recent Videos:
You can go back to the homepage right here: Homepage





