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

Attachments

1
  • 17 Oct 2018, 03:00 PM

Activity

Show:

Deepak Pansheriya October 17, 2018 at 3:02 PM

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

Details

Assignee

Reporter

Labels

Components

Priority

Created September 19, 2018 at 11:01 AM
Updated October 17, 2018 at 3:02 PM