Hi there,

I found a topic with a part of our problem (https://experience.dynamics.com/ideas/idea/?ideaid=fd3a8318-bd60-eb11-8fed-0003ff45c6cd#) and commented there, but there was no reaction. So i decided to open this "idea" myself.

Idea description

It would be great if the Bank Code Field in the Purchase Invoice could be filled automatically when the QR-IBAN or IBAN from the QR-Bill file matches the IBAN/QR-IBAN in the Vendor Bank Account, i.e, when there is a match, the field could be filled automatically.

Our current state and why it needs to be done

The current behavior leads to failures in accounting (i will explain it more detail below). In my opinion an ERP-System should be interested to not implement functionality what leads to failures in accounting. To be said: maybe our system is somehow wrong configured, but our implementation partner gave us the information that this functionality is not supported. ere is what we got as answer from our implementation partner (translated from german to english):

We have analyzed the situation. The standard solution is that only the preferred bank code is always taken into account on the purchase invoice screen. If none preferred bank account code is stored for the vendor, it is not filled and the invoice is posted without a bank code if it is not entered manually. However, if you enter the invoice in the purchase entry journal, the bank details from the QR code are taken into account, regardless of what is in the preferred bank account code.

As you see, he told us we should use "Purchasing entry journal" (i dont know the correct name of it in english) instead, because there it seems to work that Dynamics automatically sets correct bank code. Due to the fact (regarding our implementation partner) "purchasing entry journal" does not support an approval process, we can not use that way.

Problem 1 - preferred bank account code is always used

We can set a preferred bank account code on a vendor. When we scan a QR-Bill, IBAN is set correctly in purchase invoice. But instead to set the correct corresponding bank code, it sets the preferred bank account code.

Effect: user does not recognize a wrong bank code is used and payment is done on wrong IBAN. This has already led to problems with vendors. As i mentioned above - with this functionality Dynamics supports/produces actively failures! To be honest, in my opinion this problem is more a bug than anything else and it should be easely fixable when it would automatically set corresponding bank code or throw an info message if no corresponding bank account code is defined on vendor. Futhermore, i do not understand why it should work when using "purchasing entry journal" - but it does not when using "purchase invoice". It's somehow inconsistent functionality inside Dynamics itself. I would really appreciate if there is a clarification about that behavior. Do you know about that problem?

Problem 2 - it is not user friendly

As the owner of idea (https://experience.dynamics.com/ideas/idea/?ideaid=fd3a8318-bd60-eb11-8fed-0003ff45c6cd#) Laeticia Cunah already mentioned, it's absolutely a waste of time if user has to set it manually. Additionally, it would prevent user errors due to selecting wrong bank code manually. In my opinion a modern ERP-System should support users instead burdening additional work. 

Solution

As already mentioned Dynamics should try to set bank code automatically in purchase invoice if a QR-Bill is scanned and therefore IBAN is known. If on vendor a corresponding bank code with that specific IBAN is missing, bank code should be empty and an info message should be shown. Preferred bank account should only be used if there is no IBAN provided!

I would really appreciate a clarification on that behavior. Our implementing partner advised us to open an "idea" in here. For me this is not really an idea, it is a clear misbehavior when preferred bank code is set instead corresponding bank code to IBAN.