details: https://code.openbravo.com/erp/devel/pi/rev/ac6861ecdd85
changeset: 30633:ac6861ecdd85
user: Alejandro <alekosmp86 <at> gmail.com>
date: Wed Nov 09 12:24:38 2016 -0500
summary: Fixes issue 34371: Dates are truncated in voided invoice
Reversed invoices had dates with HH:MM:SS <> 00:00:00. Function C_Invoice_Post
has been modified to trunc the dateinvoiced and dateacct fields. Reversed
invoices
are now created with date with HH:MM:SS = 00:00:00
diffstat:
src-db/database/model/functions/C_INVOICE_POST.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (14 lines):
diff -r 65e9c589a623 -r ac6861ecdd85
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml Wed Nov 09
17:16:22 2016 +0100
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml Wed Nov 09
12:24:38 2016 -0500
@@ -635,8 +635,8 @@
v_UpdatedBy, IsSOTrx, v_RDocumentNo, 'DR',
'CO', 'N', 'N', v_DoctypeReversed_ID,
v_DoctypeReversed_ID, '(*R*: ' || DocumentNo || ') ' ||
COALESCE(TO_CHAR(Description), ''), SalesRep_ID,
- now(), NULL, 'N', NULL,
- now(), C_PaymentTerm_ID, C_BPartner_ID, C_BPartner_Location_ID,
+ TRUNC(now()), NULL, 'N', NULL,
+ TRUNC(now()), C_PaymentTerm_ID, C_BPartner_ID,
C_BPartner_Location_ID,
AD_User_ID, POReference, DateOrdered, IsDiscountPrinted,
C_Currency_ID, PaymentRule, C_Charge_ID, ChargeAmt * -1,
0, 0, --Totals are recalculed adding invoice lines
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
