位置：首页-资讯-后端开发

WIP Return Cost

2023-06-05 13:32

短信预约 -IT技能 免费直播动态提醒

Unexpected Variation In Item Unit Cost During "WIP Completion Return" (文档 ID 1603855.1)

In this Document

Symptoms

Cause

Solution

Applies to:

Oracle Cost Management - Version 12.1.3.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Other Inventory Issues

ACTUAL BEHAVIOR
---------------
(Finished Good) Item was Manufactured through a Discrete job "F1309056". This job was completed at a unit cost of "229.42310" for 100 Quantity.
later on "user" did a "WIP Completion Return" of 100 Quantity for the same job, this time system picked unit cost "22,942.31000" for return transaction.
This was a huge unexpected variance...

Cause

The cause of this issue :

When we calculate return txn value, the formula is like below.
relieved_matl_completion_value * return_qty / prior_completion_qty

Then cst_comp_snapshot.prior_completion_quantity was zero when processing assembly return.

The issue was clarified in details with the same scenario in
Bug 9502821 - WRONG VALUE IN ACCOUNTING OF WIP COMPLETION RETURN TRANSACTION

Solution

Data fix:
=======
There is no way to recost already costed txns. And, now the assembly item cost is wrong after the return txn, it became 0. So, CT should do average cost update for that item to make it correct. And, for already
happened wrong accounting entries in the wip job, CT should do manual GL, because we can't recost txns.

Code fix:
======
Download and review the readme and pre-requisites for Patch.9502821:R12.BOM.C
File (include directory) Version
++ ------------------------------------------- ------------------
  patch/115/sql/CSTLCWPB.pls 120.1.12010000.2
  patch/115/manualsteps/ad_apply_patch.xml 120.4
  patch/115/sql/CSTPACPB.pls 120.1.12010000.2

免责声明：

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

阅读原文内容投诉