Acccounts Payable – Viewing Invoices posted to PO’s

  • Acccounts Payable – Viewing Invoices posted to PO’s

    Posted by karen-sligh on May 5, 2017 at 1:14 pm
    • Karen Sligh

      Member

      May 5, 2017 at 1:14 PM

      We are having issues attempting to view the invoice payment against a PO when;
      > receiving and invoicing have been posted for payment
      > the cheque has not been created
      We cannot find the payment in GP. Are we missing something?
      txs
      karen
      Create a great day!

      ——————————
      Karen
      Ongwanada
      Kingston ON
      ——————————

    • Leslie Vail

      Member

      May 6, 2017 at 9:02 AM

      Hi,
      If the checks have not yet been created, the invoice is still outstanding. If the invoice has been received, but just not paid, you can still find them. You can pick out the invoice based on its source and the status of the PO. If you always use Receive and Invoice, is the question how do you tell which of the outstanding payables are related to PO’s?
      If you look in the PM20000 table, you will see fields named TRXSORCE, and BCHSOURC. If the TRXSORCE starts POIVC, you know this transaction is related to a PO. The BCHSOURC will be from ‘Rcvg Trx Ivc’. The remaining outstanding balance is in the CURTRXAM. If you also need to know the PO number that the invoice relates to, look in the PORDNMBR column. Does this help?
      Kind regards,
      Leslie 

      ——————————
      Leslie Vail
      Accounting Systems Consulting, Inc.
      Dallas TX
      ——————————
      ——————————————-

    • Leslie Vail

      Member

      May 6, 2017 at 9:05 AM

      To easily view the invoice, build a SmartList and create a GoTo that will open the Inquiry window. You could also put this in a refreshable Exec report and build a DrillDown. You need SmartList builder to easily accomplish this.
      Kind regards,
      Leslie

      ——————————
      Leslie Vail
      Accounting Systems Consulting, Inc.
      Dallas TX
      ——————————
      ——————————————-

    karen-sligh replied 7 years, 1 month ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Acccounts Payable – Viewing Invoices posted to PO’s’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!