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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0011314

Openbravo ERP

09. Financial management

public

2009-11-11 12:27

2009-12-30 11:21

Reporter

networkb

Assigned To

eduardo_Argal

Priority

immediate

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40MP10

Target Version

2.40MP13

Fixed in Version

2.50MP10

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Description

Total 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)

Proposed Solution

Additional Information