Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Merge Customer & V...
Finance forum

Merge Customer & Vendor balance using Dynamics 365 Finance & Operations

(0) ShareShare
ReportReport
Posted on by pams.basilio 425

Dear D365 Expert,

Pease advise the steps how to merge the balance of Customer ABC (123456) with Supplier ABC (789789) using Dynamics 365 F&O.  I understand that I can use a manual journal entry to manually knock-off the balance from one account then transfer to another.  Is there an automated way or less tedious way to transfer balance i.e. offset or transfer balance functionality?

Company A has receivables from Customer ABC of USD 500

Company A has payable to Supplier ABC of USD 300

*Customer ABC and Supplier ABC refers to one company*

Is there a D365 function so that Company A will only have a net receivable from Customer ABC of USD 200 ?

Please advise or any reference to existing docs will be helpful.

Regards,

Pamela

Categories:
Financial Management
  • Suggested answer
    Community member Profile Picture
    Community member 2 on at
    Merge Customer & Vendor balance using Dynamics 365 Finance & Operations
    Hi Pam,
     
    MS added a new feature called customer /vendor netting, through which you can settle outstanding customer and vendor transactions with each other.
    This feature is available in the 10.0.38 version and can be enabled through feature management.
     
    Best Regards,
    Deepansh
  • MATTGUO Profile Picture
    MATTGUO 22,308 on at
    RE: Merge Customer & Vendor balance using Dynamics 365 Finance & Operations

    Hi Pam,

    Yes, your understanding is correct and you can test it in your test environment.

  • pams.basilio Profile Picture
    pams.basilio 425 on at
    RE: Merge Customer & Vendor balance using Dynamics 365 Finance & Operations

    Hi Mattguo,

    Just to reconfirm if my understanding is correct that only when there is credit note or over payment on the customer then it can be tranferred to Vendor to offset any payable balance (uinf Customer reimbursement feature)?  If the balance on the customer is Debit or Receivable, it can only be transferred using manual journal or Excel add-in as suggested by Andre ?

  • pams.basilio Profile Picture
    pams.basilio 425 on at
    RE: Merge Customer & Vendor balance using Dynamics 365 Finance & Operations

    Hi Ties Philippi,

    Thanks for the help and document provided.  

    I will read about customer reimbursement and test how can this be done in D365 F&O.  

    Regards,

    Pamela

  • MATTGUO Profile Picture
    MATTGUO 22,308 on at
    RE: Merge Customer & Vendor balance using Dynamics 365 Finance & Operations

    Hi Pam,

    By the way, if you want to transfer customer balance to vendor, the reimbursement feature can be used, but customer balance need to be negative amount, then it can work.

    If transfer vendor balance to customer, suggest creating journal and using bridge account to transfer the balance.

  • Suggested answer
    Ties Philippi Profile Picture
    Ties Philippi 960 on at
    RE: Merge Customer & Vendor balance using Dynamics 365 Finance & Operations

    Hi Pam,

    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 (or vendor if I remember correctly) 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

    Best regards

    Ties Philippi

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,622 Super User 2024 Season 2 on at
    RE: Merge Customer & Vendor balance using Dynamics 365 Finance & Operations

    Hi Pamela,

    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. Before doing these settlements, you have to inform the business partner or ask approval to settle these amounts. This company might have another opinion on the outstanding balances. E.g. there was an issue with a delivery and he is expecting a credit note.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans