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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0041694
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 04. Warehouse managementmajoralways2019-08-26 14:142020-01-20 14:07
ReporterngarciaView Statuspublic 
Assigned ToTriage Omni WMS 
PriorityurgentResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revisionbf50dc6daf1a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToSandrahuguet
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0041694: Wrong accounting entry for Cost Adjustments over production products with transactions in more than one legal organization

DescriptionWrong accounting entry for Cost Adjustments over production products with transactions in more than one legal organization
Steps To ReproduceAs group admin role:
   In Organization window, remove the General Ledger from 'F&B International Group' organization
   Assign 'F&B International Group US/A/US Dollar' general ledger to 'F&B US, Inc.' organization
   Create a new product in * organization
   Set it as production
   Create a Goods Receipt in F&B España Region Norte
   Create another Goods Receipt in F&B US, East Coast
   Add a purchase price list in the price lists of the two business partner included
   Create a Goods Shipment in F&B US, East Coast
   Launch the costing background process and check the costing entries are created at * level (as it is a production product)
   Add a manual cost adjustment to the transaction related to the goods receipt done in España Region Norte
   Post it
   BEFORE THE FIX: Check there are accounting entries created for F&B US East Cost and F&B España, S.A. US/A/Euro general ledger
   AFTER THE FIX: Check there are some cost adjustment lines with Need Posting = 'Y' that belong to F&B US that did not generate any accounting entry
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by feature request 0024530 newTriage Omni WMS The Cost of the Manufacturing products should be calculated with the new costing engine. 

-  Notes
(0114285)
collazoandy4 (reporter)
2019-08-27 21:26
edited on: 2019-09-10 16:50

 Test Plan
  As group admin role:
   Create a new production product (Costing) in * organization
     Set a standard cost of 5
   Create a Goods Receipt in F&B España Region Norte for Costing product with 5 units
   Create another Goods Receipt in F&B US, East Coast for Costing product with 10 units
   Create a Goods Shipment in F&B US, East Coast for 10 units of Costing product
   Launch the costing background process and check the product transactions have cost calculated
   Add a manual cost adjustment to the transaction related to the goods receipt done in España Region Norte
   Go to the new cost adjustment created and Post it and check
     Accounting entries for F&B US East Cost organizations are only for F&B International Group US/A/US Dollar General Ledger
     Accounting entries for F&B España - Región Norte are for both general ledgers (F&B España, S.A. US/A/Euro and F&B International Group US/A/US Dollar)
Test Plan II
  As group admin role
    Create a new production product (Costing2) in * organization
     Set a standard cost of 5
   Create a Goods Receipt in F&B España Region Norte for Costing2 product with 5 units
   Create a Goods Shipment in F&B España Region Norte for 5 units of Costing2 product
   Launch the costing background process and check the product transactions have cost calculated
   Add a manual cost adjustment to the transaction related to the goods receipt
   Go to the new cost adjustment created and Post it and check
     Accounting entries for F&B España - Región Norte are for both general ledgers (F&B España, S.A. US/A/Euro and F&B International Group US/A/US Dollar)
Test Plan III
  As group admin role
    Create a new production product (Costing3) in * organization
     Set a standard cost of 5
   Create a Goods Receipt in F&B US, East Coast for Costing3 product with 5 units
   Create a Goods Shipment in F&B US, East Coast for 5 units of Costing3 product
   Launch the costing background process and check the product transactions have cost calculated
   Add a manual cost adjustment to the transaction related to the goods receipt
   Go to the new cost adjustment created and Post it and check
     Accounting entries for F&B US East Cost organizations are only for F&B International Group US/A/US Dollar General Ledger
(0114326)
hgbot (developer)
2019-08-29 13:15

 Repository: erp/devel/pi
Changeset: bf50dc6daf1aab806e09d74cdd1ee944d2fae99f
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Tue Aug 27 15:02:18 2019 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/bf50dc6daf1aab806e09d74cdd1ee944d2fae99f [^]

Fixes issue 41694: Wrong accounting entry for Cost Adjustments over production
products with transactions in more than one legal organization

When a Cost adjustment have lines from with organizations that doesn't belongs to
the same natural tree a wrong accounting schema was used to create the fact lines.

Now the accounting schema used to create the fact lines are checked if it's belongs
to the same natural tree than the transaction line.

---
M src/org/openbravo/erpCommon/ad_forms/DocCostAdjustment.java
---
(0114327)
Sandrahuguet (developer)
2019-08-29 13:17

 code review + testing ok
(0114346)
hudsonbot (developer)
2019-08-30 20:01

 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/981eeb35474e [^]
Maturity status: Test
(0114458)
ngarcia (developer)
2019-09-09 13:43
edited on: 2019-09-09 13:44

 With the current solution, cost adjustment lines are only posted if they belong to an organization that generates accounting in the general ledgers assigned to the document's organization.

Each transaction should generate accounting in the corresponding General Ledger.

I will update the steps to reproduce the situation
(0114505)
collazoandy4 (reporter)
2019-09-10 16:50

 Test Plan IV
  As group admin role
    In Organization window, remove the General Ledger from 'F&B International Group' organization
    Assign 'F&B International Group US/A/US Dollar' general ledger to 'F&B US, Inc.' organization
    Create a new production product (Costing4) in * organization
       Add two purchase price of 5, one for Spain and Another for US
    Create a Goods Receipt in F&B España Region Norte for Costing4 product with 5 units
    Create another Goods Receipt in F&B US, East Coast for Costing4 product with 10 units
    Create a Goods Shipment in F&B US, East Coast for 10 units of Costing4 product
    Launch the costing background process and check the product transactions have cost calculated
    Add a manual cost adjustment to the transaction related to the goods receipt done in España Region Norte
    Go to the new cost adjustment created and Post it and check
      Accounting entries for F&B US East Cost organizations are only for F&B International Group US/A/US Dollar General Ledger
      Accounting entries for F&B España - Región Norte are for both general ledgers (F&B España, S.A. US/A/Euro and F&B International Group US/A/US Dollar)
(0114611)
hgbot (developer)
2019-09-18 08:36

 Repository: erp/devel/pi
Changeset: 8051c60ae08c1a3b9469cb8cd32b403fe846e545
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Sep 18 08:29:08 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8051c60ae08c1a3b9469cb8cd32b403fe846e545 [^]

related to issue 41694 Backed out changeset bf50dc6daf1a

---
M src/org/openbravo/erpCommon/ad_forms/DocCostAdjustment.java
---
(0114644)
hudsonbot (developer)
2019-09-18 15:36

 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/39a64f55bfbd [^]
Maturity status: Test
(0114718)
Sandrahuguet (developer)
2019-09-23 11:16

 Set as a design defect, the problem is that production has not been migrated to the new cost engine. See issue https://issues.openbravo.com/view.php?id=24530 [^]

- Issue History
Date Modified Username Field Change
2019-08-26 14:14 ngarcia New Issue
2019-08-26 14:14 ngarcia Assigned To => Triage Finance
2019-08-26 14:14 ngarcia Modules => Core
2019-08-26 14:14 ngarcia Resolution time => 1568584800
2019-08-26 14:14 ngarcia Triggers an Emergency Pack => No
2019-08-26 14:14 ngarcia Issue Monitored: networkb
2019-08-27 14:56 aferraz Assigned To Triage Finance => collazoandy4
2019-08-27 20:05 collazoandy4 Status new => scheduled
2019-08-27 21:26 collazoandy4 Note Added: 0114285
2019-08-29 13:15 hgbot Checkin
2019-08-29 13:15 hgbot Note Added: 0114326
2019-08-29 13:15 hgbot Status scheduled => resolved
2019-08-29 13:15 hgbot Resolution open => fixed
2019-08-29 13:15 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bf50dc6daf1aab806e09d74cdd1ee944d2fae99f [^]
2019-08-29 13:17 Sandrahuguet Review Assigned To => Sandrahuguet
2019-08-29 13:17 Sandrahuguet Note Added: 0114327
2019-08-29 13:17 Sandrahuguet Status resolved => closed
2019-08-29 13:17 Sandrahuguet Fixed in Version => 3.0PR19Q4
2019-08-30 20:01 hudsonbot Checkin
2019-08-30 20:01 hudsonbot Note Added: 0114346
2019-09-09 13:43 ngarcia Assigned To collazoandy4 => Triage Finance
2019-09-09 13:43 ngarcia Note Added: 0114458
2019-09-09 13:43 ngarcia Status closed => new
2019-09-09 13:43 ngarcia Resolution fixed => open
2019-09-09 13:43 ngarcia Fixed in Version 3.0PR19Q4 =>
2019-09-09 13:44 ngarcia Note Edited: 0114458 View Revisions
2019-09-09 13:47 ngarcia Steps to Reproduce Updated View Revisions
2019-09-09 13:57 Sandrahuguet Assigned To Triage Finance => collazoandy4
2019-09-09 22:40 collazoandy4 Status new => scheduled
2019-09-10 16:50 collazoandy4 Note Added: 0114505
2019-09-10 16:50 collazoandy4 Note Edited: 0114285 View Revisions
2019-09-16 14:02 ngarcia Relationship added caused by 0024530
2019-09-18 08:36 hgbot Checkin
2019-09-18 08:36 hgbot Note Added: 0114611
2019-09-18 15:36 hudsonbot Checkin
2019-09-18 15:36 hudsonbot Note Added: 0114644
2019-09-23 11:12 Sandrahuguet Type defect => design defect
2019-09-23 11:16 Sandrahuguet Note Added: 0114718
2019-09-23 11:33 Sandrahuguet Assigned To collazoandy4 => Triage Finance
2019-09-23 11:33 Sandrahuguet Status scheduled => acknowledged
2020-01-20 14:07 ngarcia Resolution time 1568584800 =>

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker