charles 9/6/2009 1:29:03 AM

Matching Invoices with Payments/Credit Memos

Hey all,

I have a requirement to synchronize invoices from an external system into GP.  These come in as purchasing invoices, which will have payments/credit memos/etc. applied.  The results will then be synchronized back.  In order to synchronize back, I have to match up the payments with the original invoice.

From looking at the Payables_Hist_Transaction, which contains the posted payments/credit memos/etc.  I don't see any link back to the invoice.  Since I selected to apply a payment to the invoice from the GUI (and I can verify that it is linked), I can't see why this info is not included (or maybe it is and I am missing it). 

 Is there a way to find out which payable transaction is associated with which document?

Thanks!

Version: Unknown or N/A
Section: eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3