Inventory To Projects ERV Transactions Hitting Different Account's
Last updated on SEPTEMBER 10, 2017
Applies to:Oracle Project Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, SUPPORT
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.
The account to do not change
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.
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