Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Vendor Maintenance Bal...
Finance | Project Operations, Human Resources, ...
Answered

Vendor Maintenance Balance not matching Aged AP balance

(0) ShareShare
ReportReport
Posted on by The New Recruit

Hi all, I'm currently working to resolve an issue where the balance shown on the vendor maintenance screen is not matching what is seen on the aged ap report. I've checked the documents tab, switched the detailed viewing option from current plus open to all documents and have discovered 6 transactions that were not showing initially and doesn't show on the aged ap report as well. However when I added up all the transactions showing in vendor maintenance, the total I got was what was showing on the aged ap. Is there any way to get the balance to show on the aged ap to show in vendor maintenance.

P.S. the 6 transactions that were found does not have a status of active, is it that the vendor maintenance screen will only show active transactions as well as the aged ap report? I'm still learning the system so any advice and tips would be appreciated. 

  • The New Recruit Profile Picture
    The New Recruit on at
    RE: Vendor Maintenance Balance not matching Aged AP balance

    Update issue was resolved. Ran a database restore, rebuilt the vendor balances from documents, ran another integrity check to verify the document balances. Checked vendor maintenance and the balances are now matching with aged ap. Thanks so much for the advice.

  • The New Recruit Profile Picture
    The New Recruit on at
    RE: Vendor Maintenance Balance not matching Aged AP balance

    its the same number, nothing has changed and the balances were calculated normally

  • MARC_ Profile Picture
    MARC_ 620 on at
    RE: Vendor Maintenance Balance not matching Aged AP balance

    Did it change after you ran the integrity check?  Or same number? 

    What is your current A/P for that vendor on an A/R report?  For your calc'd balance, is that by hand?  Or via SQL?  

    Marc

  • The New Recruit Profile Picture
    The New Recruit on at
    RE: Vendor Maintenance Balance not matching Aged AP balance

    Update, so the integrity check is complete and this is the result.

    Calcd CurrBal:-2873.77 <> AP_Balances.CurrBal:-2373.77

    Calcd YtdBal: -2373.77 <> Calcd Curr Bal: -2873.77

    As you can see the balances arent really matching, really out of ideas at this point, but im still searching various forums for help on this matter.

  • The New Recruit Profile Picture
    The New Recruit on at
    RE: Vendor Maintenance Balance not matching Aged AP balance

    Hi thanks for the reply, checked in with them and did the backup, going to try to rebuild AP vendor balance using the ap integrity check. 

  • Verified answer
    MARC_ Profile Picture
    MARC_ 620 on at
    RE: Vendor Maintenance Balance not matching Aged AP balance

    They should match - that balance is kept in AP_Balances table.  You might want to reach out to your VAR and see about running AP Integrity check.  This process should only be run after you have taken a backup of your data, which is why you should work with them.  

    It sounds like you may need to rebuild your Vendor Balances, but your VAR would be the best to determine that. 

    Marc

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