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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to check open invo...
Finance | Project Operations, Human Resources, ...
Answered

How to check open invoices for a customer in GP

(0) ShareShare
ReportReport
Posted on by PavanBujji 208

Hi All,

I have a query on Credit Limits and how does it work in GP ? and how to check the open invoices or unpaid order for a customer ( which has not yet paid ).

I have tried with 2 invoices .One invoice is with paid order and other end is un paid order (customer needs to be paid) and posted those 2 invoices. 

I opened the Transaction by Customer console (Sales -- > Sales --> inquiry --> Transaction by customer) and enter the CustomerID and including the Work ,Open

and history documents .I got those 2 invoices in that console. How can we know that, there is one order that needs to be pending amount from the customer ?.

2019_2D00_10_2D00_04_5F00_1739.png

Can any one explain me regarding on this ?.

Thanks ,

Pavan G.

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Craig Fuller Profile Picture
    Craig Fuller 411 on at
    RE: How to check open invoices for a customer in GP

    I'm not sure. What happens when you look up one of those invoices in the Transaction by Document? Can you see it there and zoom into the document itself? If everything looks normal you may want to submit a new question regarding this so an experienced Accounts Receivable person can possibly provide an answer.

  • PavanBujji Profile Picture
    PavanBujji 208 on at
    RE: How to check open invoices for a customer in GP

    @Criag,

    I have unposted invoices are there for that customer. But it will not come under the WORK Status. Why?.

  • Craig Fuller Profile Picture
    Craig Fuller 411 on at
    RE: How to check open invoices for a customer in GP

    Unposted documents saved in a batch will appear in WORK. In your example both were posted so they appear in OPEN. When a document is fully paid and Paid Transaction Removal is run it will move to HIstory.

    Here is a more detailed summary. community.dynamics.com/.../work-open-and-history

  • PavanBujji Profile Picture
    PavanBujji 208 on at
    RE: How to check open invoices for a customer in GP

    @Craig,thank you for your answer. You have answered my question.

    I have another doubt in this.

    When will i get WORK and HISTORY statuses in that console?. i have already posted that two invoices which are shown in the above window.

    Thanks in advanced,

    Pavan G.

  • Verified answer
    Craig Fuller Profile Picture
    Craig Fuller 411 on at
    RE: How to check open invoices for a customer in GP

    Kindly click the "Yes" link if I successfully answered your question.

  • Suggested answer
    Craig Fuller Profile Picture
    Craig Fuller 411 on at
    RE: How to check open invoices for a customer in GP

    If I'm understanding your question correctly, to see unpaid or remaining balances for an invoice in that window you need to expand the scrolling window using the buttons on the right (circled in blue). Then for each scrolling window record there will be 2 rows instead of one and you want to look at the second row in the Amount Remaining section.

    pastedimage1570632646054v1.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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 841 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 753 Super User 2025 Season 2

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 566

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans