Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027509Openbravo ERP03. Procurement managementpublic2014-08-29 14:182014-10-02 08:54
Reporterpsanjuan 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04.1
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027509: Matched Invoice posting is not correct if the purchase invoice is posted prior to the good receipt/s
DescriptionMatched Invoice posting is not correct if the purchase invoice is posted prior to the good receipt/s
Steps To ReproduceIn F&B International Group Client, navigate to Product window.
Create a new record and set:
Organization F&B US. Product Name "Costing A". Tax Category: Exempt.
Navigate to Price window, select "Be Soft Drinker Price List" and enter 25 as Unit and List prices.

Navigate to Purchase Order window and create a new record. Order date: 27/08/2014. Organization: F&B US
BP: Be Soft Drinker. Navigate to Lines and select Costing D product, enter 580 as ordered quantity. Book the order.

Navigate to Purchase Invoice window and create a new record. Invoice date and Accounting date: 30/08/2014. Enter Be soft Drinker BP and press "Create Lines From" button, select the order above.
Complete and Post the invoice. Posting would look like:

14.500 product expense - Account Payables 14.500 (580 * 25)

Navigate to Goods Receipt window and create a new record. Select F&B US organization and Be Soft..business partner.
Movement date/Accounting Date: 02/09/2014. Press the button Create Lines From. Select the order and in the field quantity modify to 80. Enter a Storage Bin. and press OK.
Complete.

Run the costing background process so this transaction is cost calculated therefore it can be post.
Post the receipt. Posting would look like:

2.000 Product Asset - Goods Receipt not invoiced 2.000 (80*25)

Navigate to Matched Invoices window and search by product: Costing D. Post the transaction. Posting would look like:

2.000 Goods Receipt not invoiced
12.500 Invoice Price difference - Product Expense 14.500

Above posting is not ok as it takes by granted that all units have been included in the Goods Receipt and that is not the case.








Proposed SolutionCorrect posting should be:

2.000 Goods Receipt not invoiced - Product Expense 2.000

Rest of goods receipts should also be related to the invoice, therefore every time that a new receipt is completed and post the corresponding posting is properly done.

Above can be done if the new goods receipt is created by using the process button "Create Lines From" and then selecting the Invoice.

In our example new goods receipt posting would look like:

12.500 Product asset - Goods Receipt and not invoiced 12.500

In our example if we navigate once again to the Matched Invoices window, we will realize that there is a new transaction for Costing A product. Posting looks like:

12.500 Goods receipt not invoiced
2.000 price difference - product expense 14.500

Once more above posting is not correct.

Correct one should be:

12.500 Goods Receipt not invoiced - Product Expense 12.500
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-29 14:18psanjuanNew Issue
2014-08-29 14:18psanjuanAssigned To => dmiguelez
2014-08-29 14:18psanjuanOBNetwork customer => No
2014-08-29 14:18psanjuanModules => Core
2014-08-29 14:18psanjuanTriggers an Emergency Pack => No
2014-08-29 14:35psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6494#r6494
2014-08-29 14:36psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6495#r6495
2014-08-29 14:39psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6496#r6496
2014-08-29 14:39psanjuanProposed Solution updated
2014-08-29 14:47psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6497#r6497
2014-08-29 14:47psanjuanProposed Solution updated
2014-08-29 14:51psanjuanProposed Solution updated
2014-08-29 14:53psanjuanProposed Solution updated
2014-08-29 14:55psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6498#r6498
2014-08-29 14:55psanjuanProposed Solution updated
2014-08-29 14:58psanjuanProposed Solution updated
2014-08-29 14:59psanjuanProposed Solution updated
2014-08-29 15:00psanjuanProposed Solution updated
2014-10-01 18:45hgbotCheckin
2014-10-01 18:45hgbotNote Added: 0070627
2014-10-01 18:45hgbotStatusnew => resolved
2014-10-01 18:45hgbotResolutionopen => fixed
2014-10-01 18:45hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/72175c27ab9942c791e98e92eff97b9810dfb667 [^]
2014-10-02 08:54psanjuanNote Added: 0070646
2014-10-02 08:54psanjuanStatusresolved => closed
2014-10-02 08:56psanjuanNote Edited: 0070646bug_revision_view_page.php?bugnote_id=0070646#r6714

Notes
(0070627)
hgbot   
2014-10-01 18:45   
Repository: erp/devel/pi
Changeset: 72175c27ab9942c791e98e92eff97b9810dfb667
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Sep 25 10:19:09 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/72175c27ab9942c791e98e92eff97b9810dfb667 [^]

Fixes bug 27509: Matched Invoice posting is not correct...

---
M src/org/openbravo/erpCommon/ad_forms/DocMatchInv.java
---
(0070646)
psanjuan   
2014-10-02 08:54   
(edited on: 2014-10-02 08:56)
fixed and working.

Please see document attached

https://docs.google.com/a/openbravo.com/spreadsheets/d/1Ilm1oct0vH4iKFlI1I0VbmYM-r8fdo1moK02jd2Zigg/edit#gid=1025660841 [^]

Products:
Costing DDD
Costing V91