Report/query containing info below desired by customer
I've downloaded FSG
whitepaper, but, my customer wants report asap. Has anyone produced a
query you're willing to share that provides the following info?
Supplier Name
Check number
Amount of Check
Invoice Date
GL Account number that check was charged to
Supplier Name
Check number
Amount of Check
Invoice Date
GL Account number that check was charged to
Previously,
I've looked around in AP_CHECKS_ALL, AP_SUPPLIER_SITES_ALL,
AP_SUPPLIERS, and AP_INVOICES_ALL and see that vendor_id is one of the
common denominators (not sure where to find GL ACCOUNT #), but, I'm not
yet sure of the relationships in these tables and want to produce valid
results. Any FSG and/or BI Publisher training recommendations would
also be appreciated.
Tagged:
0