WIP Return Cost

In this Document

Applies to:

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
 

猜你喜欢

AI推送时光机

WIP Return Cost

后端开发2023-06-05

Incorrect Cost for WIP Assembly Return 1

后端开发2023-06-05

WIP Completion Return Wrong value

后端开发2023-06-05

WIP PERIOD BALANCE

后端开发2023-06-05

javascript中return,return true,return false三者的用法

后端开发2023-08-09

PostgreSQL DBA(175) - Cost EST（SeqScan）

后端开发2024-04-02

Oracle中怎么创建WIP任务单

后端开发2024-04-02

全表扫描的COST计算

后端开发2024-04-02

python中，exit，return,

后端开发2023-01-31

python: return 函数

后端开发2023-01-31

C语言中return用法 return 1什么意思

后端开发2023-08-18

return用法总结

后端开发2021-12-06

C语言中的return true和return false有什么区别

后端开发2023-08-19

javascript return函数吗

后端开发2023-05-17

php return怎么用

后端开发2023-06-07

python中Return浅析

后端开发2023-01-31

CBO如何选择相同cost的索引

后端开发2024-04-02

Python中return的用法

后端开发2023-06-20

php中return的作用

后端开发2024-05-01

php中return的作用

后端开发2024-05-01

首页课程

资料下载问答资讯