Welcome, Guest. Please Login.
05/19/24 at 04:23:32
News:
Home Help Search Login


Pages: 1
Send Topic Print
Income and Balance Sheet earlier that last 2 years (Read 656 times)
RHAGEN
Browser
*


I love YaBB 1G -
SP1!

Posts: 7
Gender: male
Income and Balance Sheet earlier that last 2 years
07/05/06 at 10:29:37
 
Is it possible to use Crystal Reports or some other report generator to create P&L and Balance Sheets for periods earlier than the last two years as long as the transaction data has been retained?
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Income and Balance Sheet earlier that last 2 y
Reply #1 - 07/05/06 at 10:53:05
 
I remember Lynn said that what you have to do is to make a play company then go to AM-A reset the Period End Close Date, then UT-K-D.
 
Now to recreate the Reports on Crystal or MS Access, that's another animal. A little bit complicate.  
 
We have the SQL Queries for ms access that can be use on crystal, let me know if you want it.
 
 Grin
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: Income and Balance Sheet earlier that last 2 y
Reply #2 - 07/05/06 at 11:42:15
 
yes you can.
 
you would have to report off the BKGLTRAN data and not the BKGLCOA data, which DBA/EVO financials report off of the Chart of Accout balances in BKGLCOA.
 
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
Pages: 1
Send Topic Print