how to get supplier's outstanding details?

[dvsprao108]

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

[oteixeira]

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

[dvsprao108]

Hi Octavio,

Thanks for the reply.

Can you please provide "SQL equerries for both" my issues?

Thanks,
Surya

[hiszaki]

HI Octavio

is the Accounts Payable Trial Balance is available for R12 or change the request name because I don't find this request in the R12.

Thanks
Hisham

[oteixeira]

Hello Hisham.
For R12 the report names are different. I'm still on 11.5.10.2 so i don't know which names are used in R12.

Octavio

[Shashi_k]

Hi,

In R12 Open Account Balances Listing report is used instead of AP trial balance report.

Regards,
Shashi.

[dvsprao108]

Hi Octavio,

Can you please provide "SQL querries for both" my issues?

Thanks,
Surya

[Racle11i]

Hi,

Thanks guys for the questions and answers

Both of them were interview questions once i was faced.

Best Regards

[hiszaki]

Hi Shashi.

Thanks for your reply.

Hisham

[dvsprao108]

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

[oteixeira]

Hello Surya.

Perhaps the Liability Account you are entering as a parameter in the Accounts Payable Trial balance does not include the invoices in the form query. Instead of using the liability account try to use the supplier name and see if the report still shows no data was found.

Octavio

[dvsprao108]

hi Octavio,

I ran "AP Trail Balance report" with Liability account and got some data, but it is not tallied with unpaid invoices total of "Calculate Balance Owed" from invoice inquiry.

Can you please help me, since this is some urgent requirement by the user.

Thanks in advance,

Surya

[hiszaki]

Hi Surya

Check the liability account for the supplier which you inquiry in the invoice inquiry form then re-run the AP Trail Balance report again for this account.

Thanks
Hisham