Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Easy way to see project invoices payment status

(0) ShareShare
ReportReport
Posted on by 5

Working as a project manager I would like to have a report or grid where I can check the payment status of invoices per project.

What I do now is: Project X - invoice Journals - select 1 of may invoices - transactions, when the balance is €0 I know that the invoice is paid, if it equals the invoice amount the invoice is apparently not yet paid.

There must be a grid or report where I can see all invoices of a specific project and their according payment status.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,904 Super User 2024 Season 2 on at
    RE: Easy way to see project invoices payment status

    Hi Clueless,

    For each project invoice, there is a customer transaction. These transactions contains the information about remaining amount and has settlement details.

  • Clueless Profile Picture
    Clueless 5 on at
    RE: Easy way to see project invoices payment status

    Hi Andre,

    I use Excel as my source to create custom reports, therefore I tap into our Dynamics Database with an power query and pivot this data for my own liking.

    I already found that the table projectposttransviews contains all the posted project invoices. but it does not contain the payment status (or balance) of these invoices. I guess the payments are in a different table.

    Does anybody have a clue which table I need to access and holds the balance/payment status of each project invoice?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,904 Super User 2024 Season 2 on at
    RE: Easy way to see project invoices payment status

    Hi Clueless,

    Some customers do have a small customization to have a new menu item in the menu and show all customer transactions. For sales order and free-text invoices there is a list page for open customer invoices. You can also consider a customization for a similar list in the project and accounting management menu,  

  • Clueless Profile Picture
    Clueless 5 on at
    RE: Easy way to see project invoices payment status

    Hi Andre,

    I didn't know about this grid and although it shows exactly what I wanted I think it is not very user-friendly and/or very accessible.

    but thanks for your help.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Easy way to see project invoices payment status

    Hello Clueless,

    There is nothing available out of the box that fits your requirement.

    You can check things in AR as Andre mentioned but that would require you 'navigating around' rather than seeing things directly at the project level.

    If the workaround is not feasible for you then you have to consider making a system modification.

    Best regards,

    Ludwig

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,904 Super User 2024 Season 2 on at
    RE: Easy way to see project invoices payment status

    Hi Clueless,

    It would be an option to go to Account receivable > All customers > Transactions. Then you can set an option to show only open transactions. These transactions do have information like invoice number, invoice amount, settled amount and open balance.

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

Product updates

Dynamics 365 release plans