Anyone know if there is a way to figure out what transactions are being included in the consolidated rate calculation? For some reason our average is skewing higher, when it's normally the same as current/historical.
k
KevinJ of Kansas
04/12/2021, 5:50 PM
any period/date mismatches?
c
Chris
04/12/2021, 7:05 PM
I will look for that
Chris
04/12/2021, 8:21 PM
Don't see any period mismatches. Also are there any other processes that can kick this off? In the system notes it's showing a user changing the average rate, but according to them they have no idea how to do that. They have not run any of the close processes yet.
EDIT: It terms of the process kicking off again, it seems like that may have just been user error. They may have clicked the little calc icon.
k
Karina
04/12/2021, 9:54 PM
have you reviewed your accounts where the revalue checkbox is checked (or not)? is anything missing or extra?
c
Chris
04/19/2021, 2:23 PM
I'll have to check, but I don't believe anything was changed
Chris
04/25/2021, 4:54 PM
Figured it out. There was 1 transaction in a subsidiary that had a date of 3/1 instead of 3/31 and that messed up the average
l
Luis
04/26/2021, 8:59 AM
Hi @Chris, may I know how that messed it up assuming they belong to the same period?
c
Chris
04/26/2021, 1:15 PM
@Luis Normally the average rate is the same as the current rate under one of the subs, but last month it was not so finance asked us to change it. Turns out under one of the subs there was a transaction with a date of 3/1 while all the others have 3/31 and that was screwing up the average and that caused unexpected discrepancies with other subs that roll into it. So fixing that one transaction fixed the problem.