Clearing Standard Cost Pending Changes

(0) Share

Report

Posted on by Community Member Microsoft Employee

Running 2013 SP2 with Manufacturing. In process of setting up to use Standard Costing updating after it not being maintained in 4 years.

Issue is we have thousands of pending changes in table ICIV0323 that need to be cleared out. Additionally many have an Override set. I understand the interaction with CT00003 and the 3 windows controlling entries of pending, proposed, and override updates.

Not sure of proper fields to clear in ICIV0323 and what is the relationship between the various effective dates and the current cost effective date field "_1".

Secondly I would like to confirm that the history table CT00200 just receives data during roll/revalue and does not control any action on ICIV0323.

Thank you in advance.

Randy

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (1)

Report

RE: Clearing Standard Cost Pending Changes

Thank you again on this one.
Verified answer

Redbeard 12,931 on at

Like (0)

Report

RE: Clearing Standard Cost Pending Changes

You should not use SQL to clear values in the CT00003 or ICIV0323 tables. You can make these changes, using the Standard Cost Changes window. Since you have numerous updates to do, you may want to check out my blog post on Macros.

http://redbeardblogging.blogspot.com/2014/09/how-to-create-and-run-simple-macro-in.html

CT00200 receives data during the roll/revalue process when you click change cost, and not until. Here is a link to a KB explaining the function

support.microsoft.com/.../883471