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.
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]
>