Skip to main content

Background

Our Finnish company uses Invoice Payment Reference Numbers.

Company/Invoice tab General

For customer invoices, we have enabled the “RF Finnish Modula 10” as Cust Inv Creation Method.

In order to get validation of supplier’s payment references when uploading supplier invoices, we have enabled “Used” as Supp Inv Validation Method.

Issue

When we receive invoices from our suppliers (via Pagero), we will get a validation of the payment reference in the upload. This works normally quite well with domestic suppliers, however, our foreign suppliers’ invoices are stopped with load error "Bank Reference has invalid format!”

This is due to the fact we are not receiving a correct payment reference by them (which is not surprising, they are using the reference modula for whatever country they are located in), error relates to the field ncf_reference / EpiReference being incorrect and it seems the supplier reference validation is using the customer reference validation method.

Is there a way to ignore certain suppliers from validation of this field?

I have noticed that you can setup Supplier basic data (Supplier/Invoice tab General) and indicate Mandatory Payment Reference at Invoice Entry, An option to resolve this issue would then be turn off the general supplier payment reference validation method on company and instead indicate all domestic suppliers MUST have this field at supplier invoice entry.

My issue is that I am not sure that will still force the supplier using this to use a specific reference method for the supplier payment reference validation, just that the field may not be empty.

 

 

Hello @LOVISATS 

Turning off on company level and activating Mandatory Payment Reference on supplier level would not resolve your problem I think.

Basically, company level setup checks whether entered payment reference is according to IFS rules ( I don't know exactly the rules but I am working on this nowadays, soon I will find out).

So if you just set the field on company as Not Used system will not validate against its rules. 

 

 

So here is question what do you really need to have? Do you want to have only payment reference entered and not validated, then you can change as you wrote.

But if you want it to be validated then you must have it set to Used. And for foreign suppliers, you can check Do Not Validate Payment Reference checkbox on supplier level and see if your issue is resolved.

 

 

Hope this helps


Hi @Furkan Zengin 

Your proposal seems to match our needs, however we are running IFS 10 UPD18 and that version, the option (Do Not Validate Payment Reference) does not exist unfortunately as can be seen in below screenshot.

 Which version is your screenshot from? 


Hello @LOVISATS 

I have reviewed the function Do Not Validate at Invoice Entry. It is part of localization functionality called Use Automatic Generation of Official Invoice Number. That might be reason you don’t have it.

 

In this case, better you will uncheck on company level and activate on supplier level. You will not validate the payment reference but you will be able to manage as you want.

Hope this helps


Reply