Rounding grandtotal in invoice view dialog

A full ERP system - moved to GitHub. See full description for details.

Brought to you by: kthiemann, mar_cal_westf, mjmckay, nwessel, and 2 others

#1410 Rounding grandtotal in invoice view dialog

Milestone: z_don't_use_3.5.1

Status: closed-works-for-me

Owner: Mark Ostermann

Labels: Database (55)

Priority: 5

Updated: 2009-08-28

Created: 2008-07-30

Creator: Mario Calderon

Private: No

Hi,

when we open the invoice view dialog or search for an invoice with the search dialog, we see the grandtotal amount as a rounded amount. This is an error.

For example an already paid invoice: grandtotal = 12.82 ,
the dialog shows grandtotal = 13.00, openamount = 0.18.

Reviewing the underlying view c_invoice_v we see a cast for grandtotal, among others, which is the reason for the rounding.

Eliminating the casting the presentation of grandtotal and openamount is correct.

Best regards
Susanne Calderon

Discussion

Mark Ostermann - 2009-08-13

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

Mark Ostermann - 2009-08-13

Bug Triage on Bug Day 2009-08-13. Triage with adempiereTrunk and PostgreSQL.
Test:
a) Invoice
* Invoiceline 12,09
* CT Sales 0,73
* GrandTotal 12,82
--> Invoice Info/ c_invoice_v: Grand Total 12,82/ Open 12,82
b) Payment
--> Invoice Info/ c_invoice_v: Grand Total 12,82/ Open 0,00

Cannot repoduce Error in PostgreSQL and current Trunk. Please somebody confirm for Oracle.

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

Mark Ostermann - 2009-08-13

Set Priority down to 5.

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

Mark Ostermann - 2009-08-13

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

Carlos Ruiz - 2009-08-13

Confirmed it's working with oracle too.

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 - 2009-08-13

priority: 5 --> 9

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

Mark Ostermann - 2009-08-13

Thanks Carlos.

Described Error cannot be reproduced in current trunk and PostgreSQL/ Oracle. Setting Status Pending for SF close.

Greetings from Sankt Augustin
Mark

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

Mark Ostermann - 2009-08-13

priority: 9 --> 5

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

SourceForge Robot - 2009-08-28

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 - 2009-08-28

status: pending-works-for-me --> closed-works-for-me
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.