Search found 451 matches

by oteixeira
Fri Nov 13, 2009 8:51 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Retainage Invoices
Replies: 4
Views: 1419

Hello.

There is a good presentation showing all steps:

http://www.slideshare.net/OracleERP/r12-ap-new-features

Octavio
by oteixeira
Fri Nov 13, 2009 7:55 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Retainage Invoices
Replies: 4
Views: 1419

Hello Surya.

Are you talking about R12 function?

Octavio
by oteixeira
Thu Nov 12, 2009 6:46 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Customer Interface Table in 11i and R12
Replies: 1
Views: 2063

Hello.

I'm afraid some table names you mention are not correct. Following the table names found in R11i which have the same name in R12:

RA_CUSTOMERS_INTERFACE_ALL
RA_CUST_PAY_METHOD_INT_ALL
RA_CUSTOMER_BANKS_INT_ALL
RA_CUSTOMER_PROFILES_INT_ALL
RA_CONTACT_PHONES_INT_ALL

Octavio
by oteixeira
Tue Nov 10, 2009 11:53 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: how to get supplier's outstanding details?
Replies: 12
Views: 6350

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
by oteixeira
Mon Nov 09, 2009 6:54 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: how to get supplier's outstanding details?
Replies: 12
Views: 6350

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
by oteixeira
Fri Nov 06, 2009 6:45 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: how to get supplier's outstanding details?
Replies: 12
Views: 6350

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 (unp...
by oteixeira
Thu Nov 05, 2009 11:13 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: units of mesure use in fixed assets
Replies: 3
Views: 839

Hello.

1.Navigate to Setup/Depreciation/Methods and create a Depreciation Method of type Production.
2.Create a Asset Category using the Depreciation Method in 1.
3.Create an Asset and assign the Category in 2 to it.

Octavio
by oteixeira
Thu Nov 05, 2009 7:32 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: units of mesure use in fixed assets
Replies: 3
Views: 839

Hello.

You need to assign a Production depreciation method to your assets.

Octavio
by oteixeira
Tue Nov 03, 2009 6:33 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: miscellanious receipt
Replies: 2
Views: 714

Hello. A Misc Receipt is used to record payments and receipts that are not connected with payments of supplier invoices or receipts of customer transactions. You use this type of transaction to record, for example: -Petty cash payments. -Transfer of amounts between banks. From the main menu, the nav...
by oteixeira
Tue Nov 03, 2009 6:26 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: How to understand a fully retired assets
Replies: 1
Views: 1049

Hello Amitava.

Information about retired assets is kept on table FA_RETIREMENTS. For a fully retired asset a record with STATUS = 'PROCESSED' should exist on this table. Also ADJUSTED_COST cost on table FA_BOOKS is equal to zero.

Hope this helps.
Octavio
by oteixeira
Mon Nov 02, 2009 7:46 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: WTH not included in invoice AR 11i
Replies: 2
Views: 853

Hello Benny.

As the invoices are not yet paid, i think the best solution is to cancel them and enter new ones already with the correct WHT distribution line.


Octavio
by oteixeira
Fri Oct 30, 2009 6:24 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Latest version of FSG in Oracle Apps?
Replies: 2
Views: 1085

Hello.

I believe FSG is part of GL product and it has no specific version.

Octavio
by oteixeira
Thu Oct 22, 2009 11:37 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: FA IMPLEMENTATION
Replies: 3
Views: 1068

Hi Emanuel. First, in your legacy system, TB must match both the Cost and the Accumulated Depreciation of the assets to be uploaded to FA. This is essential because you should have already uploaded your legacy TB to GL. You must use the asset cost and the accumulated depreciation, not the net or gro...
by oteixeira
Thu Oct 22, 2009 6:33 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Compiling a Report inside ERP
Replies: 1
Views: 655

Hello Amitava.

Refer to Metalink Doc ID: 237533.1

Octavio
by oteixeira
Thu Oct 22, 2009 6:24 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Need User Manual for Budgeting in R12
Replies: 1
Views: 669

Hello Satya.

You can download it from:

http://download.oracle.com/docs/cd/B538 ... ocset.html

Octavio