My Oracle Support Banner

AP.9.2.Accounting Tag Validation With Accounting Date To Default On Voucher Page (Doc ID 3011737.1)

Last updated on MARCH 20, 2024

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 The Accounting Tag effective date is not taken into consideration for Voucher creation accounting date in the following scenarios :

1) 2 Effective dates on Accounting tag, both active :

1.1.Voucher with accounting date < than the latest effective date of accounting tag-01.08.2023 . The values that are taken on the voucher are the most recent ones , which is incorrect ,because it should have appeared the ones from the 1st effective date.

2) inactivate the accounting tag from 01/01/1901 and leave active the one from 25/08/2023.

2.1.Voucher with accounting date < than the latest effective date of accounting tag-01.08.2023. Values on accounting tag from the most recent one which is incorrect as the accounting tag is inactive at the time of the accounting date of the voucher. The accounting tag should not appear at all!

3) Activate the accounting tag with 01/01/1901 and inactivate the one with 28/08/2023.

3.1. Voucher with accounting date < than the latest effective date of accounting tag-01.08.2023. Accounting tag is not visible at all which is incorrect as it is active until 25.08.2023.

Issue can be replicated following the next steps :

  1. Activate Accounting tag at Payables level – Setup Financial>Common Definition>Design Chartfields>Accounting Tags>Tag registration by Products .Check Payables checkbox.
  2. Create an Accounting tag for Payables with 01/01/1901 effective date and multiple lines separated by percentage : -50%Line1 Account 100001 dept 10200 -50% line 2 account 100002 dept 11000 (Setup Financial>Common Definition>Design Chartfields>Accounting Tags>Accounting tag ).
  3. Create a voucher with accounting date of 25 aug 2023. Accounting tag is visible.
  4. Add another effective date- 25 aug 2023- to accounting tag and change the accounts. Keep both active. The second effective date has the following data : -50%Line1 Account 100003 dept 10200 -50% line 2 account 100004 dept 11000
  5. Create a voucher with accounting date of 1st of august. Only the accounts from effective date=01/01/1901 should be taken into the voucher. Result > Incorrect: on the voucher appear the latest values for accounts- the one from the most recent effective date.
  6. Create a voucher with accounting date of 25 august. The accounts from the latest effective date accounting tag should appear. Result>Correct!
  7. Inactivate the accounting tag from 01/01/1901 and leave active the one from 25.08.2023.
  8. Create a voucher with accounting date of 1st of August but the values populated on Accounting tag are the ones from effective date of 25 august. Result >Incorrect! The accounting tag should not be visible as it is inactive until 25 August.
  9. Create a voucher with accounting date of 25 august. The accounting tag should be visible and take the values from the most recent effective 25 august. Result >Correct!
  10. Activate the accounting tag with effective date of 01/01/1901 and inactivate the one with effective date of 25 /08/2023.
  11. Create a voucher with accounting date of 01 august. The values from the accounting tag of 01/01/1901 should appear. Result > Incorrect. Accounting tag is not visible at all ! It should be available as it has an inactive effective date of 25 august which is > than the accounting date on the voucher ( 01 august ).
  12. Create a voucher with accounting date of 25 august. The accounting tag should not appear as it is inactive from 25 august. Result > Correct!

More information can be found in the attached replication document.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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