ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Vendor Part numbers Disappearing!
http://www.istechforum.com/YaBB.pl?num=1141410906

Message started by timgolds on 03/03/06 at 10:35:05

Title: Vendor Part numbers Disappearing!
Post by timgolds on 03/03/06 at 10:35:05

Have a Major problem!

Vendor Part nUmbers are disappearing! It's a really weird thing! And I need some help fixing the problem beofre it gets out of hand.

Here is what I know.

The part numbers exist in my 05 backup company (copy the company every year for historical reference).

When I go into IN-A, it shows a primary vendor, however, when I click on Vendors, There are no vendors!

If I go into IN-B ande enterthe same part number, It shows the vendor, However, when I click on Vendors, It's blank! If I Tab past the vendor info in IN-B, then click Vendors, I get the vendor but no part number!

As soon as I enter the Vendor Part number in IN-B/Vendors, the system appears to keep the number (for now any way)

Question, What is making the Vendors Part numbers disappear and why isn't it happening to my 05 backup?

Please Help,

Tim

Title: Re: Vendor Part numbers Disappearing!
Post by JNAPIER on 03/03/06 at 11:08:52

This is probably not related, but I had to remove the primary vendor from the inventory record when I had multiple vendors and pricing. If their was a primary vendor, the po would not pull in the correct price or vendor part # for anything but the primary?

John

Title: Re: Vendor Part numbers Disappearing!
Post by timgolds on 03/03/06 at 16:05:22

John,

I remember Allen saying somehting about changing the vendor info to another file and only the primary is in MTICMSTR. I think there is a bug there as explained above. Items that have had their vendor info changed since the update work fine but old ones will not show any vendors until you pass the input field under IN-A.

(Thank goodness we only have one vendor for most parts!)

Tim

Title: Re: Vendor Part numbers Disappearing!
Post by Lynn Pantic on 03/03/06 at 18:25:57

The primary vendor is stored in MTICMSTR. Any others (and all Vendor part numbers) are stored in BKSBVEND. We have not (at least not intentionally) changed how these files are accessed in a long time. IS Tech never has and DBA made the change maybe back in 1999 or even earlier.

Title: Re: Vendor Part numbers Disappearing!
Post by timgolds on 03/06/06 at 10:40:38

Lynn,

I'm doing some checking between my 05 files and my current files. When I'm in IN-A and look at vendors, What is the "T" field on the far right?

Also, My 05 BKSBVEND table has a lot less entries than my current table. However, Looking at the two, there are parts that have not changed or been edited since the 05 backup.

One of the parts is 12-00003 a Gray primer that we have used since 2004. It's in the BKSBVEND.B file but not the BKSBVEND.B05. Everything is identical in MTICMSTR though.

Any help or ideas would be greatly appriciated.

Tim

Title: Re: Vendor Part numbers Disappearing!
Post by timgolds on 03/06/06 at 11:35:10

Lynn,

More info.

Have a part that doesn't have vendor part numbers (however it should have)! Did some checking. The records do not exist in BKSBVEND.B but do exist in my backup company .B05! The Primary Vendor is listed in MTICMSTR.B and .B05 nether have anything entered under MTIC.PROD.VPC

However, I do have parts that have entries under MTIC.PROD.VPC! Could this be the problem? Do I need to update something?

Title: Re: Vendor Part numbers Disappearing!
Post by timgolds on 03/08/06 at 09:14:43

Lynn,

More information and need major understanding.

When I go into TAS-D and look at MTICMSTR.B I have MTIC.PROD.VEND, MTIC.PROD.VNAM and MTIC.PROD.VPC. However, When I go into MTICMSTR.B with Access or Pervasive Control Center, I have MTIC.PROD.VEND.1 through MTIC.PROD.VEND.10, MTIC.PROD.VEND1 through MTIC.PROD.VEND10 and MTIC.PROD.VPC1 through MTIC.PROD.VPC10!

Why am I not seeing these under TAS-D? What if there was data under 2-10?

Title: Re: Vendor Part numbers Disappearing!
Post by fdiala on 03/22/06 at 11:00:14

Hi

I have the same problem with disappearing vendor numbers. I checked my last backup with the current BKSBVEND table, and many records are missing from the current one. If you dont have a lot of new vendor items since your last back up, you can replace the BKSBVEND from the backup and run SBUTIL from UT-A.
In my case, lots of new items where entered since the last backup, so I need different way to handle it.

I really need help, any suggestions?

Thanks
Diala

Title: Re: Vendor Part numbers Disappearing!
Post by timgolds on 04/04/06 at 12:57:39

More info:

Ok so we have been adding the vendor part numbers back manually as we find they are missing. If course, they just disapear later so wo are doingthis alot!

Just tried to add a new vendor to a part and got an error! Went into IN-B tabed pass Vendor and clicked on the Vendors button.

On vendors screen , clicked on add and pressed F2 (also does it when you click lookup) on the Vendor field. Get "the array element specified is out of range for this field."

Any idea what's going on? Does this help with the Vendor number disappearing?

Please let me know what I can do to fix this problem.

Tim

Title: Re: Vendor Part numbers Disappearing!
Post by fdiala on 04/27/06 at 06:22:19

Hi,

I just lot my vendor#s again, did anyone find a reason why this is happening? now its happening more frequently than before, we cant rely on DBA now, lots of duplicate stock items were entered thinking they do not exist, and then discovering that its only the vendor# that disappeared. :( >:(
Any advancements??

Diala

Title: Re: Vendor Part numbers Disappearing!
Post by fdiala on 06/08/06 at 07:36:41

Hi,

Any advancements on the topic? It happening so often now, its impossible to rely on the system. This morning I added approved vendor and their Part#, I went to make a PO for those items, and it gave me the message that vendor not approved. I went back and checked, the vendors had disappeared. Its really frustrating, I am afraid many duplicate items might be added thinking we dont have stock numbers for them simply because teh vendor#s are disappearing and we cant find them.

Any body, Any suggestions, PLS NEED HELP URGENTLY. This issue is driving me crazy and eating up most of my time. >:(

Diala

Title: Re: Vendor Part numbers Disappearing!
Post by gtladmin on 06/08/06 at 10:54:53

Tim and Diala:

What versions are you guys running? Include the update version so we can look on our systems and see if with the same versions the same issues are occurring.

Val

Title: Re: Vendor Part numbers Disappearing!
Post by fdiala on 06/08/06 at 11:36:30

Hi Val,

I am using DBA Classic Version 2002.4 DL

Thanks,

Diala

Title: Re: Vendor Part numbers Disappearing!
Post by gtladmin on 06/08/06 at 11:48:50

Diala,

We're on the EvoERP version (see my post info), so it could just be an issue with the Classic. But, I'll ask the folks here if they've seen those issues. Usually something like that they'll speak up on, but I'll double-check just to be sure.

Val

Title: Re: Vendor Part numbers Disappearing!
Post by fdiala on 06/09/06 at 05:13:51

Thanks a lot Val,

The thing is the records completly disappear from BKSBVEND, they are just deleted!!. when you go into Inventory entry, If a primary was specified, it still show it there, but when you click on vendors... there is nothing... My assumption is something is not right with BKSBVEND and BKSBMFG (bec it happens to manufacturers as well). At first it used to happen once every 6 or 7 months..but lately its happening every few weeks, sometimes a couple of time a week and we do add new mfg and vendors all the time, so its really becoming a big issue. Its greatly appreciated if someone can look into it.

Thanks again,

Diala

Title: Re: Vendor Part numbers Disappearing!
Post by JNAPIER on 06/09/06 at 07:42:30

I would just upgrade to a version a little more current version. It will be well worth your while ;D

John

Title: Re: Vendor Part numbers Disappearing!
Post by gtladmin on 06/09/06 at 07:59:20

Yep, for what it's worth, Diala, we don't seem to be having the problem here. It's worth it to do the upgrade. It certainly has been for us!

Good Luck,

Val

Title: Re: Vendor Part numbers Disappearing!
Post by rvallier on 06/12/06 at 11:50:50

We are having a similar problem, our version is 2004.1 w update through 5/8/06 - is there a solution to the problem?

Thanks,
Robin :-/

Title: Re: Vendor Part numbers Disappearing!
Post by fdiala on 06/13/06 at 04:02:13

Hi Robin,

You are having the same problem with the ISTech updates? Since when did it start and what is the frequency?

Diala

Title: Re: Vendor Part numbers Disappearing!
Post by Lynn Pantic on 06/13/06 at 08:16:23

Whatever is causing this, I suspect it has been around for a long time because we have reports from both users on original DBA and users with IS Tech Updates. We just don't know what. Those of you that are seeing it - do you frequently delete part numbers in IN-B? Or delete or change Manufacturer or Vendor cross references in IN-B or BM-K & L? Our suspicion is that under some set of conditions, deleting an entry in one of these programs is going haywire and deleting other entries as well. Nothing else really makes sense because no other programs actually update those files. They just read them.

Title: Re: Vendor Part numbers Disappearing!
Post by fdiala on 06/14/06 at 04:40:49

Lynn,

We very rarely delete vendor or mfg part numbers. But we do add on regular basis, almost daily. Now the time frame of loosing data is a matter of days and sometimes even minutes. I mentioned that earlier, some time last week, I myself, entered a vendor part number and went to do the PO, and it gave me the msg that vendor is not approved. I am sure I entered the information. I do not think its an indexing problem, because the records will just not be there... Do you have any suggestions? or things to look out for or test?

Regards,

Diala