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


Pages: 1
Send Topic Print
Sales Report (Bookings total) (Read 835 times)
Charlie Klihr
Member
**


Custom Transformer
Manufacturing

Posts: 66
Gender: male
Sales Report (Bookings total)
10/04/06 at 06:16:11
 
Does anyone have a Crystal Report that will list total sales for a given time frame? The report in DBA seems not to give accurate information untill the end of the year.
Back to top
 
 

Charlie (I'm Too Old For This) Klihr
DBA Classic 2004.1, ISTS 12/28/13
25 Users
Evo~Erp 14 Users, Build- 01/02/14 T7-7iR6
PSQL v11
Crystal Reports v7.0
Windows Server 2008 R2
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Sales Report (Bookings total)
Reply #1 - 10/04/06 at 08:45:17
 
I'm sure I have something, but it's a simple enough one that you should probably do it yourself so that it comes out the way you want it. Not to mention the fact that it could well be less time consuming to just create it than to change the database references. Lastly, I see you're on v7 - not too many are, and compatability might be an issue.
 
Unless you end up wanting more info, you only need one table - BKARHINV; group by Customer Code, select by date and add a subtotal by group. If you want the customer name on the report you'll need to add and link to BKARCUST.
 
If even that sounds like Greek to you, don't be afraid to ask for more help.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Charlie Klihr
Member
**


Custom Transformer
Manufacturing

Posts: 66
Gender: male
Re: Sales Report (Bookings total)
Reply #2 - 10/06/06 at 07:49:16
 
Thanks for your reply.  I have many reports in V7, and I have been concerned about updating. Do you know if V7 reports will still work with a later version of Crystal Reports? It would be a lot of work to redo them.
Back to top
 
 

Charlie (I'm Too Old For This) Klihr
DBA Classic 2004.1, ISTS 12/28/13
25 Users
Evo~Erp 14 Users, Build- 01/02/14 T7-7iR6
PSQL v11
Crystal Reports v7.0
Windows Server 2008 R2
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Sales Report (Bookings total)
Reply #3 - 10/09/06 at 05:23:51
 
As far as I know the reports are all backward compatible, so you shouldn't have any trouble.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print