Multi Currency - average PO cost use rate on PO date instead of MR date and match invoice imbalance.

Description

Sceanrio 1

Accounting currency is SGD.
PO is entered on 1st September 2018 with price of 100USD. conversion rate was 1.2
MR and invoice is received on 3rd September 2018 with price of 100USD and rate was 1.3.

When MatchPO posted it create cost record with 120 as cost price as using PO accounting date for currency conversion.
When matchInvoice post, there is no price change. So no cost correction occurs.

Scenario 2
PO is entered on 1st September 2018 with price of 100USD. conversion rate was 1.2
MR received on 2nd September 2018 and rate on same date is 1.4.
Invoice is received on 3rd September 2018 with price of 100USD and rate was 1.3.

In above case, difference of rate variance is posted to suspense balance as amtsrc is not set 0 in IPV GL entry which cause src amount imbalance in posting.

Environment

None

Activity

Show:
Deepak Pansheriya
October 17, 2018, 3:02 PM

Scenario 1 is already fixed in 5.1 branch.
Attached is patch for fixing scenario 2.

Assignee

Unassigned

Reporter

Deepak Pansheriya

Labels

Tested By

None

Components

Priority

Minor
Configure