Reverse (Correct) Invoice foreign currency, wrong Payment Allocation Posting

Description

  • Primary schema=USD, Secondary schema=THB

  • Accounting Schema: Use Suspense Balancing=N

  • Accounting Schema: Use Currency Balancing=N

  • Invoice (Customer or Vendor) in foreign currency (e.g. THB) with multiple invoice lines, e.g.
    2 invoice lines each THB 94,160.00.

  • Post Invoice: invoice converted to primary schema currency USD
    DR Charge1 USD 2,775.58
    DR Charge2 USD 2,775.58
    CR Payables USD 5,551.16 => All OK

  • Reverse (Correct invoice) and post
    CR Charge1 USD 2,775.58
    CR Charge2 USD 2,775.58
    DR Payables USD 5,551.16 => All OK

  • View Allocation
    DR Payables USD 5,551.17
    CR Payables USD 0.01
    DR Realized loss USD 0.01
    CR Payables 5,551.17 => Wrong GL posting
    Problems:
    Payables not zero (0.01 impact)
    Realized gain/loss 0.01

  • The correct posting should be
    DR Payables USD 5,551.16
    CR Payables USD 5,551.16
    OR

  • DR Payables USD 5,551.17
    CR Payables USD 0.01
    CR Payables USD 5,551.17
    DR Payables USD 0.01

Same problems for vendor credit memos, customer invoices and credit memos.
I haven't checked Reverse (Accrual), perhaps same problem there.
A root cause analysis should be done, perhaps other document types affected too by this problem.

Environment

None

Activity

Show:
Andres Lopez Andrade
June 25, 2020, 3:48 PM

Triaged by Andres Lopez

  1. Create Currency Rate for THB

  2. Create Invoice and Payment

  3. Void Payment and Invoice

  4. Fact Accounting is fine

Assignee

Unassigned

Reporter

Michael Powacht

Labels

None

Tested By

None

Components

Affects versions

Priority

Major
Configure