Welcome, Guest. Please Login.
05/19/24 at 03:22:05
News:
Home Help Search Login


Pages: 1
Send Topic Print
CR & custom finanacials (Read 1280 times)
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 461
Gender: female
CR & custom finanacials
11/15/05 at 14:35:08
 
Does anyone use CR to create custom financial statements where I could get more than 4 columns of info in the same report?
 
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
kchri
Browser
*


Skiing

Posts: 19
Gender: male
Re: CR & custom finanacials
Reply #1 - 02/01/06 at 13:27:54
 
Bump...anyone?  anyone?
Back to top
 
 
Email WWW   IP Logged
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 461
Gender: female
Re: CR & custom finanacials
Reply #2 - 02/01/06 at 15:57:51
 
Smiley yep... still waiting....
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
Tim Goldstein
Full Member
***


'Cause sooner or
later everyone needs
a chief geek

Posts: 213
Gender: male
Re: CR & custom finanacials
Reply #3 - 02/16/06 at 11:10:15
 
Lenette,
 
Yes!  just started.  Using XI.  However I'm finding that due to the fact that there is no relation between BKGLTRAN.B  and any other part of the system,  it takes some work to "Munge" the BKGL.TRN.INVC string field into a DBL or INT to reference the WO, PO, SO and item numbers.  However, I have created a monthly WO variance report with drill down that does work 90% of the time.  
 
I'm having a problem with it skipping a couple of items.  I thing the problem is in my "Munge" but not sure.  If you would like the code, let me know.  It uses cascading prompts for date ranges (only available in XI)
 
Cheers;
 
Tim
Back to top
 
 

Tim
Email WWW timgolds timgolds   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: CR & custom finanacials
Reply #4 - 02/16/06 at 12:16:23
 
Financial statements in DBA/Evo use BKGLCOA, not BKGLTRAN.  And there is no need for the SO/WO/PO number detail in Financial Statemetns per se.  Sounds like you are doing some other kind of financial report, Tim, not an Income Statement or Balance sheet in the conventional sense.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Tim Goldstein
Full Member
***


'Cause sooner or
later everyone needs
a chief geek

Posts: 213
Gender: male
Re: CR & custom finanacials
Reply #5 - 02/16/06 at 14:15:29
 
Lynn,
 
Yes and no.  I go through the transaction to check validity from the reports my accountant has created for BKGLCOA.  If there is a problem I can drill down into the transaction in crystal to see why an account is off by drilling into the WO, SO or PO.
 
You are correct not a conventional ballance sheet.  However, we do have conventional ballance sheet reports our accountant had created in GL-N.  I'm just making sure they are correct and finding problems.
 
Of course as soon as you release the drill down feature everything I've done becomes obsolete!  But it is still a great learning experiance.
Back to top
 
 

Tim
Email WWW timgolds timgolds   IP Logged
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 461
Gender: female
Re: CR & custom finanacials
Reply #6 - 02/16/06 at 16:03:10
 
I'd be happy just to have 12 consecutive months on the Income/Expense Statement.
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
Pages: 1
Send Topic Print