Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0027509Openbravo ERP03. Procurement managementpublic2014-08-29 14:182014-10-02 08:54
psanjuan 
dmiguelez 
urgentmajoralways
closedfixed 
20Ubuntu 8.04.1
 
 
Core
No
0027509: Matched Invoice posting is not correct if the purchase invoice is posted prior to the good receipt/s
Matched Invoice posting is not correct if the purchase invoice is posted prior to the good receipt/s
In 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.








Correct 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
No tags attached.
Issue History
2014-08-29 14:18psanjuanNew Issue
2014-08-29 14:18psanjuanAssigned To => dmiguelez
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