how to get supplier's outstanding details?
-
- Posts: 76
- Joined: Fri Aug 01, 2008 4:55 am
- Location: India
how to get supplier's outstanding details?
Hi Folks,
Can anybody explain me the below doubt (ver 11.5.10.2)?
1) how to get the opening balances of all the suppliers?
2) how to get all outstanding (unpaid) invoice details for a supplier?
If you could able to tell me sql script also, will be great help.
Thanks in advance,
Surya
Can anybody explain me the below doubt (ver 11.5.10.2)?
1) how to get the opening balances of all the suppliers?
2) how to get all outstanding (unpaid) invoice details for a supplier?
If you could able to tell me sql script also, will be great help.
Thanks in advance,
Surya
Hello Surya.
Answering your questions:
1) how to get the opening balances of all the suppliers?
Run the Accounts Payable Trial Balance. You can enter an As of Date parameter which allows you to see the open balances for any date in the past or for the current date.
2) how to get all outstanding (unpaid) invoice details for a supplier?
Run the Invoice Aging Report. This will show you the unpaid invoices for a supplier at system date.
If you still need the queries, let me know for which of the questions you need it.
Octavio
Answering your questions:
1) how to get the opening balances of all the suppliers?
Run the Accounts Payable Trial Balance. You can enter an As of Date parameter which allows you to see the open balances for any date in the past or for the current date.
2) how to get all outstanding (unpaid) invoice details for a supplier?
Run the Invoice Aging Report. This will show you the unpaid invoices for a supplier at system date.
If you still need the queries, let me know for which of the questions you need it.
Octavio
-
- Posts: 76
- Joined: Fri Aug 01, 2008 4:55 am
- Location: India
-
- Posts: 76
- Joined: Fri Aug 01, 2008 4:55 am
- Location: India
-
- Posts: 76
- Joined: Fri Aug 01, 2008 4:55 am
- Location: India
Hi Octavio,
There are balances (unpaid invoices) for some suppliers, if i do "Calculate Balance Owed" from invoice inquiry, but I don't know how to get the similar balances for all the suppliers.
In "AP Trail balance report" when i give AP liability account, its showing no data found.
Please help me?
Thanks,
Surya
There are balances (unpaid invoices) for some suppliers, if i do "Calculate Balance Owed" from invoice inquiry, but I don't know how to get the similar balances for all the suppliers.
In "AP Trail balance report" when i give AP liability account, its showing no data found.
Please help me?
Thanks,
Surya
-
- Posts: 76
- Joined: Fri Aug 01, 2008 4:55 am
- Location: India
Who is online
Users browsing this forum: Bing [Bot], Google [Bot] and 21 guests