0009626: Conversion rate is not applied to witholding when posting cancelled payment from bank statement

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009626

Openbravo ERP

09. Financial management

public

2009-06-25 11:23

2009-07-16 17:55

Reporter

networkb

Assigned To

eduardo_Argal

Priority

immediate

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40MP3

Target Version

Fixed in Version

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

0009626: Conversion rate is not applied to witholding when posting cancelled payment from bank statement

Description

A partner has defined a withholding for purchasing invoices.
The official Currency of the Client is, for example, Euros. However, the business partner purchase price list, uses, other currency, for example, USD.

A new purchase is created, for this partner, selecting the witholding.
Complete and post it.

Create a new Bank statement for this payment. Complete it and post it.

Go to cancelled payment (linked to bank statement line) and post it.

It appears a line in the gl journal, with "Suspense Balancing", whos amount is the same that witholding conversion rate.

(See the attached picture)

Steps To Reproduce

Create a withholding in Master Data Management > Businness Partner Category > Witholding. Set 10, as rate.

Link this witholding to a business partner (provider), in Master Data Management > Business Partner > Witholding tab.

Go to Master Data Management > Business Partner > Vendor/Credit Tab. Here, link to Purchase Price List. Change its currency to USD.

Go to General Setup > Conversion rate. Generate one from USD to EUR from 01-01-2000 to 01-01-2030. Multiplied by 0.5
Generate other one from EUR to USD (same dates, Multiplied by 2)

Create a new purchase invoice (with lines). Select the business partner, and witholding.
Complete it and post it.

Create a new Bank Statement an includes the invoice. Complete and post it.

Go to its lines, and press "Linked items". Go to its Cancelled payment.

In cancelled payment, to its Header and post it.

The final gl journal is not correct

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

depends on

backport

0009695

closed

eduardo_Argal

Conversion rate is not applied to witholding when posting cancelled payment from bank statement

Attached Files

Pantallazo-1.png (204,070) 2009-06-25 11:23
https://issues.openbravo.com/file_download.php?file_id=1462&type=bug
png

Issue History

Date Modified

Username

Field

Change

2009-06-25 11:23

networkb

New Issue

2009-06-25 11:23

networkb

Assigned To

=> rafaroda

2009-06-25 11:23

networkb

File Added: Pantallazo-1.png

2009-06-25 15:41

williams-tegik

Issue Monitored: williams-tegik

2009-06-25 17:29

rafaroda

Note Added: 0017594

2009-06-25 17:29

rafaroda

Assigned To

rafaroda => eduardo_Argal

2009-06-26 18:28

williams-tegik

Note Added: 0017624

2009-06-26 18:30

williams-tegik

Note Added: 0017625

2009-06-26 18:31

williams-tegik

Note Deleted: 0017624

2009-06-26 18:54

williams-tegik

Note Added: 0017626

2009-06-29 13:20

psarobe

Status

new => scheduled

2009-06-29 13:20

psarobe

fix_in_branch

=> pi

2009-07-10 21:51

hgbot

Checkin

2009-07-10 21:51

hgbot

Note Added: 0018124

2009-07-10 21:51

hgbot

Status

scheduled => resolved

2009-07-10 21:51

hgbot

Resolution

open => fixed

2009-07-10 21:51

hgbot

Fixed in SCM revision

=> http://code.openbravo.com/erp/devel/pi/rev/786b89452eb130058f1b542b4602d3919ba69326 [^]

2009-07-16 13:34

sureshbabu

Status

resolved => closed

2009-07-16 13:34

sureshbabu

Note Added: 0018315

2009-07-16 13:34

sureshbabu

Fixed in Version

=> pi

2009-07-16 17:55

anonymous

sf_bug_id

0 => 2822574

Notes

Sure Rafa,

We have reproduced every time times and this occurs in the purchase process of any invoice in a foreign currency (different from our accounting) that has a retention.. this at the moment of the settlement of the bank statement.

So conditions are:
-Purchase Invoice
-Purchase Invoice in a foreign currency , different from our accounting.
-It has a retention
-Pay the debt from a bank statement
-Post the automatic generated settlement of the bank statement.

What happens

When you create the bank statement of that payment and post it, everything seems to work fine, but in the settlement of that bank statement the retention is posted in the foreign currency quantity as local currency... you will see this better in an example.

Premises of example
-Accounting books in MXN, local currency
-To simplify, products will NOT have taxes.
-the Product A bought in the invoice, has a purchase price list of 100 USD.
-We have a retention in the system of 10%
-Conversion rate of purschase invoice date 10 MXN per USD
-Conversion rate of bank statement 10 MXN per USD

Process

1.Purchase Invoice to vendro X of prouct A, whit the retention of 10% applied.
*Scince we are applying a retention of 10%, the payment generated is of 90 USD,
*Accounting as foollows

               Vendor 1000
Porudcts 1000

So far so good, as expected.

2. Process bank statement to process the payment of the 90 USD,from a Bank in local currency MXN (If you process it from a bank in other currency then you will mix this bug to another one already reported, issue 0009532 )

                        Bank 900
Bank in transit 900

So far so good.

3. Then we post the automatic generated settlement

                       Bank in transit 900
                       Retention 10
Vendor 1000
                       Suspense Balancing 90

***Notice that the system is posting the amount in the retention in USD as if they were MXN, .. in other words the system is not converting this 10 USD into 100 MXN, . as expected.

Because of this, the system obviously cannot balance the post.

--------------

This bug and the 0009532 are critical for us and I think for every other customer that purchases or sells in other currency (A lot of companies do.)