[Karen Sligh]

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]

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]

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
——————————
——————————————-