Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0018820Openbravo ERP03. Procurement managementpublic2011-10-20 13:162012-05-25 12:10
psanjuan 
Sandrahuguet 
highminoralways
closedfixed 
20Ubuntu 8.04.1
 
3.0MP12 
Google Chrome
Core
No
0018820: Create Purchase Invoices from Deliveries process seems not to work.
Create Purchase Invoices from Deliveries should behave as describe below:

"There is a process "Create Purchase Invoices from Deliveries" which allows to create supplier's invoices from deliveries or goods-shipments dated on a given period of time.
Let's imagine that our Company works with a supplier from whom we acquire very expensive items/goods. Besides our Company has an agreement with the supplier which implies that the supplier is not going to invoice those items to us until we tell them to do so, once those items have being sold and delivered to a customer.
This process can be found at the application path:
Procurement Management // Transactions // Create Purchase Invoices from Deliveries"

but...it seems it does not work.
Create at least two shipments on Sales Management for 2 items/products making sure that quantity on hand is enough for both of them.
Goods Shipments dated on October 2011.
Launch the process by entering below data:

- Starting Date = 01-10-2011
- Ending Date = 31-10-2011
- Warehouse = España Región Norte
- Vendor = Refrescos Frias
- Order Reference = empty
- Invoice Date = 31-10-2011

Press OK.
Nothing happens.
The process is completed properly but no purchase invoice is created.

We should research on the code because it could be something is missing here and that's the reason why it does not work.
VMA-Reviewed
related to defect 0018964 closed jonalegriaesarte "Create Purchase Invoices from Deliveries" should not be accessible to "Openbravo Admin" role as this is an advanced feature 
related to defect 0019528 closed umartirena Service Project should be hidden by the configuration script 
depends on defect 0020188pi closed Sandrahuguet Paymentrule is mandatory in the database in c_invoice table, and this field is deprecated now. 
related to defect 0017337 closed vmromanos Check why there's not way to launch the report 'Warehouse movement' (RptM_Movement) 
Issue History
2011-10-20 13:16psanjuanNew Issue
2011-10-20 13:16psanjuanAssigned To => jonalegriaesarte
2011-10-20 13:16psanjuanWeb browser => Google Chrome
2011-10-20 13:16psanjuanModules => Core
2011-11-03 13:11psanjuanRelationship addedrelated to 0018964
2012-02-15 19:04iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-16 17:49vmromanosTag Attached: VMA-Reviewed
2012-03-28 15:18SandrahuguetAssigned Tovmromanos => Sandrahuguet
2012-03-28 15:22SandrahuguetStatusnew => scheduled
2012-03-28 15:22Sandrahuguetfix_in_branch => pi
2012-04-03 13:30SandrahuguetNote Added: 0047342
2012-04-03 13:35SandrahuguetNote Edited: 0047342bug_revision_view_page.php?bugnote_id=0047342#r3331
2012-04-13 09:14SandrahuguetRelationship addeddepends on 0020188
2012-04-19 15:25vmromanosRelationship addedrelated to 0019528
2012-04-19 15:39vmromanosNote Added: 0047756
2012-04-20 12:15SandrahuguetNote Added: 0047784
2012-04-25 09:16hgbotCheckin
2012-04-25 09:16hgbotNote Added: 0047942
2012-04-25 09:16hgbotStatusscheduled => resolved
2012-04-25 09:16hgbotResolutionopen => fixed
2012-04-25 09:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cc3f11024ed78a12207012cc6968b184c1afa71c [^]
2012-04-25 09:16vmromanosNote Added: 0047943
2012-04-25 09:16vmromanosStatusresolved => closed
2012-04-25 09:16vmromanosFixed in Version => 3.0MP11
2012-04-25 15:50vmromanosStatusclosed => new
2012-04-25 15:50vmromanosResolutionfixed => open
2012-04-25 15:50vmromanosFixed in Version3.0MP11 =>
2012-04-25 15:50hgbotCheckin
2012-04-25 15:50hgbotNote Added: 0047961
2012-04-25 16:16SandrahuguetStatusnew => scheduled
2012-04-26 19:32hudsonbotCheckin
2012-04-26 19:32hudsonbotNote Added: 0048092
2012-04-26 19:32hudsonbotCheckin
2012-04-26 19:32hudsonbotNote Added: 0048095
2012-04-30 17:28naiaramartinezRelationship addedrelated to 0017337
2012-05-09 08:52hgbotCheckin
2012-05-09 08:52hgbotNote Added: 0048485
2012-05-09 08:52hgbotStatusscheduled => resolved
2012-05-09 08:52hgbotResolutionopen => fixed
2012-05-09 08:52hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/cc3f11024ed78a12207012cc6968b184c1afa71c [^] => http://code.openbravo.com/erp/devel/pi/rev/14fa9e4fa73f9163d8643ae7525612894ad636b1 [^]
2012-05-09 08:52vmromanosNote Added: 0048486
2012-05-09 08:52vmromanosStatusresolved => closed
2012-05-09 08:52vmromanosFixed in Version => 3.0MP12
2012-05-25 12:10hudsonbotCheckin
2012-05-25 12:10hudsonbotNote Added: 0049072

Notes
(0047342)
Sandrahuguet   
2012-04-03 13:30   
(edited on: 2012-04-03 13:35)
Test Plan 1:
Go to Goods Shipments and create one:
 - Organization: F&B US, Inc.
 - Warehouse: US East Coast
 - Business Partner: Happy Drinks, Inc.
 - Movement Date: 03-04-2012
 - Add a new line
   ·Product= Ale Beer
   ·Movement Quantity=2

Go to Create Purchase Invoices from Deliveries
 - Starting Date: 01-04-2012
 - Ending Date: 30-04-2012
 - Warehouse: US East Coast
 - Vendor: Happy Drinks, Inc.
 - Invoice Date: 30-04-2012

And you can see the purchase invoice create.

Test Plan 2:
Go to Goods Shipments and create one:
 - Organization: F&B US, Inc.
 - Warehouse: US East Coast
 - Business Partner: Happy Drinks, Inc.
 - Movement Date: 03-04-2012
 - Add a new line
   ·Product= Apple juice
   ·Movement Quantity=10

Go to Create Purchase Invoices from Deliveries
 - Starting Date: 01-04-2012
 - Ending Date: 30-04-2012
 - Warehouse: US East Coast
 - Vendor: Happy Drinks, Inc.
 - Invoice Date: 30-04-2012

And you can see the message: Has not defined a pricelist to the product Apple juice


Test Plan 3:
Go to Business Partner
Select Happy Drinks, Inc.
Go to vendor tab and select blank to Purchase Pricelist

Go to Create Purchase Invoices from Deliveries
 - Starting Date: 01-04-2012
 - Ending Date: 30-04-2012
 - Warehouse: US East Coast
 - Vendor: Happy Drinks, Inc.
 - Invoice Date: 30-04-2012

And you can see the message: Has not defined a pricelist to the business partner

(0047756)
vmromanos   
2012-04-19 15:39   
This process was developed for a very specific customer need. It creates purchase invoices for a concrete business partner for all the goods shipments related to a project (defined at the Service project window) where this business partner is included into the list of suppliers (Supplier tab).

The service project is not displayed anymore (0019528), so this process should also be hidden.
(0047784)
Sandrahuguet   
2012-04-20 12:15   
Test Plan:
In Quick Launch write Create Purchase Invoices from Deliveries, notice that you can not go to this process.
(0047942)
hgbot   
2012-04-25 09:16   
Repository: erp/devel/pi
Changeset: cc3f11024ed78a12207012cc6968b184c1afa71c
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Apr 25 09:04:40 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cc3f11024ed78a12207012cc6968b184c1afa71c [^]

Fixed issue 18820 Hidden Create PI from Deliveries process

---
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_PROCESS.xml
---
(0047943)
vmromanos   
2012-04-25 09:16   
code review + testing OK
(0047961)
hgbot   
2012-04-25 15:50   
Repository: erp/devel/pi
Changeset: 01c9ee1b4fb9a1b566fc487d578e6ff10e387d29
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed Apr 25 15:50:07 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/01c9ee1b4fb9a1b566fc487d578e6ff10e387d29 [^]

Issue 18820: backout changeset to fix API check

---
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_PROCESS.xml
---
(0048092)
hudsonbot   
2012-04-26 19:32   
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/70a717a9ffa1 [^]

Maturity status: Test
(0048095)
hudsonbot   
2012-04-26 19:32   
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/70a717a9ffa1 [^]

Maturity status: Test
(0048485)
hgbot   
2012-05-09 08:52   
Repository: erp/devel/pi
Changeset: 14fa9e4fa73f9163d8643ae7525612894ad636b1
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Apr 25 16:40:40 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/14fa9e4fa73f9163d8643ae7525612894ad636b1 [^]

Fixed issue 18820 Hidden Create PI from Deliveries process

---
M src-db/database/sourcedata/AD_MENU.xml
---
(0048486)
vmromanos   
2012-05-09 08:52   
Code review + testing OK
The menu entry is now hidden
(0049072)
hudsonbot   
2012-05-25 12:10   
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/5401e185a8b0 [^]

Maturity status: Test