ERPstuff - Oracle EBS Community

HI Prathmesh,

O2C a/c entries are as follows :

At shipments:

Dr COGS
Cr Inv

At invoicing:

Dr Receivables
Cr Revenue
Cr Tax
Cr Freight

At Receipt:

Dr Cash Clearing
Cr Receivables

At Clearing

Dr Cash
Cr Cash Clearing

Hope it is clear

Thanks

Karan

Hi Bala Accounts Payable: Both DM & CM reduces the supplier balance in AP. Ex- PO Price ? 100 Inv Price ? 110 (By mistake) (Over billing) If supplier comes to know of the mistake then he will send a Credit memo to us indicating that our account has been credited in his books to the tune of 10. C...

In Cash Management responsibility the navigation for reconciliation is Bank statements#61664;Bank Statements and Reconciliation Give the necessary details like bank account number, account name, statement date, statement number, GL Date. Mention the control totals with the help of bank statement &am...

Hi nass_kp

With the help of elimination sets we can eliminate the inter company balances when we run "Oracle General Ledger Automatic Intercompany Eliminations program"

Thanks
Karan

Hi Farhat

You can run "Prepayment status report" to get the details supplier wise.

Thanks
Karan

Hi Farhat

It is not possible to use more than 30 segments. Using more segments will complicate the process & i have never seen organizations using more than 12 segments.

Yours is a unique case but unfortunately there is no work around for this as far as i know.

Thanks
Karan

Hi Folks

Can u pls list out the important reports used in Cash management module.

Thanks in advance

Karan

Hi Entering of asset from purchasing: 1.Enter a PO in purchasing for the asset item. Make sure the account mentioned therein is the Asset clearing account. 2.Enter a standard invoice for the purchase order & match it with PO or receipt as the case may be. 3.Validate the invoice, create accountin...

Hi Nagaramesh

In that case you can raise 2 dummy invoices in different currencies & carry on with the payment.

More ideas folks

Thanks
Karan

Hi

As far as GL is concerned the concept of ?Set of books? has been removed & ?Ledgers? have been introduced in R12. Many html forms are used in R12.

Please add more differences folks.

Thanks
Karan

Hi Murthy I have raised the first standard invoice as it is the original invoice sent by the supplier. On the date of payment the supplier asks us to pay in currency other than the invoice currency. For that purpose I have raised a DM against original invoice, raise a dummy invoice in payment curren...

Thanks Swamy

Hi Benny

If any mass additions have not been transferred to Fixed assets then there will be balance in asset clearing account.

Thanks
Karan

Hi Jayasree In payables both the invoice currency & payment currency must be same. However if you want to make a payment in other than invoice currency then there is a work around for that which is illustrated below. 1. Invoice - 4000 INR 2. Payment to be made in USD 3. Raise a DM for 4000 INR &...

Hi Jairam

We cant match if PO is in one currency & invoice is in other currency.

Thanks
Karan