Hi all,
I created a GI with pivots for my company that shows unit sales, $ and margin by period as in the past it was done by calendar month.
All totals line up and even individual amounts add up as well. There is just one particular set of months from 2 fiscals ago where the units don’t show up same as the calendar date report but instead show up 2 periods later.
I was wondering if this would go away if I used TranPeriodID? only thing is the TranPeriodID is formatted differently which causes the reports to show up as “20-2602” instead of “02-2026”. when I try to format it it then messes up the internal comparisons and none of the unit sales line up properly anymore.
in short, is it fine to stick with FinPeriodID from ARTRAN?
Joseph