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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Missing Invoices

(0) ShareShare
ReportReport
Posted on by

The SmartList shows about 20 invoices open with no payment applied, however I am not able to locate them in the select checks window.

How do I investigate and resolve this issue?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    Hi,

    It's possible that the parameters you have entered in the Select Checks window excludes those invoices. It's a long shot, but it's possible. What I would do is to go to the Edit check batch window and see if anything shows for that vendor. You know that there aren't any query settings that could exclude the outstanding invoice. If you see one of them listed and click on it, you may get an error message that tells you the vendor or document is on hold. The select checks query wouldn't select these invoices and SmartList doesn't filter them out.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    on at

    How do I update these invoices using SQL?

  • Tami Farrelly Profile Picture
    5,080 on at

    maybe they arent posted?

  • Community Member Profile Picture
    on at

    these invoices are showing open with no payment applied, however not able to locate them in the select checks window

  • Tami Farrelly Profile Picture
    5,080 on at

    yes...but are they "POSTED"

  • Community Member Profile Picture
    on at

    How do I check using SQL if they are posted or not?

  • Community Member Profile Picture
    on at

    I am not finding these transactions in the following table and it seems that all invoices were posted.

    PM10000

    PM10300

    PM10400

  • Tami Farrelly Profile Picture
    5,080 on at

    when you say invoices??

    how are these invoices generated?

    are these from a vendor?

    or for a customer?

  • Community Member Profile Picture
    on at

    Could someone please help me with this issue?

    I have invoices that are showing open with no payment applied, however not able to locate them in the select checks window

  • Tami Farrelly Profile Picture
    5,080 on at

    is this in purchasing or sales

    maybe you should define the question

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans