Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004002Openbravo ERP07. Sales managementpublic2008-06-17 09:172008-09-03 21:56
Reporterrafaroda 
Assigned Tocromero 
PrioritylowSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target Version2.40Fixed in Version2.40 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004002: Review processes that create Invoices because of Tax Date
DescriptionProcesses that create invoices need to be reviewed since Tax Date field has been added to C_Invoice table. This affects the following processes:
* First, fix made in C_INVOICE_TRG in revision 4327 needs to be reverted [1].
* Generate Invoices (C_Invoice_Create0 procedure)
* Create AP Expense Invoice (ad_process/ExpenseAPInvoice)
* Generate Purchase Invoices from Deliveries (C_Create_PInvoice_From_Outs procedure)
* Create Invoices from Orders (ad_forms/GenerateInvoicesManual)
* Generate Invoice from Receipt (M_Inout_CreateInvoice procedure) inside Goods Receipt
* Copy From Invoice (ad_actionButton/CopyFromInvoice) inside Sales/Purchase Invoice
* C_Invoice_Post0 procedure
* C_Invoice_Create1 procedure
* C_ComissionRun_Process procedure
* M_Rappel_Invoice_Create procedure
* C_Invoice_CreateReceipt procedure

[1] https://dev.openbravo.com/websvn/openbravo/?op=comp&compare[]=%2Ftrunk@4326&compare[]=%2Ftrunk@4327 [^]
Steps To Reproduce1) Go to Sales Management || Transactions || Sales Order
2) Create a new Warehouse Order Sale Order
3) Go to Lines tab and create a new one
4) Go back to Header tab and complete the Sale Order
5) A Shipment is automatically created
6) Go to Sales Management || Transactions || Generate Invoices
7) Select the corresponding Organization and Business Partner and click on OK button
8) Go to the Invoice created at Sales Management || Transactions || Sales Invoice
9) Invoice created is Completed but mandatory Taxdate field is not filled
10) Try to navigate to Lines tab: 'You have not filled in all needed fields' message displays

1) Project & Service Management || Transactions || Expense Sheet
2) Fill the 'Header' and go to 'Lines' tab
3) Select 'Reinvoicing', a product and a business partner.
4) Go back to 'Header' tab and click on 'Process expenses' button
5) Go to Project & Service Management || Transactions || Create AP Expense Invoices
6) Select the employee of the expense sheet, fill the dates and click on 'Process' button.
7) Go to Procurement Management || Transactions || Purchase Invoice and select the created purchase invoice.
8) Invoice created is Completed but mandatory Taxdate field is not filled
9) Try to navigate to Lines tab: 'You have not filled in all needed fields' message displays
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00003312.40 closed rafaroda Taxdate field is not completed in processes that generate Invoices 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-17 09:17rafarodaNew Issue
2008-06-17 09:17rafarodaAssigned To => cromero
2008-06-17 09:18rafarodaRelationship addedrelated to 0000331
2008-06-17 09:21rafarodaStatusnew => scheduled
2008-06-17 09:22rafarodaTarget Version => 2.50
2008-06-17 12:04cromeroNote Added: 0007775
2008-06-17 18:18cromeroNote Edited: 0007775
2008-06-17 18:18cromeroDescription Updated
2008-06-17 18:48cromeroTarget Version2.50 => 2.40
2008-06-17 19:04svnbotCheckin
2008-06-17 19:04svnbotNote Added: 0007816
2008-06-17 19:04svnbotStatusscheduled => resolved
2008-06-17 19:04svnbotResolutionopen => fixed
2008-06-17 19:04svnbotsvn_revision => 5125
2008-07-01 17:56anonymoussf_bug_id0 => 2007963
2008-09-03 21:56psarobeRegression testing => No
2008-09-03 21:56psarobeStatusresolved => closed
2008-09-03 21:56psarobeFixed in Version => 2.40

Notes
(0007775)
cromero   
2008-06-17 12:04   
(edited on: 2008-06-17 18:18)
It would be necessary to review all the mentioned process/reports/forms and when in inserts in the C_Invoice it must also insert the value for the TAXDATE with the same value passed for the DATEACCT.
(0007816)
svnbot   
2008-06-17 19:04   
Repository: openbravo
Revision: 5125
Author: cromeroherrero
Date: 2008-06-17 19:04:30 +0200 (Tue, 17 Jun 2008)

Fixed bug 4002: Review processes that create Invoices because of Tax Date
Functions and inserts modified in order to include TaxDate with the same value that DateAcct
* C_COMMISSIONRUN_PROCESS.xml
* C_CREATE_PINVOICE_FROM_OUTS.xml
* C_INVOICE_CREATE.xml
* C_INVOICE_POST.xml
* M_INOUT_CREATEINVOICE.xml
* M_RAPPEL_INVOICE_CREATE.xml
* C_INVOICE_TRG.xml
* ad_forms/InvoiceVendorMultiline_data.xsql
* ad_process/ExpenseAPInvoice_data.xsql

---
U trunk/src/org/openbravo/erpCommon/ad_forms/InvoiceVendorMultiline_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_process/ExpenseAPInvoice_data.xsql
U trunk/src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml
U trunk/src-db/database/model/functions/C_CREATE_PINVOICE_FROM_OUTS.xml
U trunk/src-db/database/model/functions/C_INVOICE_CREATE.xml
U trunk/src-db/database/model/functions/C_INVOICE_POST.xml
U trunk/src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml
U trunk/src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml
U trunk/src-db/database/model/triggers/C_INVOICE_TRG.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=5125&sc=1 [^]