ERPstuff - Oracle EBS Community

Hi, It has been observed that after creating the payment invoice the status is showing as 'Validated' and Accounted is showing as 'Yes' though the invoice has not been approved by the approver and also the creater does not have the right to approve the invoice. How this is possible. How to rectify t...

Hi,

I would like to have a report with the following details.

Asset Number
Original Cost
Accumulated Depreciation
Net Book Value

Can anyone provide me the SQL for this.

Thanks in advance.

Amitava

Hi,

I have checked up with the sql provided by you and found that it is not using the correct document sequence.

But we have done the set up correctly.

What is the solution to rectify this problem.

Thanks.

A. Ganguly

Hi, Misc-Tax-Invoice(VAT Related) transactions are numbered by this Document Sequence. We have created the setup thru VAT Document Sequencing. But still it is not working. Nevigation- India Local Receivables-> India TCS/VAT/Service Tax -> Setup -> VAT Document Sequencing -> Document Sequencing Setup...

Hi Friends, I am having the following problem related to Document Sequencing in AR. Posting this issue with a hope that I would get some help from an expert person. Every year we create Document Sequence for the new financial year and the Document Sequence starts from 1. In AR we have around 25 Doc....

I would like to know how to create a Report Set. Can any one suggest a good document where I can get the step by step procedure for creating Report Set .

Thanks

A. Ganguly

Yes the Item is LOT controlled Item. But the LOT has got sufficient stock vit still the System is splitting the LOT.

Thanks.

aganguly

Version R12/11i? = 11i Instance PROD/TEST/VIS? = PROD Module? = Order Management OS? = AIX 5.3L We have been facing a problem in Pick Release. It has been observed that while Pick Release the System is splitting an order line automatically even if the sufficient stock is available. Why this is hapen...

Version R12/11i? = 11i
Instance PROD/TEST/VIS? = PROD
Module? = Order Management
OS? = Aix 5.3L

I want to restrict one user so that he cannot BooK the Order. How to disable the 'Book Order' Tab from the User.

Thanks.

AGanguly

Thanks a lot Karthikeyan.

I need to know one thing. While changing the cost of the asset by 0.01% and again go back to the original cost do I need to amortize the asset ?

Thanks in advance.

Amitava

How the Penny Cost Adjustment is done in Assets.

Pls. tell me the steps for this.

Thanks in advance.

Amitava

Hi Friends, I have a business scenario where the P.O. and the Receipts for an Item is done in One Unit and Maintained in Inventory and issued to Production department in another. How should I do setups for such Items? Just to elaborate with an Example, an Item is received from Supplier in 'Feet' Uni...

I want to generate a list of assets which are live. How can I understand that one asset is fully retired(from table). I want to exclude the fully retired assets from the list.

Pls. advice.

Thanks in advance.

Amitava

I would like to know how to transfer a part of the asset in a different unit from the exising unit where all the units are in the same book. For example The current cost of an asset is Rs. 50,000. I want to transfer a Part of the asset where the value is Rs. 20,000 to a different unit. The asset had...

How can I compile a report inside ERP ?

Can anyone help/guide me in this regard !


Thanks.

Amitava