E9.04.507a SQL force set PartCost.AvgMaterialCost

Yahoo Archive
1
I have done this with a UD for our initial loading of data. On my system it processes 560 records per minute. On slower DMT runs I was told to split the file and run them all simultaneously. I run 8 sessions for some updates like BOO and BOM.

Something like below should get the update done.

Greg Payne

For each ttUD15 where (ttUD15.rowmod = 'A' or ttUD15.rowmod = 'U') and ttUD15.Company = cur-comp.


For each Part where Part.Company = ttUD15.Company and Part.PartNum = ttUD15.key1.
If Available Part then Do:


find PartCost where PartCost.Company = ttUD15.Company and PartCost.PartNum = ttUD15.key1 and PartCost.CostID = ttUD15.key2 no-error.
If Not available PartCost then do:
Message "DEBUG Adding Part Cost record for " + ttUD15.key1.
Create PartCost.
PartCost.Company = ttUD15.Company.
PartCost.PartNum = ttUD15.key1.
PartCost.CostID = ttUD15.key2.
Release PartCost.
End.

For each PartCost where PartCost.Company = ttUD15.Company and PartCost.PartNum = ttUD15.key1 and PartCost.CostID = ttUD15.key2.
Message "DEBUG Updating Part Cost record for " + ttUD15.key1 + " " + ttUD15.key3 + " " + string(ttUD15.number03).
If ttUD15.number01 <> 0 Then Assign PartCost.LastMaterialCost = ttUD15.number01.
If ttUD15.number02 <> 0 Then Assign PartCost.AvgMaterialCost = ttUD15.number02.
End.
End.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Hyndman
Sent: Tuesday, January 08, 2013 11:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9.04.507a SQL force set PartCost.AvgMaterialCost



Thanks all. DMT ran for 78 hours and never did get thru all needed updates. This is a known performance issue that was addressed in 9.05.700. Trying to see if Epicor will provide a back-level patch to 9.04.507a.
Linda

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Stephen Edginton wrote:
>
> Perform a Cost Adjustment in DMT to do this, You should not update the tables directly.
>
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Hyndman
> Sent: 17 December 2012 16:24
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] E9.04.507a SQL force set PartCost.AvgMaterialCost
>
>
>
> We need to reset the average material cost. Tried using DMT to modify all Lots but the PartCost table still doesn't reflect the correct value. We are SQL. Can we safely force set it?
>
>
>
> [Non-text portions of this message have been removed]
>


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
2
We need to reset the average material cost. Tried using DMT to modify all Lots but the PartCost table still doesn't reflect the correct value. We are SQL. Can we safely force set it?
3
First question - are you using Average cost?



If you are, I wouldn't use SQL to reset your average cost. This could have
a financial impact and you would want the system to reset those AVG Cost
where there is quantity on hand.



Did you get an DMT error log when you tried to reset the avg cost for Lots?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Hyndman
Sent: Monday, December 17, 2012 9:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9.04.507a SQL force set PartCost.AvgMaterialCost





We need to reset the average material cost. Tried using DMT to modify all
Lots but the PartCost table still doesn't reflect the correct value. We are
SQL. Can we safely force set it?





[Non-text portions of this message have been removed]
4
We are using Lot Average. Some records do err out with "Lot Number is required for this type of transaction." Others run with no error. Every record we ran thru the DMT had a Lot Number. The PartCost value is incorrect for those with errors. We do want to override the cost, even for those that have On Hand. We understand there will be financial impact. Thanks, Cathy.
Linda

--- In vantage@yahoogroups.com, "Cathy" <cathy@...> wrote:
>
> First question - are you using Average cost?
>
>
>
> If you are, I wouldn't use SQL to reset your average cost. This could have
> a financial impact and you would want the system to reset those AVG Cost
> where there is quantity on hand.
>
>
>
> Did you get an DMT error log when you tried to reset the avg cost for Lots?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Hyndman
> Sent: Monday, December 17, 2012 9:24 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] E9.04.507a SQL force set PartCost.AvgMaterialCost
>
>
>
>
>
> We need to reset the average material cost. Tried using DMT to modify all
> Lots but the PartCost table still doesn't reflect the correct value. We are
> SQL. Can we safely force set it?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Perform a Cost Adjustment in DMT to do this, You should not update the tables directly.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Hyndman
Sent: 17 December 2012 16:24
To: vantage@yahoogroups.com
Subject: [Vantage] E9.04.507a SQL force set PartCost.AvgMaterialCost



We need to reset the average material cost. Tried using DMT to modify all Lots but the PartCost table still doesn't reflect the correct value. We are SQL. Can we safely force set it?



[Non-text portions of this message have been removed]
6
Thanks all. DMT ran for 78 hours and never did get thru all needed updates. This is a known performance issue that was addressed in 9.05.700. Trying to see if Epicor will provide a back-level patch to 9.04.507a.
Linda

--- In vantage@yahoogroups.com, Stephen Edginton wrote:
>
> Perform a Cost Adjustment in DMT to do this, You should not update the tables directly.
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Hyndman
> Sent: 17 December 2012 16:24
> To: vantage@yahoogroups.com
> Subject: [Vantage] E9.04.507a SQL force set PartCost.AvgMaterialCost
>
>
>
> We need to reset the average material cost. Tried using DMT to modify all Lots but the PartCost table still doesn't reflect the correct value. We are SQL. Can we safely force set it?
>
>
>
> [Non-text portions of this message have been removed]
>