ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> General Ledger/Check register report
http://www.istechforum.com/YaBB.pl?num=1112373176

Message started by kristinfitz on 04/01/05 at 08:32:56

Title: General Ledger/Check register report
Post by kristinfitz on 04/01/05 at 08:32:56

I am trying to create a report in Crystal that is a check register for the current month that pulls information such as vendor code, check no, check date, check amount, dec, but most importantly, the general ledger account charged. I can get this report to run with all the info I need but I have not been able to link the GL account to it. Has anyone attempted this? If so, any help would be greatly appreciated. Thanks!

Title: Re: General Ledger/Check register report
Post by Lynn Pantic on 04/01/05 at 14:03:51

You really can't. At the time of cutting checks, the only GL Accounts involved are AP and Cash. The original expense accounts are in the voucher or, in the case of PO Invoices, all the way back to the PO Receiving. And let's say you enter a voucher for American express and distribute it to a number of expense accounts, then make a partial payment. Really close to impossible to tie GL to checks.

Title: Re: General Ledger/Check register report
Post by aricon on 04/01/05 at 14:10:14

I sort of disagree. Sort of in that other systems (Great Plains, Solomon, Syspro, Visual, etc.) do this, but not usually in a "report" format. Usually done as a query that is displayed within the user interface.

That said, it could be done as a report, but would require a series of embedded sub-reports and without program logic to drive which reports appear under which conditions (as Lynn indicated - PO versus voucher and such) it would be REALLY difficult.

Title: Re: General Ledger/Check register report
Post by kristinfitz on 04/04/05 at 05:13:04

Thanks for the input.. I will keep trying to see if I can get something like what I need. :)