I need a query of the following:
Invoices generated in December 1 through March 1
Based on a ship to of:
The query should contain the following:
G/L Tax Liability Account
Amount of Invoice
Amount of Tax charged
Can somebody pls help me getting this query done. I'm getting Invoice ID, Amount and Date from AP_INVOICES_ALL, i hope "ship to" will come from "RA_CUSTOMERS", but donno how to join them. Am I looking into correct tables.
Your help is appreciated.