ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> SHip to Y/N field
http://www.istechforum.com/YaBB.pl?num=1109701629

Message started by cathyh on 03/01/05 at 10:27:09

Title: SHip to Y/N field
Post by cathyh on 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?

Title: Re: SHip to Y/N field
Post by David Waldmann on 03/01/05 at 11:07:18

BKAR_NEW_CUST

Title: Re: SHip to Y/N field
Post by kevind on 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.

Title: Re: SHip to Y/N field
Post by cathyh on 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.

Title: Re: SHip to Y/N field
Post by cathyh on 03/01/05 at 11:37:21

Thanks, Kevin, I guess we posted about the same time.
:D