Clarity: XOG and Timesheet Originated Transaction's External ID Will Be Null On The Adjustment WIP Record

Document ID : KB000050100
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

A WIP transaction originated from timesheet or XOG (when externalID is used) has external ID in the PPA_WIP table. After an adjustment has been approved on such transaction, the new adjustment row created as a result of the WIP adjustment will not retain the external_ID value from the original (adjusted) row. This can cause problems when clients run reports

Voucher transactions do not have ppa_wip.external_id value and are not affected.

Steps to Reproduce:

  1. XOG in a transaction with quantity = 2, externalID="myExternalID_123"

  2. Run Post Transactions to Financial job, then post the transaction to WIP

  3. Query ppa_wip to make sure the transaction's External ID is there for this transaction and note down its transno value. Let's say the transno is 5001001
    select * from ppa_wip where EXTERNAL_ID = "myExternalID_123"

  4. Go back to Clarity Create WIP Adjustment page, select the transaction and adjust the transaction by changing its quantity = 5

  5. Submit the adjustment

  6. Approve the adjustment

  7. Run the query with the original transno value to get the adjustment transaction's transno
    select applyto
    from ppa_wip where transno = 5001001 -- replace with the real transaction number
    Let's say applyto value is 5001002 in this example, this is the transno for the adjustment transaction that gets inserted with status=0 by the WIP adjustment

  8. Run the following query to check the EXTERNAL_ID on the original WIP records:
    select external_id
    from ppa_wip
    where transno = 5001001 -- replace with the real transaction number
    The returned EXTERNAL_ID value is "myExternalID_123", as expected.

  9. Run the following query to check the EXTERNAL_ID on the new WIP records:
    select external_id
    from ppa_wip
    where transno = 5001002 -- replace with the real transaction number

Expected Result: EXTERNAL_ID value should be "myExternalID_123"
Actual Result: EXTERNAL_ID value is null

Solution:

Workaround:
None.

Status/Resolution:
Resolved in Clarity 12.1.3

Keywords: CLARITYKB, CLRT-57204, clarity12resolved, clarity1213resolved, revmgr.