Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#2703 Currency difference accounted on suspense account MatchInv

Core
open
nobody
5
2012-01-03
2012-01-03
Daniel Tamm
No

If the currency rate has changed on a foreign currency invoice during the time when the goods are delivered (receipt) and the invoice the accounting gets messed up and the difference multipled by the foreign currency rate is accounted on the suspense account.

How to reproduce bug:
* Create a purchase order in a currency different (currency X) from the accounting currency.
* Set the currency rate for currency X.
* Create a receipt for the purchase order.
* Change the currency rate for currency X to be different than the rate on the receipt.
* Create an invoice on the new date with the new rate.
* Match the receipt and the invoice line.
* Check the accounting of the MatchInv. It will be very wrong.

Discussion

  • Daniel Tamm
    Daniel Tamm
    2012-01-03

    Attaching patch. I haven't had time to catch up with how to contribute using current repository, so please feel free to apply the patch. It's a minor change but it means a lot to the correctness of the accounting.

     
  • Daniel Tamm
    Daniel Tamm
    2012-01-03

    The InvoicePV (Invoice Price variance) is still messed up with my first patch if the invoice price differs from accounted receipt price if the difference is due to a real difference in price. Now the accounting isn't wrong (nothing goes to suspense), however, the distribution between IPV and Currency Difference is wrong.
    I'll work some more and attach an improved patch that will be more correct.

     
  • Daniel Tamm
    Daniel Tamm
    2012-01-03

    New patch handling real IPV as well as currency difference.

     
    Attachments
  • Daniel Tamm
    Daniel Tamm
    2012-01-03

    Uploaded new patch.

     
  • Hi Daniel,

    Nice post. However, I cannot see how you post the currency difference. Could you enlighten me a bit more ?

    Rgds,

    Armen