Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0018471 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2011-09-08 13:20 | 2011-12-23 11:19 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0MP7 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 38ac082e328d | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | Google Chrome | |||||||
| Modules | Core | |||||||
| Support ticket | 12542 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0018471: [APRM] wrong accounting from sales invoice to reconcilation with multicurrency | |||||||
| Description | If you have disabled the payment accounting, and you have disabled, in financial account, the transaction accounting, if you have multicurrency and the invoice date is diferent than reconciliation date (diferent currency rates), the accounting generated in transaction is wrong | |||||||
| Steps To Reproduce | . currency rates: EUR - USD: 06/09/2011 0.5 / 2 EUR - USD: 08/09/2011 0.25 / 4 USD - EUR: 06/09/2011 2 / 0.5 USD - EUR: 08/09/2011 4 / 0.25 . accounting schema in EUR . financial account in MXN: . payment method: wire transfer . automatic receipt / automatic deposit / upon receipt use / upon deposit use: not selected . execution type: manual . upon reconciliate used: cleared payment account . sales invoice in MXN and 06/09/2011 Total Gross Amount: 201.78 . post it: 43000 Clientes (euros) 807.12 - 0 47700 Hacienda Pública. IVA repercutido 0 - 123.12 70000 Ventas de mercaderías 0 - 684.00 . generate invoice payment and reconcile it (reconcile date 08/09/2011). To post the reconcile the entry is: 43000 Clientes (euros) 0 - 403.56 66800 Diferencias negativas de cambio 201.78 - 0 47200 Hacienda Pública. IVA soportado 201.78 - 0 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0040913) psanjuan (viewer) 2011-09-12 15:01 edited on: 2011-09-16 09:26 |
currency rates explained are between EUR and USD but Financial Account and Sales invoice currency is MXN, so currency rates which should be used are: EUR - MXN: 06/09/2011 0.5 / 2 EUR - MXN: 08/09/2011 0.25 / 4 MXN - EUR: 06/09/2011 2 / 0.5 MXN - EUR: 08/09/2011 4 / 0.25 Sales invoice in MXN Sales invoice posting dated on 06/09/2011 exchange rate used MXN - EUR: 06/09/2011 2 / 0.5 DEBIT 403.56 (Clientes) CREDIT 403.56 (Sales Revenue) Reconciliation posting dated on 08/09/2011 DEBIT 605.34 (6680000) DEBIT 201.78 (cleared bank account) CREDIT 807.12 (Clientes) Above posting is wrong. Right posting should be: DEBIT 807.12 (cleared bank account) CREDIT 403.56 (Clientes) CREDIT 403.56 (768000) exchange rate used: MXN - EUR: 08/09/2011 4 / 0.25 |
|
(0041237) eduardo_Argal (viewer) 2011-09-22 14:55 |
Verify new project multi accounting |
|
(0044019) dalsasua (viewer) 2011-12-23 11:19 |
Posting is correct. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-09-08 13:20 | malsasua | New Issue | |
| 2011-09-08 13:20 | malsasua | Assigned To | => eduardo_Argal |
| 2011-09-08 13:20 | malsasua | Web browser | => Google Chrome |
| 2011-09-08 13:20 | malsasua | Modules | => Core |
| 2011-09-08 13:20 | malsasua | OBNetwork customer | => Yes |
| 2011-09-08 13:20 | malsasua | Support ticket | => 12542 |
| 2011-09-08 13:20 | malsasua | Resolution time | => 1318370400 |
| 2011-09-08 13:42 | malsasua | Issue Monitored: networkb | |
| 2011-09-12 15:01 | psanjuan | Note Added: 0040913 | |
| 2011-09-12 15:02 | psanjuan | Note Edited: 0040913 | View Revisions |
| 2011-09-12 15:04 | psanjuan | Note Edited: 0040913 | View Revisions |
| 2011-09-15 18:18 | jonalegriaesarte | Assigned To | eduardo_Argal => mirurita |
| 2011-09-16 09:26 | psanjuan | Note Edited: 0040913 | View Revisions |
| 2011-09-16 09:26 | psanjuan | Note Edited: 0040913 | View Revisions |
| 2011-09-19 18:12 | mirurita | Assigned To | mirurita => eduardo_Argal |
| 2011-09-22 14:55 | eduardo_Argal | Status | new => scheduled |
| 2011-09-22 14:55 | eduardo_Argal | Note Added: 0041237 | |
| 2011-09-22 14:55 | eduardo_Argal | fix_in_branch | => pi |
| 2011-10-04 18:32 | eduardo_Argal | Status | scheduled => resolved |
| 2011-10-04 18:32 | eduardo_Argal | Fixed in SCM revision | => https://code.openbravo.com/erp/devel/pi/rev/38ac082e328dee383e40097e4c91d2321cf6b141 [^] |
| 2011-10-04 18:32 | eduardo_Argal | Resolution | open => fixed |
| 2011-12-23 11:19 | dalsasua | Note Added: 0044019 | |
| 2011-12-23 11:19 | dalsasua | Status | resolved => closed |
| 2011-12-23 11:19 | dalsasua | Fixed in Version | => 3.0MP7 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |