Skip to main content

Notifications

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

Inconsistency between Accounts payable and Vendor balance

Posted on by 49

Hi,

I am looking for a bit of an explanation for the below, I am sure its probably ok but it appears inconsistant:

In the Chart of Accounts and Aged Accounts Payable Report, the Vendor balance shows as a negative figure but on the Vendor ledger the same amount appears as a positive entry.

I would expect to see consistency accross all three, is this just the way Business Central displays the information or is there something in the set up we need to adjust.

We are currently on version 20.4 and using OnPremise.

Thanks

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Inconsistency between Accounts payable and Vendor balance

    Yes the Vendor List shows positive. I agree this is inconsistent with all the other displays.

  • Jake2023 Profile Picture
    Jake2023 49 on at
    RE: Inconsistency between Accounts payable and Vendor balance

    Hi Kim,

    Thank you for coming back to me, I think I may have miswrote this, the Vendor Ledger entries are correct showing negative (the same as the Chart and Reports)

    pastedimage1673283546519v2.png

    however the list view on the Vendors list shows a positive

    pastedimage1673283517722v1.png

    This is what is causing the confusion when looking at the vendor list Overview versus the Chart/Reports

    Thanks again for you time on this

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Inconsistency between Accounts payable and Vendor balance

    It sounds like you have a customization. Invoices show as negative in the vendor ledger by default with credit memos being positive.

    Maybe some screenshots would help us.

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 Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

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,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans