Welcome, Guest. Please Login.
06/07/25 at 16:26:00
News:
Home Help Search Login


Pages: 1
Send Topic Print
custom income statement (Read 744 times)
ddlong
Full Member
***




Posts: 205
Gender: female
custom income statement
05/16/12 at 12:42:57
 
In our GL COA we use departments.  On the income statement, for expenses, rather than showing each GL account, it has been requested that I have one line for each department with the line total being the total of each gl for that particular department.  Then have separate reports by department listing each GL  and amount expensed to that department only.  Is that possible?  Before this year everything got manually entered into spreadsheets, but since we have converted Accounting to EVO, the controller doesn't want to do that any more.  Our company president does not like the canned format at all.  
 
I am hoping to have one by first week in June.   Any suggestions appreciated.
 
Darla Long
Catalytic Industrial Group, Inc.
Back to top
 
 

Darla Long
Catalytic Industrial Group, Inc.
Independence Ks
dba 2004.1 client/server EVO Version 2020.0 08/07/20 Build Pervasive 11.3
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: custom income statement
Reply #1 - 05/22/12 at 10:57:58
 
We have something similar here. You will need ms access (it can be done on ms excel, but it will be more complicate) to create a report like that
 
Here is the query: (For current year only, also our fiscal year start on August)
 
SELECT  
CInt(Trim([BKGL_ACCT])) AS ACCN,  
Trim([BKGL_TYPE]) AS ACCT,  
Trim([BKGL_ACCTD]) AS ACCD,  
Trim([BKGL_GLDPT]) AS DPT,  
CCur([BKGL_CURRENT_2]) AS CY_AUG,  
CCur([BKGL_CURRENT_3]) AS CY_SEP,  
CCur([BKGL_CURRENT_4]) AS CY_OCT,  
CCur([BKGL_CURRENT_5]) AS CY_NOV,  
CCur([BKGL_CURRENT_6]) AS CY_DEC,  
CCur([BKGL_CURRENT_7]) AS CY_JAN,  
CCur([BKGL_CURRENT_8]) AS CY_FEB,  
CCur([BKGL_CURRENT_9]) AS CY_MAR,  
CCur([BKGL_CURRENT_10]) AS CY_APR,  
CCur([BKGL_CURRENT_11]) AS CY_MAY,  
CCur([BKGL_CURRENT_12]) AS CY_JUN,  
CCur([BKGL_CURRENT_13]) AS CY_JUL
FROM BKGLCOA
WHERE (((CInt(Trim([BKGL_ACCT])))>3999));  
 
 
 Roll Eyes
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print