Does anyone have a good report that works consistently???This report works on and off, depending on the period. The main company "A" selected for the report has 8 periods.
My column that is not working has this setup:
YTD Column Test Column added
Type: GL GL
Book Code: ACTUAL ACTUAL
Fiscal Year: BASE BASE-1
Period Code: BASE BASE
Curr/YTD: CUR CUR
Start Date: 01/01/2006 01/01/2006
End Date: 08/31/2006 08/31/2006
Result: $20000 $20000 (should be $190000)
Company "B" has a July year end, and when I run the report I get only August data in both columns.
The strange thing is, if I change the Test column to end 07/31/2006 the numbers in BOTH columns change!
Result: $260000 $250000
I have no idea where these numbers are coming from. I added @PER and @YR to my column and it says 01/2007 and 01/2006 which is right for this company but should be giving the numbers for those dates, right?
I have been back and forth to the VAR about this report and they have never in 5 years been able to give me a solution.
thanks
b.
My column that is not working has this setup:
YTD Column Test Column added
Type: GL GL
Book Code: ACTUAL ACTUAL
Fiscal Year: BASE BASE-1
Period Code: BASE BASE
Curr/YTD: CUR CUR
Start Date: 01/01/2006 01/01/2006
End Date: 08/31/2006 08/31/2006
Result: $20000 $20000 (should be $190000)
Company "B" has a July year end, and when I run the report I get only August data in both columns.
The strange thing is, if I change the Test column to end 07/31/2006 the numbers in BOTH columns change!
Result: $260000 $250000
I have no idea where these numbers are coming from. I added @PER and @YR to my column and it says 01/2007 and 01/2006 which is right for this company but should be giving the numbers for those dates, right?
I have been back and forth to the VAR about this report and they have never in 5 years been able to give me a solution.
thanks
b.