Forum Discussion
Record date different from Control Period (accounting)
Hello Community - In accounting, sometimes the Control Period for the General Ledger encompasses dates that are not actually in that period (in this case March = 3). It could be, as is the example, that the Record Date actually falls outside of the Control Period. In this case, the accounting "control period" is 3, but the record date actually falls in April. It technically could be any other month as well.
What I need help with is how to always get the "converted for amount" measure to sum correctly based on the Control Period, regardless of when the record date was (as long as the record date has been assigned to a particlar "control period". Our accounting team decides this. So, they could technically assign a date of May 17 to Control Period 2 if there was some type of deferred transaction or something. And in that example, I would want any transactions assigned as Control Period 2 to be included regardless of what the record date was. How can I go about this?
2 Replies
HoangHugoSolution Specialist
Hi
I understand your team will assign the "Control Period", and you want to filter by the "Control Period" but not "Record Date"
If so, try this one
measure
Converted for Amount = CALCULATE (SUM(amount),REMOVEFILTER(record date))
HoangHugo Hi Hugo - Let me try and explain it this way.
A better way to phrase what I was trying to ask is that Control Period should equal Month Number (from my date table). So if the control period = 5, then all account codes with values for that control period should fall into month number 5 (i.e. May) irrespective of what the corresponding transaction or record date was. If you see my example above, you see that the Control Period is 3, but the record date is in April. So if you put that into a matrix visual the value gets assigned to April...it needs to get assigned to March (i.e. accounting period 3).