Minor variance (0.01) in secondary (USD) schema, GL Unallocated Cash, after payment fully allocated

Description

Scenario: Primary schema=THB, Secondary schema=USD

  • Invoice 1 Period 9: Total amount THB 12,587.48 THB/USD rate: 32.458922422202 => AR posting: USD 387.80

  • Payment Receipt(without allocation) Period 10: Amount THB 18,549.52 THB/USD rate: 33.93972535567 => Unallocated cash posting CREDIT USD 546.54

  • Manual Payment Allocation 1: Period 10: Amount THB 12,587.48 THB/USD rate: 33.93972535567 => Unallocated cash posting DEBIT USD 370.88

  • Invoice 2 Period 12: Total amount THB 40,125.00 THB/USD rate: 33.27812049435 => AR posting: USD 1,205.75

  • Manual Payment Allocation 2: Period 12: Amount THB 5,962.04 (Payment now fully allocated) => Unallocated cash posting DEBIT USD 175.67

  • There is now a DEBIT balance of USD 0.01 in GL Unallocated Cash, which should normally be written off against CURRENCY BALANCING in Doc_AllocationHdr.java > createPaymentRoundingCorrection()

I also turned on FINE trace log: Here are the relevant messages:
09:17:17.158 Doc_AllocationHdr.createPaymentRoundingCorrection: Payment=(206)18549.52/546.54 - Allocation=(206)18532.60/546.55 [24]
09:17:17.158 Doc_AllocationHdr.createPaymentRoundingCorrection: No Difference [24]

Issue should be assigned to Elaine, I sponsor the bug fix.

Environment

None

Attachments

1

Activity

Michael Powacht 
December 1, 2021 at 11:41 PM

Thanks !

Heng Sin Low 
December 1, 2021 at 11:40 AM

Test Scenario:
Primary schema=THB, Secondary schema=USD
Period 9, THB/USD rate: 32.458922422202
Period 10, THB/USD rate: 33.93972535567
Period 12, THB/USD rate: 33.27812049435

Invoice #1 - Period 9
Total amount THB 12,587.48
AR posting DEBIT USD 387.80

Payment Receipt (without allocation) - Period 10
Amount THB 18,549.52
Unallocated cash posting CREDIT USD 546.54

Manual Payment Allocation #1 - Period 10
Amount THB 12,587.48
Unallocated cash posting DEBIT USD 370.88

Invoice #2 - Period 12
Total amount THB 40,125.00
AR posting DEBIT USD 1,205.75

Manual Payment Allocation #2 - Period 12
Amount THB 5,962.04 (Payment now fully allocated)
Unallocated cash posting DEBIT USD 175.67
Unallocated cash posting CREDIT USD 0.01
Currency Balancing posting DEBIT USD 0.01

Michael Powacht 
December 1, 2021 at 2:20 AM

testing was successful. Please initiate peer-review and deploy in trunk.

Michael Powacht 
November 29, 2021 at 2:53 AM

Cheers , I’ll start testing tomorrow.

Elaine Tan 
November 29, 2021 at 2:31 AM

Hi

Please find attached the patch file.

Thanks,
Elaine

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created November 25, 2021 at 6:11 AM
Updated February 1, 2022 at 12:53 PM
Resolved December 6, 2021 at 10:50 AM