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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / How can i contra my AR...
Finance forum

How can i contra my AR and AP balabce in D365

(0) ShareShare
ReportReport
Posted on by 452

Guys,

I have a scenario which the account is my customer and also my vendor. I would like to contra the AR and AP payment at on the month

Eg. Star International Pte Ltd

I created the customer account C0001 with balance of 1,000

I also created the vendor account V0001 with balance of 1,200

I am expecting to pay V0001 200,00 after i contra with the AR balance

In AX2012, i able to post  a transaction below:

Debit V0001  1,000

Credit C0001         1,000

Then i use the open settlement to mark the open invoices

But in D365 i am getting the error status that cannot have customer and vendor in 1 voucher

Contra-payment.png

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    in 8.1 a new parameter is introduced in GL to allow multiple customer / vendor in a single voucher.

    Pls enable it and the journal would post.

  • Dexin Profile Picture
    452 on at

    Rahul Mohta

    This new parameter really help.

    Thank you very much

  • MATTGUO Profile Picture
    22,349 Moderator on at

    There are some concerns you should know: docs.microsoft.com/.../one-voucher

  • CapsLock Profile Picture
    1,419 on at

    On top of the problems that presents having two subledger transactions in the same voucher described in the link provided by Mattguo, the ability to allow multiple subledger transactions in a single voucher will be deprecated:

    https://docs.microsoft.com/en-us/dynamics365/finance/general-ledger/one-voucher

    pastedimage1584645400753v2.png

    That's why, I wouldn't go that way to establish a process. Microsoft does not recommend do this.

    The best approach I can think of is to use bridge accounts:

    pastedimage1584645305057v1.png

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 > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans