0012914: Purchase Invoice in foreign currency generate incorrect Cash Journal

Description

If a purchase invoice is in a foreign currency, form of payment is cash and no payment is manually define, when it is being completed. The system generates a correct payment in foreign currency. In the Cash Journal, it generates an entry in local currency using the defined conversion rate. The amount in cash journal header is correct but the line is not being converted. It is still in foreign currency. The cash joural cannot be process because amount is different.

Steps To Reproduce

1. define USD to EUR and EUR to USD conversion rate in SmallBazaar
2. create a price list in USD
3. create a product with price in the USD price list
4. create a new purchase invoice with the USD price list, select AP invoice for transaction document and cash for form of payment.
5. create a line, select the product created in step 3, enter the quanty
6. go back to header and complete it
7. go to payment tab, the payment is generated in foreign currency with correct amount
8. go to finance management -> transaction -> cash journal and find the corresponding entry, the header is converted to foreign currency but the line is not. Furthermore, if user tries to delete the line and recreate it, the payment will not appear in debt payment selector because it is in different currency.

Proposed Solution

Do the conversion in the payment in purchase invoice instead, then create the cash journal entry for the converted payment.

Tags

No tags attached.

Attached Files

sc.zip [^] (655,096 bytes) 2010-04-08 20:20

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0029625) alfredtang (reporter) 2010-07-28 06:23	Still having the same problem in the MP20 release. Now it shows the message Error: In line10 the amount does not match with amount of the debt payment. Conversion money applied

(0041002) psarobe (manager) 2011-09-16 10:11	This flow is no longer available in 3.0. In the new release you now have a new financial flow. We encourage you to upgrade to 3.0 Regards

Issue History
Date Modified	Username	Field	Change
2010-04-08 20:20	alfredtang	New Issue
2010-04-08 20:20	alfredtang	Assigned To	=> adrianromero
2010-04-08 20:20	alfredtang	File Added: sc.zip
2010-04-08 20:20	alfredtang	Issue Monitored: alfredtang
2010-07-28 06:23	alfredtang	Note Added: 0029625
2011-06-03 10:59	dalsasua	Assigned To	adrianromero => dalsasua
2011-07-20 18:12	dalsasua	Assigned To	dalsasua => jonalegriaesarte
2011-09-16 10:11	psarobe	Note Added: 0041002
2011-09-16 10:11	psarobe	Status	new => closed
2011-09-16 10:11	psarobe	Resolution	open => unable to reproduce