Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011314
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2009-11-11 12:272009-12-30 11:21
ReporternetworkbView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version2.50MP10
StatusclosedFix in branchpiFixed in SCM revision8e63d4c111b6
ProjectionnoneETAnoneTarget Version2.40MP13
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP10SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011314: uncorrected posting in payment status when conersion rates is used

DescriptionTotal amount from Payment Management is not the same as Sales Invoice total amount if at the Invoice Date had an Conversion Rate and at the Transaction Date other. This is why (using Spanish COA) 430 account has diferent amount in both accounting entries.
Steps To Reproduce-Login as Openbravo Admin
-Go to Master Data Management || Pricing || Price List || Price List
-Create a new record with currency USD and check Sales Price List
-Save
-Go to Price List Version
-Create a new record (for example, Price List Schema: Standard)
-Save
-Go to Product Price
-Create a new record (for example:
   Product: paint
   List Price: 8
   Standard Price: 6
   Price Limit: 10
-Save
-Back to Price List Version and click 'Create Price List Version'
-Go to General Setup || Application || Currency
-Select ISO Code: USD
-Go to Conversion Rate
-Create a New Record:
   Currency: USD
   To Currency: EUR
   Valid from Date: 09-11-2009
   Valid to Date: 11-11-2009
   Multiple Rate by: 1.5
-Save and new:
   Currency: USD
   To Currency: EUR
   Valid from Date: 12-11-2009
   Valid to Date: 31-12-9999
   Multiple Rate by: 2
-Save


-Go to Sales Management || Transactions || Sales Invoice
-Create a new record (chose the Price List created, realised that the currency has changed to USD; Invoice Date: 09-11-2009; Accounting Date: 09-11-2009)
-Save
-Go to Lines
-Create a new record (Product: paint; Attribute Set Value: Black; Ordered Quantity: 10; Tax: VAT 16%)
-Save
-Go to Header and Complete
-Check Grand Total Amount (In this case: 78.88)

-Go to Financial Management || Receivables & Payables || Transactions || Payment Status Management
-Create a New Record
   Currency: EUR
   Transaction Date: 30-11-2009
   Accounting Date: 30-11-2009
-Save
-Create Lines From
-Select Final Status: In Remittance, and select the invoice created;
-Save and Process
-Realised that total amount from Payment Management is not the same as Sales Invoice total amount (IE, if Spanish COA is used, 430 account has diferent amount in both accounting entries)


TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00113562.40MP13 closededuardo_Argal uncorrected posting in payment status when conersion rates is used 

-  Notes
(0021725)
rafaroda (viewer)
2009-11-11 14:53

 Eduardo,

Can you please comment on this issue?

In Sales Management || Transactions || Sales Invoice we are setting accounting date 09-11-2009 (which corresponds to conversion 1,5x1) and when posting the invoice this date and conversion rate are taken into account.

In Financial Management || Receivables & Payables || Transactions || Payment Status Management we are setting accounting date 30-11-2009 (which corresponds to a conversion 2x1) and when posting it this date and conversion rate are taken into account.

So both postings differ. Is there any account where this conversion rate variation is reflected?

Thanks.
(0021817)
hgbot (developer)
2009-11-13 17:22

 Repository: erp/stable/2.40
Changeset: d0582e9c95883f79b88440d53efd3e968ce82d3a
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Fri Nov 13 17:20:41 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/d0582e9c95883f79b88440d53efd3e968ce82d3a [^]

Fixes bug 0011314: uncorrected posting in payment status...

---
M src/org/openbravo/erpCommon/ad_forms/DocDPManagement.java
M src/org/openbravo/erpCommon/ad_forms/DocLineDPManagement_data.xsql
M src/org/openbravo/erpCommon/ad_forms/DocLine_DPManagement.java
---
(0021821)
hgbot (developer)
2009-11-13 18:01

 Repository: erp/devel/pi
Changeset: c5b63334e942f65e9f973af232a087fa95bf4068
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Fri Nov 13 13:59:26 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c5b63334e942f65e9f973af232a087fa95bf4068 [^]

Fixes bug 0011314: uncorrected posting in payment status when conersion...

---
M src/org/openbravo/erpCommon/ad_forms/DocDPManagement.java
M src/org/openbravo/erpCommon/ad_forms/DocLineDPManagement_data.xsql
M src/org/openbravo/erpCommon/ad_forms/DocLine_DPManagement.java
---
(0021922)
psarobe (viewer)
2009-11-17 13:49

 Tested working fine
(0022292)
eduardo_Argal (viewer)
2009-12-01 12:51

 The process is still not correct
(0022294)
hgbot (developer)
2009-12-01 12:54

 Repository: erp/devel/pi
Changeset: 8e63d4c111b6b00e48fbabbb2f4f3918652490d3
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Dec 01 12:51:19 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8e63d4c111b6b00e48fbabbb2f4f3918652490d3 [^]

Fixes bug 0011314: uncorrected posting in payment status when conersion rates is used

---
M src/org/openbravo/erpCommon/ad_forms/DocDPManagement.java
---
(0022430)
hudsonbot (viewer)
2009-12-04 09:14

 ---
A changeset related to this issue has passed a series of tests and has been promoted to main:

Changeset: http://code.openbravo.com/erp/devel/main/rev/f6bc559b1872 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
---
(0023154)
arunkumar (viewer)
2009-12-30 11:21

 Tested & Working fine

- Issue History
Date Modified Username Field Change
2009-11-11 12:27 networkb New Issue
2009-11-11 12:27 networkb Assigned To => rafaroda
2009-11-11 12:27 networkb OBNetwork customer => Yes
2009-11-11 14:53 rafaroda Note Added: 0021725
2009-11-11 14:53 rafaroda Assigned To rafaroda => eduardo_Argal
2009-11-13 13:58 eduardo_Argal Status new => scheduled
2009-11-13 13:58 eduardo_Argal fix_in_branch => pi
2009-11-13 17:22 hgbot Checkin
2009-11-13 17:22 hgbot Note Added: 0021817
2009-11-13 17:22 hgbot Status scheduled => resolved
2009-11-13 17:22 hgbot Resolution open => fixed
2009-11-13 17:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/d0582e9c95883f79b88440d53efd3e968ce82d3a [^]
2009-11-13 18:01 hgbot Checkin
2009-11-13 18:01 hgbot Note Added: 0021821
2009-11-13 18:01 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/d0582e9c95883f79b88440d53efd3e968ce82d3a [^] => http://code.openbravo.com/erp/devel/pi/rev/c5b63334e942f65e9f973af232a087fa95bf4068 [^]
2009-11-17 13:49 psarobe Note Added: 0021922
2009-11-17 13:49 psarobe Status resolved => closed
2009-11-17 13:49 psarobe Fixed in Version => 2.50MP9
2009-11-18 00:00 anonymous sf_bug_id 0 => 2899463
2009-12-01 12:51 eduardo_Argal Note Added: 0022292
2009-12-01 12:51 eduardo_Argal Status closed => new
2009-12-01 12:51 eduardo_Argal Resolution fixed => open
2009-12-01 12:51 eduardo_Argal Fixed in Version 2.50MP9 =>
2009-12-01 12:51 eduardo_Argal Status new => scheduled
2009-12-01 12:54 hgbot Checkin
2009-12-01 12:54 hgbot Note Added: 0022294
2009-12-01 12:54 hgbot Status scheduled => resolved
2009-12-01 12:54 hgbot Resolution open => fixed
2009-12-01 12:54 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/c5b63334e942f65e9f973af232a087fa95bf4068 [^] => http://code.openbravo.com/erp/devel/pi/rev/8e63d4c111b6b00e48fbabbb2f4f3918652490d3 [^]
2009-12-04 09:14 hudsonbot Checkin
2009-12-04 09:14 hudsonbot Note Added: 0022430
2009-12-30 11:21 arunkumar Note Added: 0023154
2009-12-30 11:21 arunkumar Status resolved => closed
2009-12-30 11:21 arunkumar Fixed in Version => 2.50MP10

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker