Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0004002
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2008-06-17 09:172008-09-03 21:56
ReporterrafarodaView Statuspublic 
Assigned Tocromero 
PrioritylowResolutionfixedFixed in Version2.40
StatusclosedFix in branchFixed in SCM revision5125
ProjectionnoneETAnoneTarget Version2.40
OSLinux 32 bitDatabaseOracleJava version1.5
OS VersionUbuntu 7.10Database version10 g SEAnt version1.7
Product VersionpiSCM revision5081 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0004002: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00003312.40 closedrafaroda Taxdate field is not completed in processes that generate Invoices 

-  Notes
(0007775)
cromero (reporter)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-06-17 09:17 rafaroda New Issue
2008-06-17 09:17 rafaroda Assigned To => cromero
2008-06-17 09:18 rafaroda Relationship added related to 0000331
2008-06-17 09:21 rafaroda Status new => scheduled
2008-06-17 09:22 rafaroda Target Version => 2.50
2008-06-17 12:04 cromero Note Added: 0007775
2008-06-17 18:18 cromero Note Edited: 0007775
2008-06-17 18:18 cromero Description Updated
2008-06-17 18:48 cromero Target Version 2.50 => 2.40
2008-06-17 19:04 svnbot Checkin
2008-06-17 19:04 svnbot Note Added: 0007816
2008-06-17 19:04 svnbot Status scheduled => resolved
2008-06-17 19:04 svnbot Resolution open => fixed
2008-06-17 19:04 svnbot svn_revision => 5125
2008-07-01 17:56 anonymous sf_bug_id 0 => 2007963
2008-09-03 21:56 psarobe Regression testing => No
2008-09-03 21:56 psarobe Status resolved => closed
2008-09-03 21:56 psarobe Fixed in Version => 2.40

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker