Inventory To Projects ERV Transactions Hitting Different Account's (Doc ID 1985063.1)

Last updated on JUNE 18, 2016

Applies to:

Oracle Project Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, SUPPORT

ACTUAL BEHAVIOR
---------------
Received transactions IPV and ERV, where as when checked ERV transactions accounting in Projects it's going to Unvochered Payables, where as Payables send to GL as Realized Gain/Loss Account , but in Projects it's picking the different account.

EXPECTED BEHAVIOR
-----------------------
The account to do not change

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
ERV transaction for Manufacturing environment, this is my scenario, every thing working as expected, but when i check the accounting INV to PA accounting showing different, where as AP to GL going correct account..

I created PO for Item related in GBP 100, where the functional currency is in USD, the corresponding Amount in USD: 300, this is Project related PO.

Create a Receipt for 100 GBP and it's deliver, ran the cost collection manager, projects for the transactions as Material and PPV

Create an invoice with the matching PO, where as i used different exchange rate for Example 3.5 and line level i change the amount instead of 100 GBP i made only 90 GBP and invoice validated and accounted.

AP send the entry's to GL ERV and IPV , at that time ERV used my Realized Gain/Loss Account 740060. --until here all the accounting correct, there was no issue.

in Project manufacturing ran the process Transfer Project Invoice Charges for that project and run the cost collection process as well and import the cost into Projects..

In project i received transactions IPV and ERV, where as when i check my ERV transactions accounting in Projects it's going to 210020-Unvochered Payables, where as Payables send to GL as Realized Gain/Loss Account 740060, but in Projects it's picking the different account.

My question here is where this accounting picking while INV to PA process, even when i check the in payable's Setup: Options: Financial Options: it's showing Realized Gain/Loss Account only, i dont see any other accounts, where the process picking this account and sending to GL

As PPV,IPV and ERV these accounting will take it from Financials options only, even i check Org level setup accounting as well. Please advice me here where this accounts taking, is there any setups i miss or is there any bug in the product.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms