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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Consolidate vendor and...
Finance | Project Operations, Human Resources, ...
Answered

Consolidate vendor and customer balances in Dynamics

(0) ShareShare
ReportReport
Posted on by CU27040926-1 4

Consolidate vendor and customer balances in Dynamics

Hi ca any one help me on this please 
 
How to consolidate the Vendor as customer as consolidate account statement
 
Please help me on this issue
 
I have the same question (0)
  • Suggested answer
    Fasih Profile Picture
    Fasih 416 on at
    Hi,
     
    There is no automatic process to settle balances between a customer and vendor with the same party ID. Possibly, you can create an overview in Excel, then use the Excel Add-in to create journal lines. But assuming the vendor and customer are related via the global address book you can see the outstanding balances on total via the balance function on a customer this includes the related vendor transactions as well.

    For transfer of the transactions, you could look into customer reimbursement, this basically transfers the customer (credit) transactions to the related vendor account.

    docs.microsoft.com/.../reimburse-customers\

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,849 Super User 2026 Season 1 on at
    Hi,
     
    What exactly do you mean with consolidation? Do you need only a report showing all transactions from one party being both a customer and vendor? Or do you need to settle transactions and keep the balance on either the customer or vendor?
  • Suggested answer
    CU27040926-1 Profile Picture
    CU27040926-1 4 on at
    Hi Andre,
     
     
    Thanks for your response, 
     
     
    I need both ways to test my scenarios
     
    Con you please explain how to set for this.  
     
     
     
     
    Thanks,
    Nagendra.

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 463 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 423 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 392

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans