PartCost Table error?

Like John says, according to the data dictionary, the default value for PartCost.CostID is 1. There should be no nulls.

If you really do have records where that field is a null, you may need to get support from Epicor.

Just to clarify:
It sounds like you have already run a query on exclusively the PartCost table independantly with no links to any other table. So, if your query were to look like this:

SELECT PartCost.Company, PartCost.PartNum, PartCost.CostID
FROM PartCost
ORDER BY PartCost.CostID

then your resuling recordset would have 6 records at the top with Company name and PartNum, but CostID will be null for those 6 records.

Is this a correct understanding of your problem?

If so, sorry, I wouldn't know how those nulls got there, so I wouldn't know how to properly get them deleted.



--- In vantage@yahoogroups.com, "Babette Welch" <bwelch@...> wrote:
>
> Maybe this will clarify it:
>
> 1) the duplicates are ONLY with one company; the other company has no
> duplicates.
>
> 2) The Plant Cost is set up; One plant each company
>
>
>
> Does anyone know how to DELETE these extra records?
>
>
>
> Babette Welch
>
>
>
>
>
>
>
>
>
>
>
>
>
> Previous;
>
> 4a. PartCost Table error?
>
> Posted by: "Hatcher, John" johnh@... jahatcher43
>
> Date: Thu Mar 26, 2009 5:32 am ((PDT))
>
>
>
> Hi Babette,
>
>
>
> The duplicates are probably not duplicates but rather the record for
> each company. Take a look at the Company field as well.
>
>
>
> The CostID cannot be blank. This can be corrected by setting up the
> plant cost D. (found under engineering/setup.)
>
>
>
> Hope this helps.
>
>
>
> John A. Hatcher
>
> Manager of IS
>
> Versa Products Co., Inc.
>
> (201) 518-5948
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Hello



The subject has a question mark because I am not sure if this is an
error.



We are using Costing Workbench to roll-up our cost and establish
Standard costs.

We have two companies, one works smoothly, the other will not record ANY
changes in cost.



Most of our BOMs use the same 6 purchased parts.

I noticed in the PARTCOST table that these 6 parts have duplicate
records.

The only difference (that I see) is the COSTID field.



The record which responds to changes to Standard Cost has a "1" for
COSTID.

The duplicate record has a null.





Could this duplicate be why our roll-up does not work?

How do I delete that duplicate?



Thank you in advance.



Babette Welch

IT

Argoncis, Inc





[Non-text portions of this message have been removed]
Hi Babette,



The duplicates are probably not duplicates but rather the record for
each company. Take a look at the Company field as well.



The CostID cannot be blank. This can be corrected by setting up the
plant cost D. (found under engineering/setup.)



Hope this helps.



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)





[Non-text portions of this message have been removed]
Maybe this will clarify it:

1) the duplicates are ONLY with one company; the other company has no
duplicates.

2) The Plant Cost is set up; One plant each company



Does anyone know how to DELETE these extra records?



Babette Welch













Previous;

4a. PartCost Table error?

Posted by: "Hatcher, John" johnh@... jahatcher43

Date: Thu Mar 26, 2009 5:32 am ((PDT))



Hi Babette,



The duplicates are probably not duplicates but rather the record for
each company. Take a look at the Company field as well.



The CostID cannot be blank. This can be corrected by setting up the
plant cost D. (found under engineering/setup.)



Hope this helps.



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948







[Non-text portions of this message have been removed]