Anyone know if there is a way to figure out what t...
# administration
c
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
any period/date mismatches?
c
I will look for that
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
have you reviewed your accounts where the revalue checkbox is checked (or not)? is anything missing or extra?
c
I'll have to check, but I don't believe anything was changed
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
Hi @Chris, may I know how that messed it up assuming they belong to the same period?
c
@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.