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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Vendor settlements ent...
Finance | Project Operations, Human Resources, ...
Suggested answer

Vendor settlements entity

(1) ShareShare
ReportReport
Posted on by MB-16 42
Hello everyone,
 
I need to know if there is an entity to upload the vendor settlement transactions to. I tried to use "Vendor payment journal line settled invoice entity" but always faced errors. Could anyone help with this case?
 
 
  Thanks.
Categories:
Dynamics 365 Finance
I have the same question (0)
  • MB-16 Profile Picture
    MB-16 42 on at
    Vendor settlements entity
     
    The line number already existed in the uploading sheet.
     
    And for the payment journal, I created it manually, not through data entities, and yes, I am trying with unposted journal lines.
     
    Could you please tell me how this entity "Vendor payment journal line settled invoice entity"  works so I can use it correctly?
     
    Regards.
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    CA Neeraj Kumar 4,016 on at
    Vendor settlements entity
    Hi,
     
    Please add a column "Line number" in the uploaded/created vendor payment journal lines, sometimes the line numbers show in decimals.
     
    Have you created the vendor payment journal lines through data entities? If yes, please export it once to validate the data.
     
    Hope you are trying with unposted vendor payment journal lines.
    if possible, please share the data entities prepared by you with 2-3 records (alter sensitive information).
     
    Regards,
    Neeraj Kumar
  • MB-16 Profile Picture
    MB-16 42 on at
    Vendor settlements entity
     
    These are the two errors:
    "Results. The value '2,0000000000' in field 'Line number' is not found in the related table 'Vendor payment journal line'.
    Results. The value '2,0000000000' in field 'Line number' is not found in the related table 'Vendor payment journal line'.
    Results. Validation of field 'Amount settled' failed
    Results. Validations failed"
     
     "Results. Matching record for the read only data source 'VendTransOpen' does not exist."
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    CA Neeraj Kumar 4,016 on at
    Vendor settlements entity
    Hi, 
     
    What's the error you are facing in using above entity, as we use that entity to do the settlement against particular invoice.. 
     
    Regards,
    Neeraj Kumar

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,351

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 638 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans