When Sales Tax is Included on the Purchase Order, PO_LINE_DISTRIB - MONETARY_AMOUNT and MONETARY_AMT_BSE Values are Not Equal Causing Incorrect Commitment Control Data.
Last updated on SEPTEMBER 01, 2016
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
The data on PO_LINE_DISTRIB is not correct when Sales Tax is included on the PO. The issue can be seen with a query of PO_LINE_DISTRIB. Compare the values of MONETARY_AMOUNT and MONETARY_AMT_BSE. The tax amount is not included in the MONETARY_AMT_BSE field.
When this transaction is then budget checked, this further causes issue with the data on KK_ACTIVITY_LOG and KK_LIQUIDATION. The FOREIGN_AMOUNT and MONETARY_AMOUNT values are not equal.
Steps to recreate the issue:
- Create a purchase order that has Sales Tax.
- Query PO_LINE_DISTRIB and compare the MONETARY_AMOUNT and MONETARY_AMT_BSE values.
- If this transaction is budget checked. The MONETARY_AMOUNT on KK_ACTIVITY_LOG and KK_LIQUIDATION are incorrect
- The FOREIGN_AMOUNT does not equal the MONETARY_AMOUNT on KK_ACTIVITY_LOG and KK_LIQUIDATION
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms