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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029735
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 04. Warehouse managementmajoralways2015-04-28 16:392015-05-04 12:13
ReporterVictorVillarView Statuspublic 
Assigned Toaferraz 
PriorityurgentResolutionfixedFixed in Version3.0PR15Q2
StatusclosedFix in branchFixed in SCM revisiond593b9e93b66
ProjectionnoneETAnoneTarget Version3.0PR15Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Toumartirena
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0029735: Wrong accounting of the cost adjusment lines under some circumstancies (Goods Movement)

DescriptionWrong accounting of the cost adjusment lines under some circumstancies (Goods Movement)
Steps To ReproduceAs group Admin role,
  Go to Product window:
    create a new one
    Name: test
  Add a purchase Price list: Tarifa bebidas
  unit/list price: 5

Costing Rule assigned to the organization should be "Average".

Go to Purchase Order:
   Create a new one for this product: qty: 10
Complete it.
Go to Goods receipt window,
  Create the lines from the Purchase Order created before.
  Storage Bin: RN- 2-0-0
Complete it.

Go to Goods movement,
  create a new one with this product.
  From: RN-2-0-0
  to: RN-0-0-0
Complete it

Go to Product window:
  create a new one
  Type: service
  name: transport
 Accounting tab:
Asset Account : 62400 Transportes
Product Expense : 62400 Transportes


Go to Landed Cost Type document:
 select the Distribution by Amount algorithm
 select the product: Transport


Create a landed cost document --> Cost 20 assigned to the Goods Receipt created before. Process it

Launch the Costing Background process and realise that the transactions have been calculted.

Go to Cost Adjustment document and Post it.
The entries posted are the ones related to the Goods Movement transaction which needs also to be adjusted.

Realise that the journal entry is:

35000 Productos terminados A Debit: 40.00
61000 Variación de existencias de mercaderías Credit: 40.00

That is wrong, as the net effect of the adjustment accounting should be 0.

Proposed SolutionTherefore correct posting should be:

(1) In the case of NOT allowing Negative Posting.

The journal entry for the Movement From transaction must be:

61000 Variación de existencias de mercaderías Debit: 20.00
35000 Productos terminados A Credit: 20.00

The journal entry for the 'Movement To' transaction must be:

35000 Productos terminados A Debit: 20.00
61000 Variación de existencias de mercaderías Credit: 20.00

(2) In the case of allowing Negative Posting.

The journal entry for the Movement From transaction must be:

35000 Productos terminados A Debit: -20.00
61000 Variación de existencias de mercaderías Credit: -20.00

The journal entry for the 'Movement To' transaction must be:

35000 Productos terminados A Debit: 20.00
61000 Variación de existencias de mercaderías Credit: 20.00
TagsApproved
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 00297203.0PR15Q3 closedaferraz Wrong accounting of the cost adjusment lines under some circumstancies (Goods Movement) 

-  Notes
(0076929)
hgbot (developer)
2015-05-04 12:12

Repository: erp/backports/3.0PR15Q2
Changeset: d593b9e93b662cc5de64c26cf5bfb38c98805bd2
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Apr 29 13:56:15 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/d593b9e93b662cc5de64c26cf5bfb38c98805bd2 [^]

Fixes issue 29735: Wrong accounting in Cost Adjusment

Wrong accounting of the cost adjusment lines in case of Goods Movement From.
In this case, accounting should consider negative amounts, in order to have a net effect of the goods movement adjustment accounting as 0.

---
M src/org/openbravo/erpCommon/ad_forms/DocCostAdjustment.java
---
(0076930)
hgbot (developer)
2015-05-04 12:12

Repository: erp/backports/3.0PR15Q2
Changeset: f30b59323b06148189262f5eaa4cf8b79901ec39
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Apr 29 16:35:18 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/f30b59323b06148189262f5eaa4cf8b79901ec39 [^]

Related to issue 29735: Modify TestCosting tests

Modify GM11, GM12, GM13 and GM5 tests, where cost adjustments from goods movements are created, to update accounting amounts

---
M src-test/src/org/openbravo/test/costing/TestCosting.java
---
(0076931)
umartirena (reporter)
2015-05-04 12:13

Code Review + Testing OK

- Issue History
Date Modified Username Field Change
2015-04-29 14:25 aferraz Type defect => backport
2015-04-29 14:25 aferraz Target Version 3.0PR15Q3 => 3.0PR15Q2.1
2015-04-30 14:08 dmitry_mezentsev Tag Attached: Approved
2015-05-04 10:18 umartirena Target Version 3.0PR15Q2.1 => 3.0PR15Q2
2015-05-04 12:12 hgbot Checkin
2015-05-04 12:12 hgbot Note Added: 0076929
2015-05-04 12:12 hgbot Status scheduled => resolved
2015-05-04 12:12 hgbot Resolution open => fixed
2015-05-04 12:12 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/d593b9e93b662cc5de64c26cf5bfb38c98805bd2 [^]
2015-05-04 12:12 hgbot Checkin
2015-05-04 12:12 hgbot Note Added: 0076930
2015-05-04 12:13 umartirena Review Assigned To => umartirena
2015-05-04 12:13 umartirena Note Added: 0076931
2015-05-04 12:13 umartirena Status resolved => closed
2015-05-04 12:13 umartirena Fixed in Version => 3.0PR15Q2


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker