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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

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 [^]

Issue History
Date Modified	Username	Field	Change