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:PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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
Distrib Line 3: $ 475
Distrib Line 4: $1000
Distrib Line 3: $ 32.20 which = (475 / 1475) * 100
Distrib Line 4: $ 67.80 which = (1000 / 1475) * 100
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
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document