Openbravo Issue Tracking System - Openbravo ERP | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0000904 | Openbravo ERP | 03. Procurement management | public | 2007-02-06 10:40 | 2008-06-12 09:43 |
Reporter | user71 | ||||
Assigned To | gorkaion | ||||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | OS | 5 | OS Version | ||
Product Version | |||||
Target Version | Fixed in Version | ||||
Merge Request Status | |||||
Review Assigned To | |||||
OBNetwork customer | |||||
Web browser | |||||
Modules | Core | ||||
Support ticket | |||||
Regression level | |||||
Regression date | |||||
Regression introduced in release | |||||
Regression introduced by commit | |||||
Triggers an Emergency Pack | No | ||||
Summary | 0000904: Procedure C_COMMISSION_PROCESS contains errors | ||||
Description | - > When generating the commission with origin of orders, makes a consultation comparing the DateInvoiced field of the C_Order table. That field does not exist. Problem detected and solved in 4 lines: LINE: 245 ERROR: || ' AND h.DateInvoiced >= to_date('':2'')' SOLUTION: || ' AND h.DateOrdered >= to_date('':2'')' LINE: 246 ERROR: || ' AND h.DateInvoiced < to_date('':3'') + 1'; SOLUTION: || ' AND h.DateOrdered < to_date('':3'') +1'; LINE: 255 ERROR: || ' AND h.DateInvoiced >= to_date('':2'')' SOLUTION: || ' AND h.DateOrdered >= to_date('':2'')' LINE: 256 ERROR: || ' AND h.DateInvoiced < to_date('':3'') +1'; SOLUTION: || ' AND h.DateOrdered < to_date('':3'') +1'; - > And the commissions based on Entrance does not process them | ||||
Steps To Reproduce | |||||
Proposed Solution | |||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | |||||
Issue History | |||||
Date Modified | Username | Field | Change |
Notes | |||||
|
|||||
|
|