Reporting Currency - Can we make it behave as if it is the primary currency in Oracle Inventory?
Business Requirement:
1. To have functionality wherein the Reporting Currency follows the costing method calculation (ie. average costing)
of the primary currency.
Example
1. Primary Currency is in PHP
2. Reporting Currency is in USD
Currency Conversion 50 Php @ 1 USD November 11, 2011
Currency Conversion 50 Php @ 1.50 USD November 12, 2011
November 11
Item Receipt (1000 units x 50 Php) = 50,000 Php Reporting Currency = 1,000 USD
November 12
Item Receipt (2000 units x 50 Php) = 100,000 Php Reporting Currency = 1,500 USD
November 12
Issuance of items - Quantity 1000 units (Standard System Behavior)
Average Costing Method will give us unit cost rate at Php 50 per item based on the primary currency which is at (Php 50,000)
and for the reporting currency the system will just pick up the conversion rate at the time of transaction which is at USD 1.50 thus
1. To have functionality wherein the Reporting Currency follows the costing method calculation (ie. average costing)
of the primary currency.
Example
1. Primary Currency is in PHP
2. Reporting Currency is in USD
Currency Conversion 50 Php @ 1 USD November 11, 2011
Currency Conversion 50 Php @ 1.50 USD November 12, 2011
November 11
Item Receipt (1000 units x 50 Php) = 50,000 Php Reporting Currency = 1,000 USD
November 12
Item Receipt (2000 units x 50 Php) = 100,000 Php Reporting Currency = 1,500 USD
November 12
Issuance of items - Quantity 1000 units (Standard System Behavior)
Average Costing Method will give us unit cost rate at Php 50 per item based on the primary currency which is at (Php 50,000)
and for the reporting currency the system will just pick up the conversion rate at the time of transaction which is at USD 1.50 thus
0