Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029730
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2015-04-29 12:092015-08-20 23:16
ReporterpsanjuanView Statuspublic 
Assigned Toaferraz 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision0390d75ed291
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Review Assigned Tovmromanos
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0029730: [Cost Adjustments] It should not be possible to manually correct the cost of a transaction valued at Standard Cost.

DescriptionIt should not be possible to manually correct the cost of a transaction valued at Standard Cost.
Steps To ReproduceYou 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.





Proposed SolutionIt 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".
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0029729 closedaferraz Differences between actual cost and standard cost (variances) should not trigger Cost Adjustments. 
causes defect 0031080 closedaferraz Standard Algorithm is not working with Cost Adjustment: Inventory Amount Update and Manual Cost Correction 

-  Notes
(0078553)
psanjuan (manager)
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 (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2015-04-29 12:09 psanjuan New Issue
2015-04-29 12:09 psanjuan Assigned To => Triage Finance
2015-04-29 12:09 psanjuan Modules => Core
2015-04-29 12:09 psanjuan Triggers an Emergency Pack => No
2015-04-29 12:10 psanjuan Relationship added caused by 0029729
2015-04-30 09:50 psanjuan Summary [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:50 psanjuan Description Updated View Revisions
2015-04-30 09:50 psanjuan Steps to Reproduce Updated View Revisions
2015-04-30 13:16 psanjuan Summary [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:16 psanjuan Description Updated View Revisions
2015-04-30 13:16 psanjuan Steps to Reproduce Updated View Revisions
2015-04-30 13:29 psanjuan Steps to Reproduce Updated View Revisions
2015-04-30 13:29 psanjuan Proposed Solution updated
2015-04-30 13:30 psanjuan Steps to Reproduce Updated View Revisions
2015-05-04 12:31 dmitry_mezentsev Relationship replaced blocks 0029729
2015-06-11 17:38 aferraz Assigned To Triage Finance => aferraz
2015-06-29 12:33 psanjuan Note Added: 0078553
2015-06-29 14:18 psanjuan Note Edited: 0078553 View Revisions
2015-06-29 15:05 psanjuan Note Edited: 0078553 View Revisions
2015-06-29 15:30 psanjuan Note Edited: 0078553 View Revisions
2015-06-30 10:57 psanjuan Note Edited: 0078553 View Revisions
2015-07-07 11:29 hgbot Checkin
2015-07-07 11:29 hgbot Note Added: 0078704
2015-07-07 11:29 hgbot Status new => resolved
2015-07-07 11:29 hgbot Resolution open => fixed
2015-07-07 11:29 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0390d75ed2910f2f45334a5d92f2822802902a3d [^]
2015-07-07 11:30 vmromanos Review Assigned To => vmromanos
2015-07-07 11:30 vmromanos Status resolved => closed
2015-08-20 23:16 hudsonbot Checkin
2015-08-20 23:16 hudsonbot Note Added: 0079480
2015-10-09 10:58 VictorVillar Relationship added causes 0031080


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker