Discrepancy Between Inventory Valuation and Receiving Inspection Amount
(Doc ID 2256204.1)
Last updated on SEPTEMBER 30, 2024
Applies to:
Oracle Cost Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Goal
Receiving Inspection amount is not same as Inventory Valuation amount when material overhead is defined. Items are received with PO (purchase order) unit price:184.01 x quantity:640 (=total amount:117766.4) , but Receiving Inspection amount is calculated = 117767. Why there is one amount mismatch here?
Reproducing Steps:
- Currency precision is set to 0.
- Material overhead is defined as below;
- Overhead1: 0.025 (total amount basis, resource_id =4561)
- Overhead2: 16.96 (item basis, resource_id =4562)
- Overhead3: 0 (item basis, resource_id =4563)
- Receive PO with PO unit price:184.01, quantity:640.
- Deliver them to Inventory.
- Material Transaction Distribution records are created as below;
Accounting_Line_Type_id | Cost_Element_ID | Primary_Quantity | Base_Transaction_Value | Rate_or_Amount | Resource_Id |
1- Inventory Valuation | 1 - Material | 640 | 117766 | 184.01 | |
1- Inventory Valuation | 2 - Material Overhead | 640 | 13799 | 21.56025 | |
5- Receiving Inspection | -640 | -117767 | 184.01 | ||
3- Material Overhead Absorption | 2 - Material Overhead | -640 | -2944 | 4.60025 | 4561 |
3-Material Overhead Absorption | 2 - Material Overhead | -640 | -10854 | 16.96 | 4562 |
3-Material Overhead Absorption | 2 - Material Overhead | -640 | 0 | 0 | 4563 |
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |