INVOICE MATCHING VALIDATION - Part3 ( Two way and Three way matching)

foreign

[Music] in this session we are going to discuss about

matching validations for two-way three-way matching

uh in previous sessions part one and part two we discussed about invoice total

matching as well as charge matching so what is the setup you need to go to accounts payable

parameter invoice validation this is mandatory for any matching and I am removing the

charges matching now and so I am taking

two-way matching

let's take uh otherwise three-way matching here

I'll take three-way matching and a low uh matching policy over right

lower or higher than the company policy uh

policy override if you want to do this uh like lower than or higher then you

can make it this one and uh tolerance uh display unit price

match icon tolerance for the unit price if greater than or less than or uh what

is the tolerance you can select it and uh for the price uh what is the

tolerance percentage you can provide or you can make it as a percentage sorry

make it as a mood I'm taking the five percent as tolerance

if you take percentage these two Fields enabled if I take amount these two

Fields enabled so it depends on the selection of the

matching price total these two Fields one of them is uh enabled and one of

them will be grayed out

so display price total matching uh price total matching if you want to make it as

uh greater than or less than dollars or greater than tolerance you can select it

so these are the setups needed First Step uh

uh price matchings so you see here previous episodes

previous discussion we talked about uh invoice total matching and this part and

charges matching we discussed now price and quantity matching the name itself uh

having the price and quantity price and quantity will match and uh

we have two methods two-way matching and three-way matching let's see the I'm not

going to explain the concept from the starting point while testing the

scenario I'll show you what is matching in two way and what is matching in three

so let's see the same like a price tolerance we have if

you want to mention any price tolerance you can provide the tolerance here

let's take new one uh you have a table level item

uh if I want to provide the table level only applicable for only that particular

item and the group level and all you can provide currently I'm taking table level

one item I selected and account vendor also I'm taking as a table level and I

am selecting this vendor my Pro price tolerance is 10 percent

okay so let's I saved it and I'm going to do one more thing

matching policies so in the matching policies uh specify

the line matching policy for item window so this is the combination if you want

to provide different matching policies in combination of item and window you

can provide from here okay different matching policies see

here you have item and vendor item and vendor level if you want to provide the

policy and you can do that okay

otherwise uh you have the option like only item uh item level you can provide

the matching policy whether it is supposed to follow the company policy or

two way three-way which one is allowed for this item

okay and you have same thing for vendor level as well vendor uh if you want to

follow the company policy you can do that otherwise you can make it as three-way or two-way matching policy for

this particular vendor foreign if you want both the combinations item

and vendor

for example double one zero one

and one double zero one so whenever you select this uh window

for raising the purchase order when you are purchasing this item from

this window the matching policies

matching otherwise not required for example in

this combination matching policy not required we given so that is one thing I want to show you

price tolerance we checked and matching policy we checked item price tolerance

uh these are the groups okay leave it uh we'll go with testing part

here we need to get entire picture how two-way matching and three way matching

will work

one double zero one is my vendor and

I'm taking this item whenever I taken that item

it is matching policy is three-way based on the parameters we selected

from the purchase order it's three-way matching

so purchase order product receipt as well as invoice required

but product receipt sorry purchase order confirmed let's post the product receipt

now

so I didn't changed anything in the product receipt

okay one thing you need to know this it's a three-way matching

foreign

and we are posting invoice

now

if I go directly see currently it is match status is passed

if I go directly to matching details

see price matching performed unit price 100 at the time of invoice and

disorder why is it the time of invoice and purchase order it is matching

okay rise at the time of purchase order and price at the time of

invoice it is match then quantity

invoice quantity product receipt quantity

matching okay

investor matching not performed because we didn't enable that

so in three-way matching what are the

documents system trying to match one is invoice

one first will go with purchase order one is purchase order

and product receipt

and invoice so from the purchase order

what is the unit price and what is the unit price at the time

of invoice it's supposed to be matched then only it will pass then next

matching policy is that quantity at the time of product received and quantity at

the time of invoice need to be matched okay net amount also that is fine anyway

so if you want to check match product receipts

product receipts matching if you want to check it out this is the thing

so one item

and product received quantity one one and Native mode is one and he you have

one quantity everywhere so it's matching right

so let's test the scenario by editing some data

at the invoice level uh let's take

1000 .

it's failed why it is failed let's check it out

okay unit price one zero double nine

thousand past why it is passed why it is false because we given the

tolerance of 10 percent

tolerance in the uh this level parameter level we

given five percent that is five but for this combination what is the price

tolerance we given is 10 percent

you remember I guess so the price tolerance table this when when

you uh do the purchase order with this item and uh this vendor combination be

given ten percent see if you have doubt

let's take thousand one thousand ten percent Miss hundred so if I

take this as

one thousand 101

see price matching failed if I go to matching details now

this is failed at the price at the time of purchase order price at the time of

invoice is not matching it's over the tolerance that we have provided

this one failed okay net amount failed meta mode is one thousand one zero one

but actually at the time of purchase order it is thousand

getting okay so one not one unmatched purchase order

total is one not one failed so this is one thing you need to notice

quantity anywhere it is matching because we didn't change any quantity

okay

five percent means 50. 50 one

unit price it is passed uh post sorry

net you need price

so unit price I'll give thousand

and quantity will test it

will give the quantity of two per two let's go and check the matching

now see uh unit price it's passed anyway

but here net unit price also passed unmatched

amount it's failed because thousand is unmatched

because of uh

see quantity also failed Let's test one more testing

1000 99

say first everything only this unmatched amount failed

and the invoice total it's failed because quantity is different

let's go and check the parameters once again

is greater than percent is five percent we given

uh display price total match now we given uh greater than or less

than

price total it is

price total percentage

okay so quantity quantity at the time of product receipt

and quantity at the time of invoice supposed to be matched and price at the

time of in purchase order price at the time of uh invoice need to be matched

okay so this is one thing

and let me delete this line

and test one more scenario

double foreign

product received I'll leave this one and create new purchase order

so now it's created

so for this item item group

this all details are not filled let's go and do that

information management

laser product

what are the things need to be done what is the error message item group

inventory unit sales unit uh okay

and what else

in the sale level also quantity need to be made I'm sorry unit need to measure

ment is inventory foreign

let's select now

okay now it's accepted what I want to show in this is

once you select these see policy matching is not required

how it's taking the combination of this window and this item uh

item you raise the purchase order the policy

the matching policy we have provided is

not required when you select this item and this

window we have given not required so

by default it is coming node okay this is one thing and

let's try with two-way matching right two very thing we need to check it out

um let's check the two-way matching

I'll give I'll change the two-way match mode

or I'll go with this purchase order with two-way matching

and uh what else purchase order

will color must be filled in ah there are some other setups for this

actually for this item

combinations maybe black

dimensions

um something that leads to

this item I did many changes

so leave this um will change it at the

parameter level itself to do a matching anyway it is just

testing purpose

and I'm selecting here two-way matching for my company

now my company policy itself to a matching uh headline

[Music]

one second

to be matching now

so in three-way matching we what and all will be mesh

is it demo purchase order and price at the time of invoice

and quantity at the time of product received and quantity at the time of

net amount also um

quantity right

so I'll post the product receipt as well

even though we are posting product received

touching rule is to a so system

okay product received done

hmm

let's go with matching details

that is matching everything first see quantity not performed

nothing invoice total not perform only price at the time of purchase order and

price at the time of invoice net amount at the time of purchase order net amount

at the time of uh invoice need to be matched

that is two-way matching so only prices will match here

uh in three-way matching quantity as well with the product received

when I select

same remaining tolerance and I'll be given same thing right

so same it will

it's passed everything unmatched purchase order total it's

showing fail that's it but it's everything passed

price total match failed total match it's failed price match its past prize match means

uh unit price and price total total of the purchase

order and total of the invoice it doesn't match because that's why it's

got failed okay

okay these are the things uh I want to discuss in this session

I hope uh you understand uh entire end to end uh matching validations invest

total matching charges matching how it will work what is the tolerance tolerance how it will work and three-way

matching and two-way matching don't confuse in three-way matching

three documents needs to be matched one is purchase order invoice and another

one is product received quantity at the time of product receipt and quantity at the time of invoice need to be matched

price at the time of uh purchase order price at the time of invoice need to be

matched and same way uh total total also total at the time of purchase order and

total at the time of invest need to be matched that is three way matching and two-way matching there will be no

quantity matching at all there is no matching with product received to only two documents will match uh what are

those documents purchase order and invoice price at the time of purchase order and price at the time of invoice

need to be matched total price total at the time of purchase order need to be

managed with the price uh total of the

invoice okay

so it's filled right and need required approval we selected so once it is

uploaded you can watch it so I hope this session is helpful in understanding

the investment matching validations uh we'll come up with a different topic in

next episodes coming up Source Let's uh just I'll

overview it uh I'll give the summary of this concept

so what are the setups required in accounts payable parameters inval

invoice validation you need to activate the invoice validation otherwise no

matching policy will be applicable for the legal entity that is one thing if they if we need uh

approval if there is any discrepancies then you need to select the required

approval option in the parameters if you want to update the match test this

header level automatically then this option will be enabled

and if you are performing invoice total matching activate this and provide the

tolerance if you if there is any tolerance that you need to provide

individually like dot for example

invoice total matching if you want to provide the invoice total matching uh

for the combination for the combination you can

provide from the invoice total tolerance form

so it's slow

right

hmm okay I mean well I'll explain other

things we need charges matching if you want to capabilities

and if you want to do the tolerance for charge level code

wise you have uh charge level code uh

in the matching policies in invoice matching setup you have

that option to select the charge code level tolerance

I don't know why it is keep on going to release the products

and three-way matching if there is any taller this is company level

policy and if you want to provide the item level and vendor level policies or

to our vendor level policies you can go to the matching uh setup and you need to

select the um matching policies if you want to provide

the price tolerance and you can provide that as well in the accounts payable

invoice matching setup

okay this is not enabled that's why it is not coming once you enable in the

parameters then only it will appear

meanwhile you can check the price tolerances how you need to set up for

the item and vendor level price tolerance and matching policies for the

item and the vendor level or only for item level or only for uh

vendor level you can provide these what are the policies that you want to apply

for that combination and charge tolerance anyway it's not

enabled that's why system is not and providing that particular form if I

enable these two now you can see the tolerances set the

charge code level or invoice total tolerance

so at the vendor level and you have charged tolerance as well here

so I think it helps

uh we'll discuss another Topic in another episode or another session

hope understood if anyone wants uh d365 functional FM

code training uh please contact my number

or you can find my number in this channel one of the episode class one

if you go with that episode you'll get my number or you can call me through

this number so that I will provide you the guidance

I am getting one call uh okay uh we'll discuss another Topic in another