Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018471Openbravo ERP09. Financial managementpublic2011-09-08 13:202011-12-23 11:19
Reportermalsasua 
Assigned Toeduardo_Argal 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version3.0MP7 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket12542
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018471: [APRM] wrong accounting from sales invoice to reconcilation with multicurrency
DescriptionIf 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-09-08 13:20malsasuaNew Issue
2011-09-08 13:20malsasuaAssigned To => eduardo_Argal
2011-09-08 13:20malsasuaWeb browser => Google Chrome
2011-09-08 13:20malsasuaModules => Core
2011-09-08 13:20malsasuaOBNetwork customer => Yes
2011-09-08 13:20malsasuaSupport ticket => 12542
2011-09-08 13:20malsasuaResolution time => 1318370400
2011-09-08 13:42malsasuaIssue Monitored: networkb
2011-09-12 15:01psanjuanNote Added: 0040913
2011-09-12 15:02psanjuanNote Edited: 0040913bug_revision_view_page.php?bugnote_id=0040913#r2688
2011-09-12 15:04psanjuanNote Edited: 0040913bug_revision_view_page.php?bugnote_id=0040913#r2689
2011-09-15 18:18jonalegriaesarteAssigned Toeduardo_Argal => mirurita
2011-09-16 09:26psanjuanNote Edited: 0040913bug_revision_view_page.php?bugnote_id=0040913#r2711
2011-09-16 09:26psanjuanNote Edited: 0040913bug_revision_view_page.php?bugnote_id=0040913#r2712
2011-09-19 18:12miruritaAssigned Tomirurita => eduardo_Argal
2011-09-22 14:55eduardo_ArgalStatusnew => scheduled
2011-09-22 14:55eduardo_ArgalNote Added: 0041237
2011-09-22 14:55eduardo_Argalfix_in_branch => pi
2011-10-04 18:32eduardo_ArgalStatusscheduled => resolved
2011-10-04 18:32eduardo_ArgalFixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/38ac082e328dee383e40097e4c91d2321cf6b141 [^]
2011-10-04 18:32eduardo_ArgalResolutionopen => fixed
2011-12-23 11:19dalsasuaNote Added: 0044019
2011-12-23 11:19dalsasuaStatusresolved => closed
2011-12-23 11:19dalsasuaFixed in Version => 3.0MP7

Notes
(0040913)
psanjuan   
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   
2011-09-22 14:55   
Verify new project multi accounting
(0044019)
dalsasua   
2011-12-23 11:19   
Posting is correct.