INVOICE MATCHING VALIDATION

hi everyone today we are going to discuss about invoice validation invoice matching

validation so to do that

let's open

presentation

not saved

[Music] foreign

Ty okay let's get started

first of all for invised matching validation uh to enable the invoice matching

validation you need to go to accounts payable parameters

invoice validation in the invoice validation

this is the field that you need to enable for invoice validation see if you

disable this all other fields has been created

so if you enable this field and invoice validation will be activated

and uh in invoice matching policies will be activated with the help of this field

once it is enabled you have post invites with

discrepancies if you want to allow the invoice with discrepancies then with an

approval then you need to select the required approval if suppose it is uh if

there is a discrepancies whatever the validation setup we did

even though discrepancies is there you need to take your take approval and you

need to post it then this supposed to be required approval

require approved automatically update uh invoice matching

status match status in the header automatically it will update the status

if you enable this it will automatically enable the status of the invoice

validation so we have uh three different types of

matchings we can say invoice total matching invoice total matching which

will match the totals of the invoice it's a purchase order

at the time of purchase order what is the in total

and it's supposed to match with the invoice total so I'll show you in the in Practical uh

for this concept so that you will get clear picture currently invoice total

matching is means purchase order total equal to

invoice total in simple words it is purchase order

total equal to invoice total so if you enable this field

then only it will activate the invoice total match

so I have are

tolerance limits as well for this if I need two larynx greater than

tolerance I'll use greater than otherwise greater than or less than so

it may be greater or less that anything is fine for with three percent three

percent tolerance for example 100 is the total invoice invoice total if it is 97

3 percent means three percent on 100

it is 3 rupees I guess so it is 97 till 97 it will allow you uh to pass the

invoice validation uh same way if you select the greater than or less than one

zero three hundred is the total one zero three till one zero three the invoice

validation will pause so I'll go with uh if greater than for this invoice

validation for matching validation will go with different way uh

so I'll give five percent greater than is my tolerance if 100 is

the total amount till 105 it will allow the invoice validation

to pass so So currently I am discussing only

inverse total matching so for invoice validation

to be applicable for the legal entity first you need to enable the matching

validation in the accounts payable parameters if there is any discrepancies if you

want to post it with an approval then you need to select

the required approval if the automatically invoice validation status

need to be updated then you need to enable this So currently we are discussing about

invoice total matching invoice totally if you want to perform invoice total

matching you need to activate this once it is activated if there is any

tolerance limit that you need to set you can provide is great if greater than

tolerance or greater than or equal to tolerance and so on percentage of the tolerance that you want to sell

and you have invoice matching set so invoice matching setup

it's under invoice matching setup invoice total tolerance

I have one more setup this is overall legal entity level set up in the

parameters and if you want to set the uh

individual vendor level for example this vendor I

have taken two percent uh same way

if I want to restrict another window with different percentage I can use it

normally if it is other vendors it is five percent tolerance but if I select

these windows it is two person tolerance while testing I'll explain you very

clearly so that you will get uh easily understood this is the setup you need to

perform um to do invoice validation so we are

discussing about the major concept invoice matching Concepts uh invoice

validation to perform the invoice validation what

is the first step you need to go to accounts payable parameters you need to

activate enable the invoice validation and uh if you want to do the uh

posting of the invoice with the discrepancies at the time if you with

the approval then you need to select the required approval option currently we

are discussing about invoice total matching so invoice total matching I enabled and I have given the tolerance

of five percent so this is the testing we did till now so sorry this is the

setup we did till now and coming to the testing testing part you need to get the clear

picture how it is working and what are the setups we did what is

the outcome from the setup so now setup we did now we are going to do testing

and what is the output whether we achieved what we expected or not that we

will come to know in the testing let's go and create the purchase order

hmm

I don't know why it is very slow

yeah so let's create new purchase order

I'm selecting the window

let's click on OK

foreign

so I'm taking a side

is

90 it is showing because of discount

save it

teeth are fine

so we are creating the new purchase order and we are confirming the purchase order

of this filling all the details

foreign [Music]

to confirm the purchase order

I can now it will be completed yeah it's confirmed now let's pause the product received

we are posting the product once it once once it is done we'll need

the in ways

there we can see the matching validations

foreign

let's start with the invoicing

see in the invoice tab I am giving uh

currently match status updated as passed because we selected

that's why it is

these two I'll change this to

hey come on

99

5 it's failed so if I take one zero four

something slow actually so we have selected that automatic uh

match status right so it's a bit slow

so 1 0 2 it's failed sorry one zero three one zero two

passed and if we go with

99 passed

one zero three it will go failed so because

why it is acting like that so let's check our

power before testing this

invoice validation

sorry

so in the usmf legal entity let's check the parameters

so in the invoice validation we have selected match invoice total

and if greater than tolerance is set as 5 percent

even we selected five percent in hundred five percent means 5 rupees it's

supposed to allow till 105. it's supposed to allow till until 105

but it allowed only till one zero two it

is passing when you select

when you give the unit price to one zero two

so if we select 0 to the total is one zero two then it

is passing and if you one zero three is failing because

this is parameter level even though we set it as five percent but if you go to

the tolerance limit for this particular vendor level you have different percentage of

Tolerance so here we selected for this window two

percent tolerance we have given so two percent of 100 rupees is one zero two

sorry two percent of 100 is 2 so that's why it is allowing greater

than tolerance that means till until

there will be no issue with the matching policies I it will pass the status

matching if you go with one zero three it will fail so here it's failed right

if you want to review the matching details in the review tab you have matching

details you can review how it's matched what is the

status of the match status of the invoice validation

everything all the details will be available here see here price

not performed because we didn't perform any price matching

then quantity not performed we didn't match the any quantity matching that's

why not perform we did only invoice total matching that's why it's showing

the match status so actually balance is one zero two

balance is one zero two and invoice amount is one zeroth sorry one zero

three and one zero three so total price variance amount is one zero sorry three

so that's why you click on invoice total matching you

will get all the things actual invoice total one zero three

expected invoice total hundred variance percentage is three percent failed

total discount there is no discount charges there is nothing sales tax nothing rounding of nothing so invoice

total 103 expected is hundred but three percent variance it's got failed this is

the uh details about uh your invoice here you can see uh tolerance percentage two

percent it will allow until two percent uh so I want this to be posted with an

approval see here matching status has been failed and I cannot post the invoice because my

matching validation has been failed if I if I try to post the invoice which was

failed in during the invoice validation

so it it will throw you an error message saying that

invoice int could not post because it contains

matching errors which must be approved so you need to approve your invoice

before if you need to take approval for matching discrepancies before posting

your invoice that is what it is saying so

you can click from here as so you can click matching details on the

top let's close it here

and go to approval tab

approve it

so here you need to approve this one once it is approved you can able to post

the in lies

I think some error is coming let me

know

I think this is

not this one

is very slow actually 319 today is 3 20. this is the one

so after uh taking the approval then you can post the invoice

so this is the uh

so this is one type of invoice validation that we discussed and

I'll start with charges matching

in another video another live session maybe today itself

so

once that is performed so that we'll go to next concept uh

two-way matching and three-way matching where which is very important

okay me

okay we will discuss other uh charges matching as well as two-way and

three-way matching in another video I'll close this one

next uh in next video I will going to explain those three ways of