Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035107 | Openbravo ERP | 09. Financial management | public | 2017-01-31 13:56 | 2017-09-21 16:50 |
|
| Reporter | maite | |
| Assigned To | CSousa | |
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q4 | |
| Merge Request Status | |
| Review Assigned To | aferraz |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 45097 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0035107: To include "line_id" information in fact_acct when posting "Undeductable" invoice line tax in Purchase Invoice |
| Description | When posting a Purchase Invoice, in case tax rate is defined as "Tax not deductible", an specific fact_acct record is created beucase product's account should be used instead of tax's account. In that case, it would be usefull to add "line_id" information in fact_acct record to track specific invoice line related with each accounting entry |
| Steps To Reproduce | 1. Access Tax Rate window, search for "Adquisiciones IVA 4%" and set it as "Tax not deductible"
2. Register new Purchase Invoice for any Org and BP. Add any line and set "Adquisiciones IVA 4%" tax. Process invoice and post it
3. Verify accounting information related with this invoice via database and realize that "line_id" field is empty in records pointing to taxes:
select line_id from fact_acct where record_id='INVOICE_ID' and c_tax_id is not null; |
| Proposed Solution | In DocInvoice.java class, add "line_id" information when docLine1 is created (line 871):
docLine1.m_TrxLine_ID = data[j].cInvoicelineId;
|
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-01-31 13:56 | maite | New Issue | |
| 2017-01-31 13:56 | maite | Assigned To | => Triage Finance |
| 2017-01-31 13:56 | maite | OBNetwork customer | => Yes |
| 2017-01-31 13:56 | maite | Modules | => Core |
| 2017-01-31 13:56 | maite | Support ticket | => 45097 |
| 2017-01-31 13:56 | maite | Triggers an Emergency Pack | => No |
| 2017-01-31 13:56 | maite | Issue Monitored: networkb | |
| 2017-04-20 11:23 | CSousa | Note Added: 0096085 | |
| 2017-05-08 13:29 | CSousa | Status | new => scheduled |
| 2017-05-08 13:29 | CSousa | Assigned To | Triage Finance => CSousa |
| 2017-09-18 16:24 | hgbot | Checkin | |
| 2017-09-18 16:24 | hgbot | Note Added: 0099121 | |
| 2017-09-18 16:24 | hgbot | Status | scheduled => resolved |
| 2017-09-18 16:24 | hgbot | Resolution | open => fixed |
| 2017-09-18 16:24 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0daf8bc29298e93172de694ef63555fe248b15d5 [^] |
| 2017-09-18 16:26 | aferraz | Review Assigned To | => aferraz |
| 2017-09-18 16:26 | aferraz | Note Added: 0099122 | |
| 2017-09-18 16:26 | aferraz | Status | resolved => closed |
| 2017-09-18 16:26 | aferraz | Fixed in Version | => 3.0PR17Q4 |
| 2017-09-21 16:50 | hudsonbot | Checkin | |
| 2017-09-21 16:50 | hudsonbot | Note Added: 0099410 | |
|
Notes |
|
|
(0096085)
|
|
CSousa
|
|
2017-04-20 11:23
|
|
1. Access Tax Rate window, search for "Adquisiciones IVA 4%" and set it as "Tax not deductible"
2. Register new Purchase Invoice for any Org and BP. Add any line and set "Adquisiciones IVA 4%" tax. Process invoice and post it
3. Verify accounting information related with this invoice via database and realize that "line_id" field is filled in records pointing to taxes:
select line_id from fact_acct where record_id='INVOICE_ID' and c_tax_id is not null; |
|
|
|
(0099121)
|
|
hgbot
|
|
2017-09-18 16:24
|
|
Repository: erp/devel/pi
Changeset: 0daf8bc29298e93172de694ef63555fe248b15d5
Author: Carlos Sousa <carlos.sousa <at> openbravo.com>
Date: Thu Apr 20 11:18:53 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0daf8bc29298e93172de694ef63555fe248b15d5 [^]
Fixes issue 35107: To include "line_id" information in fact_acct when
posting "Undeductable" invoice line tax in Purchase Invoice.
"line_id" information included in fact_acct when a
"Undeductable" invoice line tax in Purchase Invoice has been posted
---
M src/org/openbravo/erpCommon/ad_forms/DocInvoice.java
---
|
|
|
|
|
|
|
|
|
|