ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> CR & custom finanacials
http://www.istechforum.com/YaBB.pl?num=1132094108

Message started by Lenette on 11/15/05 at 14:35:08

Title: CR & custom finanacials
Post by Lenette on 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?

Title: Re: CR & custom finanacials
Post by kchri on 02/01/06 at 13:27:54

Bump...anyone? anyone?

Title: Re: CR & custom finanacials
Post by Lenette on 02/01/06 at 15:57:51

:) yep... still waiting....

Title: Re: CR & custom finanacials
Post by timgolds on 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

Title: Re: CR & custom finanacials
Post by Lynn Pantic on 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.

Title: Re: CR & custom finanacials
Post by timgolds on 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.

Title: Re: CR & custom finanacials
Post by Lenette on 02/16/06 at 16:03:10

I'd be happy just to have 12 consecutive months on the Income/Expense Statement.