Thanks very much Jim I have been thinking along the lines of external reporting tools, my only concern being I have to sum up all previous ledgertrans to get the openning balance of a financial year. I believe XL Reporter is just extracting the ledger transaction records so I guess your solution would ignore the openning balance records and have to sum all other ledgertrans records in XL reporter to get the openning balance for each different year is it? Anyone else any other experience/suggestion? Thanks James
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Hummer Sent: 09 November 2008 02:17 To: [email protected]; Wing Chan Subject: RE: [Axapta-Knowledge-Village] 2 different financial years within 1 company We have several customers that have this issue. With XL Reporter which is an Excel based report writer for DAX we have made a program called XL Calendar so that you can built your own business calendars. You can build a fiscal and calendar year and two weekly years. This is exposed in the Metadata so you can built Excel Financial Reports. Contact [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> com if you want a trial version of the software. Jim _____ To: [email protected] From: [EMAIL PROTECTED] Date: Sat, 8 Nov 2008 15:59:43 +0800 Subject: [Axapta-Knowledge-Village] 2 different financial years within 1 company Hi everyone, Can anyone shine some light on how I might be able to do reporting of 2 separate financial results using the same company 1st result is say 1 April to 31 March (legal requirement) 2nd result is say 1 Jan to 31 Dec (group reporting) Since they over lap there is a year end period/closing and so AX will complain if I try to run a financial report and if i try to base a report on only ledger transactions then I have a problem that there will be openning balances and so would not get the figures right etc. I guess this is a fairly common requirement for some customers so hoping someone has some ideas can throw at me asap Would I be able to set up a consolidated company wiht different financial period and run consolidation into it? Or would the openning balances also get copied over? Thanks James

