Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0022307Openbravo ERP08. Project and service managementpublic2012-11-14 17:472013-02-20 04:50
ngarcia 
ngarcia 
highminoralways
closedfixed 
5
 
 
OBPS
Core
18701
No
0022307: Create AP Expense Invoices process creates a PI with wrong transaction document
Create AP Expense Invoices process creates a PI with wrong transaction document
As group admin role:
   Go to Document Type window and check that there is more than one active record for the same organization and Document Category "AP Invoice":
      Reversed Purchase Invoice
      AP Invoice
   Configure an employee BP (for example, Javier Martin) as a Vendor and configure the following parameters:
      Purchase Pricelist: for example Otros servicios
      PO Payment Method
      PO Payment Terms
      PO Financial Account
   Create a new product:
      Product Type: Expense type
   Add a price for the same price list defined before
   Create a new Expense sheet for that employee, add a line with the created product and process it
   Run the Create AP Expense Invoices process for that employee
   Go to the Purchase Invoice window and notice that a Reversed Purchase Invoice has been created and the invoiced quantity values of the lines are positive
   The PI could not be completed
In ExpenseAPInvoice_data.xsql the cDoctypeTarget method calls the AD_GET_DOCTYPE_EXPENSES function which orders the obtained records by the isexpense column. The associated field (AFCAC02426F149D0B1F71C6923057A5E) was hidden in the following commit:

https://code.openbravo.com/erp/devel/pi/rev/102717e18418 [^]
No tags attached.
Issue History
2012-11-14 17:47ngarciaNew Issue
2012-11-14 17:47ngarciaAssigned To => dmiguelez
2012-11-14 17:47ngarciaModules => Core
2012-11-14 17:47ngarciaOBNetwork customer => No
2012-11-14 17:53ngarciaProposed Solution updated
2012-12-27 10:44ngarciaOBNetwork customerNo => Yes
2012-12-27 10:44ngarciaSupport ticket => 18701
2012-12-27 10:44ngarciaResolution time => 1363129200
2012-12-27 10:44ngarciaTriggers an Emergency Pack => No
2012-12-27 10:44ngarciaIssue Monitored: networkb
2012-12-27 10:44ngarciaAssigned Todmiguelez => jonalegriaesarte
2013-01-21 10:18jonalegriaesarteAssigned Tojonalegriaesarte => ngarcia
2013-02-14 11:01hgbotCheckin
2013-02-14 11:01hgbotNote Added: 0056433
2013-02-14 11:01hgbotStatusnew => resolved
2013-02-14 11:01hgbotResolutionopen => fixed
2013-02-14 11:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f721f5a384cbacc2d49503aa97971666a325c3ef [^]
2013-02-15 15:04ioritzCiaNote Added: 0056493
2013-02-15 15:04ioritzCiaStatusresolved => closed
2013-02-19 23:11ngarciaNote Added: 0056554
2013-02-20 04:50hudsonbotCheckin
2013-02-20 04:50hudsonbotNote Added: 0056597

Notes
(0056433)
hgbot   
2013-02-14 11:01   
Repository: erp/devel/pi
Changeset: f721f5a384cbacc2d49503aa97971666a325c3ef
Author: Naiara Garcia <naiara.garcia <at> openbravo.com>
Date: Wed Feb 13 12:47:22 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f721f5a384cbacc2d49503aa97971666a325c3ef [^]

Fixed issue 22307: Create AP Expense Invoices process creates a PI with wrong
 transaction document

---
M src-db/database/model/functions/AD_GET_DOCTYPE_EXPENSES.xml
---
(0056493)
ioritzCia   
2013-02-15 15:04   
Verified
(0056554)
ngarcia   
2013-02-19 23:11   
fixed in 3.0MP21
(0056597)
hudsonbot   
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