SQL Query Extract Supplier Balances in R12.2.4
1) Please let me know how do i get supplier balances with details as below :vendor name, vendor number, address, email address and if possible current balance. Wht is the right condition for all the vendors we used in the last 3 years.
2: I got all but Supplier columns but current open balances i am figuring out. Is there any standard seeded function which I can use to get supplier open balances at any time ?
3) What is the right condition for all the vendors we use for the last 3 years.?
4) Is there any seeded report we can use it Supplier Balances ?