Skip to main content

Notifications

Announcements

No record found.

Business Central forum

OCR Data Service Issues

Posted on by

Hi, I was wondering if someone could help me out with some errors I'm getting with receiving the documents with the OCR Service. 

I am expecting a new vendor to error out when I receive the document back into NAV. When I correct the OCR data and send back the vendor name or Map Text to Account for the vendor name it goes to the next error which is the mapped currency is not found in the table. I'm using CAD for Canadian currency. The document I'm using always is analyzed with the currency code as being CND. I'm not sure where readsoft is getting this, it is not indicated on the document at all. 

I have tried correcting the OCR data and sending it back to readsoft and running the document again starting with the 'new from file' and then 'send to OCR' service. It always returns the same error because CND is returned on the analysis instead of CAD for currency code. 

I also tried changing the settings on the lexmark account to allow manual processing of document on the documents that have an error, corrected the currency code at readsoft but that did not work either. 

Any insight into where CND would be coming from as it's not a standard currency code anywhere. I may have accidentally used that when I first setup the service on readsoft. Maybe there is a way to reset the learned data on readsoft. I have not see that. 

Thank-you. 

Categories:
  • RE: OCR Data Service Issues

    Thank-you Chris!      

  • Verified answer
    Chris Bulson Profile Picture
    Chris Bulson on at
    RE: OCR Data Service Issues

    Hello,

    I've been playing with this today and have figured out that once it "learns" a mistake... it doesn't like to Unlearn it.  I'm assuming you accidentally corrected the first invoice to CND and now it's going to use that for every invoice that matches.

    I've purposely corrected one of my Invoices with Bad data and now no matter how many times I correct it, it always comes back with this incorrect data.  You can flag your documents for manual edit on the store-nav.readsoftonline.com/subscriptions page... under Configure.  This allows you to go in and manually correct the document.  I haven't been able to figure out how to get it to forget the bad data though.  May need to get Lexmark support to do this.

    Manually correcting the document as I described above does allow you to fix the Total Amount\Tax issue as well.

    Thanks,

    Chris

  • RE: OCR Data Service Issues

    I tried another document from another vendor. It didn't give me the currency issue. However it doesn't seem to like the before tax total being different than the after tax total.

    The total amount 1,579.79 on the created document is different than the total amount 1,658.78 in the incoming document.

  • Chris Bulson Profile Picture
    Chris Bulson on at
    RE: OCR Data Service Issues

    You've also tried to correct the document with Currency CAD and send it back?  I believe it should be pulling the currency from the Vendor... unless it thinks it's reading it off the Invoice.

    Are you able to manually walk through and enter the Invoice for this Vendor without using the OCR service?  Just to make sure there isn't a setup issue.

    Thanks,

    Chris

  • RE: OCR Data Service Issues

    When I receive the document back from the service I get this error message. "The field Currency Code of table Purchase Header contains a value (CND) that cannot be found in the related table (Currency)" I corrected the OCR data and sent it back as blank for currency. I'm not sure why this is returning CND no matter what I do.

  • RE: OCR Data Service Issues

    Hi Chris,

    I did put CAD in the Currencies window. I removed it this morning. The default currency shows on the G/L setup dialog as CAD. On the vendor card. The currency code is blank. I will run the document again to see if that makes a difference. Any idea where it is pulling the CND from when I receive the document?

  • Chris Bulson Profile Picture
    Chris Bulson on at
    RE: OCR Data Service Issues

    Hello,

    Did you setup a currency in the 'Currencies' window in Financials?  If you're on a Canadian instance of Financials, it will automatically use CAD as the default currency.  You do not want to set this up as we've seen some people do.

    If you navigate to that vendor card in Financials, under the 'Invoicing' section you can select to 'Show More'.  Here you are able to setup a Currency Code and it should be blank if you want it to use default (CAD).

    Thanks,

    Chris

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans