RMA COGS Account Error of Intercompany Invoicing (Doc ID 1491527.1)

Last updated on MAY 17, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Finance & Accounting

ACTUAL BEHAVIOR
---------------
COGS account for intercompany RMA is wrong.

EXPECTED BEHAVIOR
-----------------------
To correct COGS account of intercompay RMA SO.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. COGS account setting up in A27 (ASUS Ledger) and U21 (UTC Ledger)
In A27 item’s COGS account = 001.xxxx.xxxx.xxxx.xxx.xxxx.xxxx
In U21 item's COGS account = 002.xxxx.xxxx.xxxx.xxx.xxxx.xxxx

2. Create intercompany SO, Pick and Ship successfully.
SO Number = 22112041000002
Item = 90PF1ABA43211KA02B0T
SO Status = Pending pre-billing acceptance after Ship confirm
Selling Legal Entity = UTC
Shipping Legal Entity = ASUS
Shipping Warehouse = A27 For Legal Entity From ASUS

3. Create RMA referring to original SO, 22112041000002 and RMA Receipt.
RMA SO number = 22112043000002
Receiving Legal Entity = UTC
Receiving Warehouse = U21 in UTC legal Entity
RMA SO Status = Close after RMA Receipt

4. Launch Cost Manager to create transaction distributions.

5. View RMA SO distribution in Material Transaction form.
Found the COGS account for RMA Receipt is wrong.
It is 001.xxxx.xxxx.xxxx.xxx.xxxx.xxxx.
Actually it should be 002.xxxx.xxxx.xxxx.xxx.xxxx.xxxx
from U21 item’s COGS account.

Changes

This is used to be standard function, customer needs to customize COGS workflow to fulfill it. But now a new System Parameter "Source Line for deriving COGS account on referenced RMA" is provided.
A value 'Return Line to be used as Source' will ensure that the current Return Line is used as Source whereas a value of 'Referenced Sales Line to be used as Source' or NULL will ensure the old behavior of deriving COGS using the Source Sales Line attributes is retained.

Note: 

(1) This System Parameter is not only used for determining the Warehouse from original SO or RMA Line, but is used for deriving all attributes related to COGS WF.  In fact, this System Parameter is used to derive which Line ID is used to trigger COGS Workflow.

(2) If the System Parameter is set to 'Referenced Sales Line to be used as Source' or NULL the previous behavior is retained.

(3) If System Parameter is set to 'Return Line to be used as Source' then from COGS derivation perspective the behavior would be same as if the RMA is non-referenced one.       

Per Bug 17067525 this patch is intended only for inter-company flow which does not use Advance accounting.

Currently for normal returns (Sales Order Shipping Org and Return Receiving Org being the same), COGS on return line will be derived from the Source Sales order. This is a feature from Costing module and the COGS account derived by OM will not be honored by Costing. If this is your case, then a bug / ER will have to be logged against Costing Team.

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