PS_ITEM fields are being overridden (ENTRY_TYPE, ENTRY_REASON, CONTRACT_NUM, etc.)
When we manually load the item activity tables (PENDING_ITEM, GROUP_CONTROL, PENDING_DST) and run the ARUPDATE to offset the item, the PS_ITEM table is being updated with the latest item activity.
For example, the original values for item ABCD on the PS_ITEM table:
ENTRY_TYPE: EPFOC
ENTRY_REASON: SALES
ENTRY_AMOUNT: -10
When we manually load the offset item (with an ENTRY_AMT = 10 to close out the item) to the PENDING_ITEM, GROUP_CONTROL, PENDING_DST tables and run the ARUPDATE, the values are changed on the PS_ITEM table to:
ENTRY_TYPE: RC
ENTRY_REASON: PFO
0