FEE_CODE Error: Incoming Supplier Invoice Application Message

Hi Jeff, we are getting the same error on some of our Pagero files but it seems due to the invoice line amounts not totaling the Invoice header amount. (out by a .01 or something). We are not passing through the taxes amount so they are all 0.00.   I tested adding that balance factor in and the XML file processes through. We are on 24R1 version.   Can you confirm on your files that error if the line amounts total the invoice header amount? wondering if that’s the issue for you as well?  It’s an odd message if so and don’t understand why it would fail this early due to that.  Thanks!

Hi! First, thank you for taking time to respond. I looked at a handful of failures and this matches our issue perfectly; each was .01 off. 

You mention a ‘balance factor’ but I’m not sure what that is. Can you expand on that so I can reach out to our Finance team with more information?

This is fantastic news! Also, we’re still on Apps10, moving to 25R1 first quarter next year.

Thanks, Jeff

Hi Jeff.  I just meant, I used the failed XML file and updated the invoice row amount by the .01 and then it did work so I was able to confirm it wasn’t technically a “Fee code” issue, it was an out of balance issue but for some reason IFS is identifying the difference as a fee code error.   I asked our Finance team to go back to Pagero to ask them to ensure Invoices are balanced however given this was an issue in apps10 and still in 24R1 SU12 perhaps we need to go to IFS and ask for enhancement/fix to allow these to go through.  I also confirmed in apps9  it did allow this “out of balance” to go through application message side and would just error in the external invoice side so this is the behavior I would expect now as well.   

Error when out of balance xml file is loaded in apps9 - it passes first step of loading, but fails at creation of supplier invoice due to the lines being out of balance to the header:

Hi Rcoubrou, do you have any updates on if IFS or Pagero was able to help you solution this issue?

Also, when you manually adjusted the failed XML file how did you reprocess it within IFS? Did you use the External File Assistant or something else perhaps? Thanks for any guidance you can give!

​@tjpatterson I had logged a call with IFS and this was our findings.  You either had to blank out “accepted invoice rounding difference in invoice currency” which is set at the company level (which we wouldn’t want to do), or just make sure the supplier # is populated in the XML file / or the xml is in balance (ie: if both are not valid, that’s why the fee code error, but if one is there/correct you will get the error in the external invoice form so you can fix the issue at least).  Bottom line, Pagero should ensure the XML file lines amount balance to the invoice total amount so a non issue.

IFS:

A) Observe the reported issue in customer's testing environment with different scenarios;

-XML without the supplier code and amount mismatch when 'Accepted invoice Rounding Difference in Invoice Currency' has 0.05 (this is the situation where the issue is created with fee code error)

-XML with the supplier code and amount mismatch when 'Accepted invoice Rounding Difference in Invoice Currency' has 0.05 (the issue is not created because supplier code is present)

-XML without the supplier code and mismatched amount when 'Accepted invoice Rounding Difference in Invoice Currency' has 0.05 (need to fix in external supplier invoice window by adding supplier code then you can push through)

-XML with the supplier code and amount mismatch when 'Accepted invoice Rounding Difference in Invoice Currency' has 0.00 (the issue is not created and the user needs to tick 'Disregard Net Amount Difference' once the invoice is loaded and add invoice line as required for mismatch amount and correct it from installment information as well as discussed during the call)

Resolution is either:   

1 )Putting the supplier code in the XML with amount mismatch while putting amount to 'Accepted invoice Rounding Difference in Invoice Currency' in company set up.

2) Keep 'Accepted invoice Rounding Difference in Invoice Currency' in company set up blank and proceed with fixing it before creating invoice:  The user needs to tick 'Disregard Net Amount Difference' once the invoice is loaded and add invoice line as required for mismatch amount and correct it from installment information as well as - or in External supplier invoice fix the necessary fields to have a balanced manual supplier invoice before creation

Thanks

Rachel