Welcome, Guest. Please Login.
05/18/25 at 02:33:10
News:
Home Help Search Login


Pages: 1
Send Topic Print
Cutomer report that shows discount code (Read 917 times)
cindellis
Browser
*




Posts: 28
Gender: female
Cutomer report that shows discount code
04/18/07 at 06:18:59
 
Is there a report that exists that will show all customers that have a discount code?  We are needing a list of everyone who gets a built in discount off our product when we bill them.  I know we put discount codes in on their accounts so I thought maybe there was a report somewhere that I could run that would show all the customers that had a code and what the percent was.  Anyone have any ideas?
Back to top
 
 
  IP Logged
RAGINE
Full Member
***


I love YaBB 1G -
SP1!

Posts: 150
Gender: female
Re: Cutomer report that shows discount code
Reply #1 - 04/18/07 at 07:17:15
 
Try SO-Q-G
Back to top
 
 

Ragine Hendrickson
Manufacturing Systems Inc/TRU-CATCH TRAPS
ISTECH 2004.1 10/31/06 UPDATE
Email WWW   IP Logged
cindellis
Browser
*




Posts: 28
Gender: female
Re: Cutomer report that shows discount code
Reply #2 - 04/18/07 at 07:25:10
 
Our new owners are wanting a listing of each customer and what discounts they receive.  So I need to somehow get those discount codes listed with the customers.
Back to top
 
 
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Cutomer report that shows discount code
Reply #3 - 04/20/07 at 10:50:26
 
Crystal Reports
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
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Cutomer report that shows discount code
Reply #4 - 04/22/07 at 19:31:27
 
Or straight export from BKARCUST
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
cindellis
Browser
*




Posts: 28
Gender: female
Re: Cutomer report that shows discount code
Reply #5 - 04/23/07 at 06:15:40
 
Lynn,
 
How do I run the report straight from BKARCUST?  Our person who created our old reports no longer works with us, so I am trying to learn how to do everything in DBA. Can you help me out?
Back to top
 
 
  IP Logged
kkmfg
Senior Member
****


Ghost of the code

Posts: 375
Gender: male
Re: Cutomer report that shows discount code
Reply #6 - 04/23/07 at 07:18:41
 
I think she was referring to the ability to export data with DE-A. That would give you a text file with the information you need. But you might need something like Microsoft Access or Crystal Reports to turn that raw data into something you could actually read. DE-A allows one to export only the fields they need so you could constrain it to just output what you are looking for. Then it might be readable enough but if not it really will be Access or CR to the rescue.
 
Quote from cindellis on 04/23/07 at 06:15:40:
Lynn,

How do I run the report straight from BKARCUST? Our person who created our old reports no longer works with us, so I am trying to learn how to do everything in DBA. Can you help me out?

Back to top
 
 

Collin
K & K Manufacturing, Inc

EvoERP Version 1-22-10 SP3
5 User Workgroup Pervasive 10
Email WWW   IP Logged
cindellis
Browser
*




Posts: 28
Gender: female
Re: Cutomer report that shows discount code
Reply #7 - 04/23/07 at 07:26:46
 
I was hoping that wasn't the answer.  Our Access is totally messed up!!  Ever since we switched to a new company, we haven't been able to get it working correctly.  We get ODBC errors.  We've tried the white paper steps to get that fixed, but we kind of gave up on that project for a while.
Back to top
 
 
  IP Logged
kkmfg
Senior Member
****


Ghost of the code

Posts: 375
Gender: male
Re: Cutomer report that shows discount code
Reply #8 - 04/23/07 at 07:52:49
 
Well, on the positive side, if you use DE-A you'd be inputting a textfile into Access and would not be using ODBC so that shouldn't affect you.
 
Quote from cindellis on 04/23/07 at 07:26:46:
I was hoping that wasn't the answer. Our Access is totally messed up!! Ever since we switched to a new company, we haven't been able to get it working correctly. We get ODBC errors. We've tried the white paper steps to get that fixed, but we kind of gave up on that project for a while.

Back to top
 
 

Collin
K & K Manufacturing, Inc

EvoERP Version 1-22-10 SP3
5 User Workgroup Pervasive 10
Email WWW   IP Logged
cindellis
Browser
*




Posts: 28
Gender: female
Re: Cutomer report that shows discount code
Reply #9 - 04/23/07 at 09:16:47
 
Thanks so much for the help.  I was able to figure out how to get that BKARCUST text file out of our Access program.  Now that I know how to do that, we can run some other reports we need even though the other part of Access isn't working.  Thanks again!   Grin
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print