SQL query to match payments to invoices in Microsoft Dynamics GP (Great Plains)

How do you match payment information from an external source to invoices in Microsoft Dynamics GP (Great开发者_如何学C Plains)?

I found this post, but it doesn't go into detail about the actual query to use:

http://dynamicsuser.net/forums/p/36640/189486.aspx