Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0029730Openbravo ERP04. Warehouse managementpublic2015-04-29 12:092015-08-20 23:16
psanjuan 
aferraz 
urgentmajoralways
closedfixed 
20Ubuntu 8.04.1
 
 
vmromanos
Core
No
0029730: [Cost Adjustments] It should not be possible to manually correct the cost of a transaction valued at Standard Cost.
It should not be possible to manually correct the cost of a transaction valued at Standard Cost.
You should work with Standard algorithm set in the costing rule of the organization.

Navigate to Product window and create a new product named "Manual Cost Standard"
Select a purchase price list version and enter 100.00 as unit/list price.
Go to Costing tab and enter an standard cost = 100.00

Go to purchase order and create an order for 820 units of the product. Book the order.
Go to goods receipt and create a new one for the order above by using "Create Lines From". Receipt 820 into the warehouse. Complete and post the receipt.

Product Asset account value of the product is set to 82.000
Realize that standard cost is 100.00 and the cost of the transaction (receipt) is 82.000. Inventory and Accounting are equal.

Go back to the product window, transaction tab and select the receipt transaction.

Press the Manual Cost Adjustment process button.

Enter a total cost amount of 550, an accounting date and select the field "Incremental".
Press Done.

Realize that the Total Cost of the transaction has changed to 82550 while the cost (standard cost) remains as it is.

Navigate to the cost adjustment and post it.
Posting looks like

550 Product Asset account Debit
550 Inventory Variance Credit.

All of this means that inventory and accounting values do not match for that product.
Same way it will not be possible to release that difference in any output transaction of the product, as all of those output transactions will be valued at the standard cost that is 100.00

This behaviour is not correct in case of standard cost.





It should not be possible to manually adjust the cost of a transaction dated on a given date, whether for that given date the costing algorithm used in the costing rule available is "Standard".
No tags attached.
blocks defect 0029729 closed aferraz Differences between actual cost and standard cost (variances) should not trigger Cost Adjustments. 
causes defect 0031080 closed aferraz Standard Algorithm is not working with Cost Adjustment: Inventory Amount Update and Manual Cost Correction 
Issue History
2015-04-29 12:09psanjuanNew Issue
2015-04-29 12:09psanjuanAssigned To => Triage Finance
2015-04-29 12:09psanjuanModules => Core
2015-04-29 12:09psanjuanTriggers an Emergency Pack => No
2015-04-29 12:10psanjuanRelationship addedcaused by 0029729
2015-04-30 09:50psanjuanSummary[Cost Adjustments] It should not be possible to Manually correct the cost of a transaction while working with Standard Cost. => [Cost Adjustments] It should not be possible to Manually correct the cost of a transaction valued at Standard Cost.
2015-04-30 09:50psanjuanDescription Updatedbug_revision_view_page.php?rev_id=8389#r8389
2015-04-30 09:50psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=8391#r8391
2015-04-30 13:16psanjuanSummary[Cost Adjustments] It should not be possible to Manually correct the cost of a transaction valued at Standard Cost. => [Cost Adjustments] It should not be possible to manually correct the cost of a transaction valued at Standard Cost.
2015-04-30 13:16psanjuanDescription Updatedbug_revision_view_page.php?rev_id=8398#r8398
2015-04-30 13:16psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=8399#r8399
2015-04-30 13:29psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=8400#r8400
2015-04-30 13:29psanjuanProposed Solution updated
2015-04-30 13:30psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=8401#r8401
2015-05-04 12:31dmitry_mezentsevRelationship replacedblocks 0029729
2015-06-11 17:38aferrazAssigned ToTriage Finance => aferraz
2015-06-29 12:33psanjuanNote Added: 0078553
2015-06-29 14:18psanjuanNote Edited: 0078553bug_revision_view_page.php?bugnote_id=0078553#r8930
2015-06-29 15:05psanjuanNote Edited: 0078553bug_revision_view_page.php?bugnote_id=0078553#r8933
2015-06-29 15:30psanjuanNote Edited: 0078553bug_revision_view_page.php?bugnote_id=0078553#r8934
2015-06-30 10:57psanjuanNote Edited: 0078553bug_revision_view_page.php?bugnote_id=0078553#r8941
2015-07-07 11:29hgbotCheckin
2015-07-07 11:29hgbotNote Added: 0078704
2015-07-07 11:29hgbotStatusnew => resolved
2015-07-07 11:29hgbotResolutionopen => fixed
2015-07-07 11:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0390d75ed2910f2f45334a5d92f2822802902a3d [^]
2015-07-07 11:30vmromanosReview Assigned To => vmromanos
2015-07-07 11:30vmromanosStatusresolved => closed
2015-08-20 23:16hudsonbotCheckin
2015-08-20 23:16hudsonbotNote Added: 0079480
2015-10-09 10:58VictorVillarRelationship addedcauses 0031080

Notes
(0078553)
psanjuan   
2015-06-29 12:33   
(edited on: 2015-06-30 10:57)
Verified

Test Plan I
Organization having Average algorithm defined in the corresponding Costing Rule.
All Products setup for that organization are valued under Average Algorithm.
It is possible to manually adjust Product transactions. "Manual Cost Adjustment" process button is shown.

Test Plan II
Organization having Standard algorithm defined in the corresponding Costing Rule.
All Products setup for that organization are valued under Standard Algorithm.
It is not possible to manually adjust Product transactions."Manual Cost Adjustment" process button is NOT shown.

Test Plan III
Organization having an Average algorithm defined in the corresponding costing rule.
All Products setup for that organization are valued under Average Algorithm.
It is possible to manually adjust Product transactions."Manual Cost Adjustment" process button is shown.
A new costing rule is created based on Standard algorithm. New transactions valued at Standard cost can not be manually changed.

Test Plan IV
Organization having a Standard algorithm defined in the corresponding costing rule.
All Products setup for that organization are valued under Standard Algorithm.
It is not possible to manually adjust Product transactions."Manual Cost Adjustment" process button is not shown.
A new costing rule is created based on Average algorithm. New transactions valued at Average cost can be manually changed.

(0078704)
hgbot   
2015-07-07 11:29   
Repository: erp/devel/pi
Changeset: 0390d75ed2910f2f45334a5d92f2822802902a3d
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Jun 12 12:13:50 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0390d75ed2910f2f45334a5d92f2822802902a3d [^]

Fixes issue 29730: Avoid manual cost correction in Standard Cost transactions

Manual Cost Adjustment button will not appear in transactions with standard costing algorithm to avoid manual cost correction in this type of transactions.

---
M src-db/database/sourcedata/AD_FIELD.xml
---
(0079480)
hudsonbot   
2015-08-20 23:16   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8c91718397a5 [^]
Maturity status: Test