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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0023066
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2013-02-13 11:232013-02-20 04:50
ReportermiruritaView Statuspublic 
Assigned Toeduardo_Argal 
PrioritynormalResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revision82031a01853c
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionpiSCM revision 
Review Assigned Tomirurita
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023066: Matched Invoices accounting not using breakdown information

DescriptionMatched Invoices accounting not using breakdown information.
The price difference between order and invoice should be distributed taking in account the breakdown of the invoice (which has been inherited from the order).
Steps To Reproduce1) Login as System Administrator
2) Go to Purchase Order || Accounting dimension tab and change:
  - UI Pattern: Standard
  - Active: true
3) Login as F&B International Group Admin
4) Create 2 projects
  - MyProject1
  - MyProject2
5) Enable project dimension to be displayed at purchase order line breakdown
6) Go to Product window and update
     - Cerveza Ale 0,5L
          - Product Type: expense type
          - Sale: false
          - Book Using Purchase Order Price: true
7) Create new Purchase Order
  Header
   - Organization: F&B España - Región Norte
   - Business Partner: Bebidas Alegres, S.L.

   * Line
     - Line No: 10
     - Product: Cerveza Ale 0,5L
     - Ordered Quantity: 100
     - Net Unit Price: 1.36
     - Tax: Compras exentas

      * Accounting dimension 1
        - Line: 10
        - Amount: 100
        - Project: MyProject1
      * Accounting dimension
        - Line: 20
        - Amount: 36
        - Project: MyProject2
8) Post the Purchase Order
100 debit (MyProject1)
 36 debit (MyProject1)

9) Go to Pending Goods receipts and receive the full order
10) Enable goods receipt accounting (General Ledger Configuration || Active Tables) for Spain
11) Go to created Goods Receipt document and post
12) Fully invoice the previous order as follows:
   * Line
     - Line No: 10
     - Product: Cerveza Ale 0,5L
     - Ordered Quantity: 100
     - Net Unit Price: 1.4 (prices has changed!!!!)
     - Tax: Compras exentas
      * Accounting dimension 1
        - Line: 10
        - Amount: 102,94
        - Project: MyProject1
      * Accounting dimension
        - Line: 20
        - Amount: 37,06
        - Project: MyProject2

13) Post the invoice
102.94 debit (MyProject1)
37.06 debit (MyProject2)

14) Enable matched invoices accounting (General Ledger Configuration || Active Tables) for Spain
15) Post the matched invoice
Realize that the difference it is not taking in account the breakdown.
See attached screenshot.

----------------------------------
4 debit (the assigned project is wrong)
                                          140 credit (the assigned project is wrong)
----------------------------------

it should be:

----------------------------------
1.06 debit (MyProject1)
2.94 debit (MyProject2)
                          102.94 credit (MyProject1)
                          37.06 credit (MyProject2)
----------------------------------
TagsNo tags attached.
Attached Filespng file icon MathedInvoices_breakdown_accounting.png [^] (14,528 bytes) 2013-02-13 11:23

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0031354 closedvmromanos Wrong amtsourcedr and amtsourcecr when posting a Matched Invoice document 

-  Notes
(0056439)
hgbot (developer)
2013-02-14 12:32

 Repository: erp/devel/pi
Changeset: 82031a01853c9878faf812a2e049b5782b44e2e9
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Feb 14 12:32:14 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/82031a01853c9878faf812a2e049b5782b44e2e9 [^]

Fixes bug 23066

---
M src/org/openbravo/erpCommon/ad_forms/DocMatchInv.java
M src/org/openbravo/erpCommon/ad_forms/DocMatchInv_data.xsql
---
(0056496)
mirurita (developer)
2013-02-15 18:05

 code review + testing OK

Testing Plan
1) Create new Purchase Order
  Header
   - Organization: F&B España - Región Norte
   - Business Partner: Refrescos Naturales S.A.
   * Line
     - Line No: 10
     - Product: Agua sin Gas 1L
     - Ordered Quantity: 100
     - Net Unit Price: 1.02
     - Tax: Compras exentas

2) Go to Pending Goods receipts and receive the full order
3) Enable goods receipt accounting (General Ledger Configuration || Active Tables)
4) Go to created Goods Receipt document and post
5) Create a purchase invoice from purchase order of step 3
6) Update the unit price to 1.03. The total of the invoice will be 103
7) Complete and post the invoice
8) Enable matched invoices accounting (General Ledger Configuration || Active Tables)
9) Configure invoice price variance account for "Agua sin Gas 1L" product.
10) Got o Matched Invoices window and post the record generated for previous invoice.
11) Go to "Accounting Transactions Details" window and apply filters to check if the 1€ of difference has been posted.
(0056601)
hudsonbot (developer)
2013-02-20 04:50

 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/d828167a9e83 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2013-02-13 11:23 mirurita New Issue
2013-02-13 11:23 mirurita Assigned To => dmiguelez
2013-02-13 11:23 mirurita File Added: MathedInvoices_breakdown_accounting.png
2013-02-13 11:23 mirurita Modules => Core
2013-02-13 11:23 mirurita Triggers an Emergency Pack => No
2013-02-13 13:06 eduardo_Argal Assigned To dmiguelez => eduardo_Argal
2013-02-13 17:26 eduardo_Argal Status new => scheduled
2013-02-13 17:26 eduardo_Argal fix_in_branch => pi
2013-02-14 12:32 hgbot Checkin
2013-02-14 12:32 hgbot Note Added: 0056439
2013-02-14 12:32 hgbot Status scheduled => resolved
2013-02-14 12:32 hgbot Resolution open => fixed
2013-02-14 12:32 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/82031a01853c9878faf812a2e049b5782b44e2e9 [^]
2013-02-15 18:05 mirurita Review Assigned To => mirurita
2013-02-15 18:05 mirurita Note Added: 0056496
2013-02-15 18:05 mirurita Status resolved => closed
2013-02-15 18:05 mirurita Fixed in Version => pi
2013-02-20 04:50 hudsonbot Checkin
2013-02-20 04:50 hudsonbot Note Added: 0056601
2015-11-16 12:42 vmromanos Relationship added related to 0031354

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker