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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payables Invoice showi...
Microsoft Dynamics GP (Archived)
Suggested Answer

Payables Invoice showing open, but is fully applied

(0) ShareShare
ReportReport
Posted on by Community Member

I'm sure this has been answered somewhere in the forum, but I could not find anything at my level of the issue.  I have a payables invoice that is showing open when doing an inquiry.  There are two payments applied to the invoice, both of which add up to the total of the invoice, and both payments are in history.  We have run checklinks as well as tried a reconcile on the vendor, but nothing is moving the invoice to history, which it should be.  Is there any other way to fix this invoice and get it into history, without fixing it in the SQL tables?  I don't want to do that if I don't have to. 

Thank you!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    have you run the 'remove paid transaction' process?

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    I don't know of a way short of voiding everything and starting over to fix this in the user interface.

    I've seen this happen before and it's just one of those burps that happens. The SOP reconcile has a cool utility that will move completed documents to history, sadly Payables does not. There's really no elegant way to fix this other than updating the sql table. First, when you look up the transaction in the inquiry window, what is the balance in the Unapplied field? If it isn't zero, then there's your problem.  With your transaction selected, zoom back on the Unapplied Amount and make sure that your two payments are listed.  If they are, then you need to change the amount in the CURTRXAM field in the CM20200 table to zero. After the change, run Check Links on the Payables Transaction Logical File. The transaction should then be moved to history.

    Try it on your test company first.

    Kind regards,

    Leslie

  • L Vail Profile Picture
    L Vail 65,271 on at

    Deanne,

    I think she's dealing with payables.

    Leslie

  • Community Member Profile Picture
    Community Member on at

    oops - my bad

  • L Vail Profile Picture
    L Vail 65,271 on at

    Now worries, I do it all of the time.

  • Community Member Profile Picture
    Community Member on at

    Hi Leslie!  Thank you for your reply.  I'm looking at the CM20200 table and there is not a CURTRXAM field in this table.  Also - am I looking up the transaction by the CMTrxNum, which I'm guessing is the payment number?  If so - my payment is not listed.

    The invoice shows two payments applied, however it does show the amount of one of the payments in the unapplied field.  But there is nothing to apply.  It's as if the transaction shows applied, but GP doesn't recognize it. 

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    Boy, what was I smoking? I'm not sure where I came up with the CM20200 table. As you noticed, that's not the right table. The table I meant was the PM20000 table (The PM Open table).

    1. I'm getting from your reply that maybe only one of the payments shows as applied. Is the other payment still unapplied? No, you said the payments were in history so they have to be fully applied.

    2. Let's look in the Apply table and make sure our payments are showing up right. Look in the PM10200 (PM Apply To Work/Open) and PM30300 (Apply to Hisotory). I would do something like this:

    select 'PM10200' as [Table], vendorid, docdate, apfrdcnm,  aptodcnm, aptodcty, appldamt

    from pm10200

    where aptodcnm = 'InvoiceNo'

    and vendorid = 'VendorID'

    union

    select 'PM30300' as [Table], vendorid, docdate, apfrdcnm,  aptodcnm, aptodcty, appldamt

    from PM30300

    where aptodcnm = 'InvoiceNo'

    and vendorid = 'VendorID'

    If both payments were applied, this should return two records showing the payments that were applied to the invoice.

    3. Next, let's see where all the documents live. We'll be looking in the PM20000 (PM Open Transactions) and the PM30200 (Paid Transaction History).  I'd do something like this:

    select 'PM20000' as [Table], DOCNUMBR, DOCAMNT, CURTRXAM, VENDORID

    from pm20000

    where docnumbr in ('Check#1', 'Check#2', 'InvoiceNo')

    and vendorid = 'VendorID'

    UNION

    select 'PM30200' as [Table], DOCNUMBR, DOCAMNT, CURTRXAM, VENDORID

    from PM30200

    where docnumbr in ('Check#1', 'Check#2', 'InvoiceNo')

    and vendorid = 'VendorID'

    5. The results of these two queries should point us in the right direction.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at

    Hi Leslie!  Haha!  Not a problem.  I ran the scripts as you suggested and below is what I am seeing:

    *************

    SCRIPT:

    select 'PM10200' as [table], vendorid, docdate, apfrdcnm, aptodcnm, aptodcty, appldamt

    from pm10200

    where aptodcnm = '0336163-IN'

    and vendorid = 'Vendor ID'

    union

    select 'PM30300' as [table], vendorid, docdate, apfrdcnm, aptodcnm, aptodcty, appldamt

    from pm30300

    where aptodcnm = '0336163-in'

    and vendorid = 'Vendor ID'

    ***********

    RESULTS:

    table   apfrdcnm    aptodcnm      aptodcty appldamt

    PM10200   CREDIT CARD   0336163-IN           1 1.56

    PM10200   19320            0336163-IN           1 154.44

    PM10200                            0336163-IN           1 154.44

    PM30300   CREDIT CARD   0336163-IN           1 1.56

    PM30300   28224            0336163-IN           1 154.44

    **Interesting on this - I have no IDEA what that 19320 voucher number is.  It is not in any inquiry screen for the vendor.

    ************

    SCRIPT:

    select 'PM20000' as [table], docnumbr, docamnt, curtrxam, vendorid

    from PM20000

    where docnumbr in ('CREDEIT CARD', '28224', '0336163-in')

    AND VENDORID = 'Vendor ID'

    UNION

    SELECT 'PM30200' AS [TABLE], DOCNUMBR, DOCAMNT, CURTRXAM, VENDORID

    FROM PM30200

    WHERE DOCNUMBR IN ('CREDEIT CARD', '28224', '0336163-in')

    AND VENDORID = 'Vendor ID'

    *************

    RESULTS:

    table   docnumbr docamnt curtrxam

    PM20000   0336163-IN  156        154.44

    PM30200   28224        154.44 0

    The "Credit Card" and the "28224" are the payments applied to this invoice, and both are in history, however the invoice does show a remaining amount open of the 154.44.

    Thank you for all your help!!

    Linda DiGiacomo

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans