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 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
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 (viewer)
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 (viewer)
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:17 rafaroda OBNetwork customer => N
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 OBNetwork customer N =>
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