ISTech Support Forum - Same customer listed in IN-A

Welcome, Guest. Please Login.

	05/09/25 at 06:26:04 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Manufacturing

‹ Previous topic | Next topic ›

Pages: 1

Same customer listed in IN-A (Read 528 times)

Prier Products

Full Member

I Love YaBB 2!

Posts: 107

Same customer listed in IN-A
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!

IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: Same customer listed in IN-A
Reply #1 - 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)

Tongue

Kelloggs

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

« Last Edit: 08/12/13 at 18:28:18 by Kelloggs »

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

Prier Products Full Member I Love YaBB 2! Posts: 107	Re: Same customer listed in IN-A Reply #2 - 10/14/13 at 09:07:22 We deleted the customer and it works fine now. It was a really old customer anyway. Thanks!
Back to top	IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Manufacturing

‹ Previous topic | Next topic ›