search

uzerpllp / uzerp

uzERP - Open Source Business Management
http://www.uzerp.com
Other
55 stars 25 forks source link

Error when accruing GRNS where order in Foreign currency #56

Open steveblamey opened 9 years ago

steveblamey commented 9 years ago

If accruals accounting in ON when accruing an invoice the system posts a journal to accruals control for selected received lines.

If the order is in currency other than base then it seems to be incorrectly calculating the BASE value of the accrual (as GL is in BASE currency all accruals need to be in BASE).

Need to investigate the calculation being done and the effect once an invoice is posted against the received line.

mshiner commented 8 years ago

The functions concerned are Accrual pid=901&action=accrual&controller=porders&module=purchase_order Invoice creation pid=515&action=createinvoice&controller=porders&module=purchase_order

It looks like there are several problems...

  1. When the accrual is posted the value in currency is MULTIPLIED by the currency rate rather than divided by
  2. When the invoice is subsequently matched no currency or invoice variance is written

There is a wrinkle in that you CAN post match an invoice to a GRN need to check that accruals processing is being done correctly. pid=902&action=match_invoice&controller=porders&module=purchase_order

mshiner commented 7 years ago

Also change search handler and grid to include currency of order pid=901&action=accrual&controller=porders&module=purchase_order