c2c-oerpscenario team mailing list archive

["Vinay Rana \(openerp\)" <699872@xxxxxxxxxxxxxxxxxx>]

** Attachment added: "DR Entry"
   https://bugs.launchpad.net/openobject-addons/+bug/699872/+attachment/1791676/+files/dr_entry.png

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/699872

Title:
  v6rc2 account_voucher - foreign curency in supplier voucher posts
  slightly incorrect rounding

Status in OpenObject Addons Modules:
  Invalid

Bug description:
  I have the following settings:

  Base curency - USD
  Purchase journal - USD and HKD
  ex rate as at 31/12 - 7.782170

  Part 1 - bug in supplier voucher

  I created a new supplier voucher for 258.7 HKD dated 31/12
  In the account_move_line table the entries are:

  credit USD 33.24;HKD -258.70;
  debit USD 33.24;HKD 258.68;

  The calculations for the foreign curency, shouldnt be translated to base and then back, but just posted in as follows:
  credit USD 33.24; HKD -258.70;
  debit USD 33.24;HKD 258.70;

  If I do the same operation via the normal purchase invoice screen, all
  is recorded correctly 258.70.

  Part 2 - improvements needed to foreign curency payments

  I will take the scenario from Part 1 (the invoice) , go to make the
  payment by clicking the Pay invoice button.

  I would like to settle the amount in HKD as well. I have a HKD bank acount and a HKD bank journal for that purpose, so I select that from the journal dropdown menu.
  The total stays at 258.70, yet Instead of displaying the original foreign curency amount in the transactions window, I see the 258.68, which is easy to figure out that it got converted from the base curency back into the payment curency and the generated account_move_line entries are as follows:

  credit 33.24;-258.70;
  debit 33.24; 258.68;

  By looking in the db, I can see that the account_voucher_line has no
  foreign curency fields and therefore, I expect this will lead to more
  problems. I suggest to introduce a bit more accounting consistency as
  follows:

  1 - database changes - account_voucher_line table - add the
  'invoice_currency_amount'

  2 - view changes - voucher changes in the transactions window:
  a) add a non-editable field 'Invoice curency' - obtain value from the account_move_line
  b) add a non-editable field  'Curency Original Amount' - obtain value from the account_move_line
  c) add a editable field 'Curency Amount' which will be driven by foreign_curency _ids of the specific invoice and recorded in account_voucher_line.invoice_currency_amount.
  d) add a non-editable field 'Curency Open Balance' which is the value of (b)-(c)

  3) change the calculation algorithm, so the entries generated in the
  account_move_line as a result of posting the voucher is:

  credit USD 33.24; HKD -258.70;
  debit USD 33.24;HKD 258.70;

  The above will also sort out the issue of being able to generate the
  exact aged reports even when we have partial multicurency payments and
  other complex scenarios, which I believe currently is limited only to
  the base curency.

  Hope this is all clear.
  Regards,

  Vadim