Purchase Order Re-Activate cause Wrong Cost price

Description

1. set Average PO in accounting schema
2. create a brand new product e.g. TP3
3. create PO for 11USD 1xqty
4. create MR for 1qty (system create matching PO record and create costing records)
5. Open Product Cost window
Cost Tab - Current Cost Price = 11.00, Accumulated Qty = 1, Accumulated Amt = 11USD
Cost detail - refering to PO with 11 USD
6. Open PO Re-Activate it, change PriceEntered from 11 to 33 complete it, Match PO and MR again.

BUGS
1. PO Re-Activate doesn't delete matching PO - Implement or Disallow Reactivate until Matching exists
2. M_CostDetail.CurrentCostPrice is not changed still 11 instead 33. (this happening on 2nd and next test rounds)
3. Delete PO Matching doesn't delete m_costhistory record so if e.g. 5x reactivate PO then 5 records created.

Environment

4.1.0.v20170218-0824

Activity

Show:

Patric June 25, 2020 at 7:16 AM

reproduced by Patric Massing

may a possible solution could be to not allow to modify the Purchase Order Line if a material receipt exists.
So the first step is to reverse/void the material receipt.
If the material receipt is then created anew, the current cost price is correct calculated.

Joseph Chu May 4, 2017 at 6:41 PM

BUG 2 is same to me:

1-5: reproduced
6 : After price modified and PO completed with same qty , this PO CANT be matched with MR as done before. (Matching PO records exist)

So,
As step 6 done, product cost have no change wanted. Error price make a wrong cost used by followed document (MR , PO), how can correct all ?

Thanks for reviewer.

Norbert Bede April 2, 2017 at 9:44 AM

Note to BUG 2. our customer mischmatch UOM and enter instead 0.2 EUR 8000 EUR as unit price. Because on reactivation Matching PO no deleted automatically and user doesnt delete it THEN product cost were not updated because matching not created again. This case long term cost difference.

Details

Assignee

Reporter

Labels

Tested By

Norbert Bede

Components

Affects versions

Priority

Created April 2, 2017 at 9:21 AM
Updated June 25, 2020 at 7:16 AM