Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007260Openbravo ERP07. Sales managementpublic2009-01-20 18:252009-03-05 17:22
RenateNieuwkoop 
gorkaion 
normalmajorhave not tried
closedfixed 
5
2.40 
2.40MP3 
Core
No
0007260: Postgres: Payment term generated incorrect Payment date in Sales Invoice
Our students use the university platform for the BFT training and it's 2.40 Community version with Postgres Database.
I have 2.40 training locally with Oracle and I didn't have the same issue.

As per the snapshot, the payment term is one month, the checkbox 'next business day' is selected, yet for a Sales Invoice dated 20-1-2009, the due date in the Payment is 22-2-2009, which is a Sunday. The expected due date would be 20-2-2009, which is one month after 20-1-2009 and is a business day.


How to recreate the issue:
Enter a Sales Order for a customer, add a line with a product.
Go to 'Generate Invoices' and select the BP on the SO.
Check the Sales Invoice:
Sales Management || Transactions || Sales Invoice || Header

In the Sales Invoice, click the payment term link:
Master Data Management || Business Partner Setup || Payment Term || Header
commsup_sprint6
blocks defect 0007033 closed gorkaion Postgres: Payment term generated incorrect Payment date in Sales Invoice 
Issue History
2009-01-30 11:52psarobeTypedefect => backport
2009-01-30 11:52psarobefix_in_branch => 2.40
2009-01-30 11:52rafarodaAssigned Torafaroda => gorkaion
2009-02-18 13:44svnbotCheckin
2009-02-18 13:44svnbotNote Added: 0013651
2009-02-18 13:44svnbotStatusscheduled => resolved
2009-02-18 13:44svnbotResolutionopen => fixed
2009-02-18 13:44svnbotsvn_revision => 13312
2009-02-19 12:53gorkaionTag Attached: commsup_sprint6
2009-03-03 17:31psarobeFixed in Version => 2.40MP3
2009-03-05 17:22psarobeRegression testing => No
2009-03-05 17:22psarobeStatusresolved => closed

Notes
(0013651)
svnbot   
2009-02-18 13:44   
Repository: openbravo
Revision: 13312
Author: gorkaion
Date: 2009-02-18 13:44:00 +0100 (Wed, 18 Feb 2009)

Fixed bug 7260. Modified the day of the week calculation to ensure that saturday and sunday are always days 6 and 7.

---
U branches/r2.40/src-db/database/model/functions/C_PAYMENTDUEDATE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13312&sc=1 [^]