Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0002433 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | minor | always | 2007-12-28 12:24 | 2008-07-08 12:05 | |||
| Reporter | jaimetorre | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40beta | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0002433: Remittance>CreateFile: Decimals in PostgreSQL | |||||||
| Description | When creating a plain file from a remittance to send to the bank, the amounts are not properly parsed if using PostgreSQL. The bank does not accept decimals and therefore all the amounts are multiplied by 100. The problem is that in Oracle: 2.25*100 = 225 while in PostgreSQL: 2.25*100 = 225.00 To avoid this problem, the amounts in the CreateFile_data.xsql file could be calculated with the round function: round(amount*100,0) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0002893) cromero (viewer) 2008-01-29 13:20 edited on: 2008-06-12 09:23 |
Logged In: YES user_id=1500614 Originator: NO Fixed bug since revision 2170 I have used the round function as you indicated. Thank you. Carlos Romero Openbravo Team |
|
(0006022) 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=1859647 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-07-08 12:05 | psarobe | Status | resolved => closed |
| 2008-07-08 12:05 | psarobe | Fixed in Version | 2.40alpha-r2 => 2.40beta |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |