Miscellaneous Charges Not Prorated Correctly When Added After One of the Distribution Lines on a Purchase Order (PO) is Closed (Doc ID 2827349.1)

Last updated on DECEMBER 16, 2021

Applies to:

Symptoms

When adding Miscellaneous Charges for a flat amount to a PO line schedule that has any distribution lines that are "closed" (via PO Rollover), the Miscellaneous Charges that are Type 'Misc Chg Expense' are getting incorrectly prorated across the distribution lines by including the "closed" distribution line amount in the proration calculation.

Using the two Misc Charges below [Set Up FIN/SCM > Product Related > Procurement Options > Charges/Costs > Misc and Landed Costs] -

     Misc Charge           Type             Prorate   Calc Method   Alloc Method   Landed Cost   Merch Supp Chg  
  [A] FRGTPR      Freight Exp PR          [X]         Flat Amt       Matl Value             [  ]                  [X]
  [B] MISCPR       Misc Chg Exp PR      [X]         Flat Amt       Matl Value             [  ]                  [X]

If add [A] for flat amt, then flat amt gets correctly prorated across only ‘open’ PO line distribution amounts.

If add [B] for flat amt then flat amt gets incorrectly prorated as it includes ‘closed’ PO line distribution amount when prorated across the ‘open’ PO line distribution rows. It should not include the ‘closed’ PO line distribution amount when calculating the prorated amount.


Steps to reproduce the issue:

1.Navigate to Purchasing > Purchase Orders > Add/update PO page and search for a budget checked and dispatched PO with 1 line with 1 schedule with 4 distrib lines where distrib line 1 was 'closed' via PO Rollover from Budget Period 2020  to Budget Period 2021, and distribution lines 3 & 4 are “open”

2.On the one Schedule, click on Misc Charges icon, and add a line for Charge Type FRGTPR (Freight Prorated) for Flat Amt $100

3.On list of distribution lines for the Schedule, click on Misc Charges icon for Distribution Line 3 and also Distribution Line 4; see that Misc Charges calculation correctly prorated the Freight across Distribution Line 3 and Distribution Line 4

                    Merch Amt
Distrib Line 3:  $ 475
Distrib Line 4:  $1000
                    -------
                       $1475

                      Freight Amt
Distrib Line 3:   $ 32.20           which = (475 / 1475) * 100
Distrib Line 4:   $ 67.80           which = (1000 / 1475) * 100
                     --------
                     $100.00 correct

NOTE: Do not save the PO.

4.Back on the one Schedule, click on Misc Charges icon, and this time add a line for Charge Type MISCPR (Misc Chg Expense Prorated) for Flat Amt $100

5.On list of distribution lines for Schedule 1, click on Misc Charges icon for Distribution Line 3 and also Distribution Line 4

ISSUE: Misc Charges calculation incorrect since included the amount in the “closed” Distribution Line 1

                    Merch Amt   Line Status
Distrib Line 1: $   25.00       closed
Distrib Line 3: $  475.00      open
Distrib Line 4: $1000.00      open
                   ---------
                   $1500.00

                  Misc Chg Amt
Distrib Line 3: $ 31.67           which = (475 / 1500) * 100
Distrib Line 4: $ 66.67           which = (1000 / 1500) * 100
                   --------
                   $ 98.34 incorrect, should be $100.00

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.