Username:  Password:
Forgot your username or password?        
     
Home Product Tour FAQ Forum Contact Us Download           
MySF Forums
Home       Calendar
        



Comparative Years Expand / Collapse
Author
Message
Posted 6/10/2010 3:45:08 PM
Advanced Member

Advanced MemberAdvanced MemberAdvanced MemberAdvanced MemberAdvanced MemberAdvanced MemberAdvanced MemberAdvanced Member

Group: Forum Members
Last Login: 29/03/2016 3:46:38 AM
Posts: 51, Visits: 150
I know there's some way to do it but can't work it out. How do i show 2009 and 2010 figures (ie comparative accounting) on my 2010 end of year reports please.
Kat
Post #4616
Posted 6/10/2010 5:47:35 PM


MySF Administrator

MySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF AdministratorMySF Administrator

Group: Administrators
Last Login: 26/07/2017 11:15:18 PM
Posts: 254, Visits: 1,078
Hello,

At present there is no way to produce comparative reports through MySF Manager. This is something that has been requested by other users and is going to be implemented into the software as soon as possible.

Because it is quite difficult to do with how the software has been designed, it will take some time to implement but we are working on it.

Regards,

MySF
Post #4617
Posted 7/10/2010 3:06:47 PM
Regular Member

Regular MemberRegular MemberRegular MemberRegular MemberRegular MemberRegular MemberRegular MemberRegular Member

Group: Forum Members
Last Login: 27/12/2016 10:02:50 PM
Posts: 12, Visits: 33
Hi Katfish2,

If you badly need the report I have found the following procedure will give you a good printout including comparison figures. It involves exporting the reports out of MySF and importing them into Excel.

1. Export this year's year end report, saving as type Microsoft Excel (not the data one) and file name as page 1. Repeat process for last year's report but save as page 2.

2. Open a new file in Excel, then paste your page 1 on page 1.

3. Then paste your page 2 as a new page.

4. Select and copy the column of figures and column heading from page 2 and paste them into page 1 next to page 1's column. Caution: Make sure the figures line up with correct item name.

Note: I use Open Office spreadsheet and it works fine for me. Also the figures in the Excel report are text not numbers but if you remove the opening inverted comma they become numbers and then you can apply calculations if you need.

NoelW
Post #4618
« Prev Topic | Next Topic »



All times are GMT -6:00, Time now is 2:15am

Powered by InstantForum.NET v4.1.4 © 2018
Execution: 0.109. 10 queries. Compression Disabled.