Welcome, Guest. Please Login.
05/19/25 at 11:20:25
News:
Home Help Search Login


Pages: 1
Send Topic Print
SHip to Y/N field (Read 597 times)
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
SHip to Y/N field
03/01/05 at 10:27:09
 
I am trying to extract from the customer list all the customers with the Ship To Y/N field set to Y.  I can't find the field in the BKARCUST file.  Does anyone know where this field is?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: SHip to Y/N field
Reply #1 - 03/01/05 at 11:07:18
 
BKAR_NEW_CUST
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
kevind
Active Member
*****


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

Posts: 634
Gender: male
Re: SHip to Y/N field
Reply #2 - 03/01/05 at 11:27:43
 
BKAR_CUST_YEAR  Is the field that flags a customer as a  
'Ship To'.  If it is blank, then 'Ship To' is displayed as N, If it  
has a customer code, then 'Ship To' is displayed as Y, and  
a customer code is displayed in the 'Bill' field.
 
To only select customers with 'Ship To' set to 'Y' you select
on the BKAR_CUST_YEAR not equal to a null string.
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
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: SHip to Y/N field
Reply #3 - 03/01/05 at 11:35:50
 
I don't think it is that one since I have customers who are not ship to and that field is yes.  I don't know exactly what that field refers to.  I think I figured it out though.  The Y/N doesn't show up in a field but the mandatory Bill to Customer code does.  I just had to pick all customers with a Bill To code ( in field BKAR_CUST_YEAR).
In my copy of the file names with field names that IS tech has helpfully made available, that field is listed as unused.  I wish the name could be changed before using it to something more descriptive of what it will represent.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: SHip to Y/N field
Reply #4 - 03/01/05 at 11:37:21
 
Thanks, Kevin, I guess we posted about the same time.
 Cheesy
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print