WIPReturnCost

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

In this Document

成都創(chuàng)新互聯(lián)長期為超過千家客戶提供的網(wǎng)站建設服務，團隊從業(yè)經(jīng)驗10年，關注不同地域、不同群體，并針對不同對象提供差異化的產(chǎn)品和服務；打造開放共贏平臺，與合作伙伴共同營造健康的互聯(lián)網(wǎng)生態(tài)環(huán)境。為余姚企業(yè)提供專業(yè)的網(wǎng)站制作、網(wǎng)站建設，余姚網(wǎng)站改版等技術服務。擁有10余年豐富建站經(jīng)驗和眾多成功案例,為您定制開發(fā)。

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

網(wǎng)站標題：WIPReturnCost
轉載源于：http://jinyejixie.com/article8/ijggop.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供外貿建站、App開發(fā)、品牌網(wǎng)站設計、標簽優(yōu)化、企業(yè)網(wǎng)站制作、定制網(wǎng)站

聲明：本網(wǎng)站發(fā)布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經(jīng)允許不得轉載，或轉載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內容