Skip to main content
Question

Payable Incoming Documents - Currency Issue Bills


Forum|alt.badge.img

Good day,

We just started using the Payables Incoming Document feature.  It works fine in my US tenant however, when I tried to demo it in the UK/EUR instance for other currency (GBP/EUR) I get the below message.  The vendor profile is correct in the currency types.

Any ideas or solution on fixing this issue.  It the currency rate is defined however, could this be a date issue on the currency effective date?  

Thank you

@Evan G 

 

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • May 10, 2023

Hello @EvanG ,

I wonder if the problem is that the currency on the bill shown above is not USD. I noticed in the Help for Incoming Documents screen, a limitation highlighted pink:

Does “The locale of a file should be en-us” mean that non-US currency documents cannot be recognized in the version you are using?  The Help segment I posted above is from version 2022 R1


meganfriesen37
Captain II
Forum|alt.badge.img+11

@Laura02 - it does work in Canada for both CAD and USD bills, but our bill formats are generally pretty similar compared to the US.  I know when it first released it was specifically restricted to Canada and the US, but I thought that was more around where the data was being processed?

@EvanG The fact that the error is around the rates makes me think that you may not have an exchange rate type and/or the correct conversion direction.  Acumatica is a bit picky if you’ve got rates going one way (GBP to EUR) but not the other direction (EUR to GBP).  Generally I’ve always found it easiest to just set up automatic rate refresh schedules to pull the rates going both directions on a regular basis to avoid this.


Forum|alt.badge.img
  • Varsity I
  • May 10, 2023

Good day,

I added the local to Acumatica.  The file was recognized with no issue.  Dates were fine.  I am not sure what it means by file locale?  We get ap bills from all over the world.  China, UK, Europe etc.  Is an issue with the PDF.  The file is getting recognized with no issue. I still think it is relate to the currency issue?  Does this product only work with USD?  Please ask Acumatica Support. 

 

@Laura02 Please ask Acumatica Support.  I have three tenants Brazil, Mexico and UK/EUR.  Currency seems to be to the issue.  I tested creating a bill not file Recognition.  Recognition works fine.  it is when we try to created the bill is the issue.

Thank you

Evan

 


Forum|alt.badge.img
  • Varsity I
  • May 10, 2023

@meganfriesen37   Hi Megan,  I have failed in setting up the automatic refresh.  We have USD as the based tenant and conversion set up from USD to GBP and the other way and USD to EUR and  the other way.  Do I need one for GBP to EUR?  Have not thought that was needed since are financial are in USD.

Can you provide the automatic refresh directions?  Also, any thoughts on setting the cross currency rates with Acumatica.  We don’t convert this way normally.  I would like to get this product work.

Thank you

Evan


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • May 11, 2023

Hello Evan,

I was able to update your Automation Schedule (I removed the Limit number and fleshed out the Conditions and Filter tabs to match the schedule that is working in your US tenant).  It’s now working and all currency rates are up-to-date in both directions.

I noticed you have two documents awaiting recognition in AP Incoming Documents screen. One Vendor is denominated is EUR and the other is GBP, while the base currency of the tenant is USD.

The help is vague; as noted above. I think the situation might be: we can’t create a bill via Document Recognition for a vendor whose currency denomination does not match base currency.  I’ve opened an Acumatica case to request clarification and further assistance.

 

Laura


Forum|alt.badge.img
  • Varsity I
  • June 1, 2023

Good day,

The issue is still open.  The ACM support case has now been escalated to Level 2.

When we can a resolution I will update.

@EvanG 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings