My Oracle Support Banner

Transaction Group 032 (non Stock Shipment) has Incorrect Cost With Different Unit of Measure (UOM) on Sales Order Versus Purchase Order (PO) (Doc ID 2829913.1)

Last updated on DECEMBER 22, 2021

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Transaction Group 032 (non stock shipment) has incorrect cost with different UOM on sales order versus PO.
 In this example, the sales order was for 7800 EA USD and then based on Purchasing Attributes configuration the requisition and PO are created in 26 CS based on a conversion rate between CS and EA as 300 IN USD. The BU base currency is HKD. When the costing program runs it takes the PO CS price in USD and then uses the exchange rate between USD and HKD to calculate the 7800 EA in HKD using the PO unit price in CS. This is making the costing side in transaction group 032 way too high.


Steps to reproduce the issue:

1) Create sales order marked as direct ship with a UOM of EA . (Order Management > Quotes and Orders > Create or Update Sales Order)
2) Run Req load with system source as BOM to create requisition from above sales order. (Purchasing > Requisition > Load Requisitions)
3) Source Requisition to PO (Purchasing > Purchase Order > Stage/Source Requests > PO Auto Source)
4) PO is created in CS UOM as per Item Supplier UOM and price.
5) Create voucher and post it. (Accounts Payables > Vouchers > Add/Update > Regular Entry)
6) Now Mark lines for Billing on Sales order.(Order Management > Quotes and Orders > Create OM Billing Entries > Mark Lines for Billing)
7) Run Cost Accounting creation (CM_CSTACCTG) process. (Cost Accounting > Inventory and Mfg Accounting > Create Accounting Entries > Cost Accounting Creation)
8) Navigate to Cost Accounting > Inventory and Mfg Accounting > Review Transaction Details> Non stock Shipment
9) Note it takes the price on the PO which is in CS and multiplies that by the UOM of EA that is on the sales order and quantity it quantity and determine the cost which makes it completely overstated.



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.