web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

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) ShareShare
ReportReport
Posted on by 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)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

  • Verified answer
    Lexicon_ Profile Picture
    141 on at

    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.

  • Birgir Gunnlaugsson Profile Picture
    5 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans