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 Invoice and Check Transaction

(0) ShareShare
ReportReport
Posted on by 42

I have a situation, I can view the PO and Receipt in the PO screen.  The check was processed but neither the check or the invoice is visible in any of the reports or screens.  It is as if it never existed.  I need to void the check to reopen the invoice for payment but it is not visible.

Has this happened to anyone and how did you deal with it.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    twelvestrikes Profile Picture
    3,657 on at

    Hi Janelle

    This sounds to me like you are trying to track the invoice and payment from the PO side of things and what I think has happed is that the invoice was entered into Payables transaction entry and not Enter/Match Invoices.

    Payables transaction entry is used for non PO invoices and Enter/Match Invoices is used to enter invoices that pertain to a PO.

    You have 2 options to correct this. One would be to void the cheque and the invoice and then re-enter in the correct place or leave the transaction and do a return on the PO receiving to clear the double entry.

    Here are the instructions for what you asked:

    You can void the cheque by going to Transactions > purchasing > Void Historical Transactions

    (assuming the cheque was fully applied to the invoice and is now in history).

    Select the cheque and then void.  Make sure to pay attention to the void date and posting date.

    Once you do that, the invoice that the payment was applied to will be returned to the open files.

    go to Inquiry > purchasing > transaction by vendor

    Enter the vendor and then search for the open invoice you are looking for.

    If you highlight the invoice and then drill into it, you can determine if the invoice was entered into payables transaction entry or into Enter/Match Invoices.

    If it was entered into payables transaction entry, then you need to void the invoice.

    transactions > purchasing > void open transactions.

    Then you can go an re-enter the invoice in the Enter/match Invoices window and then apply to the receiving. Note that you cannot reuse the same invoice number so you may need to add another character to it.

    Then you can issue another cheque against the newly entered invoice.

    There is a new setting in Payables Management Setup called Warn if Vendor has Existing Purchase Order which would help stop this type of issue from occurring if you don't have it enabled, it would be worth enabling it.

  • Janelle Bartholomew-Miller Profile Picture
    42 on at

    Thanks for your response.  My issue is though the check was cut it is not available to be voided.  There is no trace on the system for this.

  • twelvestrikes Profile Picture
    3,657 on at

    Hi Janelle

    Was the cheque issued using payables cheque processing, so basically a system cheque? Or was this cheque manually issued?

  • Janelle Bartholomew-Miller Profile Picture
    42 on at

    Hi Jeffrey

    It was a system cheque.

    Janelle

  • twelvestrikes Profile Picture
    3,657 on at

    Hi Janelle

    First off I would check the SQL tables to see if the transaction even exists.

    Select * from PM30200 where DOCNUMBR = 'xxxxx'

    Where xxxx represents the cheque number.

    If the transaction is here you can verify which documents the cheque has been applied to

    Select * from PM30300 where APFRDCNM = 'xxxxx'

    Where xxxxx represents the cheque number

    If the transaction is not in the PM30200 try seeing if it is still in the open table

    Select * from PM20000 where where DOCNUMBR = 'xxxxx'

    Where xxxx represents the cheque number.

    If not in the above table, has the cheque been posted?

    Select * from PM10300

    If the above returns nothing, then I would say that the transaction does not appear in the system.

    As another thought, if you have multiple companies, have you checked to see that maybe the invoice and payment were recorded in a different company to the one where the PO was issued from?

  • Janelle Bartholomew-Miller Profile Picture
    42 on at

    Thanks Jeffrey.  I will investigate and get back to you.

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