Need help in SQL queries
Posted: Tue Oct 13, 2009 9:34 am
Hi Friends,
I need some SQL queries for the below requirements.
1) need to review the data (unposted journals) in GL which was transferred from SOURCE AP, PO & PA.
2) need to review the data (posted journals) in GL which was transferred from SOURCE AP, PO & PA
3) need to review the data of Approved Purchase Orders, but not yet received material from Supplier.
Could anybody help me please?
Thanks,
Surya
I need some SQL queries for the below requirements.
1) need to review the data (unposted journals) in GL which was transferred from SOURCE AP, PO & PA.
2) need to review the data (posted journals) in GL which was transferred from SOURCE AP, PO & PA
3) need to review the data of Approved Purchase Orders, but not yet received material from Supplier.
Could anybody help me please?
Thanks,
Surya