Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000904Openbravo ERP03. Procurement managementpublic2007-02-06 10:402008-06-12 09:43
user71 
gorkaion 
normalminoralways
closedfixed 
5
 
 
Core
No
0000904: Procedure C_COMMISSION_PROCESS contains errors
- > 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
No tags attached.
Issue History

Notes
(0004493)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1653108 [^]