INVOICE MATCHING VALIDATION - Part2

oh

hello everyone welcome back

uh

today we are going to discuss about uh

charge to charge total matching how it

will work and what are the setups we

need to perform uh first of all uh in

accounts pay first setup is to perform

this activity uh you know uh

uh you need to activate the validation

invoice validation in the accounts

payable parameters

this

is

so let's go to Open Table parameters

in the cones payable parameters we have

invoice validation option

you need to enable this you know uh very

well

matching charges you need to enable this

one and I have the I have given the

tolerance of greater than or less than 3

percent and

though so if we go to tolerance invoice

matching setup uh charges tolerance we

have uh this is parameter level it will

applicable to the end thereof or legal

entity level if you want to update

charge level code wise uh tolerance then

you can take this uh code as well as and

whatever the charge tolerance you want

to update you can update for me

and we have one setup in the charge code

setter

in the charge code setup accounts

payable compare purchase order and

invoice values if you enable this system

will compare with a purchase order and

invoice values and you can see all the

details uh relating to the charge code

Magic

so these are the three three setups

required for charge match charges

validation or charges matching

first one is that in parameters you need

to activate the validation and charge

matching you need to enable and if there

is any tolerance you can provide there

as well and as well as tolerance charge

uh charge code tolerance you can provide

in the substrate level where you can

update the tolerance for each charge

code level

and you have in the charge code setup

you have comparison of purchase order

with invoice values if you enable that

the comparison will perform for a

purchase order and invoice values for

the charge code level

so let's get started with testing part

these are the setups and now we are

going to test it and we'll see the

output

so let's create one purchase order

foreign

that you want to purchase

let's take 1000 as a price

and I am removing the discount as well

go to purchase tab

to maintain charges

by the charges

let's take the right

I'm giving 100 as a value

once

we select the maintain charges

you need to allocate the charges to the

lines

otherwise it won't allow to confirm

the purchase order

let's allocate it

once it is allocated just straight away

confirm the purchase order

[Music]

and

let's post the invoice now

the invoice level you need to match the

validations

once you click on the invoice you'll get

all the device matching related stuff as

well

let's wait for the

invoice form to open

yeah it's open now and I'll give

charge matching

Sam

and

21 invoice date

why the line is not appearing

currently default is product receipt

quantity

we didn't posted any product recipient

that's why that line itself not showing

I'll take this order quantity as default

once we update this one uh line

automatically will appear in the live

level

whatever we've prepared in the purchase

order

okay once it is done let's check the

matching details first it is already

passed status

uh so price quantity price matching

nothing is happened because we didn't

mentioned any price matching and

quantity matching also nothing and in

the invoice total matching we have

something relates to the uh

uh matching status which is already post

and total uh normally balance is

thousand and charges is 100 and it's

came as a 100 1 100 invoice amount and

compared charges is 100 it is passed if

I click compare charge values

it will give all the details uh passed

right right 100

uh actual total charges expected total

charges variance nothing is there uh

because we didn't changed anything uh

these are the values available here

so

let's edit the charges at the invoice

level and we'll see uh what will happen

in the matching details

if I give

one zero three

as a charger

okay let's check the matching details

still it is passed

and let's check the invoice total still

it is passed why we have given uh

tolerance of how much

let's check in the parameter level

I think three percent greater than or

less than tolerance we have given and

so that's why it's uh

past

so let's check the compare charge values

see here one zero three hundred expected

three variance

total

tolerance percentage actually tolerance

percentage is five percent because uh

variance percentage is three percent

because even though we have given three

percent at the parameter level uh we

have uh

tolerance for the charge code level we

have set up as a five percent that's why

it is five percent and it is within the

tolerance it has been passed

let's edit the charges again

um

financials

maintain charges

let's take 110.

okay

save it

then go to matching details

check the details

invoice total

it's failed

because 110

comparable charges is 110

let's check the compare charge values

failed and 110 actual expected 100

variance amount 10 variance percent is

10 only 5 percent is allowed dollars

okay

so this is the uh

uh oral concept of charge matching how

it will work uh how it will perform the

tolerance limits and all

I I hope uh this helped you

uh

let's take one more example with 98

so

invoice total

it's passed

charge value

5 minus two percent

it is uh within the tolerance

Let's test one more scenario

it's failed see

it's failed because our tolerance is uh

five percent

okay

matching

so matching details

invoice total

it's failed

let's check

90 actual expected 100 variance minus 10

percent

and tolerance is five percent

so that's

uh its work uh like greater than or less

than we have given right so it will be

um

greater than or less than we given as a

tolerance so it will be in both cases

positive way as well as uh negative way

I hope this uh helps you uh charges

matching uh in next uh episode or next

video we'll start with two-way matching

and three-way matching how it will work

and

uh

we'll see how it goes

thanks all

enjoy the day

so I'll stop here

foreign