E1: 03B: Delinquency Fee Late Charge Issue Where R03B525 Foreign Subject To Late Charge (FSLC) Is Wrong (Doc ID 2266672.1)

Last updated on JUNE 12, 2017

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE CLARIFICATION
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1. Release:9.2
2. Full Tools Release: 9.2.x
3. Program ID(s): P03B2501, P03B2801
4. UBE(s): R03B525, R03B20
5. Version name: R03B20 version ZJDE0001


DESCRIPTION OF PROBLEM
======================
Credit Analysis Refresh (R03B525)is ran for Delinquency Fee creation over a foreign Invoice (Base Currency = CAD, Transaction currency = USD) that was entered in January 2017 when exchange was 1.34. The Fee is created end of March.  Since there is approval required, you go to P03B22 Delinquency Review Program.  When you inquire on the new Fee to approve or reject, notice that the Foreign Subject To Late Charge (FSLC) field has been changed to 1,015.15, then the fee is calculated off of this total.   This is incorrect calculations. The help states calculation is: 13.5% divided by 365 days x .01 x (amount - the foreign gross amount and again repeating for domestic gross amount) x # of days late.   Example 13.5% /365 x .01 x 1,015.15 x 45 (days late) = 16.89 (this is what customer gets), GCS test duplicates the 1,015.15, but the late fee is 16.52.

STEPS TO REPRODUCE
==================
1. Setup a new Policy with: check box retroactive Fee, require approval, Delinquency days is zero, no grace days, begin date 01/01/2002, RF=1,CO=1, AR= 1, curr=USD, annual % 13.5%
2. Create a new Customer AB and Master record, currency in Master needs to be set to USD, flag to allow Delinq Fees in Master
3.Go to Currency Exchange Rate Entry and either change or create your own exchange rate with USD to CAD have only 3 entries - 1. 01/01/17 for 1.34, 2. 03/01/17 for 1.32 and last 5/1/17 for 1.32.
4. Create a foreign invoice with base company currency of CAD and transaction currency for 1,000.00.   leave payment term blank for net 30days no discounts, no taxes involved, date this 1/15/17, post it.  Your amounts will show as 1,000.00 for foreign open and gross, and 1,340.00 for domestic open and gross.
5. Run Credit Analysis Refresh (R03B525) for Fees only, so use proc. options for aging, set GL Date, As Of, (all dates) to 4/1/17 (note tested with
3/30/17, 4/1/17 just to see differences).  Run it in FINAL Mode, since approval is required it does not create the RF yet.
6. After R03B525 completes Fast Path to P03B22 to review the results and notice how the "Foreign Subject To Late Charge (FSLC)" changed my 1,000.00 to 1,015.15 and then the Fee total is based on this 1,015.15.

Changes

Code Defect

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms