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
 
 




 

Reply via email to