ERPstuff - Oracle EBS Community

Hi keke

You can find all setup about invoice approval work flow in the Oracle payables user guide at section:
Setting Up Invoice Approval Work#61442;ow

Hope I can give you a guide to help you
Thanks
Hisham

Hi faizan_hafiz

TOAD is a tool using in oracle database. It has a lot of options like Debugger, SQL tuning, Formatter, Admin, ...etc

For more information about TOAD you can visit the site:
www.quest.com

But please don't change any data through TOAD it's very very dangers.
Thanks
Hisham

Hi wenjie I would like to inform you that by using TOAD we can do anything on Database, we can update in data, amounts, balances but this is very dangers & not recommend form Oracle unless you fix a problem & meta link send to you a SQL statement to run it on DB. If you open the period throu...

Hi sethrosu

I think you can use any SQL tools (ex. TOAD) to build your SQL statement with your specific conditions & get the results you need.

Best Regards,
Hisham

Hi segu For my little information I don't know if there is an invoice reconciliation or not because both of type of invoices (in AP or AR) related to expenses account with supplier accounts or revenue accounts with customer accounts. So the reconciliation will not made for these accounts so please t...

Hi Shweta, If you close the period in FA, you cannot rollback depreciation even the period is not close at GL. You can make the following, run the depreciation for specific period then see the results by the standard reports or you can transfer to GL without closing the period in FA. If you have any...

Hi Karan Now you record the Prepayment-100 USD for this supplier ok, then you enter an standard invoice with the total of purchasing 1100 USD then you made the match function with the purchase order no. After you approve the standard invoice, go to action button then choose apply / un-apply the prep...

Hi Karan

I would like to know what you mean for the above topic, is how I enter an invoice which had a prepayment before or how I enter invoice as a prepayment.

I'm sorry about my misunderstanding but I just want to know.

Thanks
Hisham

Hi Nagaramesh, What I mean that if you have for example 10 checks you collect them from customers, and have 5 checks you paid to suppliers. In cash management you have 2 ways to make Reconciliation function: 1) Open Cash management --> bank reconciliation --> Bank statement. 2) Open Cash management ...

Hi malick I hope I can help you for some terms. When you define the bank, your choose the account use of this bank: 1) Internal -- this used when I define the bank I will use it in AP and AR (my banks). 2) Customer -- this used when you define the customer's bank which the customer can paid to you t...

Hi Stanza

I think that Karan is right so you can choose your solution for the above steps.

Thanks
Hisham

Hi segu The reconciliation of invoice,payment,transaction and receipts is a transaction in Cash Management module. It help you to make your bank statement in your application equal the current statement in your banks. For example, suppose you get a check from customers & put them in your bank to...

Hi Subramanian When you choose the bank number check about the format type for the document number. May be the document number still has a one currency only. make a format accept multi currency then assign this format type to the payables document you want to pay from it. Wait for your reply Thanks ...

Hi Subramanian You can payment an invoice with other currency that the invoice currency. I think you can define in bank account forms enable the option Multiple Currency Payments in payable option tab. Don't forget define a payment format enable multi-currency. This way is used in R11i & I think...

Hi all

I have a report builder with extension rep, and the source file was deleted. so can any person tell me if there any tools can convert the report .rep to .rdf.

Thanks
Hisham