Welcome, Guest. Please Login.
03/28/24 at 09:14:04
News:
Home Help Search Login


Pages: 1
Send Topic Print
customer class (Read 813 times)
josie
Browser
*


I Love EvoERP!

Posts: 25
customer class
03/09/17 at 14:06:10
 
How can I print a customer list that also shows the class for each customer?
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: customer class
Reply #1 - 03/10/17 at 00:40:38
 
Select System Mrg
Click on UT
Select UT-A
Type sqlexport.rwn
Click Continue
Paste : select bkar_class,bkar_custcode, bkar_custname from BKARCUST order by bkar_class;
Click Execute
Click Export to CSV
 
have fun
 
Cheesy
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
josie
Browser
*


I Love EvoERP!

Posts: 25
Re: customer class
Reply #2 - 03/10/17 at 07:53:21
 
hi Kellogs,
 
When I get to paste under your instructions, I'm not sure where to go to get this information.
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: customer class
Reply #3 - 03/10/17 at 08:39:04
 
Hi Josie,
 
copy: select bkar_class,bkar_custcode, bkar_custname from BKARCUST order by bkar_class;
Then paste it on the text field
 
Wink
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print