ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Same customer listed in IN-A
http://www.istechforum.com/YaBB.pl?num=1376342301

Message started by Prier Products on 08/12/13 at 14:18:21

Title: Same customer listed in IN-A
Post by Prier Products on 08/12/13 at 14:18:21

When we go into IN-A every part number has a blank Customer code and the name of the customer. In the Customer Table this customer does exist, and does have a blank code (I'm guessing it's an old one). If we don't want to delete the Customer from the table, how do you recommend we fix it?

We do not have any Sales Orders with zero only or start with zero.

We are on 04/04/13 SP2

Thanks!

Title: Re: Same customer listed in IN-A
Post by Kelloggs on 08/12/13 at 14:43:53

If you have more than one customer with a blank code, then you have a problem.

Open your pervasive control panel and paste this sql script:

select * from BKARCUST where ASCII(LTRIM(RTRIM(BKAR_CUSTCODE))) = 0

It should only show one single record (Your customer with blank code)

If there is only one, I will recommend you to duplicate the customer, this time with a proper customer code.

Then you can use another sql script to update your part table (MTICMSTR)

:P

Kelloggs

PD: A field that identify a record should never be "blank"

Title: Re: Same customer listed in IN-A
Post by Prier Products on 10/14/13 at 09:07:22

We deleted the customer and it works fine now. It was a really old customer anyway. Thanks!