Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Community member 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
 
  • Suggested answer
    Community member Profile Picture
    Community member 4 on at
    Consolidate vendor and customer balances in Dynamics
    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.
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,703 Super User 2024 Season 2 on at
    Consolidate vendor and customer balances in Dynamics
    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
    Fasih Profile Picture
    Fasih 392 on at
    Consolidate vendor and customer balances in Dynamics
    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\

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans