Electronic reporting - Payment model - bank file for vendor generate payments error: The value 'null' was found where an instance of an object 'valueSource' was required.

(0) Share

Report

Posted on by Lexicon_

141

I have imported the following 3 XML files into Electronic Reporting of this client (Client B):

Payment-model.xml
ANZ-Direct-Credit-Service-_2800_AU_2900_.xml
8030.CBA-Direct-Credit-Service-_2800_AU_2900_.xml

I don't have a login with this client (Client B) that can connect to Microsoft's Global repository, so I have had to export the XMLs from another Client A and import it into Client B. Client A got them imported directly from Microsoft's Global repository with no issue, and these files are unchanged from Microsoft.

Across both clients, every setting that I can set have been made identical. However they don't work the same:

In Client A the process works fine. In Vendor Payment Journal, click Generate Payments, click through two pages of dialogue, and get a .txt bank file.

In Client B, i do the same but I get an error instead of a .txt bank file. The error is:

Payment generation process information

Evaluating expression for path 'model/Payments'.

  The value 'null' was found where an instance of an object 'valueSource' was required.

Evaluating validation binding of format component PaymentFile/Content.

An error occurred during the 'Format mapping' run. For more information, contact your system administrator.

Evaluating validation binding of format component PaymentFile/Content.

  Error while evaluating expression for path 'model/Payments'.

  The value 'null' was found where an instance of an object 'valueSource' was required.
The payments cannot be generated

I have checked everything in Client B's environment. The vendor has a valid bank account. The method of payment is set correctly. The payment status is correct. The Method of Payments setup was configured correctly. Electronic reporting parameters are identical across the 2 clients. The imported configs are published and not in draft.

Does anyone have any insight please?

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Are the vendors and their bank accounts and transactions setup identically?

Please check especially that the open invoices that you want to pay have the correct method of payments and company + vendor bank accounts selected in the vendor payment file.

If that is the case and if everything looks absolutely identical, reach out to a developer for some help to do some additional testing and debugging what might be different here.

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

Lexicon_ 141 on at

Like (1)

Report
Copy link

Link copied!

Hi Ludwig,

Thank you for looking at my post!

My team doesn't know how to fix it but we made another environment within Client B and it magically works there! The environments are exactly the same version and update so this is very odd. Don't know why this happens, but we don't care anymore LOL. We are just going to override the misbehaving environment with the working environment and pretend this never happened.

I think it's very much related to this difference between the two Clients: community.dynamics.com/.../1182762

Client B was missing a "processing date" parameter that Client A has. Perhaps the "null" value that the error refers to is this date field. The new environment we created in Client B does show this parameter and everything works. We did not investigate what caused the parameter to show or hide, but since we now have a working environment, we will just move forward with that.

Was this reply helpful? Yes No
Birgir Gunnlaugsson 5 on at

Like (0)

Report
Copy link

Link copied!

Hi all, I solved this problem by re-importing the Payment Model from the Microsoft Global repository. After import the problem vanished.

Was this reply helpful? Yes No