• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Budget vs Actual

sniru9

Member
Hi List,

We have Monthly report(Budget vs Actual) which is using smart field
(FINRPTPA BSFN B83000PA) to calculate the amount
for that period(i.e March=3) using scaling '1' to display report.


We have another report to calculate Actuals and Budgets for
quarters(Q1 BSFN B83000PA, Q2, Q3, Q4) using scaling '1000' to display.

When we compare the first quarter amount with the Monthly
(sum of Q1 months), monthly report is not showing the negative sign for the amount where as it does in quarters report.

Any idea please ??????????



Thanks
Niru
One World Xe
Windows 2000, Sun Solaris, Oracle 8i
 

vap

Active Member
Niru,

Most probably field is formatted differently. It's in Properties for your
field on the report, on a different tab then Scaling. Property is called
"Edit Code" and you have a list of valid values there. If you need more
details or different possibilities - wait until Zoltan replies :) (NOT
meant as offence to you, Zoltan, we all value your participation very much).

Regards,
Vladimir Ponomarev
B733, B7331, B7332, XE (mostly XE at the moment); SQL 7.0, Oracle 8.1.5,
DB/400 (mostly SQL); Wintel, HP, AS/400 (mostly Wintel)
 

Zoltan_Gyimesi

Legendary Poster
Re: RE: Budget vs Actual

Niru, Vladimir

Edit codes are not self-evident things.
Check "Appendix A. - Edit Code Table" of "Enterprise Report Writing" documentation on the documentation CD.
It is a very useful table. I always keep a printed page of it close to me on the wall.

Hope, could help.

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

sniru9

Member
Re: RE: Budget vs Actual

Hi Vladimir,Zoltan,

We are using edit code 'K' for both the reports.Today I changed the scaling from 1000 to 1.Ran the report(Monthly) again and compared it with Quarterly even the amount also differs.I guess the problem is with business function.Any idea?

Thanks for your replies.



Thanks
Niru
One World Xe
Windows 2000, Sun Solaris, Oracle 8i
 

vap

Active Member
RE: RE: Budget vs Actual

Hi, Niru.

Well, it appears that your reports report on different figures :). Sorry,
nothing obvious comes to my mind, have never worked that much with smart
fields. Anyway, I would not be blaming business functions, from my
experience that may malfunction, but they always "malfunction as designed"
:).
If I were you I would check the following:
1. In SmartField definition you can include additional Data Selections. If
it was done differently for these two reports, this can lead to different
results.
2. If you have some experience with SQL, you can do the following: Run your
reports at debug level 1 (least detail), collect all select statements from
F0902 (or F0911) and check to see if they have different Where clauses (they
should). When you see the difference, it's commonly easy to find the reason.

Regards,
Vladimir Ponomarev
B733, B7331, B7332, XE (mostly XE at the moment); SQL 7.0, Oracle 8.1.5,
DB/400 (mostly SQL); Wintel, HP, AS/400 (mostly Wintel)
PS: Second technique may be not the simplest one, but I have used it in more
cases then I can remember. In 95% - with success (varying degree).
 

JanineM

Member
RE: RE: Budget vs Actual

Niru,
Although I am not working on XE, I would like to ask you a few questions.

How are you calculating the Quarter values. Are you using the First Quarter BSFN? Your post looked like you were trying to use the Period Activity BSFN to calculate Quarter values. I tried to create a report that had monthly columns for the first quarter and a First Quarter column. I used B83000Q1 for the First Quarter column. Everything came out correctly.

Another question, since they are separate reports that show month and quarter values, do you have any sign reversals set in the section properties of either report? It would be found on the Financial Report tab. If so, that could cause your negative signs to be different.

I could be way off on this information, since I am working with B733.1, but wanted to try to help if I could.

Good Luck,
Janine
OneWorld B733.1 SP7.1 (testing SP14.2)
AS400 Coexistent, SQL
 
Top