ADempiere ERP Business Suite / Bugs / #1974 PaymentTerm DueDate Bug

#1974 PaymentTerm DueDate Bug

Milestone: Core

Status: closed-fixed

Owner: Carlos Ruiz

Labels: PostgreSQL port (102)

Priority: 9

Updated: 2010-05-11

Created: 2009-07-10

Creator: Armen Rizal (Goodwill)

Private: No

Function paymenttermduedate in PostgreSQL does not function well. I fixed that by changing the line:

-NoDays := EXTRACT(epoch FROM TRUNC(DocDate) - FirstDay);
+NoDays := EXTRACT(DAY FROM DocDate);

My testing Payment Term is :

FixMonthCutOff=15
FixMonthDay=24
FixMontOffset=0

Regards,

Armen Rizal

Discussion

Carlos Ruiz - 2010-04-27

Committed revision 12158.
http://adempiere.svn.sourceforge.net/viewvc/adempiere?view=rev&revision=12158

I did a small change on Armen's suggestion,
instead of
NoDays := EXTRACT(DAY FROM DocDate);
I changed to
NoDays := EXTRACT(day FROM TRUNC(DocDate) - FirstDay);

to make it consistent with oracle version.

Regards,

Carlos Ruiz

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Ruiz - 2010-04-27

milestone: 898871 --> Core

priority: 5 --> 9

assigned_to: hengsin --> globalqss

status: open --> pending-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Tony Snook - 2010-04-27

Merged to trunk with Revision: 12165
http://adempiere.svn.sourceforge.net/adempiere/?rev=12165&view=rev

Log Message:
-----------
Merge bug fixes from release to trunk
merge 12158, 12159

Regards,
Tony

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

SourceForge Robot - 2010-05-11

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

SourceForge Robot - 2010-05-11

status: pending-fixed --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.