Limit and Currency Audit Rule

[kkalimeri]

Hello ,

I am trying to create an Audit Rule about an expense limit. The user's currency is Euro, but the Audit Rule I want to create it has to be in UK Pound. My Audit Rule contains the command "Greater Than 130GBP", but the system triggers even if I insert exactly 130GBP in my Expense Report. 

Can someone help me with this issue?

Thank you in advance,

Konstantina

[KevinD]

@kkalimeri hello there. Could you kindly take a screenshot of your audit rule and all the conditions you have set up, please? 

[kkalimeri]

Hello!! I am so sorry for the delay, I was out of the Office. So, I don't really know how to upload the screenshot, but I describe to you the Audit Rule down below. I forgot to mention that I wanted this Audit Rule only for those Cities that I inserted and that I have created other Similar Audit Rules but in Euros and they are perfectly working. I hope I helped.

Thank you for your time,

Konstantina

Data Object/Operator                    Field/Value

Employee                                            Employee Group
Is Not Blank
Value

And

Entry                                                    Expense Type
In
Value                                                    Hotel;Breakfast

And

Entry                                                     Transaction Type
Equal
Value                                                     Itemized entry on an expense

And

Entry                                                      Amount-Daily Total (multiple expense types)
Greater Than
Value                                                      130.00 GBP

And
(
Entry                                                       City Of Purchase
Equal
Value                                                       Southampton, UNITED KINGDOM

Or

Entry                                                        City Of Purchase
Equal
Value                                                        Manchester, UNITED KINGDOM

Or

Entry                                                         City Of Purchase
Equal
Value                                                         London, UNITED KINGDOM
                                                                                                                               )

And

Entry                                                           Currency
Equal
Value                                                           UK,Pound Sterling

[KevinD]

@kkalimeri I've sent you a private message here on the Community. Click the little envelope icon up near your name here on the Community. 

[BIHRSAS]

Hello @KevinD ,

We have the same issue, our Audit Rule contains the command "Greater Than 130 CHF", but the system triggers the exception even if we insert exactly 130 CHF in the Expense Report. 

The user's currency is Euro. 

Can you kindly help us to fix the issue ? 

Thank you in advance. 

Bihr SAS 

[KevinD]

@BIHRSAS to test the rule, you need to test with a user whose currency is CHF. The reason the rule is firing, is because you have an active rule for Germany that flags the expense report if the daily total is more than 50EUR. When you enter 130CHF, it converts the amount to the currency assigned the user. In this case, Euros. Since 130CHF converts to over 130EUR, the rule will fire because it exceeds the 50EUR limit you set in the German audit rule. See screenshots below. When creating currency related audit rules, it always evaluates the currency assigned to the user, not the currency the purchase was made in.

[BIHRSAS]

Hi  @KevinD ,

I'm sorry for my late answer, thank you so much for your quick help. 

In fact, the issue comes from the currency assigned to the User. 

We have changed the rule by setting the new expense limit in EUR and it works. 

Once again thanks so much and have a nice day. 

Bihr SAS 

[KevinD]

@BIHRSAS great to hear. Glad I could help.

[PoojaKumatkar]

Hi @kkalimeri ,

You can ask user to change currency from EURO to GBP at the time of hotel expense entry creation which will avoid currency conversion issue and then your audit rule will validate whether amount is exceeding 130 GBP. 

This must be happening because of exchange rate which updates on daily basis.

Hope this would resolve your issue.

Regards,

Pooja