SQL QUERY FOR AP INVOICES
Posted: Wed Jun 24, 2009 8:03 am
HI ALL,
I want help for a SQL query in which i can find the following relation
SUPPLIER NAME---SITE CODE----DATE----INVOICE NO.----DESCRIPTION-----GL CODE COMBINATION
Basiclly i want to the GL -- Subledger Report --- from where i can find the all invoices in a particular GL like Professional Charges.
Thanks,
Sanjay Khandelwal
I want help for a SQL query in which i can find the following relation
SUPPLIER NAME---SITE CODE----DATE----INVOICE NO.----DESCRIPTION-----GL CODE COMBINATION
Basiclly i want to the GL -- Subledger Report --- from where i can find the all invoices in a particular GL like Professional Charges.
Thanks,
Sanjay Khandelwal