Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Reconciliate payment from a customer who is also a vendor

(1) ShareShare
ReportReport
Posted on by 2

Hello,

I have the following case. A customer is also a vendor.

On the contactcard I 've made also a vendor. So to the contact is linked to a vendor and a customer.  I have posted a sales invoice for this customer and I've posted a purchase invoice for the vendor.  Say the sales invoice is 100€ and the purchase invoice from the vendor is € 60. So the vendor pays € 40. When I receive this in my BankGiro journal how can I easily reconcile the sales invoice and the purchase invoice with this payment...

In the Bank Giro journal I have to choose cutomer or vendor to reconcile..

What is the best way to go about this in Business Central?

Thank you in advance!

  • CBurgess3537 Profile Picture
    CBurgess3537 132 on at
    RE: Reconciliate payment from a customer who is also a vendor

    Yes

  • BrutusG Profile Picture
    BrutusG 2 on at
    RE: Reconciliate payment from a customer who is also a vendor

    Thank you for your answer!

  • BrutusG Profile Picture
    BrutusG 2 on at
    RE: Reconciliate payment from a customer who is also a vendor

    Thank you for your answer!

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reconciliate payment from a customer who is also a vendor

    Brutus,

    The solution I give my customers is using a General Journal entry. In your example, you have the situation where you have an outstanding customer invoice, and an outstanding purchase invoice for the same company. (i.e. the company is both a customer and a supplier). In this scenario you may come to an agreement that instead of you paying the outstanding purchase invoice, and them paying you the outstanding sales invoice, its more efficient to “contra” the entries off. In other words, raise a Sales Credit document to apply to the Sales Invoice they owe you, and raise a Purchase Credit document to apply to the Purchase Invoice you owe them. With Dynamics 365 Business Central there’s a way to raise both of these entries in one single journal rather than creating separate Sales and Purchase Documents.

    Here I have an outstanding Customer Ledger Entry for £100.00 owed to me by a customer who is also my supplier.

    pastedimage1620742482704v9.png

    And here I have an outstanding Vendor Ledger Entry for (£100.00) that I owe to the same company.

    pastedimage1620742261500v2.png

    We have agreed that rather than pay each other we’ll “contra” the entries off. To create the contra I’m going to use the “General Journal” shown below:

    pastedimage1620742261501v3.png

    In this one journal entry I’ve left the “Bal. Account No” blank (see highlighted above) as I’m balancing a Customer entry (first line) to a Vendor Entry (second line).

    In the first line I’ve selected “Customer” as the “Account Type” and an “Amount” of -100.00. This will create a negative customer ledger entry I can apply to the outstanding invoice. I can apply this to the outstanding invoice from within the journal by selecting the line and clicking “Process > Apply Entries”

    pastedimage1620742261501v4.png

    I can then apply in the usual way:

    pastedimage1620742261501v5.png

    For the second line in the journal I’ve selected an “Account Type” of “Vendor” and entered an amount of 100.00 which balances the first line. This will create a positive “Vendor Ledger Entry”. I can also apply this line to the outstanding Invoice by selecting “Process > Apply Entries” in the same manner I applied the first entry.

    Now if I click preview postings I can see exactly what is going to post:

    pastedimage1620742261501v6.png

    As shown above when I post this journal I’m going to get one Customer Ledger Entry and one Vendor Ledger Entry. I also get additional Detailed Customer and Vendor Ledger entries as I applied the transactions as well.

    If we drill down to the “G/L Entries” we can see a Credit to the Debtors account and a Debit to the Payables account.

    pastedimage1620742261501v7.png

    Now you can post the Cash Receipts Journal for the 40 Euros against the remaining balance of the Sales Invoice.

    Hope this helps.

    Thanks,

    Steve

  • Verified answer
    Gavin Profile Picture
    Gavin 2,341 on at
    RE: Reconciliate payment from a customer who is also a vendor

    Hi,

    This sounds like a contra scenario. I wrote one way this can be done in this blog post thedynamicsexplorer.com/.../


    So in your scenario you would first post the payment for €40 and apply it to the customer invoice. Next you would create the journal as per the blog above.

    Maybe others will have other ideas that could help as well.


    Hope it helps.

    Thanks

    Gavin

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 Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans