Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GL Chart of Accounts listing

Status
Not open for further replies.

theDeej

Technical User
Aug 21, 2001
51
US
CE9, CR9, SQL2k

Have created a simple report detailing the COA. User requests report not generate (or simply not be published to filestore) if the data has not changed from the prior published report.

Is there a way to do this?

Thanks for any help you can offer...

-Deej
 
In your General Ledger accounts table you should have a field for Account Add date and Account Edit Date. You could use these fields to compare to the "Last Published date" which the user could enter at run time (Crystal Parameter field). You could then use a formula to compare this date to the latest edit or add date for your GL accounts. You could set up a Yes/No variable to show in the report header to indicate if printing the report is required.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top