Invoice OCR pricing issues - Vendor issues

[Staceylee]

Hello All

We have run into a situation with a specific vendor whose unit pricing is bizarre, causing way too many issues when their invoices come in, and we are constantly having to retype the unit price.  It is fine when there is one line item, but there are many instances where there are hundreds of lines, where we have to key everything manually.  Is there any way to program the OCR to change this when processing in invoice capture?  The Vendor stated they cannot change their invoices.  Example below

[KevinD]

@Staceylee when you view the Invoice in SAP Concur, what does the Invoice Total show? Also, is Invoice Capture doing all the Distributions automatically? 

[Staceylee]

When it ports over to Concur, it is showing 300 * 117.4733 = $35,241.99 when the total is really $352.42.  Invoice capture is doing all the distributions automatically.

[PoojaKumatkar]

Hi @Staceylee ,

May i know, the screenshot you provided above is vendor actual invoice OR it is from Concur?

I'm just trying to understand whether Vendor is sending unit price in different format OR Concur is capturing in wrong format. 

Also, Can you please confirm vendor is from which country? 

[Staceylee]

This is the vendors invoice, we are in Canada.  The vendors unit pricing is based on case, one hunderd in case.  In this invoice we ordered 300 units or 3 cases.  In our system we record it as a unit of 300 as each.  Concur is reading the invoice correctly and pulling over $117 but in reality it is $1.17 per unit

[PoojaKumatkar]

Hi @Staceylee ,

Your response is bit confusing for me. I am still trying to understand the scenario here.

Vendor is from Canada - Ok

Can you please answer below 2 points:

1. On vendor actual invoice, what unit price is showing? 117.4 OR 1.17

2. What unit price Concur is capturing? 117.4 OR 1.17

[Staceylee]

Ok it might be easier to show what it does when it comes in, it is reading the vendor invoice correctly, but if you look at the vendor invoice you can see if you were to multiple the Qty with the price the total cost does not come out to the actual price, so what I am wondering is with this vendor can we force it to read the unit price to be what it actually should be..

[PoojaKumatkar · Accepted solution]

Hi @Staceylee ,

After checking vendor invoice screenshot, I could clearly see that for the 1st two lines, line item total is incorrect on vendor Invoice. 

Based on quantity and unit price, Concur system is doing correct calculations. Hence, there is no issue from Concur side.

Regarding vendor invoice, I would suggest you check with vendor regarding why you are getting incorrect amounts for the 1st two lines on invoice? wherein for the 3rd, line-item total amount it is showing correct.

If this has happened mistakenly then you can ask for the corrected invoice. 

If they still say, their invoice is correct then you can at least ask for the calculation logic, how they are calculating and getting that amount total. 

Regarding your other question, unfortunately on Invoice capture screen, you cannot write any audit rule and technically it is not feasible to force the system to read unit price from any other field.

If this answers your query, then please mark solution as accepted.