189 8069 5689

WIPReturnCost

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

WIP Return Cost

In this Document

成都创新互联长期为超过千家客户提供的网站建设服务,团队从业经验10年,关注不同地域、不同群体,并针对不同对象提供差异化的产品和服务;打造开放共赢平台,与合作伙伴共同营造健康的互联网生态环境。为余姚企业提供专业的网站制作、网站建设,余姚网站改版等技术服务。拥有10余年丰富建站经验和众多成功案例,为您定制开发。


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
 


分享文章:WIPReturnCost
本文路径:http://cdxtjz.cn/article/ijggop.html

联系我们

您好HELLO!
感谢您来到成都网站建设公司,若您有合作意向,请您为我们留言或使用以下方式联系我们, 我们将尽快给你回复,并为您提供真诚的设计服务,谢谢。
  • 电话:028- 86922220 18980695689
  • 商务合作邮箱:631063699@qq.com
  • 合作QQ: 532337155
  • 成都网站设计地址:成都市青羊区锣锅巷31号五金站写字楼6楼

小谭建站工作室

成都小谭网站建设公司拥有多年以上互联网从业经验的团队,始终保持务实的风格,以"帮助客户成功"为已任,专注于提供对客户有价值的服务。 我们已为众企业及上市公司提供专业的网站建设服务。我们不只是一家网站建设的网络公司;我们对营销、技术、管理都有自己独特见解,小谭建站采取“创意+综合+营销”一体化的方式为您提供更专业的服务!

小谭观点

相对传统的成都网站建设公司而言,小谭是互联网中的网站品牌策划,我们精于企业品牌与互联网相结合的整体战略服务。
我们始终认为,网站必须注入企业基因,真正使网站成为企业vi的一部分,让整个网站品牌策划体系变的深入而持久。