PartCost Table error?

Yahoo Archive
1
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]
>
2
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]
3
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]
4
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]