Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0028073 | Openbravo ERP | 03. Procurement management | public | 2014-11-04 10:40 | 2017-05-29 17:43 |
|
| Reporter | psanjuan | |
| Assigned To | markmm82 | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Ubuntu 8.04.1 |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q3 | |
| Merge Request Status | |
| Review Assigned To | aferraz |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 46038 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0028073: Purchase Invoice do not properly created by using "Create Lines From" button if a goods receipt has been voided. |
| Description | Purchase Invoice do not properly created by using "Create Lines From" button if a goods receipt has been voided. |
| Steps To Reproduce | Go to Product window. Create a new product named "New Product". Select F&B España org while creating the product. Go to Price tab and select "Tarifa Bebidas Alegres". Enter a unit/list price of 10.00
Go to Purchase order and create a new order for F&B España. Select "New product" and "Bebidas Alegres" business partner. Enter a quantity of 500 units. Book the order.
Go to Goods Receipt window and create a new receipt for "F&B España" and "Bebidas Alegres" business partner. Use "Create Lines From" process button and select the order. Receipt all quantity, that is 500 Units. Enter a Storage Bin. Complete the receipt
Void the Receipt by using the process button "Close" and then Void.
Enter a new receipt for "F&B España" and "Bebidas Alegres" business partner. Use "Create Lines From" process button and select the order. Receipt 150 units. Enter a Storage Bin. Complete the receipt.
Go to purchase invoice window and create a new one for "F&B España" and "Bebidas Alegres" business partner. Click on "Create Lines From".
Realize that 3 lines are created in "lines" tab and only one should be created, the one related to the 150 units actually receipt. See image attached.
|
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  issue_28073.png (126,773) 2014-11-04 10:49
https://issues.openbravo.com/file_download.php?file_id=7472&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-11-04 10:40 | psanjuan | New Issue | |
| 2014-11-04 10:40 | psanjuan | Assigned To | => dmiguelez |
| 2014-11-04 10:40 | psanjuan | OBNetwork customer | => No |
| 2014-11-04 10:40 | psanjuan | Modules | => Core |
| 2014-11-04 10:40 | psanjuan | Triggers an Emergency Pack | => No |
| 2014-11-04 10:49 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6940#r6940 |
| 2014-11-04 10:49 | psanjuan | File Added: issue_28073.png | |
| 2014-11-12 10:51 | psanjuan | Note Added: 0071592 | |
| 2016-01-27 02:21 | rqueralta | Note Added: 0083629 | |
| 2017-03-27 18:42 | ngarcia | OBNetwork customer | No => Yes |
| 2017-03-27 18:42 | ngarcia | Support ticket | => 46038 |
| 2017-03-27 18:42 | ngarcia | Resolution time | => 1492380000 |
| 2017-03-27 18:42 | ngarcia | Issue Monitored: ngarcia | |
| 2017-03-27 18:42 | ngarcia | Assigned To | dmiguelez => Triage Finance |
| 2017-03-27 18:47 | ngarcia | Note Added: 0095594 | |
| 2017-03-27 21:00 | Practics | Issue Monitored: Practics | |
| 2017-03-29 15:22 | aferraz | Assigned To | Triage Finance => markmm82 |
| 2017-03-29 21:59 | markmm82 | Status | new => scheduled |
| 2017-03-30 18:29 | markmm82 | Note Added: 0095734 | |
| 2017-03-30 18:31 | markmm82 | Note Added: 0095735 | |
| 2017-03-30 20:00 | markmm82 | Note Edited: 0095735 | bug_revision_view_page.php?bugnote_id=0095735#r14929 |
| 2017-04-03 13:12 | hgbot | Checkin | |
| 2017-04-03 13:12 | hgbot | Note Added: 0095799 | |
| 2017-04-03 13:12 | hgbot | Status | scheduled => resolved |
| 2017-04-03 13:12 | hgbot | Resolution | open => fixed |
| 2017-04-03 13:12 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/2933c75ab71382bc872e4178614fda319bbb4f70 [^] |
| 2017-04-03 13:14 | aferraz | Review Assigned To | => aferraz |
| 2017-04-03 13:14 | aferraz | Note Added: 0095800 | |
| 2017-04-03 13:14 | aferraz | Status | resolved => closed |
| 2017-04-03 13:14 | aferraz | Fixed in Version | => 3.0PR17Q3 |
| 2017-05-29 17:43 | hudsonbot | Checkin | |
| 2017-05-29 17:43 | hudsonbot | Note Added: 0096860 | |
|
Notes |
|
|
|
|
|
|
|
Test Plan
As F&B Internationa Group Admin
Go to Product window.
Create a new product named "New Product".
Select F&B España organization while creating the product.
Go to Price tab and select "Tarifa Bebidas Alegres".
Enter a unit/list price of 10.00.
Go to Purchase order window
Create a new order for F&B España.
Select "New product" and "Bebidas Alegres" business partner.
Enter a quantity of 500 units.
Book the order.
Go to Goods Receipt window
Create a new receipt for "F&B España" and "Bebidas Alegres" business partner.
Use "Create Lines From" process button and select the order.
Receipt all quantity, that is 500 Units.
Enter a Storage Bin.
Complete the receipt.
Void the Receipt by using the process button "Close" and then Void.
Enter a new receipt for "F&B España" and "Bebidas Alegres" business partner.
Use "Create Lines From" process button and select the order.
Receipt 150 units.
Enter a Storage Bin.
Complete the receipt.
Go to Purchase Invoice window
Create a new one for "F&B España" and "Bebidas Alegres" business partner.
Click on "Create Lines From".
Check that only one line was created in Lines tab related to the 150 units actually receipt.
This issue can't be reproduced |
|
|
|
|
If order is selected in Create Lines From process, the whole ordered quantity should be invoiced. In case there does not exist a new goods receipt and only the voided one an invoice with an amount of 0 is wrongly created.
Steps to reproduce:
- Create a Purchase Order, add a product to it and book it
- Create a Goods Receipt from it, complete it and void it
- Create a Purchase Invoice header, select the previously created order and check two lines are shown. The purchase invoice total gross amount is 0 |
|
|
|
|
|
|
|
(0095735)
|
|
markmm82
|
2017-03-30 18:31
(edited on: 2017-03-30 20:00) |
|
Test plan 1:
1. Create a Purchase Order, add a product to it and book it
2. Create a Goods Receipt from it, complete it and void it
3. Create a Purchase Invoice header, select the previously created order and check just one line is shown.
Notice that the whole ordered quantity has been invoiced, as consequence the purchase invoice total gross amount match the total amount of the selected order.
Test Plan 2:
As F&B International Group Admin
1. Go to Product window.
Create a new product named "New Product".
Select F&B España organization while creating the product.
Go to Price tab and select "Tarifa Bebidas Alegres".
Enter a unit/list price of 10.00.
2. Go to Purchase order window
Create a new order for F&B España.
Select "New product" and "Bebidas Alegres" business partner.
Enter a quantity of 500 units.
Select "Compras exentas" tax
Book the order.
Notice Total Gross Amount is 5000.
3. Go to Goods Receipt window
Create a new receipt for "F&B España" and "Bebidas Alegres" business partner.
Use "Create Lines From" process button and select the order.
Receipt all quantity, that is 500 Units.
Enter a Storage Bin.
Complete the receipt.
Void the Receipt by using the process button "Close" and then Void.
4. Go to Purchase Invoice window
Create a new one for "F&B España" and "Bebidas Alegres" business partner.
Click on "Create Lines From".
Select the previously created order. Press OK.
Check that only one line was created in Lines tab related to the 500 units actually receipt and Total Gross amount is the same than the order: 5000.
5. You can complete the invoice successfully.
Test Plan 3: One shipment voided and another one partially shipped.
1. Go to Product window.
Create a new product named "New Product".
Select F&B España organization while creating the product.
Go to Price tab and select "Tarifa Bebidas Alegres".
Enter a unit/list price of 10.00.
2. Go to Purchase order window
Create a new order for F&B España.
Select "New product" and "Bebidas Alegres" business partner.
Enter a quantity of 500 units.
Select "Compras exentas" tax
Book the order.
Notice Total Gross Amount is 5000.
3. Go to Goods Receipt window
Create a new receipt for "F&B España" and "Bebidas Alegres" business partner.
Use "Create Lines From" process button and select the order.
Receipt all quantity, that is 500 Units.
Enter a Storage Bin.
Complete the receipt.
Void the Receipt by using the process button "Close" and then Void.
4. Enter a new receipt for "F&B España" and "Bebidas Alegres" business partner.
Use "Create Lines From" process button and select the order.
Receipt 150 units.
Enter a Storage Bin.
Complete the receipt.
5. Go to Purchase Invoice window
Create a new one for "F&B España" and "Bebidas Alegres" business partner.
Click on "Create Lines From".
Select the previously created order. Press OK.
Check that only one line was created in Lines tab related to the receipt 150 units and Total Gross amount has been calculted according it: invoiced quantity * product price = 150 * 10 = 1500.
6. You can complete the invoice successfully.
|
|
|
|
(0095799)
|
|
hgbot
|
|
2017-04-03 13:12
|
|
Repository: erp/devel/pi
Changeset: 2933c75ab71382bc872e4178614fda319bbb4f70
Author: Mark <markmm82 <at> gmail.com>
Date: Thu Mar 30 12:19:44 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/2933c75ab71382bc872e4178614fda319bbb4f70 [^]
Fixes issue 28073: Wrong Purchase Invoice created by using "Create Lines From"
Purchase Invoice wasn't properly created by using "Create Lines From" process if
a goods receipt has been voided.
When the process was run selecting an order with a goods receipt voided, joins
between tables were adding lines related to the reverse goods receipt because the
goods receipt status wasn't taken into account.
To avoid it, was added to the query the condition that M_InOut.docstatus is
different than void ('VO') to not consider this lines of cancelled receipts.
---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
---
|
|
|
|
|
|
|
|
|
|