Dynamics GP 2010 - SSRS Payables Transaction History

To add the PO number to your SSRS Payables Transaction History Report

1. Add another dataset "PONum" that contains all of the vouchers and PO numbers. This view from Victoria Yudin is perfect.  http://victoriayudin.com/2008/10/17/sql-view-what-check-paid-purchase-order/
2. Go into your table and create a placeholder wherever you would like your PO numbers to be.
3. Under General>Value Click the Fx button to create a function
4. Paste this in
   =lookup(Fields!VCHRNMBR.Value, Fields!Voucher_Number.Value,Fields!PO_Number.Value,"PONum")
5. Save, close, Run your report and see if it works.

If you need to know more about the lookup function, try here 

http://msdn.microsoft.com/en-us/library/ee210531.aspx