ERPstuff - Oracle EBS Community

Hi, What can be the best way to autoreconcile the Cash deposits into the bank. Customer is a tolling agency and received lot of toll receipts for a day. All the receipts are entered in a third party application and interfaced to AR as a single receipt, because the total receipt is deposited into the...

Hi, I need to know with the help of tax rules, can I distinguish between two suppliers? We can have just one tax in EB Tax and have multiple statuses/rates. Now in 11i, we could have defined as many tax codes as required and associate it with the supplier site. This doesnt work in EB Tax as only thi...

Hi, We upgraded from 11.5.10.2 to R12.1.2. Till now we were using the upgraded regime (STCC). Now we have shifted the configuration owner options to point to the regime determination set ( to use the new tax logic). My question is, do we need to create new taxes post this switch? Can I reuse the old...

Hi, We are in the process of upgrade to 12.1.2 from 11.5.10.2. There are many invoices which are on hold in the 11i. After upgrade, when invoice validation is run it completes warning. Its checking for the old data which is on hold and flagging error against them. In 11i when we run it it just goes ...

Hi Folks, Please let me know if there is a better way of loading the intra company relationships in R12? We have around 40+ balancing segments and have more than 1000 rules. Doing it manually (given that dataloader wont work as its an html page) would be a huge task. Any help here is highly apprecia...

Hi, Be careful with the calendar nomenclature here. Generally when financial year is Apr-Mar, you may want to call it as APR-11 to MAR-11, since the year will close in 2011. However you may have a different setup. Please check that. You may also want to check the calendar definition here if everythi...

Hi Nadh, Please let me know what exact functionality you are looking for with Overdraft. If its just a type of bank account wherein the bank gives you a facility to over draw your funds, thats something we can map with a standard bank account. Supply a liability account and just let it be like that....

Hi Ehsan, I dont think you can do that. Apart from other sources (AR,AP,CM etc), Forecasting takes data from GL only for budgets. Unlike for reconciliation, it doesnt pick data from GL lines for forecasting. This is standard functionality. Though I am not cent percent sure about this. But I also tri...

Hi Folks, The reconciliation accounting (we have 'account for payment when payment clears and issued' enabled) is not happening correctly. It says online accounting can not be done and when we run the program create accounting it completes warning. The error being the standard cash accounting method...

Hi, When we make a payment, the cash account is not credited to the exact value of the liability account, even though there is no exchange rate variation is involved. For example, for few payments it debits say 100.10 USD and credits the cash account with 100.09 USD. This leaves the journal unbalanc...

Hi, We have a requirement wherein we need to compare the budget figures with the actual cash spent. We are using accrual system of accounting. We have enabled the budgetary control. We tried to use a secondary ledger with the accounting method as encumbrance cash. Now when a PO is raised, it will en...

Hi Octavio,

Thanks.
Does it need the allow revaluation to the fully reserved asset checkbox to be checked?

Narayan

Hi,

Instead of role, you can also run for any responsibility from which you want to create the bank account.
So say you are using Payables superuser responsibility, you can run the security wizard by selecting the payables responsobility in the user management.

Narayan

Yes. Generally I have seen encumbrance being used by companies with accrual system of accounting. When you are using cash, anyways the accruals will be ignored, and encumbrance involves accruals. So I got confused. But its okay, you can do that. Be careful with the setup of the cash ledger. You can ...

Hi,

There is no disadvantage as such.
All the reports etc need to be designed for your secondary ledger (Encumbrance Cash).
You said your client needs cash basis of accounting. Still they need encumbrance??

Narayan