ISTech Support Forum - Annual Sales Report by month

Welcome, Guest. Please Login.

	05/19/25 at 15:29:02 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Sales

‹ Previous topic | Next topic ›

Pages: 1

Annual Sales Report by month (Read 836 times)

arcticwolf1

Ex Member

Annual Sales Report by month
01/13/05 at 09:28:01

I was wondering if anyone could help me figure out which table(s) I would need to use to produce an annual sales report in Crystal Reports with sales broken down into months and sorted by customer. I looked in the inventory transactions tables as well as the customer master tables for info I could use but I must have missed something. Thanks in advance!

IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1919 Gender:	Re: Annual Sales Report by month Reply #1 - 01/13/05 at 09:47:28 BKARHINV has Inv #, Date, Total and Customer Name/Code. That should be everything you need.
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 IP Logged

arcticwolf1 Ex Member	Re: Annual Sales Report by month Reply #2 - 01/13/05 at 12:13:14 I'll try that... thanks!!
Back to top	IP Logged

kevind

Active Member

I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male

Re: Annual Sales Report by month
Reply #3 - 01/13/05 at 12:47:54

If you want to include open bookings as well, you will also need to reference BKARINV.

I usually do not use the totals in these files. Instead a let Crystal / Pervasive calculate totals from the Line Item Detail.

I wrote a Cross Tab report that shows Daily / Weekly / Monthly / Yearly totals on two pages for any year you have item detail for.

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10

IP Logged

Karen Genco Browser Posts: 29 Gender:	Re: Annual Sales Report by month Reply #4 - 01/18/05 at 18:12:46 Kevin, Are you willing to share that report?
Back to top	IP Logged

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 634 Gender:	Re: Annual Sales Report by month Reply #5 - 01/19/05 at 08:45:48 I emailed you a sample PDF of this report for your review.
Back to top	Kevin Damke Spectronics Corporation ISTECH 2004.1 7/26/13 SP1 - 20 user Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user (Prev version was 2004.1 10/24/12) (All Patches Installed as of 7/26/13) Pervasive 2000i SP4 - Crystal Reports V10 IP Logged

arcticwolf1 Ex Member	Re: Annual Sales Report by month Reply #6 - 02/04/05 at 08:10:42 Could I possibly get a copy of that report as well? thanks!
Back to top	IP Logged

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 634 Gender:	Re: Annual Sales Report by month Reply #7 - 02/04/05 at 09:29:48 Here is a .PDF sample of this report: http://spectronics.com/dba/sample sales by week.pdf
Back to top	Kevin Damke Spectronics Corporation ISTECH 2004.1 7/26/13 SP1 - 20 user Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user (Prev version was 2004.1 10/24/12) (All Patches Installed as of 7/26/13) Pervasive 2000i SP4 - Crystal Reports V10 IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Sales

‹ Previous topic | Next topic ›