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 —————————— ——————————————-
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
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!