Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020038Openbravo ERP07. Sales managementpublic2012-03-15 16:022012-06-12 12:18
chelipf 
naiaramartinez 
highmajoralways
closedfixed 
30
2.50MP34 
3.0MP13 
Mozilla Firefox
Core
No
0020038: Create Lines From in Sales invoices doesn't set taxamt and taxbaseamt fields properly
Create Lines From process doesn't set taxamt and taxbaseamt columns of C_INVOICELINE table.
- Create a new sales invoice header.
- Push create lines from button.
- Select a order or a shipment.
- Process.
I had no time to wait for your fix, then I have just fixed the problem and the patch is in the attachment file. It is based on SL_Invoice_Amt callout calculation.
VMA-Reviewed
related to defect 0020015 closed Sandrahuguet Create Lines From in Sales invoices doesn't set Excludeforwithholding field properly 
diff 3.diff (3,945) 2012-03-15 16:02
https://issues.openbravo.com/file_download.php?file_id=5083&type=bug
Issue History
2012-03-15 16:02chelipfNew Issue
2012-03-15 16:02chelipfAssigned To => vmromanos
2012-03-15 16:02chelipfFile Added: 3.diff
2012-03-15 16:02chelipfWeb browser => Mozilla Firefox
2012-03-15 16:02chelipfModules => Core
2012-03-15 16:04chelipfNote Added: 0046461
2012-03-15 16:04chelipfIssue Monitored: chelipf
2012-04-04 15:50chelipfNote Edited: 0046461bug_revision_view_page.php?bugnote_id=0046461#r3345
2012-04-04 15:59SandrahuguetRelationship addedrelated to 0020015
2012-04-04 16:02SandrahuguetRelationship deletedrelated to 0020015
2012-04-10 13:19vmromanosTag Attached: VMA-Reviewed
2012-04-12 09:42vmromanosRelationship addedrelated to 0020015
2012-04-12 12:52naiaramartinezNote Added: 0047521
2012-04-12 12:52naiaramartinezAssigned Tovmromanos => naiaramartinez
2012-04-12 12:53naiaramartinezStatusnew => scheduled
2012-04-12 12:53naiaramartinezfix_in_branch => pi
2012-04-12 13:06naiaramartinezNote Added: 0047524
2012-06-11 16:10hgbotCheckin
2012-06-11 16:10hgbotNote Added: 0049732
2012-06-11 16:10hgbotStatusscheduled => resolved
2012-06-11 16:10hgbotResolutionopen => fixed
2012-06-11 16:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d83794bd89ee0f548324fbd3b8bf6a2f217730b7 [^]
2012-06-11 16:13miruritaNote Added: 0049733
2012-06-11 16:13miruritaStatusresolved => closed
2012-06-11 16:13miruritaFixed in Version => 3.0MP13
2012-06-12 12:18hgbotCheckin
2012-06-12 12:18hgbotNote Added: 0049756

Notes
(0046461)
chelipf   
2012-03-15 16:04   
(edited on: 2012-04-04 15:50)
The same thing happens for purchase invoice. It is related to 0020015 issue.

(0047521)
naiaramartinez   
2012-04-12 12:52   
Test Plan:
    Go to sales order.
    Create a header. Set invoice terms as Immediate.
    Create a new line.
    Book the sales order.

    Go to Sales Invoice.
    Create a new header. Select the same BP as you selected in the previously created sales order.
    Press 'Create Lines From'. A popup is opened.
    Select the sales order you created previously.
    Select the lines and press OK.

    Go to the database and execute the folowing SQL:
         select taxamt, taxbaseamt
         from c_invoiceline
         order by created desc

Notice that the taxamt and taxbaseamt have the correct values.
(0047524)
naiaramartinez   
2012-04-12 13:06   
Thank you for your effort and your fix. We will push it to pi
(0049732)
hgbot   
2012-06-11 16:10   
Repository: erp/devel/pi
Changeset: d83794bd89ee0f548324fbd3b8bf6a2f217730b7
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Wed Jun 06 12:45:52 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d83794bd89ee0f548324fbd3b8bf6a2f217730b7 [^]

Fixed bug 20038: Cheli Pineda's contribution. Set taxamt/taxbaseamt fields in Create Lines From

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom.java
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
---
(0049733)
mirurita   
2012-06-11 16:13   
thanks again for your contribution!

code review + testing OK
(0049756)
hgbot   
2012-06-12 12:18   
Repository: erp/devel/pi
Changeset: 53c53ee333bb2d5b7add861925068e67dc24ca4a
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Tue Jun 12 12:16:40 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/53c53ee333bb2d5b7add861925068e67dc24ca4a [^]

Related to issue 20038: add a new contributor

---
M CONTRIBUTORS
---