ERPstuff - Oracle EBS Community

Hi Folks, Please let me know, can I do something like this? The Qatari Riyal bank account can be defined in the system as USD Account (Functional currency). Now I make all the payments (whatever currency) from this account. Bank statement will be requested from bank in USD, else manually converted i...

Hi Erikson. Thanks. We tried creating a manual journal for encumbrance in GL. We then did the check funds. We posted this line. Then we tried creating a new manual journal for encumbrance. We check funds for this. Still it did not consider the earlier manual encumbrance journal which has been posted...

Thanks for this useful info Navneeth.
You rocks...

Narayan

Hi Navneeth, Yes, the checkbox for financial option in AP for PO encumbrance is enabled. Still we are facing the issue. Actually in the GL Funds inquiry, it is showing up Actual Encumbrance Budgeted figures. But when we do a fund check in PO, it shows funds available as Budget - Actuals. Encumbrance...

Hi Navneeth,

Thanks for this wonderful document.

Is it significantly different in R12?
Can someone please upload doc on R12 consolidation?

Thanks,
Narayan

Hi Hisham, We will have just one single material account right? The issue we are facing is, when we create, approve and receive a PO for an inventory item, it creates encumbrance entries correctly. When we post this to GL, it shows in the funds inquiry screen Budget, Actual and Encumbrance figures c...

Hi Hiszaki, Thanks for the response. But I am not using a different currency in payments than the invoice. My invoice currency and the payment currency is same. My bank account currency is different than the functional currency. And my transaction currency (Invoice/Payment) is different than the Ban...

Hi Navneeth,

Thanks. But in that case, I dont want to use the bank transfer functionality. Can I handle this in GL with a JV?

Thanks,
Narayan

Hi Jo, Can you tell me what exact steps you are following? In R12, as you know, LE has to be defined in the Accounting setup manager. I am not sure if you mean territorry when you said location? Territorry needs to be defined in the responsibility Legal Entity Administrator. Then you can get it. The...

Hi, We are in 12.0.6. We are using budgetory control for our primary ledger. We want to know whether it is possible to have budgetory control at the item level? My understanding is that the budgets are defined at GL level for the code combinations which has a natural account. When I raise a PO, the ...

Hi,

If you are in R12, you need to carefully setup the payment process profile and the related payable document. Difference in payment methods in the invoice workbench, difference in currency, due date of payment etc can be other reasons why the invoice is not shown in the payment workbench.

Narayan

Hi,

Just a question?
In case I dont have AR, can I handle this just by a JV in GL?
Dr. the receiving bank account.
Cr. the paying bank account.
Will it create problems in Cash Management? Can I reconcile through GL?

Thanks,
Narayan

Hi,

Has anybody encountered such an issue when the bank account currency is different than the functional currency and there is a need of foreign currency payments?

Narayan

Hi Folks, I am in 12.0.6. Following is the scenario: Functional Currency USD (As the HO is in US) Bank Account Currency QAR (As the client is in QATAR) Transaction Currency GBP (As the PO was in GBP) My bank account for QAR is multi currency enabled. I paid the GBP invoice from the QAR bank account ...