PeopleSoft AR Realized Gain/Loss
Hello,
I'm trying to figure out how realized gain/loss amounts are being generated in our system. Shouldn't the REAL_GAIN_LOSS amount on the PENDING_ITEM table be the difference between the ENTRY_AMT * RATE_MULT (from the PS_ITEM table) and the ENTRY_AMT * the accounting date RATE_MULT?
Additionally, I have two items on the PENDING_DST table. ABC is out of balance because of the SYSTEM_DEFINED "R" entry but XYZ balances because of the offset (SYSTEM_DEFINED = "O"). I would expect the MONETARY_AMOUNTS to be -115.5 and 114.7 and the realized loss entry to be -0.8. Could there be an issue with our setup?